RE: identify which logs are need to start recovery

2001-03-29 Thread Rahul

Lisa/List, 

when we restore a datafile from a backup, oracle will check the change# in
the header of the datafile
and will try to match it with the one in the controlfile, correct ? that's
how oracle will know that the file 
is out-of-sync, now oracle will prompt from the change# as well as the log
sequence number to apply !!

from where does it get the log sequence number ? is it sotred in each
datafile ? or oralce queries it 
from v$log_history ? 

Rahul


 --
 From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, March 29, 2001 12:02 PM
 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 always cancel out.  During testing, I found that it will ask
 for every single one since the backup set from which you restored your
 datafile, regardless of whether or not it needs it (in this case, the
 datafile that was lost didn't contain any tables that had changed since
 the last backup. Go figure).
 
 HTH 
   
 Lisa Rutland Koivu 
 Oracle Database Administrator 
 [EMAIL PROTECTED] 
   
  NeoMedia 
   
 2201 Second St., Suite 600 
 Fort Myers, FL 33901, USA 
 Phone: 941-337-3434 
 Fax: 941-337-3668 
 www.neom.com  http://www.neom.com 
 www.paperclick.com  http://www.paperclick.com 
 www.qode.com  http://www.qode.com 
   
 P a p e r C l i c k . c o m  http://www.paperclick.com/home.htm 
   
 
 
  Enter 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 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 Network Services-- (858) 538-5051  FAX: (858) 538-5051 
 San Diego, California-- Public Internet access / Mailing Lists 
  
 To REMOVE yourself from this mailing list, send an E-Mail message 
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the message BODY, include a line containing: UNSUB ORACLE-L 
 (or the name of mailing list you want to be removed from).  You may 
 also send the HELP command for other information (like subscribing). 
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: identify which logs are need to start recovery

2001-03-29 Thread Nancy McCormick

I believe that it gets the log sequence number by comparing the change# to
the change# in the
v$log_history table.

Nancy

-Original Message-
Sent: Thursday, March 29, 2001 3:19 AM
To: Multiple recipients of list ORACLE-L


Lisa/List,

when we restore a datafile from a backup, oracle will check the change# in
the header of the datafile
and will try to match it with the one in the controlfile, correct ? that's
how oracle will know that the file
is out-of-sync, now oracle will prompt from the change# as well as the log
sequence number to apply !!

from where does it get the log sequence number ? is it sotred in each
datafile ? or oralce queries it
from v$log_history ?

Rahul


 --
 From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, March 29, 2001 12:02 PM
 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 always cancel out.  During testing, I found that it will ask
 for every single one since the backup set from which you restored your
 datafile, regardless of whether or not it needs it (in this case, the
 datafile that was lost didn't contain any tables that had changed since
 the last backup. Go figure).

 HTH

 Lisa Rutland Koivu
 Oracle Database Administrator
 [EMAIL PROTECTED]

  NeoMedia

 2201 Second St., Suite 600
 Fort Myers, FL 33901, USA
 Phone: 941-337-3434
 Fax: 941-337-3668
 www.neom.com  http://www.neom.com
 www.paperclick.com  http://www.paperclick.com
 www.qode.com  http://www.qode.com

 P a p e r C l i c k . c o m  http://www.paperclick.com/home.htm



  Enter 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 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 Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nancy McCormick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: identify which logs are need to start recovery

2001-03-29 Thread Vadim Gorbounov

Hi, Rahul,
Unfortunately, there is no v$view. v$log_history also isn't a good
candidate - v$log_history data are stored in the controlfile, and
controlfile loss would make database unrecoverable (we know, this is not the
case).

My assumption is Oracle stores checkpoint SEQ# in the datafile
header, as well as SCN, and for recovery purposes Oracle checks every
datafile, takes minimum SEQ# and prompt us for this log.

  The following command is used to dump file headers

  alter session set events 'immediate trace name file_hdrs level 10';  

The following is a small piece of dump, note  thread:1
rba:(0xb6.6d.160) at the end - I strongly believe 0xb6 is SEQ# and thread:1
is thread number of redo log, required for recovery. Archived log SEQ# will
be this number minus one.

