This content has been marked as final. Show 2 replies
In Oracle 11
STANDBY_ARCHIVE_DEST can be used to specify where archived logs received from a primary database are stored on a standby database. It is no longer necessary to set this parameter, because an appropriate location is automatically chosen.
In Oracle 10
STANDBY_ARCHIVE_DEST is relevant only for a standby database in managed recovery mode. It specifies the location of archive logs arriving from a primary database. Oracle uses STANDBY_ARCHIVE_DEST and LOG_ARCHIVE_FORMAT to fabricate the fully qualified standby log filenames and stores the filenames in the standby control file.
For question 2
Monitor Various process on standby database by :
SQL> select process,status from v$managed_standby;
SQL> select message from v$dataguard_status;
Mine shows this when things are normal :
PROCESS STATUS --------- ------------ ARCH CLOSING ARCH CONNECTED ARCH CLOSING ARCH CONNECTED ARCH CLOSING ARCH CLOSING ARCH CLOSING ARCH CLOSING MRP0 APPLYING_LOG RFS IDLE RFS IDLE
Edited by: mseberg on Apr 17, 2012 9:58 AM
On a physical standby database, you can define the STANDBY_ARCHIVE_DEST
You can use it to specify Alternate Directory Locations for Archived Redo Log Files
STANDBY_ARCHIVE_DEST will overrides the directory location specified with the LOG_ARCHIVE_DEST_n parameter
Edited by: mseberg on Apr 17, 2012 10:21 AM
Thankyou Very much for clearing my doubt :)
So in 10g if we do not set STANDBY_ARCHIVE_DEST on standby database it will automatically choose appropriate location am i correct ?
Actually I am working on 10g database and on standby database i did not set this parameter but still everything is working fine. ARCn process is placing archive logs from Primary database to standby FRA area. Both the databases are on same machine.
Is it mean that STANDBY_ARCHIVE_DEST default location is standby database FRA if we do not set it in parameter file?
Edited by: 928223 on Apr 17, 2012 8:15 AM