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!

restore archive log which were not backed up

787588Sep 26 2010 — edited Sep 27 2010
Hi experts,

as per understandings, after the creation of database the scn will starts from 1 and it grows sequentially,

1)i have not taken any backup until today.
2) i deleted all the archivelogs, but i have database alive
3) taken a full backup.


so i tried to restore from scn 100 to 200.
restore archivelog from scn 100 until scn 200;
error:
RMAN-20242: specification does not match any archivelog in recovery cataloag

now my scn is 504575

is it possible to restore archive log from 100 scn to 200 scn?

Thanks & Best Regards.

appriciated for the right answers.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2010
Added on Sep 26 2010
29 comments
2,235 views