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.

SQL> STARTUP NOMOUNT PFILE=E:\ORACLE\RYV\102\database\initRYV.ora

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

ORA-01110: data file 1: 'K:\ORACLE\RYV\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

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

1

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

'F:\ORACLE\RYV\ORAARCH\RYVARCHARC04733_0649429988.001'

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

SQL>

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.

Regards

Ravi

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