Skip to Main Content
Forums

Database Software

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!

Redolog files are lost

user11977214Mar 2 2011 — edited Mar 3 2011
Hi,

This is a test case.
My database is 10.2.0.1.

I have a full RMAN backup and for testing I had dropped the redolog files.
I have recovered those file using the full DB restore and cancel based recovery.

Is ther any other way from where I can get those redo log files apart from restoring the full database?

I have also ried to drop and recreate the redolog files but recovered the following error:
SQL> alter database drop logfile member '<Full Path>\REDO01.LOG';
alter database drop logfile member '<Full Path>\REDO01.LOG';

*
ERROR at line 1:
ORA-00361: cannot remove last log member <Full Path>\REDO01.LOG
for group 1

Please advice.

Thanks in advance.
This post has been answered by Hemant K Chitale on Mar 2 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2011
Added on Mar 2 2011
#performance-availability, #recovery-manager-rman
6 comments
215 views