RE: recovery during refresh
You can SOMETIMES get away with copying online redo logs when in hot backup mode, IF there is no to little database activity during the hot backup step. BUT I would not do it as a general practice just for the reasons you are experiencing. CONTROL FILES AND ONLINE REDO LOG FILES SHOULD NOT BE BACKED UP WHILE THE DATABASE IS ACTIVE. Use 'alter system backup controlfile to trace' and 'alter system archive log current' to get the most recent and up to date copies of the data you need to recover/clone/restore. -Original Message- From: Tatireddy, Shrinivas (MED, Keane) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: recovery during refresh Hi Gerardo, Thnq for responding. My doubt is , if I apply online logs , will it cause index corruptions. (ora - 600 error). In my last refresh , I applied online redo log. I got the message when I apply this log is Media recovery completed. After that I opened the db with resetlogs. Everything went fine. But later when the team is working that some indexes got corrupted and returning ora-600 errors. But in production db they are ok. Can you explain why this happened.? Srinivas -Original Message- Sent: Wednesday, December 19, 2001 3:50 AM To: Multiple recipients of list ORACLE-L Run the following via svrmgrl or sqlplus alter database backup controlfile to trace; This generates a trace file in udump directory. edit trace file: 1) strip out all lines prior to STARTUP NOMOUNT... 2) change all references to SID to test instance. 3) change all reference to file names to appropriate names for test instance. 4) make appropriate changes if there are any differences in number and size of online redo logs. 5) Remove these lines from end of trace file RECOVER DATABASE ALTER SYSTEM ARCHIVE LOG ALL; ALTER DATABASE OPEN; 6) copy hotbackup files only (do not copy online redo logs) to test file directories. 7) remove all online redo logs and control files for test instance. 8) make sure number of rollback segments in init.ora for test instance matches number of rollback segments in prod. 9) from svrmgrl or sqlplus @edited trace_file 10) issue following command: recover using backup controlfile until cancel; 11) when prompted for archive redo log, ftp it over from production to test (renaming it appropriately). 12) apply as many arhive redo logs that you feel you want 13) CANCEL (this ends recovery) if you get error, then you need apply more logs (see 10). 14) alter database open resetlogs; This will recreate online redo logs and startup the database; This is a proven procedure. HTH, Gerardo -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 9:35 PM To: Multiple recipients of list ORACLE-L Hi lists, I need to refresh a test database from production. (test1 from prod1 db) I took the hotbackup files and online redo logs. I created the controlfile using these files. After that I performed recovery. Here I applied online logs instead of archive logs. (There are 7 grous of online redo logs each contains 3 members). When I tried to open the db, it asked that datafile needs recovery. I applied online redo log instead of archive log. The next day I observed that indexes got corrupted (This msg is from another dba group who are working with this new test database) My doubt is : applying online redo logs instead of archive logs lead to this index corruption? can anybody come across such any situation. Now I need to do refresh again in another way applying archive logs. Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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: Molina, Gerardo 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
RE: recovery during refresh
Run the following via svrmgrl or sqlplus alter database backup controlfile to trace; This generates a trace file in udump directory. edit trace file: 1) strip out all lines prior to STARTUP NOMOUNT... 2) change all references to SID to test instance. 3) change all reference to file names to appropriate names for test instance. 4) make appropriate changes if there are any differences in number and size of online redo logs. 5) Remove these lines from end of trace file RECOVER DATABASE ALTER SYSTEM ARCHIVE LOG ALL; ALTER DATABASE OPEN; 6) copy hotbackup files only (do not copy online redo logs) to test file directories. 7) remove all online redo logs and control files for test instance. 8) make sure number of rollback segments in init.ora for test instance matches number of rollback segments in prod. 9) from svrmgrl or sqlplus @edited trace_file 10) issue following command: recover using backup controlfile until cancel; 11) when prompted for archive redo log, ftp it over from production to test (renaming it appropriately). 12) apply as many arhive redo logs that you feel you want 13) CANCEL (this ends recovery) if you get error, then you need apply more logs (see 10). 14) alter database open resetlogs; This will recreate online redo logs and startup the database; This is a proven procedure. HTH, Gerardo -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 9:35 PM To: Multiple recipients of list ORACLE-L Hi lists, I need to refresh a test database from production. (test1 from prod1 db) I took the hotbackup files and online redo logs. I created the controlfile using these files. After that I performed recovery. Here I applied online logs instead of archive logs. (There are 7 grous of online redo logs each contains 3 members). When I tried to open the db, it asked that datafile needs recovery. I applied online redo log instead of archive log. The next day I observed that indexes got corrupted (This msg is from another dba group who are working with this new test database) My doubt is : applying online redo logs instead of archive logs lead to this index corruption? can anybody come across such any situation. Now I need to do refresh again in another way applying archive logs. Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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: Molina, Gerardo 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: recovery during refresh
Hi Gerardo, Thnq for responding. My doubt is , if I apply online logs , will it cause index corruptions. (ora - 600 error). In my last refresh , I applied online redo log. I got the message when I apply this log is Media recovery completed. After that I opened the db with resetlogs. Everything went fine. But later when the team is working that some indexes got corrupted and returning ora-600 errors. But in production db they are ok. Can you explain why this happened.? Srinivas -Original Message- Sent: Wednesday, December 19, 2001 3:50 AM To: Multiple recipients of list ORACLE-L Run the following via svrmgrl or sqlplus alter database backup controlfile to trace; This generates a trace file in udump directory. edit trace file: 1) strip out all lines prior to STARTUP NOMOUNT... 2) change all references to SID to test instance. 3) change all reference to file names to appropriate names for test instance. 4) make appropriate changes if there are any differences in number and size of online redo logs. 5) Remove these lines from end of trace file RECOVER DATABASE ALTER SYSTEM ARCHIVE LOG ALL; ALTER DATABASE OPEN; 6) copy hotbackup files only (do not copy online redo logs) to test file directories. 7) remove all online redo logs and control files for test instance. 8) make sure number of rollback segments in init.ora for test instance matches number of rollback segments in prod. 9) from svrmgrl or sqlplus @edited trace_file 10) issue following command: recover using backup controlfile until cancel; 11) when prompted for archive redo log, ftp it over from production to test (renaming it appropriately). 12) apply as many arhive redo logs that you feel you want 13) CANCEL (this ends recovery) if you get error, then you need apply more logs (see 10). 14) alter database open resetlogs; This will recreate online redo logs and startup the database; This is a proven procedure. HTH, Gerardo -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 9:35 PM To: Multiple recipients of list ORACLE-L Hi lists, I need to refresh a test database from production. (test1 from prod1 db) I took the hotbackup files and online redo logs. I created the controlfile using these files. After that I performed recovery. Here I applied online logs instead of archive logs. (There are 7 grous of online redo logs each contains 3 members). When I tried to open the db, it asked that datafile needs recovery. I applied online redo log instead of archive log. The next day I observed that indexes got corrupted (This msg is from another dba group who are working with this new test database) My doubt is : applying online redo logs instead of archive logs lead to this index corruption? can anybody come across such any situation. Now I need to do refresh again in another way applying archive logs. Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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: Molina, Gerardo 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: Tatireddy, Shrinivas (MED, Keane) 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
