DB Copy - ORA-01503: CREATE CONTROLFILE failed

[Former Member]

Hello,

I´ve posted the original message on my webspace, the message was displayed here in the forum without any Returns/Spaces

so it will be better to read!

Sincerely,

Alessandro

Edited by: Alessandro La Micela on Feb 16, 2010 3:58 AM

Edited by: Alessandro La Micela on Feb 16, 2010 4:11 AM

[former_member524429 · Accepted solution]

Hi,

You Control file script should have this line for Target System.

CREATE CONTROLFILE REUSE SET DATABASE u2018TSIDu2019 RESETLOGS ARCHIVELOG;

Also, Ensure that you have specified correct path for all data files and redo log files according to the directory location on Target System.

Please refer this useful [Oracle DB Copy Guide for SAP System Copy|http://www.basisconsultant.com/component/remository/Sytem-Copy-Guides/Homogeneous-System-Copy-using-OnlineandOffline-Backup/]. Register yourself to download document. Please see the Step 4 of that guide.

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

Hi,

thank you very MUCH for your help! I will change the command line to "RESETLOGS" and edit all folder path (mirror logs/orig logs) to the settings of the target system.

Sincerely,

Alessandro

[Former Member · Accepted solution]

Hi,

Iu00B4ve modified the .sql skript to Resetlogs, shutdown oracle with "shutdown immediate" and deleted all control files which are written in the paths of the spfile.

Now i get the following messages:

SQL> @D:\oracle\T12\saptrace\usertrace\creatt12-2.sql

ORACLE instance started.

Total System Global Area 796917760 bytes

Fixed Size 2069096 bytes

Variable Size 541068696 bytes

Database Buffers 251658240 bytes

Redo Buffers 2121728 bytes

Control file created.

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

ALTER SYSTEM ARCHIVE LOG ALL

*

ERROR at line 1:

ORA-01649: operation not allowed with a backup control file

ALTER DATABASE OPEN

*

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SIZE 20000M SET AUTOEXTEND OFF

*

ERROR at line 2:

ORA-00933: SQL command not properly ended

ORA-01081: cannot start already-running ORACLE - shut it down first

CREATE CONTROLFILE SET DATABASE "T12" RESETLOGS ARCHIVELOG

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01100: database already mounted

I`m wondering why it says the "ORA-01589" again.

Sincerely,

Alessandro

[former_member524429 · Accepted solution]

Hi,

Database will be in inconsistent status after creation of CONTROLFILE. DB Recovery must be made in order to be able to use the database.

All required Post-processing steps after generating Control files for Target System, are well described for different recovery scenarios in that [suggested Guide|http://www.basisconsultant.com/component/remository/Sytem-Copy-Guides/Homogeneous-System-Copy-using-OnlineandOffline-Backup/].Please read them carefully and do the needful.

All the recovery types must be used by "USING BACKUP CONTROLFILE" as CONTROLFILE is created manually.

Try to execute following commands for recovery in sequence.

#recover database using backup controlfile;

(Apply all available Archive files and then cancel it.)

then execute

#recover database using backup controlfile until cancel;

CANCEL it

then execue

#alter database open resetlogs;

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

Hi,

thank you very much! The solution and commands worked fine, now the restore asks for a redo log file which we have to copy from the source system to the target system.

Thanks again!

Sincerely,

Alessandro