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:Shrinivas.Tatireddy_at_med.ge.com]
> 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:Shrinivas.Tatireddy_at_med.ge.com]
> 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: Shrinivas.Tatireddy_at_med.ge.com
>
> 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: ListGuru_at_fatcity.com (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: Gerardo.Molina_at_schwab.com
>
> 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: ListGuru_at_fatcity.com (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: Shrinivas.Tatireddy_at_med.ge.com
>
> 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: ListGuru_at_fatcity.com (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: Glenn Travis
  INET: Glenn.Travis_at_sas.com

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: ListGuru_at_fatcity.com (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).