Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: recovery during refresh

RE: recovery during refresh

From: Tatireddy, Shrinivas (MED, Keane) <Shrinivas.Tatireddy_at_med.ge.com>
Date: Tue, 18 Dec 2001 23:44:57 -0800
Message-ID: <F001.003DFA95.20011218232023@fatcity.com> 






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>



    
  
  1.   issue following command:
recover using backup controlfile until cancel;

  
  2.   when prompted for archive redo log, ftp it over from production to
test
(renaming it appropriately).

  
  3.   apply as many arhive redo logs that you feel you want

  
  4.   CANCEL   (this ends recovery) if you get error, then you need apply
more
logs (see 10).

  
  5.   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).
Received on Wed Dec 19 2001 - 01:44:57 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US