Oracle Database Discussions

Iam getting the following errors, while recovering the physical standby database to sync up with the primary.


I noticed that online redolog files are existed in the physical standby database but not on the dataguard host file system and Iam not sure as how it was not created in the file system.


So I just would like to know how to recreate these online redolog files on the data guard.

Your reponse is much appreciated.


Lgwr parameters:

Physical Standby:

log_archive_dest_1 string LOCATION=/dcat02/cat/o01cat3dump/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) db_unique_name=O01CAT3DR

log_archive_dest_2 string SERVICE=O01CAT3 valid_for=(online_logfiles,primary_role) db_unique_name=O01CAT3 LGWR ASYNC NOAFFIRM


Primary Database:

log_archive_dest_1 string LOCATION=/dcat02/cat/o01cat3arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) db_unique_name=O01CAT3

log_archive_dest_2 string SERVICE=O01CAT3DR valid_for=(online_logfiles,primary_role) db_unique_name=O01CAT3DR LGWR ASYNC NOAFFIRM



======
Errors in file /dcat02/cat/oracle/admin/O01cat3/bdump/o01cat3_mrp0_959.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/dcat02/cat/o01cat3redo1/redo_01.O01cat3'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Mon Jul 21 15:35:31 2008
Errors in file /dcat02/cat/oracle/admin/O01cat3/bdump/o01cat3_mrp0_959.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: '/dcat02/cat/o01cat3redo1/redo_01.O01cat3'
Clearing online redo logfile 1 complete
Media Recovery Log /dcat02/cat/o01cat3dump/arch/O01cat3_1_270503_475363102.arc
Mon Jul 21 15:35:31 2008
Completed: alter database recover managed standby database disconnect from session
Mon Jul 21 15:36:55 2008
Media Recovery Log /dcat02/cat/o01cat3dump/arch/O01cat3_1_270504_475363102.arc

===