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!

Recovery scenario : Is this expected ?

686313Feb 21 2009 — edited Feb 25 2009

Hi,

I did the following in oracle10g on Solaris with archivelog:

1) took a datafile offline when the database is up and running.
2) switched the logs for 3 times (alter system switch logfile).
3) Deleted the recent archivelog file from archiving location(log_archive_dest_1)
4) recovered the datafile
5) took the datafile online successfully.

Here my question is : Why step 4 has not thrown error as I have removed one of the archivelog which is required for the recovery.

Can someone please explain this ?. Let me know if my question was not clear.

Thanks,
-Sreedhar.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 25 2009

Added on Feb 21 2009

#general-database-discussions

9 comments

516 views