RE: Hot Backup Issue
I think, I need to answer this original post( late, because our time zone is different ;-)) I was doing this in the test environment ( which I mentioned in my original post too) with total database size of 250 Mb. To make the testing easier I had adopted some random method. At that point of time I didn't care whether I choose method 1 or method 2 ( described below). My motive was to design and document a full proof method for recovery from Hotbackup in case of any kind of failure. Somehow I was missing the clue in one of the test cases and I posted the query describing my original steps honestly BTW I am aware of consequences of putting all the TS ( of Production environment) in backup mode in one stretch for hot backup purpose. Any-way, I thank everybody for contributing. Thanks again everybody, Rajesh -Original Message- Sent: Tuesday, October 02, 2001 3:15 PM To: Multiple recipients of list ORACLE-L Hello, Slightly unrelated question... is it better to (in pseudo code) : 1) for each tablespace loop put tablespace in backup mode end loop for each datafile in the database loop copy data file end loop for each tablespace loop put tablespace in normal mode end loop or 2) for each tablespace loop put tablespace in backup mode for each datafile in this tablespace loop copy data file end loop put tablespace in normal mode end loop What I'm doing is (2), but I notice that Rajesh is doing (1). What are the pros and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: Rajesh Dayal 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: Hot Backup Issue
-Original Message- Sent: Tuesday, October 02, 2001 11:25 AM To: Multiple recipients of list ORACLE-L On Tue, 2 Oct 2001, Ron Rogers wrote: > Some reasons why NOT to put all tablespaces in the backup mode at > once (step 1) is that the tranactions against the database could > create a lot of redo and archive logs that could fill the space, > tranaction time could be longer as it now reads the redo not the > tables What reads the redo? I don't think you have to read the redo during hot backup mode. You read the datafiles or buffer cache just like when you're not in backup mode. There is certainly more redo created during a hot backup. Especially when the rollback tablespace has been placed in this mode and a lot of heavy DML is going on If all the tablespaces are placed in backup mode then the chances of running out of space are increased. I believe the original poster has confused redo and undo when he talks about "reading." But placing a tablespace in backup mode does not increase undo. If a job is processing the tablespaces serially then why would you place all of them in backup mode simultaneously? If you're running backup in parallel why would you place more than one tablespace in backup mode per stream? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] > Snapshot to old could occur Why? I can think of no reason that ORA-1555 should be more likely during hot backup mode. Can you explain this? > If there is a problem and the server restarts Oracle will not start > tablespaces in the backup mode you have to manually issue the > "tablespace normal" command. Do you mean 'alter database datafile end backup?' This can and should just be integrated into the database start scripts. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: MacGregor, Ian A. 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: Hot Backup Issue
On Tue, 2 Oct 2001, Ron Rogers wrote: > Some reasons why NOT to put all tablespaces in the backup mode at > once (step 1) is that the tranactions against the database could > create a lot of redo and archive logs that could fill the space, > tranaction time could be longer as it now reads the redo not the > tables What reads the redo? I don't think you have to read the redo during hot backup mode. You read the datafiles or buffer cache just like when you're not in backup mode. > Snapshot to old could occur Why? I can think of no reason that ORA-1555 should be more likely during hot backup mode. Can you explain this? > If there is a problem and the server restarts Oracle will not start > tablespaces in the backup mode you have to manually issue the > "tablespace normal" command. Do you mean 'alter database datafile end backup?' This can and should just be integrated into the database start scripts. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Hot Backup Issue
Title: RE: Hot Backup Issue That makes sense, I just wanted to check :0) And of course, transactions in other tablespaces would be writing redo as normal. The overall level of redo generated would surely be less, tho'? Because say you had 5 tablespaces and put them all into hotbackup mode. Then the 5th tablespace would be writing full blocks to the redo log for all the time it took to copy the datafiles of the first 4, rather than for just the time it took to copy itself if you only put tablespaces into backup mode while they were actually having their datafiles copied? And when recovering, Oracle doesn't mind that some redo information will be full blocks, and some not, if a transaction spans multiple tablespaces, one of which was in hotbackup mode and the rest not when the transaction was committed? Thanks, g -Original Message-From: Hallas John [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 02, 2001 1:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Hot Backup Issue Guy, I would have thought 2) was best as you are reducing the concurrency (I think that is the right word) of redo log activity. As each tablespace is in backup mode it writes the full block to the redo log when any changes are made. On the assumption that all tablespaces are being written (albeit infrequently) during the period of hot backup it is better to alter each tablespace, copy it then alter online again so that only 1 tablespace at a time is having full blocks of changed data writing to the redo logs. The overall level of redo will be the same but contention (ah ha - better word) will be reduced John -Original Message- From: Guy Hammond [mailto:[EMAIL PROTECTED]] Sent: 02 October 01 12:15 To: Multiple recipients of list ORACLE-L Subject: RE: Hot Backup Issue Hello, Slightly unrelated question... is it better to (in pseudo code) : 1) for each tablespace loop put tablespace in backup mode end loop for each datafile in the database loop copy data file end loop for each tablespace loop put tablespace in normal mode end loop or 2) for each tablespace loop put tablespace in backup mode for each datafile in this tablespace loop copy data file end loop put tablespace in normal mode end loop What I'm doing is (2), but I notice that Rajesh is doing (1). What are the pros and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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). **This email and any attachments may be confidential and the subject oflegal professional privilege. Any disclosure, use, storage or copyingof this email without the consent of the sender is strictly prohibited.Please notify the sender immediately if you are not the intendedrecipient and then delete the email from your inbox and do notdisclose the contents to another person, use, copy or store theinformation in any medium.**
Re: Hot Backup Issue
The main disadvantage of #1 is that lgwr will write full blocks to the redo logs for the entire database until the entire backup is finished. If that takes a while and there is significant activity, it can generate tremendous amounts of redo - and archive. Lgwr and the I/O subsystem are doing more work since they are writing more data. This is what I have do when using EMC and BCV splits for backups since it is so fast. #2 is, in my opinion, better for any "normal" backups - such as to tape. Since only one tablespace at a time is in backup mode, redo and archive generation is minimized. This is especially true if only a relatively small fraction of the database is undergoing significnant transactional activity. The length of time when lgwr is writing full blocks for those transactions is only as long as it takes to back up those particular tablespaces, not all tablespaces. -Don Granaman [OraSaurus - Honk if you remember UFI!] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, October 02, 2001 6:15 AM Hello, Slightly unrelated question... is it better to (in pseudo code) : 1) for each tablespace loop put tablespace in backup mode end loop for each datafile in the database loop copy data file end loop for each tablespace loop put tablespace in normal mode end loop or 2) for each tablespace loop put tablespace in backup mode for each datafile in this tablespace loop copy data file end loop put tablespace in normal mode end loop What I'm doing is (2), but I notice that Rajesh is doing (1). What are the pros and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: Hot Backup Issue
Guy, Some reasons why NOT to put all tablespaces in the backup mode at once (step 1) is that the tranactions against the database could create a lot of redo and archive logs that could fill the space, tranaction time could be longer as it now reads the redo not the tables, Snapshot to old could occur, If there is a problem and the server restarts Oracle will not start tablespaces in the backup mode you have to manually issue the "tablespace normal" command. Doing each tablespace individually allow you more control over the process. Just a few thoughts. ROR mª¿ªm >>> [EMAIL PROTECTED] 10/02/01 07:15AM >>> Hello, Slightly unrelated question... is it better to (in pseudo code) : 1) for each tablespace loop put tablespace in backup mode end loop for each datafile in the database loop copy data file end loop for each tablespace loop put tablespace in normal mode end loop or 2) for each tablespace loop put tablespace in backup mode for each datafile in this tablespace loop copy data file end loop put tablespace in normal mode end loop What I'm doing is (2), but I notice that Rajesh is doing (1). What are the pros and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: Ron Rogers 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: Hot Backup Issue
well 1 is simpler to code. :) However, if you put all tablespaces in backup mode at once, you will be generating a LOT of extra redo and archived logs. That's because even if you are not currently backinf up that tablespace (say you already HAVE backed it up), you will still have to write full blocks to the redo log for that tablespace. So it's extra strain on the system --- Guy Hammond <[EMAIL PROTECTED]> wrote: > Hello, > > Slightly unrelated question... is it better to (in pseudo code) : > > 1) > > for each tablespace loop > put tablespace in backup mode > end loop > > for each datafile in the database loop > copy data file > end loop > > for each tablespace loop > put tablespace in normal mode > end loop > > > or 2) > > for each tablespace loop > put tablespace in backup mode > for each datafile in this tablespace loop > copy data file > end loop > put tablespace in normal mode > end loop > > > What I'm doing is (2), but I notice that Rajesh is doing (1). What > are > the pros and cons of each approach? (I'll probably use RMAN at some > point, anyway :0) ). > > Cheers, > > g > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Guy Hammond > 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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Hot Backup Issue
Title: RE: Hot Backup Issue Guy, I would have thought 2) was best as you are reducing the concurrency (I think that is the right word) of redo log activity. As each tablespace is in backup mode it writes the full block to the redo log when any changes are made. On the assumption that all tablespaces are being written (albeit infrequently) during the period of hot backup it is better to alter each tablespace, copy it then alter online again so that only 1 tablespace at a time is having full blocks of changed data writing to the redo logs. The overall level of redo will be the same but contention (ah ha - better word) will be reduced John -Original Message- From: Guy Hammond [mailto:[EMAIL PROTECTED]] Sent: 02 October 01 12:15 To: Multiple recipients of list ORACLE-L Subject: RE: Hot Backup Issue Hello, Slightly unrelated question... is it better to (in pseudo code) : 1) for each tablespace loop put tablespace in backup mode end loop for each datafile in the database loop copy data file end loop for each tablespace loop put tablespace in normal mode end loop or 2) for each tablespace loop put tablespace in backup mode for each datafile in this tablespace loop copy data file end loop put tablespace in normal mode end loop What I'm doing is (2), but I notice that Rajesh is doing (1). What are the pros and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
RE: Hot Backup Issue
Hello, Slightly unrelated question... is it better to (in pseudo code) : 1) for each tablespace loop put tablespace in backup mode end loop for each datafile in the database loop copy data file end loop for each tablespace loop put tablespace in normal mode end loop or 2) for each tablespace loop put tablespace in backup mode for each datafile in this tablespace loop copy data file end loop put tablespace in normal mode end loop What I'm doing is (2), but I notice that Rajesh is doing (1). What are the pros and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: Hot Backup Issue
hi, i feel u need to give the name of online redo log file after u had applied all the archived log files, if it's asking for more files. this should solve ur problem. pls let me know if it not. i'll try finding other issues also. saurabh - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, October 01, 2001 5:50 PM > Hi All, > I am trying for hot backup restore/recovery. > Oracle 8.1.7.0.0 on WIN 2K Server. I am performing > the operations in following order: > > 1. Put all the tablespaces in backup mode. > 2. Copy all the datafiles to backup location. > 3. Do end backup for all the tablespaces. Also switch logfile >after every end backup ( some more switch logfile at the end). > 4. Shutdown the database ( after all its test instance). > > When I try to "completely recover" the database using > backed up datafile the recovery goes upto last archived logfile > and even after applying last archived logfile it asks for the > next archived logfile. > This is a very awkward situation, how can I provide next > archived logfile if there is no activity and I had shutdown the > database immediately after last switch logfile. > > If I try to open the database, then I get following error: > > ORA-01113: file 1 needs media recovery > ORA-01110: data file 1: 'D:\ORACLE\ORADATA\OHIR\SYSTEM01.DBF' > > Upon checking the metalink, some guys suggest, using > _allow_resetlogs_corruption = true. But I am afraid of using this, > because I have to implement this into production environment too > (where same problem is happening). > > After lots of testing I have found that incomplete recovery > (cancel based) goes fine with the same backup and I can open the > database without any error. But keeping the needs of production > database in mind, it would be very difficult to do an incomplete > recovery every time. > Why can't I perform complete recovery? Am I missing something? > I hope someone on this list would have experienced the problem and > would have got the solution as well. Please share your experience... > > Thanks in Advnace, > Rajesh > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rajesh Dayal > 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: Saurabh Sharma 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: Hot Backup Issue
Rachel, You are absolutely right!! Just after dropping the mail I continued with the tests, and discovered the same theory. Thanks a lot for reply. Best Regards, Rajesh -Original Message- Carmichael Sent: Monday, October 01, 2001 4:45 PM To: Multiple recipients of list ORACLE-L I am making the assumption here that you are doing recover database using backup controlfile when you do the backup In this case, what is happening to you is normal. The controlfile doesn't know what the last scn is supposed to be, so all you have to do is cancel the recovery once the last logfile has been applied and open the database resetlogs and you will be fine --- Rajesh Dayal <[EMAIL PROTECTED]> wrote: > Hi All, > I am trying for hot backup restore/recovery. > Oracle 8.1.7.0.0 on WIN 2K Server. I am performing > the operations in following order: > > 1. Put all the tablespaces in backup mode. > 2. Copy all the datafiles to backup location. > 3. Do end backup for all the tablespaces. Also switch logfile >after every end backup ( some more switch logfile at the end). > 4. Shutdown the database ( after all its test instance). > > When I try to "completely recover" the database using > backed up datafile the recovery goes upto last archived logfile > and even after applying last archived logfile it asks for the > next archived logfile. > This is a very awkward situation, how can I provide next > archived logfile if there is no activity and I had shutdown the > database immediately after last switch logfile. > > If I try to open the database, then I get following error: > > ORA-01113: file 1 needs media recovery > ORA-01110: data file 1: 'D:\ORACLE\ORADATA\OHIR\SYSTEM01.DBF' > > Upon checking the metalink, some guys suggest, using > _allow_resetlogs_corruption = true. But I am afraid of using this, > because I have to implement this into production environment too > (where same problem is happening). > > After lots of testing I have found that incomplete recovery > (cancel based) goes fine with the same backup and I can open the > database without any error. But keeping the needs of production > database in mind, it would be very difficult to do an incomplete > recovery every time. > Why can't I perform complete recovery? Am I missing something? > I hope someone on this list would have experienced the problem and > would have got the solution as well. Please share your > experience... > > Thanks in Advnace, > Rajesh > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rajesh Dayal > 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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Rajesh Dayal 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: Hot Backup Issue
I am making the assumption here that you are doing recover database using backup controlfile when you do the backup In this case, what is happening to you is normal. The controlfile doesn't know what the last scn is supposed to be, so all you have to do is cancel the recovery once the last logfile has been applied and open the database resetlogs and you will be fine --- Rajesh Dayal <[EMAIL PROTECTED]> wrote: > Hi All, > I am trying for hot backup restore/recovery. > Oracle 8.1.7.0.0 on WIN 2K Server. I am performing > the operations in following order: > > 1. Put all the tablespaces in backup mode. > 2. Copy all the datafiles to backup location. > 3. Do end backup for all the tablespaces. Also switch logfile >after every end backup ( some more switch logfile at the end). > 4. Shutdown the database ( after all its test instance). > > When I try to "completely recover" the database using > backed up datafile the recovery goes upto last archived logfile > and even after applying last archived logfile it asks for the > next archived logfile. > This is a very awkward situation, how can I provide next > archived logfile if there is no activity and I had shutdown the > database immediately after last switch logfile. > > If I try to open the database, then I get following error: > > ORA-01113: file 1 needs media recovery > ORA-01110: data file 1: 'D:\ORACLE\ORADATA\OHIR\SYSTEM01.DBF' > > Upon checking the metalink, some guys suggest, using > _allow_resetlogs_corruption = true. But I am afraid of using this, > because I have to implement this into production environment too > (where same problem is happening). > > After lots of testing I have found that incomplete recovery > (cancel based) goes fine with the same backup and I can open the > database without any error. But keeping the needs of production > database in mind, it would be very difficult to do an incomplete > recovery every time. > Why can't I perform complete recovery? Am I missing something? > I hope someone on this list would have experienced the problem and > would have got the solution as well. Please share your > experience... > > Thanks in Advnace, > Rajesh > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rajesh Dayal > 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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).