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!

How to Recover DB if some old archive logs are lost

SaurabhchSep 24 2015 — edited Sep 27 2015

Hi,

I have a database on 10g, which is running fine without any issues. I want to restore it to some another server. My current log sequence is 169. One day while taking RMAN full backup i deleted some archived log files i.e. "DELETE NOPROMPT ARCHIVELOG uNTIL TIME 'SYSDATE-1/24';". Later on this backup piece got deleted somehow. Now i have a database running fine but without old archive logs. Now my problem is

How to restore and recover database if old archive logs are lost. Because while recovery it will ask for archive log with older sequences like 14,15 or so.


Thanks,

Saurabh Chaudhary

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2015
Added on Sep 24 2015
14 comments
6,526 views