Problem in Creating controlfile

[Former Member]

Hi All,

am planning to system copy, databse restored succesfuly on target system, created control file on source system.

copied the control file on target system in /oracle/MDQ/saptrace/usertrace and renamed it as control.sql.

when am trying to generate conrol file on target system as : @/oracle/MDQ/saptrace/usertrace/control.sql

getting error as :

ORACLE instance started.

Total System Global Area 2365587456 bytes

Fixed Size 2144144 bytes

Variable Size 1203685488 bytes

Database Buffers 1157627904 bytes

Redo Buffers 2129920 bytes

CREATE CONTROLFILE REUSE SET DATABASE "MDQ" RESETLOGS ARCHIVELOG

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01200: actual file size of 27520 is smaller than correct size of 110080

blocks

ORA-01110: data file 1: '/oracle/MDQ/sapdata1/system_1/system.data1'

ORA-01507: database not mounted

ALTER SYSTEM ARCHIVE LOG ALL

*

ERROR at line 1:

ORA-01507: database not mounted

ALTER DATABASE OPEN

*

ERROR at line 1:

ORA-01507: database not mounted

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/MDQ/sapdata2/temp_1/temp.data1'

*

ERROR at line 1:

ORA-01109: database not open

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

CREATE CONTROLFILE REUSE SET DATABASE "MDQ" RESETLOGS ARCHIVELOG

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01200: actual file size of 27520 is smaller than correct size of 110080

blocks

ORA-01110: data file 1: '/oracle/MDQ/sapdata1/system_1/system.data1'

Kindly suggest.

[Former Member]

problem solved.

thanks to all

[anindya_bose]

Anshu

From the line -> CREATE CONTROLFILE REUSE SET DATABASE "MDQ" RESETLOGS ARCHIVELOG

remove the word ->REUSE

save the file and the try to generate the control file

I guess you are editing the trace file to make control.sql. Did you change all the Source SID to target SID?

Regards

Anindya

Edited by: Anindya Bose on Feb 17, 2010 12:11 PM

[Former Member]

Hi Anindya,

Thanks for reply...

i have checked with both options, but unable to generate..

regards!!

[former_member524429]

Hi,

i have chaecked the size of file system on source and target system, there is a huge differnce.

Please refer this useful document to perform complete [Oracle DB Restore using Offline/Online Backup|http://www.basisconsultant.com/component/remository/Sytem-Copy-Guides/Homogeneous-System-Copy-using-OnlineandOffline-Backup/] in systematic way .

BRARCHIVE - Return code: 0001 Success with warnings ( some offline redolog files not found).

Perform manual Log switching and ensure the availability of Offline Redo log files at Log Archive location (log_archive_dest). Then run Archive Log Backup Job.

Also please refer this useful SAP Note 490976 - BR013W No offline redo log files found for processing, to get info about the other possible causes.

Regards

Bhavik G. Shroff

[former_member524429]

Hi,

01200, 00000, "actual file size of %s is smaller than correct size of %s blocks"
// *Cause:  The size of the file as returned by the operating system is smaller
//         than the size of the file as indicated in the file header and the
//         control file. Somehow the file has been truncated. Maybe it is the
//         result of a half completed copy.
// *Action: Restore a good copy of the data file and do recovery as needed.

Your Restore operation was successful ? May be its a result of Half completed DB Restore Copy.

As, Its looking like Data File Header corruption.

Some other causes are mentioned in SAP Note 696141 - Composite SAP Note: ORA-01122.

You can refer this [thread|] and this [link|/thread/224262 [original link is broken]; (second-last reply) to get more information.

Regards,

Bhavik G. Shroff

Edited by: Bhavik G. Shroff on Feb 17, 2010 12:19 PM

[Former Member]

Hi Bhavik,

Thanks for reply..

you are right .. i have chaecked the size of file system on source and target system, there is a huge differnce.

i have taken whole database offline & redolog bkp & restored on target system.

the same error happen yesterday, & due to not copy of full database I again started the restore steps from starting

but again the same issue.

when i checked in DB13 logs:

1. BRBACKUP - Return code: 0001 Success with warnings ( BR0083W Compression rates out of date - run BRBACKUP with option '-k only')

and in

2. BRARCHIVE - Return code: 0001 Success with warnings ( some offline redolog files not found).

1st error can be solved by executing DB13 --> compress database.

Kindly suggest for 2nd error (BRARCHIVE)

thanks & regards!!