Skip to Content
author's profile photo Former Member
0
Former Member
Feb 04, 2013 at 04:34 AM

SAP datarestore with differnt SID and drive letter

154 Views

Dear GURUs,

I wated to restore our prd data our QAS system.source(PRD) and target QAS) system are database drive are different.I have created control file.

below is source system file.

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "PRD" 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'

CHARACTER SET UTF8

;

For my target QAS system system drive letter is C: instead of g: so i had change it c: and change SID . Please check that below control file. ok or not

STARTUP NOMOUNT

CREATE CONTROLFILE SET DATABASE "QAS" RESETLOGS ARCHIVELOG

MAXLOGFILES 255

MAXLOGMEMBERS 3

MAXDATAFILES 254

MAXINSTANCES 50

MAXLOGHISTORY 11680

LOGFILE

GROUP 1 (

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

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

) SIZE 50M,

GROUP 2 (

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

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

) SIZE 50M,

GROUP 3 (

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

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

) SIZE 50M,

GROUP 4 (

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

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

) SIZE 50M

-- STANDBY LOGFILE

DATAFILE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

'C:\ORACLE\PRD\SAPDATA4\SR3USR_1\SR3USR.DATA1'

CHARACTER SET UTF8

;

Please check it this file. is it correct or now. is there any other change i need in this file.