All entries for Thursday 08 July 2010

July 08, 2010

11g logical standby database creation

In 10g, you manually create the password file.
In 11g, you have to copy password from primary. Otherwise, the following error will be reported:

*** 2010-07-08 14:46:17.196 4132 krsh.c
Error 1031 received logging on to the standby
*** 2010-07-08 14:46:17.196 869 krsu.c
Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'xxx'
ORA-01031: insufficient privileges
*** 2010-07-08 14:46:17.197 4132 krsh.c
Error 1031 for archive log file 1 to 'xxxx'
*** 2010-07-08 14:46:17.197 2747 krsi.c
krsi_dst_fail: dest:2 err:1031 force:0 blast:1
ORA-01031: insufficient privileges
Destination is specified with ASYNC=61440

You also need to change the name of the password file.

So the command will be:

scp oracle@primary:/usr/orahome/dbs/orapwPrimarySid /usr/orahome/dbs/orapwStandbySid

The database do not need to be restarted.

Search this blog

Search Warwick Blogs



Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder