I have a standby database to which archive log files are applided automatically by setting the appropriate parametes in the init.ora file of the primary database.
Now my standby database archive log is not in sync with the primary database.
Now do i need to manually apply the archive logs from the primary database to standby database and perform recovery.
You have to sync up manually until the most recent log from primary and then you can keep it back in auto recovery. You do not have any other alternative other than following this when its outta sync.
Do switch a log on primary before you start applying logs manually on standby, that way by that time you apply all the logs, it will not generate another log.(I'm assuming here few logs, minimum time for log switch and applying recovery).
And make sure that before keeping it in Auto mode, log_arch_dest_state_n is 'enabled' not 'defer'.
Hi if already archive log files are in place meaning ...in correct archive directory...
Then manually run.....
RECOVER STANDBY DATABASE;
it checks for the files in archive directory and try to apply all the required files...
already the database is in managed recovery mode then you have to stop it...by
alter database recover managed standby database cancel;
please post if you have any problem.
You mean the script copies logs to STANDBY location and STANDBY is in manual recovery mode. Usually RFS process copies the logs to standby if you configure the service in init.ora and tnsnames.ora Right ? Which Command you use to apply recovery to STBY?
alter database recover managed standby database (auto)
recover standby database (manual)
If its manual what happens when your session dies, after you leave your session with that command on (Say your script make sure that it copies the logs from primary).