Applying log after restore with Different SID

[Former Member]

Dear Experts,

             I have restore offline Backup with different SID. Now i wanted to apply Log file.Log name is different on Both system. How can I apply log where SID is different.

Thanks & Regards,

Krishna

[Former Member · Accepted solution]

Hi,

I believe you have created a controlfile based on new SID, then applying log files is very simple.

Just rename the archive log files from old SID to new and then start recovery.

Regards,

Nick Loy

[Former Member · Accepted solution]

Dear Buddy,

For offline backup no need to apply archive log file.If you want the upto date , you need to apply..

The same time:while creating control file. before you need to change that text file like NORESETLOGS.

Then after created you controlfile.you can start the recover like the SQL CMD:

RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

the put auto

Then it will ask the sequence log..then you can give..if it is required to change the file you can do and can start recover .

Thank you

Mahendran

[Former Member · Accepted solution]

Hi...

             Thank a lot for your reply. I had restore data base now I am trying to create control file

STARTUP NOMOUNT

CREATE CONTROLFILE SET DATABASE "QAS" RESETLOGS  ARCHIVELOG

MAXLOGFILES 255

MAXLOGMEMBERS 3

MAXDATAFILES 254

MAXINSTANCES 50

MAXLOGHISTORY 11680

LOGFILE

GROUP 1 (

'G:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF',

'G:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF'

) SIZE 50M,

GROUP 2 (

'G:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF',

'G:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF'

) SIZE 50M,

GROUP 3 (

'G:\ORACLE\PRD\ORIGLOGA\LOG_G13M1.DBF',

'G:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF'

) SIZE 50M,

GROUP 4 (

'G:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF',

'G:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF'

) SIZE 50M

-- STANDBY LOGFILE

DATAFILE

'G:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',

'G:\ORACLE\PRD\SAPDATA1\UNDO_1\UNDO.DATA1',

'G:\ORACLE\PRD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1',

'G:\ORACLE\PRD\SAPDATA3\SR3_1\SR3.DATA1',

'G:\ORACLE\PRD\SAPDATA3\SR3_2\SR3.DATA2',

'G:\ORACLE\PRD\SAPDATA3\SR3_3\SR3.DATA3',

'G:\ORACLE\PRD\SAPDATA3\SR3_4\SR3.DATA4',

'G:\ORACLE\PRD\SAPDATA3\SR3_5\SR3.DATA5',

'G:\ORACLE\PRD\SAPDATA3\SR3_6\SR3.DATA6',

'G:\ORACLE\PRD\SAPDATA3\SR3_7\SR3.DATA7',

'G:\ORACLE\PRD\SAPDATA3\SR3_8\SR3.DATA8',

'G:\ORACLE\PRD\SAPDATA3\SR3_9\SR3.DATA9',

'G:\ORACLE\PRD\SAPDATA3\SR3_10\SR3.DATA10',

'G:\ORACLE\PRD\SAPDATA3\SR3_11\SR3.DATA11',

'G:\ORACLE\PRD\SAPDATA3\SR3_12\SR3.DATA12',

'G:\ORACLE\PRD\SAPDATA3\SR3_13\SR3.DATA13',

'G:\ORACLE\PRD\SAPDATA3\SR3_14\SR3.DATA14',

'G:\ORACLE\PRD\SAPDATA2\SR3700_1\SR3700.DATA1',

'G:\ORACLE\PRD\SAPDATA2\SR3700_2\SR3700.DATA2',

'G:\ORACLE\PRD\SAPDATA2\SR3700_3\SR3700.DATA3',

'G:\ORACLE\PRD\SAPDATA2\SR3700_4\SR3700.DATA4',

'G:\ORACLE\PRD\SAPDATA2\SR3700_5\SR3700.DATA5',

'G:\ORACLE\PRD\SAPDATA2\SR3700_6\SR3700.DATA6',

'G:\ORACLE\PRD\SAPDATA2\SR3700_7\SR3700.DATA7',

'G:\ORACLE\PRD\SAPDATA2\SR3700_8\SR3700.DATA8',

'G:\ORACLE\PRD\SAPDATA2\SR3700_9\SR3700.DATA9',

'G:\ORACLE\PRD\SAPDATA2\SR3700_10\SR3700.DATA10',

'G:\ORACLE\PRD\SAPDATA2\SR3700_11\SR3700.DATA11',

'G:\ORACLE\PRD\SAPDATA2\SR3700_12\SR3700.DATA12',

'G:\ORACLE\PRD\SAPDATA2\SR3700_13\SR3700.DATA13',

'G:\ORACLE\PRD\SAPDATA2\SR3700_14\SR3700.DATA14',

'G:\ORACLE\PRD\SAPDATA2\SR3700_15\SR3700.DATA15',

'G:\ORACLE\PRD\SAPDATA4\SR3USR_1\SR3USR.DATA1',

'G:\ORACLE\PRD\SAPDATA3\SR3_15\SR3.DATA15',

'G:\ORACLE\PRD\SAPDATA3\SR3_16\SR3.DATA16',

'G:\ORACLE\PRD\SAPDATA3\SR3_17\SR3.DATA17',

'G:\ORACLE\PRD\SAPDATA3\SR3_18\SR3.DATA18',

'G:\ORACLE\PRD\SAPDATA3\SR3_19\SR3.DATA19',

'G:\ORACLE\PRD\SAPDATA2\SR3700_16\SR3700.DATA16',

'G:\ORACLE\PRD\SAPDATA2\SR3700_17\SR3700.DATA17',

'G:\ORACLE\PRD\SAPDATA2\SR3700_18\SR3700.DATA18',

'G:\ORACLE\PRD\SAPDATA2\SR3700_19\SR3700.DATA19',

'G:\ORACLE\PRD\SAPDATA2\SR3700_20\SR3700.DATA20',

'G:\ORACLE\PRD\SAPDATA3\SR3_20\SR3.DATA20'

CHARACTER SET UTF8

;

.I m getting below error

ORA-01503: CREATE CONTROLFILE failed

ORA-01565: error in identifying file

'G:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

ORA-27041: unable to open file

OSD-04002: unable to open file

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

Please do needful.

Thanks,

krishna

[Former Member · Accepted solution]

Hi,

Did you check that the data file SYSTEM.DATA1 is present in the location where the control file is pointing to. Is the path correct?

G:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1.

Thanks

Rishi Abrol

[Reagan · Accepted solution]

Hello

The problem is that you are creating control files for the system with SID QAS and the path for all the files are pointing to PRD and not QAS.

'G:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

Instead of G:\ORACLE\PRD it should be G:\ORACLE\QAS not just for the above entry but for all the PRD references in the script.

Replace all PRD with QAS and create the control files.

Regards

RB