DATA FILE #10: 
  (name #13) /u02/oradata/simplydb/simply.dbf
creation size=12800 block size=4096 status=0xe head=13 tail=13 dup=1
 tablespace 9, index=10 krfil=10 prev_file=0
 unrecoverable scn: 0x. 11/21/2000 10:54:54
 Checkpoint cnt:1139 scn: 0x.00283091 03/29/2001 09:32:28
 Stop scn: 0x. 03/22/2001 13:00:14
 Creation Checkpointed at scn:  0x.0001d187 11/16/2000 15:37:16
 thread:1 rba:(0xb6.6d.160) 

I'm not absolutely sure, this is correct, but looks like for me.

Best regards,
Vadim Gorbounov
Oracle DBA


-Original Message-
Sent: Thursday, March 29, 2001 3:19 AM
To: Multiple recipients of list ORACLE-L


Lisa/List, 

when we restore a datafile from a backup, oracle will check the change# in
the header of the datafile
and will try to match it with the one in the controlfile, correct ? that's
how oracle will know that the file 
is out-of-sync, now oracle will prompt from the change# as well as the log
sequence number to apply !!

from where does it get the log sequence number ? is it sotred in each
datafile ? or oralce queries it 
from v$log_history ? 

Rahul


 --
 From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, March 29, 2001 12:02 PM
 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 always cancel out.  During testing, I found that it will ask
 for every single one since the backup set from which you restored your
 datafile, regardless of whether or not it needs it (in this case, the
 datafile that was lost didn't contain any tables that had changed since
 the last backup. Go figure).
 
 HTH 
   
 Lisa Rutland Koivu 
 Oracle Database Administrator 
 [EMAIL PROTECTED] 
   
  NeoMedia 
   
 2201 Second St., Suite 600 
 Fort Myers, FL 33901, USA 
 Phone: 941-337-3434 
 Fax: 941-337-3668 
 www.neom.com  http://www.neom.com 
 www.paperclick.com  http://www.paperclick.com 
 www.qode.com  http://www.qode.com 
   
 P a p e r C l i c k . c o m  http://www.paperclick.com/home.htm 
   
 
 
  Enter 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 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 Network Services-- (858) 538-5051  FAX: (858) 538-5051 
 San Diego, California-- Public Internet access / Mailing Lists 
  
 To REMOVE yourself from this mailing list, send an E-Mail message 
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the message BODY, include a line containing: UNSUB ORACLE-L 
 (or the name of mailing list you want to be removed from).  You may 
 also send the HELP command for other information (like subscribing). 
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vadim Gorbounov
  INET: [EMAIL

NOT OT! - identify which logs are need to start recovery

2001-03-29 Thread Koivu, Lisa
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 associated with each log file are stored in the control file also, I believe. List, please correct me if I am wrong.

Lisa


-Original Message-
From: Rahul [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 3:06 AM
To: 'Koivu, Lisa'; 'Oracle List I'
Subject: RE: identify which logs are need to start recovery 



Lisa/List, 


when we restore a datafile from a backup, oracle will check the change# in
the header of the datafile
and will try to match it with the one in the controlfile, correct ? that's
how oracle will know that the file 
is out-of-sync, now oracle will prompt from the change# as well as the log
sequence number to apply !!


from where does it get the log sequence number ? is it sotred in each
datafile ? or oralce queries it 
from v$log_history ? 


Rahul



 --
 From:  Koivu, Lisa[SMTP:[EMAIL PROTECTED]]
 Sent:  Thursday, March 29, 2001 12:02 PM
 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 always cancel out. During testing, I found that it will ask
 for every single one since the backup set from which you restored your
 datafile, regardless of whether or not it needs it (in this case, the
 datafile that was lost didn't contain any tables that had changed since
 the last backup. Go figure).
 
 HTH 
 
 Lisa Rutland Koivu 
 Oracle Database Administrator 
 [EMAIL PROTECTED] 
 
 NeoMedia 
 
 2201 Second St., Suite 600 
 Fort Myers, FL 33901, USA 
 Phone: 941-337-3434 
 Fax: 941-337-3668 
 www.neom.com  http://www.neom.com 
 www.paperclick.com  http://www.paperclick.com 
 www.qode.com  http://www.qode.com 
 
 P a p e r C l i c k . c o m  http://www.paperclick.com/home.htm 
 
 
 
 Enter 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 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 Network Services -- (858) 538-5051 FAX: (858) 538-5051 
 San Diego, California -- Public Internet access / Mailing Lists 
  
 To REMOVE yourself from this mailing list, send an E-Mail message 
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the message BODY, include a line containing: UNSUB ORACLE-L 
 (or the name of mailing list you want to be removed from). You may 
 also send the HELP command for other information (like subscribing). 
 
 





identify which logs are need to start recovery

2001-03-28 Thread Rahul

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 Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: identify which logs are need to start recovery

2001-03-28 Thread Koivu, Lisa
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 that it will ask for every single one since the backup set from which you restored your datafile, regardless of whether or not it needs it (in this case, the datafile that was lost didn't contain any tables that had changed since the last backup. Go figure).

HTH

Lisa Rutland Koivu
Oracle Database Administrator
[EMAIL PROTECTED]

NeoMedia

2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com http://www.neom.com 
www.paperclick.com http://www.paperclick.com 
www.qode.com http://www.qode.com 

P a p e r C l i c k . c o m http://www.paperclick.com/home.htm 




Enter 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 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 Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).