on 01-29-2011 8:16 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.