Homogeneous System Copy Issue

[Former Member]

Hi all,

First I took backup of my development system and started System copy with database backup

(1)When I used "Online or Offline recovery with saphostctrl" option I'm getting below error

(2) When I used "Control_sql file created with the Orabrcopy tool" option I'm getting below error

Can anyone tell me why I'm getting these errors & how to resolve these issues.

Regards,

Sheshi Kumar

[Former Member]

Hi Shishi,

Please compare the path level of both the oracle instances.

Regards

Chetan

[Former Member]

Hi Sheshi ,

Have you done below mentioned steps after database restore ?

After restoring datafiles and redolog files, a script must be prepared on source system to create CONTROLFILE of target system.

Use SQLPLUS to create a script to create controlfile using current CONTROLFILE content. Login to source system as QSGadm user and execute the following SQLPLUS commands. To be able to execute following commands, database must be at least in MOUNT mode.

SQL>alter database backup controlfile to trace;

As a result of this command, a trace file (e.g. qsg_ora_6944) will be created under /oracle//saptace/usertrace directory.

You have to edit this file to be able to use for CONTROLFILE creation on target system.

1. a.       Rename file name as CONTROL.SQL
2. b.      Open file to edit using NOTEPAD.
3. c.       Remove all lines before "STARTUP MOUNT" line. Delete all commented "#" lines. Also remove all lines after CHARACTER SET UTF8;" line.
4. d.      Change all Source PSG SID to QSG SID (use ctrl+H)

Change the line

CREATE CONTROLFILE REUSE DATABASE ‘PSG’ NORESETLOGS ARCHIVELOG;

As follow

CREATE CONTROLFILE REUSE SET DATABASE ‘QSG’ RESETLOGS ARCHIVELOG;

If you want to change datafile or redolog file destinations, first move the files on target destination at OS level, then edit CONTROL.SQL file for new destinations.

After CONTROL.SQL script preparation, following commands must be run to create CONTROLFILE of target system:

Database will be in inconsistent status after creation of CONTROLFILE. This can be viewed by trying to open the database.

SQL> alter database open;

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

At this step, a recovery must be made in order to be able to use the database.

If your source system is running in NOARCHIVELOG mode, then you have to use the following command to recover database.

SQL> recover database using backup controlfile until cancel;

If you restored an online backup on target system and put all the archive files created since online backup start time, use the following commands.

SQL> recover database using backup controlfile;

After execution of this command, Oracle will ask for archive files to be consistent. As archive files contains only database changes commands, you will use source system archive file on new systems database recovery. Copy all archive files created since online backup on source system to archive directory of target system. Archive file names are different from asked during recovery session. You can change archive file names for target system manually.

But recovery session must be started with the following command and cancelled again to be able to start database.

Otherwise following error will arise during database opening.

SQL> alter database open resetlogs;

alter database open resetlogs * ORA-01113: file 1 needs media recovery ORA-01110: data file 1: '/oracle/QSG/sapdata1/system_1/system.data1'

To open database, use the following command:

SQL> alter database open resetlogs;

  After opening database, LISTENER process must be started.

Note : if you have already Done this steps .Please attached ora_sql_results.log as gaurav said .

[former_member182657]

Hi Sheshi,

Could you share ora_sql_results.log file from the system ?

Regards,