Due to some issue our archives logs are not applying from production to standy. we had our standby at London. i dont see any error messages. not sure what is happening, i had case open with oracle support.
we need to shutdown all our production and DR last sunday. once it is back up it stopped sending logs. our production server is a 3 node RAC.
i just need how to apply archive logs from production to standby which is in london.
Ship the logs manually (just copy them to a location accessible to the standby database,) register them using ALTER DATABASE REGISTER LOGFILE command for each file or RMAN's CATALOG command for all files at a location, and then roll the standby forward with ALTER DATABASE RECOVER MANAGED STANDBY DATABASE command.
Please post the result:
SELECT MAX(SEQUENCE#), MAX(COMPLETION_TIME), APPLIED FROM V$ARCHIVED_LOG GROUP BY APPLIED;
SELECT * FROM V$ARCHIVE_GAP;
also you can copy them from the primary to the standby and apply them one by one:
ALTER DATABASE REGISTER LOGFILE 'LOG_FILE_NAME';
if the gapsequence is so big like 20 or 30 days i will recreate the dataguard using and clone it using rman.
yes , we do have unapplied log files. i was looking for procedure to apply logfiles manually.
As our standby is located at london. Please let me know if there is a way to copy logfiles manually other than ftp. we had a very poor network.
looking for some steps to copy logfiles.
will appreciate your quick response.