systemcopy
518226Jun 14 2006 — edited Jun 15 2006I want to copy the production database into the development database.
i have create an tracefile on the production database and modify it as follow
CREATE CONTROLFILE SET DATABASE "AK1" RESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 254
MAXINSTANCES 50
MAXLOGHISTORY 9075
LOGFILE
GROUP 11 (
'/oracle/AK1/origlogA/log_g11m1.dbf',
'/oracle/AK1/mirrlogA/log_g11m2.dbf'
) SIZE 20M,
GROUP 12 (
'/oracle/AK1/origlogB/log_g12m1.dbf',
'/oracle/AK1/mirrlogB/log_g12m2.dbf'
) SIZE 20M,
GROUP 13 (
'/oracle/AK1/origlogA/log_g13m1.dbf',
'/oracle/AK1/mirrlogA/log_g13m2.dbf'
) SIZE 20M,
GROUP 14 (
'/oracle/AK1/origlogB/log_g14m1.dbf',
'/oracle/AK1/mirrlogB/log_g14m2.dbf'
) SIZE 20M
-- STANDBY LOGFILE
DATAFILE
'/oracle/AK1/sapdata1/system_1/system.data1',
'/oracle/AK1/sapdata1/roll_1/roll.data1',
'/oracle/AK1/sapdata1/temp_1/temp.data1',
'/oracle/AK1/sapdata1/temp_2/temp.data2',
'/oracle/AK1/sapdata1/temp_3/temp.data3',
'/oracle/AK1/sapdata4/stabi_1/stabi.data1',
'/oracle/AK1/sapdata4/stabi_2/stabi.data2',
'/oracle/AK1/sapdata4/stabi_3/stabi.data3',
'/oracle/AK1/sapdata3/stabd_1/stabd.data1',
'/oracle/AK1/sapdata3/stabd_2/stabd.data2',
'/oracle/AK1/sapdata3/stabd_3/stabd.data3',
'/oracle/AK1/sapdata5/btabi_1/btabi.data1',
'/oracle/AK1/sapdata5/btabi_2/btabi.data2',
'/oracle/AK1/sapdata5/btabi_3/btabi.data3',
'/oracle/AK1/sapdata5/btabi_4/btabi.data4',
'/oracle/AK1/sapdata5/btabi_5/btabi.data5',
'/oracle/AK1/sapdata2/btabd_1/btabd.data1',
'/oracle/AK1/sapdata2/btabd_2/btabd.data2',
'/oracle/AK1/sapdata2/btabd_3/btabd.data3',
'/oracle/AK1/sapdata2/btabd_4/btabd.data4',
'/oracle/AK1/sapdata2/btabd_5/btabd.data5',
'/oracle/AK1/sapdata2/btabd_6/btabd.data6',
'/oracle/AK1/sapdata2/btabd_7/btabd.data7',
'/oracle/AK1/sapdata2/btabd_8/btabd.data8',
'/oracle/AK1/sapdata5/pooli_1/pooli.data1',
'/oracle/AK1/sapdata1/poold_1/poold.data1',
'/oracle/AK1/sapdata1/poold_2/poold.data2',
'/oracle/AK1/sapdata1/poold_3/poold.data3',
'/oracle/AK1/sapdata4/clui_1/clui.data1',
'/oracle/AK1/sapdata6/clud_1/clud.data1',
'/oracle/AK1/sapdata6/clud_2/clud.data2',
'/oracle/AK1/sapdata6/clud_3/clud.data3',
'/oracle/AK1/sapdata6/clud_4/clud.data4',
'/oracle/AK1/sapdata4/ddici_1/ddici.data1',
'/oracle/AK1/sapdata4/ddicd_1/ddicd.data1',
'/oracle/AK1/sapdata4/docui_1/docui.data1',
'/oracle/AK1/sapdata4/docud_1/docud.data1',
'/oracle/AK1/sapdata2/btabd_10/btabd.data10.dbf',
'/oracle/AK1/sapdata5/btabi_6/btabi.data6',
'/oracle/AK1/sapdata4/loadi_1/loadi.data1',
'/oracle/AK1/sapdata4/loadd_1/loadd.data1',
'/oracle/AK1/sapdata4/proti_1/proti.data1',
'/oracle/AK1/sapdata1/protd_1/protd.data1',
'/oracle/AK1/sapdata7/btabd_11/btabd.data11',
'/oracle/AK1/sapdata7/btabd_12/btabd.data12',
'/oracle/AK1/sapdata7/stabi_6/stabi.data6',
'/oracle/AK1/sapdata4/sourcei_1/sourcei.data1',
'/oracle/AK1/sapdata4/sourced_1/sourced.data1',
'/oracle/AK1/sapdata4/user1i_1/user1i.data1',
'/oracle/AK1/sapdata4/user1d_1/user1d.data1',
'/oracle/AK1/sapdata4/stabi_4/stabi.data4',
'/oracle/AK1/sapdata7/clud_5/clud.data5',
'/oracle/AK1/sapdata2/btabd_9/btabd.data9',
'/oracle/AK1/sapdata1/el620d_1/el620d.data1',
'/oracle/AK1/sapdata1/el620i_1/el620i.data1',
'/oracle/AK1/sapdata1/es620d_1/es620d.data1',
'/oracle/AK1/sapdata1/es620d_2/es620d.data2',
'/oracle/AK1/sapdata1/es620i_1/es620i.data1',
'/oracle/AK1/sapdata1/system_2/system.data2',
'/oracle/AK1/sapdata4/ddicd_2/ddicd.data2',
'/oracle/AK1/sapdata4/ddici_2/ddici.data2',
'/oracle/AK1/sapdata3/stabd_4/stabd.data4',
'/oracle/AK1/sapdata4/stabi_5/stabi.data5',
'/oracle/AK1/sapdata7/clui_2/clui.data2',
'/oracle/AK1/sapdata7/btabi_7/btabi.data7',
'/oracle/AK1/sapdata5/pooli_2/pooli.data2',
'/oracle/AK1/sapdata1/poold_4/poold.data4'
CHARACTER SET WE8DEC
;
after i copied the files to the development database i did the following:
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1364029488 bytes
Fixed Size 737328 bytes
Variable Size 788529152 bytes
Database Buffers 573440000 bytes
Redo Buffers 1323008 bytes
SQL> @/oracle/AK1/createAK1_New.sql
CREATE CONTROLFILE SET DATABASE "AK1" RESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name AP1 in file header does not match given name of AK1
ORA-01110: data file 45: '/oracle/AK1/sapdata7/btabd_12/btabd.data12'
could you help me?