on 02-04-2013 4:34 AM
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.
Hi Sahil,
In your case you need to change the drive location in the backup file which shall be used for restoration. Once the restore is done you shall use the above mentioned contolfile to create new controlfiles and then recover your database.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Perform the following actions.
1. First copy the data files from the source to Target location. ( Copy as per the control file).
2. Then create the control file.
3. If the datafile is not present as per the control file, you will face the error.
4. Create the control file.
5. Copy the archive logs from source to target and change the SID from PRD to QAS.
6. Recover the database and apply the logs.
Please check and provide your feedback.
Thanks and Regards,
Vimal
when i m creating new control file.what I have change SID PRD to QAS
CREATE CONTROLFILE REUSE DATABASE "PRD" RESETLOGS ARCHIVELOG
and in below code tooo. should i change PRD to QAS for target system control file.?
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.DA
Yes. You have to change it.
As well as for example, you have to create a folder 'G:\ORACLE\QAS\SAPDATA1\SYSTEM_1 and then try to copy the SYSTEM.DATA1 file to it.
Please do the same for the rest of the files.
G:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 , here PRD resembles the folder name....
Please check and provide your feedback.
Hi,
Please find the steps
1) Take offline backup of both the server (source and target servers)
2) Verify the backup is successfully done.
3) Run the following command on source system.
a) Login as <sid>adm
b) Sqlplus /nolog
c) connect sys as sysdba
d) alter database backup controlfile to trace;
e) exit;
f) Above command will generate a .trc file in /oracle/P01/saptrace/usertrace
g) Copy the text from CREATE CONTROLFILE until the (;) and paste it in to any new.sql or controlfile.sql file.
h) Copy the controlfile.sql to target system.
i) Edit the file and replace the entire source SID to target SID.
j) Edit the reuse database command with the set database command
4) Copy the aft generated during the backup file from the source system to target
a) Change the entire source <SID> to target <SID>.
b) Only don't change the backup volume name it must be target system <SID>.
target<SID>.log file.
5) Shutdown the target server instance.
6) From this onwards all the command on the target system only.
a) Login as <SID>adm
b) run the SAPDBA
c) select J (Restore/Recovery)
d) select B (Full restore and recovery)
e) select A (Select backup of type)
f) Select the offline backup which you want to restore
g) It will take some time to restore.
h) Once the database is restored login as <SID>adm and run the
i) Sqlplus
j) connect sys as sysdba;
k) startup nomount (if the database is already mounted shutdown it using the
shutdown command)
l) run the following command
m) @controlfile.sql (file name of the control file contains the CREATE CONTROLFILEstatement)
n) After the run the above command it should give the "Statement Processed)
o) alter database open resetlogs p. shutdown
p) Start the database and SAP services using startup.
Regards
Mukunthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please explain step 4 in details:
"
4) Copy the aft generated during the backup file from the source system to target
a) Change the entire source <SID> to target <SID>.b) Only don't change the backup volume name it must be target system <SID>.
target<SID>.log file."
I am getting following errors:
BR0386E File '/oracle/PES/sapdata3/sr3700_13/sr3700.data13' reported as not found by backup utility
BR0386E File '/oracle/PES/sapdata2/sr3_17/sr3.data17' reported as not found by backup utility
BR0386E File '/oracle/PES/sapdata2/sr3_2/sr3.data2' reported as not found by backup utility
BR0386E File '/oracle/PES/sapdata1/sr3_24/sr3.data24' reported as not found by backup utility
BR0386E File '/oracle/PES/sapdata2/sr3_20/sr3.data20' reported as not found by backup utility
BR0386E File '/oracle/PES/sapdata2/sr3_6/sr3.data6' reported as not found by backup utility
BR0386E File '/oracle/PES/sapdata1/sr3_27/sr3.data27' reported as not found by backup utility
BR0386E File '/oracle/PES/sapdata2/sr3_16/sr3.data16' reported as not found by backup utility
BR0386E File '/oracle/PES/sapdata4/sr3700_26/sr3700.data26' reported as not found by backup utility
BR0386E File '/oracle/PES/sapdata2/sr3_13/sr3.data13' reported as not found by backup utility
BR0386E File '/oracle/PES/sapdata3/sr3700_16/sr3700.data16' reported as not found by backup utility
BR0386E File '/oracle/PES/sapdata2/sr3_7/sr3.data7' reported as not found by backup utility
BR0386E File '/oracle/PES/sapdata3/sr3700_12/sr3700.data12' reported as not found by backup utility
BKI1215I: Average transmission rate was 0.000 GB/h (0.000 MB/sec).
BKI0020I: End of program at: Thu 13 Jun 2013 10:50:23 AM BDT .
BKI0021I: Elapsed time: 01 sec .
BKI0024I: Return code is: 2.
BR0280I BRRESTORE time stamp: 2013-06-13 10.50.23
BR0279E Return code from '/usr/sap/PES/SYS/exe/run/backint -u PES -f restore -i /oracle/PES/sapbackup/.relkjszq.lst -t file -p /oracle/PES/112_64/dbs/initPES.utl -c': 2
BR0374E 0 of 61 files restored by backup utility
BR0280I BRRESTORE time stamp: 2013-06-13 10.50.23
BR0231E Backup utility call failed
BR0406I End of file restore: relkjszq.rsb 2013-06-13 10.50.23
BR0280I BRRESTORE time stamp: 2013-06-13 10.50.23
BR0404I BRRESTORE terminated with errors
regards,
Hello
Create a file called control.sql in the home directory of qasadm and put the below contents is the file and save it:
CREATE CONTROLFILE SET DATABASE "QAS" RESETLOGS ARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 254
MAXINSTANCES 50
MAXLOGHISTORY 11680
LOGFILE
GROUP 1 (
'C:\ORACLE\QAS\ORIGLOGA\LOG_G11M1.DBF',
'C:\ORACLE\QAS\MIRRLOGA\LOG_G11M2.DBF'
) SIZE 50M,
GROUP 2 (
'C:\ORACLE\QAS\ORIGLOGB\LOG_G12M1.DBF',
'C:\ORACLE\QAS\MIRRLOGB\LOG_G12M2.DBF'
) SIZE 50M,
GROUP 3 (
'C:\ORACLE\QAS\ORIGLOGA\LOG_G13M1.DBF',
'C:\ORACLE\QAS\MIRRLOGA\LOG_G13M2.DBF'
) SIZE 50M,
GROUP 4 (
'C:\ORACLE\QAS\ORIGLOGB\LOG_G14M1.DBF',
'C:\ORACLE\QAS\MIRRLOGB\LOG_G14M2.DBF'
) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'C:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',
'C:\ORACLE\QAS\SAPDATA1\UNDO_1\UNDO.DATA1',
'C:\ORACLE\QAS\SAPDATA1\SYSAUX_1\SYSAUX.DATA1',
'C:\ORACLE\QAS\SAPDATA3\SR3_1\SR3.DATA1',
'C:\ORACLE\QAS\SAPDATA3\SR3_2\SR3.DATA2',
'C:\ORACLE\QAS\SAPDATA3\SR3_3\SR3.DATA3',
'C:\ORACLE\QAS\SAPDATA3\SR3_4\SR3.DATA4',
'C:\ORACLE\QAS\SAPDATA3\SR3_5\SR3.DATA5',
'C:\ORACLE\QAS\SAPDATA3\SR3_6\SR3.DATA6',
'C:\ORACLE\QAS\SAPDATA3\SR3_7\SR3.DATA7',
'C:\ORACLE\QAS\SAPDATA3\SR3_8\SR3.DATA8',
'C:\ORACLE\QAS\SAPDATA3\SR3_9\SR3.DATA9',
'C:\ORACLE\QAS\SAPDATA3\SR3_10\SR3.DATA10',
'C:\ORACLE\QAS\SAPDATA3\SR3_11\SR3.DATA11',
'C:\ORACLE\QAS\SAPDATA3\SR3_12\SR3.DATA12',
'C:\ORACLE\QAS\SAPDATA3\SR3_13\SR3.DATA13',
'C:\ORACLE\QAS\SAPDATA3\SR3_14\SR3.DATA14',
'C:\ORACLE\QAS\SAPDATA2\SR3700_1\SR3700.DATA1',
'C:\ORACLE\QAS\SAPDATA2\SR3700_2\SR3700.DATA2',
'C:\ORACLE\QAS\SAPDATA2\SR3700_3\SR3700.DATA3',
'C:\ORACLE\QAS\SAPDATA2\SR3700_4\SR3700.DATA4',
'C:\ORACLE\QAS\SAPDATA2\SR3700_5\SR3700.DATA5',
'C:\ORACLE\QAS\SAPDATA2\SR3700_6\SR3700.DATA6',
'C:\ORACLE\QAS\SAPDATA2\SR3700_7\SR3700.DATA7',
'C:\ORACLE\QAS\SAPDATA2\SR3700_8\SR3700.DATA8',
'C:\ORACLE\QAS\SAPDATA2\SR3700_9\SR3700.DATA9',
'C:\ORACLE\QAS\SAPDATA2\SR3700_10\SR3700.DATA10',
'C:\ORACLE\QAS\SAPDATA2\SR3700_11\SR3700.DATA11',
'C:\ORACLE\QAS\SAPDATA2\SR3700_12\SR3700.DATA12',
'C:\ORACLE\QAS\SAPDATA2\SR3700_13\SR3700.DATA13',
'C:\ORACLE\QAS\SAPDATA2\SR3700_14\SR3700.DATA14',
'C:\ORACLE\QAS\SAPDATA2\SR3700_15\SR3700.DATA15',
'C:\ORACLE\QAS\SAPDATA4\SR3USR_1\SR3USR.DATA1'
CHARACTER SET UTF8
;
sqlplus "/as sysdba"
startup nomount
@control.sql
alter database open resetlogs;
Cheers
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.