Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem opening database after successfull recovery

Hi All,

Can any one please help me with below error.

I am doing system copy from Source_SID to Target_SID taking online backup and generated offline redo log files during start of backup to end.

We are on Windows 2003 server, DB is Oracle 10g and system is SRM 5.0. I was trying system copy backup/restore for DB and export/import for java. I have got online consistent backup along with offline redo logs of source system. Also have taken CI export.

Here the file system directories in TARGET_SID and SOURCE_SID are different. First i have restored the online backup of Source_SID in Target_SID system (RYV). Took the trace file of Source_SID system and modified accordingly the filesystem structure directories of the TARGET SySTEM. Also renamed the TARGET_SID to SOURCE_SID.

Now started it in nomount state with below command.


ORACLE instance started.

Total System Global Area 2634022912 bytes

Fixed Size 2203184 bytes

Variable Size 1337811408 bytes

Database Buffers 1291845632 bytes

Redo Buffers 2162688 bytes

Generated the modifiled trace file script (renamed it as controlfile.sql).

SQL> @Controlfile.sql

Control file created.

SQL> alter database open;

alter database open


ERROR at line 1:

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

SQL> alter database open resetlogs;

alter database open resetlogs


ERROR at line 1:

ORA-01195: online backup of file 1 needs more recovery to be consistent


Before executing the command i have places all the offline redo log files which were generated in source system during the online backup. During online backup, offline redo logs 04729 to 04732 were generated. Now i have issued below command.

SQL> alter database recover automatic using backup controlfile until cancel;

alter database recover automatic using backup controlfile until cancel


ERROR at line 1:

ORA-00279: change 112926870 generated at 09/29/2008 17:26:55 needed for thread


ORA-00289: suggestion : F:\ORACLE\RYV\ORAARCH\RYVARCHARC04733_0649429988.001

ORA-00280: change 112926870 for thread 1 is in sequence #4733

ORA-00278: log file 'F:\ORACLE\RYV\ORAARCH\RYVARCHARC04733_0649429988.001' no

longer needed for this recovery

ORA-00308: cannot open archived log


ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

Offline Redo log files from 04729 to 04732 were applied and it was trying for 04733 which was not there. Now issued below command.

SQL> recover cancel;

Media recovery complete.

Finally tried to open database with resetlogs and here i am getting problem.

SQL> alter database open resetlogs;

alter database open resetlogs


ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced


Please suggest whether is there different procedure for system copy using backup/restore if file structure is different for Source_SID and Target_SID.

Thanking you for your help.



Former Member
Not what you were looking for? View more on this topic or Ask a question