on 08-06-2007 7:37 AM
Dear All,
I want to restore PRD backup on DEV server but nwo facing below error: Please help me to rseolve thsi ASAP....reward points guaranteed
1. Restored PRD backup on DEV server
2. generated control.sql
3. executing control file ....but in ERROR
SQL>ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
SQL> @/1/CONTROL.SQL
ORACLE instance started.
Total System Global Area 6381083200 bytes
Fixed Size 735808 bytes
Variable Size 3288334336 bytes
Database Buffers 3090677760 bytes
Redo Buffers 1335296 bytes
CREATE CONTROLFILE REUSE DATABASE "DEV" NORESETLOGS ARCHIVELOG
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name PRD in file header does not match given name of DEV
ORA-01110: data file 1: '/oracle/DEV/sapdata1/system_1/system.data1'
*********CONTENTS OF CONTROL.SQL**********************
root@bssldev1 # pwd
/oracle/DEV/saptrace/usertrace
root@bssldev1 # ls -l
total 8
-rw-rr 1 oradev dba 4060 Aug 4 19:09 control.sql
root@bssldev1 # more control.sql
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "DEV" NORESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 254
MAXINSTANCES 50
MAXLOGHISTORY 3176
LOGFILE
GROUP 1 (
'/oracle/DEV/origlogA/log_g11m1.dbf',
'/oracle/DEV/mirrlogA/log_g11m2.dbf'
) SIZE 50M,
GROUP 2 (
'/oracle/DEV/origlogB/log_g12m1.dbf',
'/oracle/DEV/mirrlogB/log_g12m2.dbf'
) SIZE 50M,
GROUP 3 (
'/oracle/DEV/origlogA/log_g13m1.dbf',
'/oracle/DEV/mirrlogA/log_g13m2.dbf'
) SIZE 50M,
GROUP 4 (
'/oracle/DEV/origlogB/log_g14m1.dbf',
'/oracle/DEV/mirrlogB/log_g14m2.dbf'
) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'/oracle/DEV/sapdata1/system_1/system.data1',
'/oracle/DEV/sapdata3/prd_1/prd.data1',
'/oracle/DEV/sapdata3/prd_2/prd.data2',
'/oracle/DEV/sapdata3/prd_3/prd.data3',
'/oracle/DEV/sapdata3/prd_4/prd.data4',
'/oracle/DEV/sapdata4/prd_5/prd.data5',
'/oracle/DEV/sapdata4/prd_6/prd.data6',
'/oracle/DEV/sapdata4/prd_7/prd.data7',
'/oracle/DEV/sapdata4/prd_8/prd.data8',
'/oracle/DEV/sapdata4/prd_9/prd.data9',
'/oracle/DEV/sapdata1/prd620_1/prd620.data1',
'/oracle/DEV/sapdata1/prd620_2/prd620.data2',
'/oracle/DEV/sapdata1/prd620_3/prd620.data3',
'/oracle/DEV/sapdata1/prd620_4/prd620.data4',
'/oracle/DEV/sapdata2/prd620_5/prd620.data5',
'/oracle/DEV/sapdata2/prd620_6/prd620.data6',
'/oracle/DEV/sapdata2/prd620_7/prd620.data7',
'/oracle/DEV/sapdata2/prd620_8/prd620.data8',
'/oracle/DEV/sapdata2/prd620_9/prd620.data9',
'/oracle/DEV/sapdata3/prd620_10/prd620.data10',
'/oracle/DEV/sapdata4/prd620_11/prd620.data11',
'/oracle/DEV/sapdata1/prdusr_1/prdusr.data1',
'/oracle/DEV/sapdata2/roll_1/roll.data1',
'/oracle/DEV/sapdata1/system_2/system.data2',
'/oracle/DEV/sapdata4/prd_10/prd.data10',
'/oracle/DEV/sapdata4/prd_11/prd.data11',
'/oracle/DEV/sapdata4/prd_12/prd.data12',
'/oracle/DEV/sapdata4/prd_13/prd.data13',
'/oracle/DEV/sapdata4/prd_14/prd.data14',
'/oracle/DEV/sapdata4/prd_15/prd.data15',
'/oracle/DEV/sapdata4/prd_16/prd.data16',
'/oracle/DEV/sapdata4/prd_17/prd.data17',
'/oracle/DEV/sapdata4/prd_18/prd.data18',
'/oracle/DEV/sapdata4/prd_19/prd.data19',
'/oracle/DEV/sapdata4/prd_20/prd.data20',
'/oracle/DEV/sapdata4/prd_21/prd.data21',
'/oracle/DEV/sapdata4/prd_22/prd.data22',
'/oracle/DEV/sapdata4/prd_23/prd.data23',
'/oracle/DEV/sapdata4/prd_24/prd.data24',
'/oracle/DEV/sapdata4/prd_25/prd.data25',
'/oracle/DEV/sapdata4/prd_26/prd.data26',
'/oracle/DEV/sapdata4/prd_27/prd.data27',
'/oracle/DEV/sapdata4/prd_28/prd.data28',
'/oracle/DEV/sapdata4/prd_29/prd.data29',
'/oracle/DEV/sapdata4/prd_30/prd.data30',
'/oracle/DEV/sapdata4/prd_31/prd.data31',
'/oracle/DEV/sapdata4/prd_32/prd.data32',
'/oracle/DEV/sapdata4/prd_33/prd.data33',
'/oracle/DEV/sapdata4/prd_34/prd.data34',
'/oracle/DEV/sapdata4/prd_35/prd.data35',
'/oracle/DEV/sapdata4/prd_36/prd.data36',
'/oracle/DEV/sapdata4/prd_37/prd.data37',
'/oracle/DEV/sapdata4/prd_38/prd.data38',
'/oracle/DEV/sapdata4/prd_39/prd.data39',
'/oracle/DEV/sapdata4/prd_40/prd.data40',
'/oracle/DEV/sapdata4/prd_41/prd.data41',
'/oracle/DEV/sapdata4/prd_42/prd.data42',
'/oracle/DEV/sapdata4/prd_43/prd.data43',
'/oracle/DEV/sapdata4/prd_44/prd.data44',
'/oracle/DEV/sapdata2/roll_2/roll.data2',
'/oracle/DEV/sapdata2/roll_3/roll.data3',
'/oracle/DEV/sapdata4/prd_45/prd.data45',
'/oracle/DEV/sapdata4/prd_46/prd.data46',
'/oracle/DEV/sapdata4/prd_47/prd.data47',
'/oracle/DEV/sapdata2/roll_4/roll.data4',
'/oracle/DEV/sapdata4/prd_48/prd.data48',
'/oracle/DEV/sapdata4/prd_49/prd.data49',
'/oracle/DEV/sapdata4/prd_50/prd.data50',
'/oracle/DEV/sapdata4/prd_51/prd.data51',
'/oracle/DEV/sapdata4/prd_52/prd.data52',
'/oracle/DEV/sapdata4/prd_53/prd.data53',
'/oracle/DEV/sapdata4/prd_54/prd.data54',
'/oracle/DEV/sapdata4/prd_55/prd.data55',
'/oracle/DEV/sapdata4/prd_56/prd.data56',
'/oracle/DEV/sapdata2/roll_5/roll.data5'
CHARACTER SET WE8DEC
;
root@bssldev1 #
*********CONTENTS OF CONTROL.SQL**********************
Please help...
Regards & Thanks,
Ankita
change control.sql:
CREATE CONTROLFILE REUSE <b>SET</b> DATABASE "DEV" NORESETLOGS ARCHIVELOG
then try again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you delete the old control file?
Do you execute that as root?
--
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.