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.