"nirav" <shivam71_at_gmail.com> a écrit dans le message de
news:1121171690.674898.15090_at_g44g2000cwa.googlegroups.com...
> Hi,
>
> Here what is your archive mode? Is it noarchivelog? If it is noarchive
> then you need to restore all the cold backup and that's all ...so you
> lose one day worth of data.
>
> Now if it is archivelog then you need to restore and then recover
> database by applying the archivelogs so you will NOT lose any data, if
> you have preserved all your archive logs....
>
You will loose whatever transactions are in the (now dead/broken/lost)
active redo logs.
Having a backup of the online redo logs will not help as they contain
transactions from yesterday.
Just open resetlogs. You cannot recover past the last archivelog, or the
last unarchived online log (not current) that may still be available on your
disk.
--
Syltrem
OpenVMS 7.3-1 + Oracle 9.2.0.5
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
Received on Tue Jul 12 2005 - 08:48:28 CDT
