Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

systemcopy

518226Jun 14 2006 — edited Jun 15 2006
I 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2006
Added on Jun 14 2006
10 comments
385 views