OraFAQ Forum: Backup & Recovery » Understand password file usage

Home » RDBMS Server » Backup & Recovery » Understand password file usage (Oracle 9i, AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Understand password file usage [message #350250]

Wed, 24 September 2008 08:54

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

Report message to a moderator

Re: Understand password file usage [message #350258 is a reply to message #350250]

Wed, 24 September 2008 09:10

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator