Need clarification on setting up the password file on the standby site!
edited Oct 22, 2009 5:18AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered ✓
Hi,
As quoted from the "Oracle Data Guard 11g Handbook" on pages 88-89:
"Step 1: Prepare the Standby System ...
...
3. Create a password file with the primary database SYS password. To create a standby database, RMAN requires that the SYS user perform the various setup and database creation. Oracle Database 11g introduced a new level of security in the password file that makes it necessary to have a copy of the primary database's password in order to operate a physical standby database. Merely creating a new password file with the same password will no longer work, as internally it will be different between the two systems and Data Guard will not be able to connect to the standby. To
0