homogeneous system copy error

[Former Member]

i am doing homogeneous system copy on oracle db backup/restore method

can any one pls help me regarding this

thanks in advance.

sapinst_dev.log

INFO       2013-03-02 18:56:35 [syxxccuren.cpp:105]

           CSyCurrentProcessEnvironmentImpl::setWorkingDirectory(iastring)

Working directory changed to E:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP.

TRACE      [iaxohsqlx.hpp:1028]

           COraSQLScriptExec<LoggingStrategy>::executeScript()

Executable started and waited successfully. Return code = 0

TRACE      [iaxohsqlx.hpp:1043]

           COraSQLScriptExec<LoggingStrategy>::executeScript()

COraSQLScriptExec<LoggingStrategy>::executeScript: Script executed with error message.

TRACE      [iaxxejsexp.cpp:199]

           EJS_Installer::writeTraceToLogBook()

OraSqlScript3.execute: Result of SQL:

{errorMessage: "ORA-01194: file 1 needs more recovery to be consistent\nORA-01110: data file 1: \'F:\\ORACLE\\QAS\\SAPDATA1\\SYSTEM_1\\SYSTEM.DATA1\'\n\n\nALTER TABLESPACE PSAPTEMP ADD TEMPFILE \'F:\\ORACLE\\QAS\\SAPDATA2\\TEMP_1\\TEMP.DATA1\'\n*\nERROR at line 1:\nORA-01109: database not open\n\n\nORA-01109: database not open\n\n\nDatabase dismounted.\nORACLE instance shut down.\nORACLE instance started.\n\nTotal System Global Area  675282944 bytes\nFixed Size            1291276 bytes\nVariable Size          348130292 bytes\nDatabase Buffers      322961408 bytes\nRedo Buffers            2899968 bytes\nDatabase mounted.\n\nDatabase altered.\n\nALTER DATABASE OPEN\n*\nERROR at line 1:\nORA-01589: must use RESETLOGS or NORESETLOGS option for database open\n\n\nORA-01109: database not open\n\n\nDatabase dismounted.\nORACLE instance shut down.\nDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production\nWith the Partitioning, OLAP and Data Mining options\n", executionWasSuccessful: false}

ERROR      2013-03-02 18:57:05 [iaxxinscbk.cpp:282]

           abortInstallation

CJS-00084  SQL statement or script failed.<br>DIAGNOSIS: Error message: ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'F:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE 'F:\ORACLE\QAS\SAPDATA2\TEMP_1\TEMP.DATA1'

*

ERROR at line 1:

ORA-01109: database not open

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

ORACLE instance started.

Total System Global Area  675282944 bytes

Fixed Size            1291276 bytes

Variable Size          348130292 bytes

Database Buffers      322961408 bytes

Redo Buffers            2899968 bytes

Database mounted.

Database altered.

ALTER DATABASE OPEN

*

ERROR at line 1:

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

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

.<br>SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

TRACE      [iaxxejsbas.hpp:388]

           handleException<ESAPinstException>()

Converting exception into JS Exception Exception.

ERROR      2013-03-02 18:57:05

           CJSlibModule::writeError_impl()

MUT-03025  Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

TRACE      [iaxxejsbas.hpp:460]

           EJS_Base::dispatchFunctionCall()

JS Callback has thrown unknown exception. Rethrowing.

ERROR      2013-03-02 18:57:05 [iaxxgenimp.cpp:731]

           showDialog()

FCO-00011  The step RunControlScript with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraOBR|ind|ind|ind|ind|4|0|RunControlScript was executed with status ERROR .

when I try to open the database i got these errors

SQL> startup

ORACLE instance started.

Total System Global Area  675282944 bytes

Fixed Size                  1291276 bytes

Variable Size             348130292 bytes

Database Buffers          322961408 bytes

Redo Buffers                2899968 bytes

Database mounted.

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-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'F:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL> recover datafile 'F:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1';

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;

ORA-00279: change 9683550 generated at 03/02/2013 18:42:51 needed for thread 1

ORA-00289: suggestion : F:\ORACLE\QAS\ORAARCH\QASARCHARC00001_0809030552.001

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

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log

'F:\ORACLE\QAS\ORAARCH\QASARCHARC00001_0809030552.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.

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'F:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

[sunny_pahuja2 · Accepted solution]

Hi,

Have you performed the recovery using archive log files ? If yes, then now choose option cancel to cancel the recovery.

Once, media recovery will be cancelled then you need yo open the database using resetlog option.

Thanks

Sunny

[Former Member · Accepted solution]

these archive log files in oraarch folder QASARCHARC00001_0809030552.001

when i apply with AUTO iam getting below error

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'F:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

then after when try to open with resetlogs it is giving error

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'F:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

[sunny_pahuja2 · Accepted solution]

Hi,

Use option "Cancel" instead of AUTO to cancel the recovery then open database with open resetlog option.

Thanks

Sunny

[Former Member · Accepted solution]

i did it ,still error persists

[former_member188883 · Accepted solution]

Hi Navin,

You may need to apply few more logs files to have your database open with resetlogs option.

You may check the last SCN number from the backup log file using which you have restore. You may need to recover atleast to that SCN number.

