Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to manually apply archives after a until time recovery

KeenOnOracleFeb 9 2010 — edited Feb 10 2010
friends.

I have recovered my DB using until time, but i'm still having archives generated after that.
how do apply them?

imagine taht situation.

archive 12001 created 09/02 14hs
archive 12002 created 09/02 13hs
archive 12003 created 09/02 12hs
archive 12004*** corrupted created 09/02 11hs
archive 12005 created 09/02 10hs
archive 12006 created 09/02 09hs

I tryed to recover the DB to just before the corrupted one bu I got the message
ora-06555-datafile string must be restored from backup created before 09/02

but my trying was to recover directly to 10hs.

may I recover to the day before and then apply those archives?

how?

my db is 10.2.0.1.0 runing on a windows server

tks

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 10 2010
Added on Feb 9 2010
#general-database-discussions
6 comments
896 views