archive log transport
edited Jun 22, 2012 4:33PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
I am having a problem with archive log transport.
When the primary database is mounted but not open log_archive_dest_2 is valid; after I do alter database open; then, log_archive_dest_2 changes to ERROR and shows ORA-01031: insufficient privileges.
I have no idea where to look for where the "block" is - any ideas?
I can do a sqlplus connect from the primary system to the standby system and do not get an error except for the error about initialization or shutdown in progress - as expected - it is standby; and I can do sqlplus connect from the standby system to the primary system.
When the primary database is mounted but not open log_archive_dest_2 is valid; after I do alter database open; then, log_archive_dest_2 changes to ERROR and shows ORA-01031: insufficient privileges.
I have no idea where to look for where the "block" is - any ideas?
I can do a sqlplus connect from the primary system to the standby system and do not get an error except for the error about initialization or shutdown in progress - as expected - it is standby; and I can do sqlplus connect from the standby system to the primary system.
0