standby database
Hello All
I faced one issue concerning my standby server , see my alert log and athe error after the recovery database ;
I just take the backup sets of my last EOD and create a standby controlfile on the primary database
alter database create standby controlfile as '/BACKUP/stbcontrol01.ctl'
and scp stbcontrol01.ctl to the standby database and cp to the diiferent location specify in pfile
Can you advice me concerning this issue ?
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/UBSSYSTEM/cotedb_system_001.dbf'
[oracle@accesscote-r2 bdump]$ tail -f alert_cotedb.log
Clearing online log 1 of thread 1 sequence number 1360
Sun May 8 15:44:38 2011
Errors in file /ORACLE/product/admin/cotedb/bdump/cotedb_mrp0_3778.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: '/UBSTEMP/cotedb_redo01a.log'
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 1347
Fetching gap sequence in thread 1, gap sequence 1347-1360
Sun May 8 15:44:39 2011
Completed: ALTER DATABASE RECOVER managed standby database disconnect from session
Sun May 8 15:47:39 2011
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 1347-1360
DBID 777179672 branch 739304148
FAL[client]: All defined FAL servers have been attempted.
-------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that is sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
-------------------------------------------------------------
cheers