Database copy -- recover database question

From: James <jamesyang_at_163.net>
Date: 29 Aug 2004 02:39:49 -0700
Message-ID: <86815f22.0408290139.1da96a6b@posting.google.com>

I am coping SAP/Oracle database R3Q to Q02,

For R3Q:
SQL> connect / as sysdba
Connected.
SQL> alter system switch logfile; (4 times, we have 2 groups , 2 memebers per group)
System altered.
SQL> alter database backup controlfile to trace; SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.

For Q02:

Copy all database & online redo logs to correcponding destination directory.

CREATE CONTROLFILE SET DATABASE "Q02" RESETLOGS ARCHIVELOG -- SET STANDBY TO MAXIMIZE PERFORMANCE
    MAXLOGFILES 255
    MAXLOGMEMBERS 3
    MAXDATAFILES 254
    MAXINSTANCES 50
    MAXLOGHISTORY 3176
LOGFILE
  GROUP 1 (
    '/oracle/Q02/origlogA/log_g11m1.dbf',     '/oracle/Q02/mirrlogA/log_g11m2.dbf'   ) SIZE 50M,
  GROUP 2 (
    '/oracle/Q02/origlogB/log_g12m1.dbf',     '/oracle/Q02/mirrlogB/log_g12m2.dbf'   ) SIZE 50M,
  GROUP 3 (
    '/oracle/Q02/origlogA/log_g13m1.dbf',     '/oracle/Q02/mirrlogA/log_g13m2.dbf'   ) SIZE 50M,
  GROUP 4 (
    '/oracle/Q02/origlogB/log_g14m1.dbf',     '/oracle/Q02/mirrlogB/log_g14m2.dbf'   ) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'/oracle/Q02/sapdata1/system_1/system.data1',
'/oracle/Q02/sapdata3/r3q_1/r3q.data1',
'/oracle/Q02/sapdata3/r3q_2/r3q.data2',
'/oracle/Q02/sapdata3/r3q_3/r3q.data3',
'/oracle/Q02/sapdata3/r3q_4/r3q.data4',
'/oracle/Q02/sapdata4/r3q_5/r3q.data5',
'/oracle/Q02/sapdata4/r3q_6/r3q.data6',
'/oracle/Q02/sapdata4/r3q_7/r3q.data7',
'/oracle/Q02/sapdata4/r3q_8/r3q.data8',
'/oracle/Q02/sapdata4/r3q_9/r3q.data9',
'/oracle/Q02/sapdata1/r3q620_1/r3q620.data1',
'/oracle/Q02/sapdata1/r3q620_2/r3q620.data2',
'/oracle/Q02/sapdata1/r3q620_3/r3q620.data3',
'/oracle/Q02/sapdata1/r3q620_4/r3q620.data4',
'/oracle/Q02/sapdata2/r3q620_5/r3q620.data5',
'/oracle/Q02/sapdata2/r3q620_6/r3q620.data6',
'/oracle/Q02/sapdata2/r3q620_7/r3q620.data7',
'/oracle/Q02/sapdata2/r3q620_8/r3q620.data8',
"q02.sql" 62 lines, 2213 characters
'/oracle/Q02/sapdata2/r3q620_5/r3q620.data5',
'/oracle/Q02/sapdata2/r3q620_6/r3q620.data6',
'/oracle/Q02/sapdata2/r3q620_7/r3q620.data7',
'/oracle/Q02/sapdata2/r3q620_8/r3q620.data8',
'/oracle/Q02/sapdata2/r3q620_9/r3q620.data9',
'/oracle/Q02/sapdata3/r3q620_10/r3q620.data10',
'/oracle/Q02/sapdata4/r3q620_11/r3q620.data11',
'/oracle/Q02/sapdata1/r3qusr_1/r3qusr.data1',
'/oracle/Q02/sapdata2/roll_1/roll.data1',
'/oracle/Q02/sapdata4/r3q_10/r3q.data10',
'/oracle/Q02/sapdata4/r3q_11/r3q.data11',
'/oracle/Q02/sapdata4/r3q_12/r3q.data12',
'/oracle/Q02/sapdata3/r3q_13/r3q.data13',
'/oracle/Q02/sapdata2/r3q_14/r3q.data14',
'/oracle/Q02/sapdata2/r3q_15/r3q.data15',
'/oracle/Q02/sapdata2/r3q_16/r3q.data16'
CHARACTER SET WE8DEC
;

SQL> recover database using backup controlfile ORA-00279: change 573410321 generated at 07/27/2004 22:11:01 needed for thread
1
ORA-00289: suggestion : /oracle/Q02/oraarch/Q02arch1_8320.dbf ORA-00280: change 573410321 for thread 1 is in sequence #8320 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

*****************************************???

/oracle/Q02/origlogB/log_g14m1.dbf

*****************************************???

Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.

Question: why media recovery is needed? I've switched all redologs to database and close database before database copy. All database files should be in consistant status and should be "open resetlogs" successfully without media recovery.

Thanks
JamesYang_at_163.net Received on Sun Aug 29 2004 - 04:39:49 CDT