PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: identify which logs are need to start recovery
Hi Rahul,
I'm not sure if there's a v$ view that will tell you, I remember looking
for this myself.
However if you initiate recovery it will ask for the appropriate arclog,
and you can always
Your PaperClick Code Here!
-Original Message-
From: Rahul [ mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 11:13 PM
To: Multiple recipients of list ORACLE-L
Subject: identify which logs are need to start recovery
usually i keep 2-3 previous archived logs, after
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: identify which logs are need to start recovery
Hi Rahul,
I'm not sure if there's a v$ view that will tell you, I remember looking
for this myself.
However if you initiate recovery it will ask for the appropriate arclog,
and you can
Title: NOT OT! - identify which logs are need to start recovery
You are right Rahul. Oracle determines if recovery is necessary by comparing the SCN of the datafiles with the control file. This is part of what goes on when a database opens. The log sequence numbers and the SCN range
usually i keep 2-3 previous archived logs, after switching and starting the
hotbackup...
but is there a v$ view to show which logs are needed to start the recovery ?
TIA
Rahul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul
INET: [EMAIL PROTECTED]
Fat City
Title: RE: identify which logs are need to start recovery
Hi Rahul,
I'm not sure if there's a v$ view that will tell you, I remember looking for this myself.
However if you initiate recovery it will ask for the appropriate arclog, and you can always cancel out. During testing, I found