NOT OT! - identify which logs are need to start recovery
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). > >
RE: identify which logs are need to start recovery
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
RE: identify which logs are need to start recovery
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
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
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).
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).