Oracle 10g Dataguard Error
712822Sep 21 2009 — edited Sep 21 2009Hi,
I created a standby database using RMAN backups.
I have followed all the steps correctly because the standby database does come up without any errors when I give the command
'alter database mount standby database;'
or
'alter database recover managed standby database using current logfile disconnect from session;'
But, in the alert log file I can see the following errors.
ORA-00313 - open failed for members of logfile group1 (and 2 and 3)
ORA-227037 - unable to obtain file status (file may not exist)
and
ORA-19527 Physical standby redo log must be renamed.
When I go back and check, the first error is correct in the sense that the redo log files are not present in the location specified.
Querying the V$LOG & V$LOGFILE do return the name and path of the log files (or where they should be but are not!)
What have I missed that the redo logs are not created at the time of restore and recover?
TIA.
KV