Home » RDBMS Server » Backup & Recovery » Understand password file usage (Oracle 9i, AIX)
Understand password file usage [message #350250] Wed, 24 September 2008 08:54 Go to next message
psoftneto
Messages: 44
Registered: July 2008
Member
Hi all,

I would like to understand.
The scenario is the following: I want to clone database A to database B.
Can you tell me if the following information are true:
1. If database A password is copied to database B, I will not need to recreate database B control file in order to start database B. If the passwords are changed after startup, the password file will not be modified.
2. If I don't have database A password file, I will need to recreate the control file and change password for database B after.

In fact, I am looking for a solution to start the database without having to recreate a new control file.

Thanks
Re: Understand password file usage [message #350258 is a reply to message #350250] Wed, 24 September 2008 09:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Password and control file are completly independent and have no relation bewteen them.
So anyway you have not to recreate the control file.

Regards
Michel
Re: Understand password file usage [message #350266 is a reply to message #350258] Wed, 24 September 2008 09:19 Go to previous messageGo to next message
psoftneto
Messages: 44
Registered: July 2008
Member
Thanks Michel.

But when do we need to recreate a control file.
Thanks
Re: Understand password file usage [message #350267 is a reply to message #350266] Wed, 24 September 2008 09:22 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

when do we need to recreate a control file

When you lost without backup.
Previous Topic: Performance impact in backup mode
Next Topic: ADMINISTER RESOURCE MANAGER in EXP_FULL_DATABASE
Goto Forum:
  


Current Time: Sat Dec 03 03:51:28 CST 2016

Total time taken to generate the page: 0.05232 seconds