Regards,

Deepak Kori

[former_member182034 · Accepted solution]

hi navin,

would you confirm me about backup type mean which backup(online, offline) you took?

hopefully, you took offline backup.

Regards

[Former Member · Accepted solution]

hi jamil

I took full offline backup

regards

navin

[former_member182034 · Accepted solution]

hi,

please run below commands,

SQL>recover database using backup controlfile until cancel;

cancel

SQL>alter database open resetlogs;

Regards,

[Former Member · Accepted solution]

hi

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'F:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

then after when try to open with resetlogs it is giving error

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'F:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

regards

navin

[Former Member · Accepted solution]

Hi

SQL> startup

ORACLE instance started.

Total System Global Area  675282944 bytes

Fixed Size                  1291276 bytes

Variable Size             348130292 bytes

Database Buffers          322961408 bytes

Redo Buffers                2899968 bytes

Database mounted.

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-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'F:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL> recover datafile 'F:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1';

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 9683550 generated at 03/02/2013 18:42:51 needed for thread 1

ORA-00289: suggestion : F:\ORACLE\QAS\ORAARCH\QASARCHARC00001_0809030552.001

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

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log

'F:\ORACLE\QAS\ORAARCH\QASARCHARC00001_0809030552.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.

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'F:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

[former_member182034 · Accepted solution]

hi navin,

please run the command

SQL> recover database using backup controlfile until cancel;

here

simple write CANCEL mean don't put the archive

Enter

and then

SQL> alter database open resetlogs;

Regards,

[Former Member · Accepted solution]

Hi

error still exist

SQL>  recover database using backup controlfile until cancel;

ORA-00279: change 9683550 generated at 03/02/2013 18:42:51 needed for thread 1

ORA-00289: suggestion : F:\ORACLE\QAS\ORAARCH\QASARCHARC00001_0809030552.001

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

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

cancel

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'F:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

ORA-01112: media recovery not started

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'F:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

[former_member188883 · Accepted solution]

Hi Navin,

Have you created a new contol file. Please share the details of the contol file which you have created.

Since you have taken full offline backup and restored it, no recovery is required.

You need to create a controlfile by modifying the SID and target paths and then open the database using resetlog option.

Do also check whether this file exists on server F:\ORACLE\QAS\ORAARCH\QASARCHARC00001_0809030552.001

Regards,

Deepak Kori

[Former Member · Accepted solution]

hi

Thank you one and all for all your help

problem got solved

i applied all redo logs one by one

F:\ORACLE\QAS\ORIGLOGA\LOG_G11M1.DBF

F:\ORACLE\QAS\ORIGLOGB\LOG_G12M1.DBF

F:\ORACLE\QAS\ORIGLOGA\LOG_G13M1.DBF

F:\ORACLE\QAS\ORIGLOGB\LOG_G14M1.DBF

from that LOG_G14M1.DBF log file got applied successfuly

SQL>  recover database using backup controlfile until cancel;

ORA-00279: change 9683550 generated at 03/02/2013 18:42:51 needed for thread 1

ORA-00289: suggestion : F:\ORACLE\QAS\ORAARCH\QASARCHARC00001_0809030552.001

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

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

F:\ORACLE\QAS\ORIGLOGB\LOG_G14M1.DBF

Log applied.

Media recovery complete.

when i try open database i got this error

SQL> ALTER DATABASE OPEN RESETLOGS;

ALTER DATABASE OPEN RESETLOGS

*

ERROR at line 1:

ORA-00603: ORACLE server session terminated by fatal error

then i add/edit parameters in initQAS.ora

UNDO_MANAGEMENT=MANUAL

_ALLOW_RESETLOGS_CORRUPTION = TRUE

_ALLOW_ERROR_SIMULATION = TRUE

SQL> startup mount pfile=F:\oracle\QAS\102\database\initQAS.ora

ORACLE instance started.

Total System Global Area  675282944 bytes

Fixed Size                  1291276 bytes

Variable Size             348130292 bytes

Database Buffers          322961408 bytes

Redo Buffers                2899968 bytes

Database mounted.

SQL> alter database open;

Database altered.

then after sometime i again opened the database the below error came

which is undo tablespace got corrupted

SQL> alter database open

  2  ;

alter database open

*

ERROR at line 1:

ORA-00607: Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [4193], [0], [608], [], [], [], [],

then i followed below procedure then database came to open mode and  installation proceeded further, no issues encountered

1. How to recover and open the database if the archive log required for recovery is missing.
2. Recover the Database without Archive Log

Regards

navin

[former_member182034 · Accepted solution]

hi navin,

please check the below link and sap note.

ora-00600

Note 1461804 - Query failed with ORA-00600

after system copy. did you recreate the undo tablespace?

Regards,

[Former Member · Accepted solution]

Hi

yes i droped old undo tablespace and after recreated undo tablespace

before systemcopy only (where installation stoped)

Regards

navin

[Former Member]

Just one tipp:

this problem is for sure not a Windows specific one.

This is an Oracle related problem and I assume that you get more skilled people in the SCN Oracle Forum.

regards

Peter

[former_member182034]

agreed with Peter.

regards,