Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 10g Dataguard Error

712822Sep 21 2009 — edited Sep 21 2009
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2009
Added on Sep 21 2009
3 comments
454 views