cancel
Showing results for 
Search instead for 
Did you mean: 

Recover database

Former Member
0 Kudos

Dear Guru's

Am getting this error when am tring to restore database by coping the sapdata1....4 from source to the target and

created the control file but

SQL> @/oracle/ZEQ/102_64/dbs/control.sql

ORACLE instance started.

Total System Global Area 2399141888 bytes

Fixed Size 2073128 bytes

Variable Size 1207963096 bytes

Database Buffers 1174405120 bytes

Redo Buffers 14700544 bytes

Control file created.

SQL> Recover Database using backup controlfile until Cancel; and get the following error

SQL> Recover Database using backup controlfile until Cancel;

ORA-00283: recovery session canceled due to errors

ORA-01201: file 1 header failed to write correctly

Please advised me what to do

Regards

Mohammed

Accepted Solutions (1)

Accepted Solutions (1)

volker_borowski2
Active Contributor
0 Kudos

Hi,

check if you have write permission on all datafiles

ls -l /oracle/???/sapdata//.

Check your CREATE CONTROLFILE statement.

If you change the SID, it is mandantory to include SET DATABASE "SID" and use RESETLOGS !

Volker

Answers (3)

Answers (3)

audunlea_hansen
Active Participant
0 Kudos

Hi!

When you copied those database files from source, was the source database shut down?

Du you have write permission on those target cataloges/files? Which user are you using when trying to start the db.

There are a number of ways to duplicate a database, but you need to follow one of the methods.. It's impossible to tell you whats wrong here since you haven't said anything of which way you are doing it.

Regards

Audun

DBA

Former Member
0 Kudos

Hi,

Did u trying to recover database from backup files or database file?

If it is from backup file (taken thru any tools like brtools etc), it can be recovered using the same, or else try this one

download STM tools from service market place and try to recover thru it.

Regards,

Rajan

Former Member
0 Kudos

Check SAP Note 941517 - Recovery over resetlogs operation.

also check the below links they might give come clues