on 10-27-2014 5:31 AM
SAP System refresh with offline drive back up
Hi,
I wanted to perform quality system refresh.Client had provided offline backup of drives.Prodcuion system SID is P11 and Quality system SID is QI1.
Data file are for Production system are as below.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
R:\ORACLE\P11\SAPDATA1\SYSTEM_1\SYSTEM.DATA1
R:\ORACLE\P11\SAPDATA1\UNDO_1\UNDO.DATA1
R:\ORACLE\P11\SAPDATA1\SYSAUX_1\SYSAUX.DATA1
R:\ORACLE\P11\SAPDATA3\SR3_1\SR3.DATA1
R:\ORACLE\P11\SAPDATA3\SR3_2\SR3.DATA2
R:\ORACLE\P11\SAPDATA3\SR3_3\SR3.DATA3
R:\ORACLE\P11\SAPDATA3\SR3_4\SR3.DATA4
R:\ORACLE\P11\SAPDATA3\SR3_5\SR3.DATA5
R:\ORACLE\P11\SAPDATA3\SR3_6\SR3.DATA6
R:\ORACLE\P11\SAPDATA3\SR3_7\SR3.DATA7
R:\ORACLE\P11\SAPDATA3\SR3_8\SR3.DATA8
NAME
--------------------------------------------------------------------------------
R:\ORACLE\P11\SAPDATA3\SR3_9\SR3.DATA9
R:\ORACLE\P11\SAPDATA3\SR3_10\SR3.DATA10
R:\ORACLE\P11\SAPDATA3\SR3_11\SR3.DATA11
R:\ORACLE\P11\SAPDATA3\SR3_12\SR3.DATA12
R:\ORACLE\P11\SAPDATA3\SR3_13\SR3.DATA13
R:\ORACLE\P11\SAPDATA3\SR3_14\SR3.DATA14
R:\ORACLE\P11\SAPDATA3\SR3_15\SR3.DATA15
R:\ORACLE\P11\SAPDATA3\SR3_16\SR3.DATA16
S:\ORACLE\P11\SAPDATA2\SR3701_1\SR3701.DATA1
S:\ORACLE\P11\SAPDATA2\SR3701_2\SR3701.DATA2
S:\ORACLE\P11\SAPDATA2\SR3701_3\SR3701.DATA3
NAME
--------------------------------------------------------------------------------
S:\ORACLE\P11\SAPDATA2\SR3701_4\SR3701.DATA4
S:\ORACLE\P11\SAPDATA2\SR3701_5\SR3701.DATA5
S:\ORACLE\P11\SAPDATA2\SR3701_6\SR3701.DATA6
S:\ORACLE\P11\SAPDATA2\SR3701_7\SR3701.DATA7
S:\ORACLE\P11\SAPDATA2\SR3701_8\SR3701.DATA8
S:\ORACLE\P11\SAPDATA2\SR3701_9\SR3701.DATA9
S:\ORACLE\P11\SAPDATA2\SR3701_10\SR3701.DATA10
S:\ORACLE\P11\SAPDATA2\SR3701_11\SR3701.DATA11
S:\ORACLE\P11\SAPDATA2\SR3701_12\SR3701.DATA12
S:\ORACLE\P11\SAPDATA2\SR3701_13\SR3701.DATA13
S:\ORACLE\P11\SAPDATA2\SR3701_14\SR3701.DATA14
NAME
--------------------------------------------------------------------------------
S:\ORACLE\P11\SAPDATA2\SR3701_15\SR3701.DATA15
S:\ORACLE\P11\SAPDATA2\SR3701_16\SR3701.DATA16
S:\ORACLE\P11\SAPDATA2\SR3701_17\SR3701.DATA17
S:\ORACLE\P11\SAPDATA2\SR3701_18\SR3701.DATA18
S:\ORACLE\P11\SAPDATA2\SR3701_19\SR3701.DATA19
S:\ORACLE\P11\SAPDATA2\SR3701_20\SR3701.DATA20
S:\ORACLE\P11\SAPDATA4\SR3USR_1\SR3USR.DATA1
R:\ORACLE\P11\SAPDATA3\SR3_17\SR3.DATA17
S:\ORACLE\P11\SAPDATA2\SR3701_21\SR3701.DATA21
S:\ORACLE\P11\SAPDATA2\SR3701_22\SR3701.DATA22
S:\ORACLE\P11\SAPDATA2\SR3701_23\SR3701.DATA23
NAME
--------------------------------------------------------------------------------
R:\ORACLE\P11\SAPDATA1\SYSAUX_2\SYSAUX.DATA2
R:\ORACLE\P11\SAPDATA3\SR3_18\SR3.DATA18
R:\ORACLE\P11\SAPDATA3\SR3_19\SR3.DATA19
S:\ORACLE\P11\SAPDATA2\SR3701_24\SR3701.DATA24
R:\ORACLE\P11\SAPDATA3\SR3_20\SR3.DATA20
R:\ORACLE\P11\SAPDATA3\SR3_21\SR3.DATA21
R:\ORACLE\P11\SAPDATA3\SR3_22\SR3.DATA22
S:\ORACLE\P11\SAPDATA4\SR3USR_2\SR3USR.DATA2
R:\ORACLE\P11\SAPDATA3\SR3_23\SR3.DATA23
R:\ORACLE\P11\SAPDATA3\SR3_24\SR3.DATA24
S:\ORACLE\P11\SAPDATA4\SR3USR_3\SR3USR.DATA3
NAME
--------------------------------------------------------------------------------
R:\ORACLE\P11\SAPDATA3\SR3_25\SR3.DATA25
R:\ORACLE\P11\SAPDATA3\SR3_26\SR3.DATA26
R:\ORACLE\P11\SAPDATA3\SR3_27\SR3.DATA27
R:\ORACLE\P11\SAPDATA3\SR3_28\SR3.DATA28
R:\ORACLE\P11\SAPDATA3\SR3_29\SR3.DATA29
R:\ORACLE\P11\SAPDATA3\SR3_30\SR3.DATA30
R:\ORACLE\P11\SAPDATA3\SR3_31\SR3.DATA31
R:\ORACLE\P11\SAPDATA3\SR3_32\SR3.DATA32
R:\ORACLE\P11\SAPDATA3\SR3_33\SR3.DATA33
R:\ORACLE\P11\SAPDATA3\SR3_34\SR3.DATA34
R:\ORACLE\P11\SAPDATA3\SR3_35\SR3.DATA35
NAME
--------------------------------------------------------------------------------
R:\ORACLE\P11\SAPDATA3\SR3_36\SR3.DATA36
R:\ORACLE\P11\SAPDATA3\SR3_37\SR3.DATA37
S:\ORACLE\P11\SAPDATA4\SR3USR_4\SR3USR.DATA4
S:\ORACLE\P11\SAPDATA4\SR3USR_5\SR3USR.DATA5
S:\ORACLE\P11\SAPDATA4\SR3USR_6\SR3USR.DATA6
S:\ORACLE\P11\SAPDATA4\SR3USR_7\SR3USR.DATA7
S:\ORACLE\P11\SAPDATA4\SR3USR_8\SR3USR.DATA8
S:\ORACLE\P11\SAPDATA4\SR3USR_9\SR3USR.DATA9
S:\ORACLE\P11\SAPDATA4\SR3USR_10\SR3USR.DATA10
S:\ORACLE\P11\SAPDATA4\SR3USR_11\SR3USR.DATA11
S:\ORACLE\P11\SAPDATA4\SR3USR_12\SR3USR.DATA12
NAME
--------------------------------------------------------------------------------
S:\ORACLE\P11\SAPDATA4\SR3USR_13\SR3USR.DATA13
S:\ORACLE\P11\SAPDATA4\SR3USR_14\SR3USR.DATA14
S:\ORACLE\P11\SAPDATA4\SR3USR_15\SR3USR.DATA15
S:\ORACLE\P11\SAPDATA4\SR3USR_16\SR3USR.DATA16
S:\ORACLE\P11\SAPDATA4\SR3USR_17\SR3USR.DATA17
S:\ORACLE\P11\SAPDATA4\SR3USR_18\SR3USR.DATA18
S:\ORACLE\P11\SAPDATA4\SR3USR_19\SR3USR.DATA19
S:\ORACLE\P11\SAPDATA4\SR3USR_20\SR3USR.DATA20
S:\ORACLE\P11\SAPDATA4\SR3USR_21\SR3USR.DATA21
S:\ORACLE\P11\SAPDATA4\SR3USR_22\SR3USR.DATA22
S:\ORACLE\P11\SAPDATA4\SR3USR_23\SR3USR.DATA23
NAME
--------------------------------------------------------------------------------
S:\ORACLE\P11\SAPDATA4\SR3USR_24\SR3USR.DATA24
S:\ORACLE\P11\SAPDATA4\SR3USR_25\SR3USR.DATA25
S:\ORACLE\P11\SAPDATA4\SR3USR_26\SR3USR.DATA26
S:\ORACLE\P11\SAPDATA4\SR3USR_27\SR3USR.DATA27
92 rows selected.
Data file are for Quality system are as below.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
S:\ORACLE\QI1\SAPDATA1\SYSTEM_1\SYSTEM.DATA1
S:\ORACLE\QI1\SAPDATA1\UNDO_1\UNDO.DATA1
S:\ORACLE\QI1\SAPDATA1\SYSAUX_1\SYSAUX.DATA1
S:\ORACLE\QI1\SAPDATA3\SR3_1\SR3.DATA1
S:\ORACLE\QI1\SAPDATA3\SR3_2\SR3.DATA2
S:\ORACLE\QI1\SAPDATA3\SR3_3\SR3.DATA3
S:\ORACLE\QI1\SAPDATA3\SR3_4\SR3.DATA4
S:\ORACLE\QI1\SAPDATA3\SR3_5\SR3.DATA5
S:\ORACLE\QI1\SAPDATA3\SR3_6\SR3.DATA6
S:\ORACLE\QI1\SAPDATA3\SR3_7\SR3.DATA7
S:\ORACLE\QI1\SAPDATA3\SR3_8\SR3.DATA8
NAME
--------------------------------------------------------------------------------
S:\ORACLE\QI1\SAPDATA3\SR3_9\SR3.DATA9
S:\ORACLE\QI1\SAPDATA3\SR3_10\SR3.DATA10
S:\ORACLE\QI1\SAPDATA3\SR3_11\SR3.DATA11
S:\ORACLE\QI1\SAPDATA3\SR3_12\SR3.DATA12
S:\ORACLE\QI1\SAPDATA3\SR3_13\SR3.DATA13
S:\ORACLE\QI1\SAPDATA3\SR3_14\SR3.DATA14
S:\ORACLE\QI1\SAPDATA3\SR3_15\SR3.DATA15
S:\ORACLE\QI1\SAPDATA3\SR3_16\SR3.DATA16
R:\ORACLE\QI1\SAPDATA2\SR3701_1\SR3701.DATA1
R:\ORACLE\QI1\SAPDATA2\SR3701_2\SR3701.DATA2
R:\ORACLE\QI1\SAPDATA2\SR3701_3\SR3701.DATA3
NAME
--------------------------------------------------------------------------------
R:\ORACLE\QI1\SAPDATA2\SR3701_4\SR3701.DATA4
R:\ORACLE\QI1\SAPDATA2\SR3701_5\SR3701.DATA5
R:\ORACLE\QI1\SAPDATA2\SR3701_6\SR3701.DATA6
R:\ORACLE\QI1\SAPDATA2\SR3701_7\SR3701.DATA7
R:\ORACLE\QI1\SAPDATA2\SR3701_8\SR3701.DATA8
R:\ORACLE\QI1\SAPDATA2\SR3701_9\SR3701.DATA9
R:\ORACLE\QI1\SAPDATA2\SR3701_10\SR3701.DATA10
R:\ORACLE\QI1\SAPDATA2\SR3701_11\SR3701.DATA11
R:\ORACLE\QI1\SAPDATA2\SR3701_12\SR3701.DATA12
R:\ORACLE\QI1\SAPDATA2\SR3701_13\SR3701.DATA13
R:\ORACLE\QI1\SAPDATA2\SR3701_14\SR3701.DATA14
NAME
--------------------------------------------------------------------------------
R:\ORACLE\QI1\SAPDATA2\SR3701_15\SR3701.DATA15
R:\ORACLE\QI1\SAPDATA2\SR3701_16\SR3701.DATA16
R:\ORACLE\QI1\SAPDATA2\SR3701_17\SR3701.DATA17
R:\ORACLE\QI1\SAPDATA2\SR3701_18\SR3701.DATA18
R:\ORACLE\QI1\SAPDATA2\SR3701_19\SR3701.DATA19
R:\ORACLE\QI1\SAPDATA2\SR3701_20\SR3701.DATA20
S:\ORACLE\QI1\SAPDATA4\SR3USR_1\SR3USR.DATA1
S:\ORACLE\QI1\SAPDATA3\SR3_17\SR3.DATA17
R:\ORACLE\QI1\SAPDATA2\SR3701_21\SR3701.DATA21
R:\ORACLE\QI1\SAPDATA2\SR3701_22\SR3701.DATA22
R:\ORACLE\QI1\SAPDATA2\SR3701_23\SR3701.DATA23
NAME
--------------------------------------------------------------------------------
S:\ORACLE\QI1\SAPDATA1\SYSAUX_2\SYSAUX.DATA2
S:\ORACLE\QI1\SAPDATA3\SR3_18\SR3.DATA18
S:\ORACLE\QI1\SAPDATA3\SR3_19\SR3.DATA19
R:\ORACLE\QI1\SAPDATA2\SR3701_24\SR3701.DATA24
S:\ORACLE\QI1\SAPDATA3\SR3_20\SR3.DATA20
S:\ORACLE\QI1\SAPDATA3\SR3_21\SR3.DATA21
S:\ORACLE\QI1\SAPDATA3\SR3_22\SR3.DATA22
S:\ORACLE\QI1\SAPDATA4\SR3USR_2\SR3USR.DATA2
S:\ORACLE\QI1\SAPDATA3\SR3_23\SR3.DATA23
S:\ORACLE\QI1\SAPDATA3\SR3_24\SR3.DATA24
S:\ORACLE\QI1\SAPDATA4\SR3USR_3\SR3USR.DATA3
NAME
--------------------------------------------------------------------------------
S:\ORACLE\QI1\SAPDATA3\SR3_25\SR3.DATA25
S:\ORACLE\QI1\SAPDATA3\SR3_26\SR3.DATA26
S:\ORACLE\QI1\SAPDATA3\SR3_27\SR3.DATA27
S:\ORACLE\QI1\SAPDATA3\SR3_28\SR3.DATA28
S:\ORACLE\QI1\SAPDATA3\SR3_29\SR3.DATA29
S:\ORACLE\QI1\SAPDATA3\SR3_30\SR3.DATA30
S:\ORACLE\QI1\SAPDATA3\SR3_31\SR3.DATA31
S:\ORACLE\QI1\SAPDATA3\SR3_32\SR3.DATA32
S:\ORACLE\QI1\SAPDATA3\SR3_33\SR3.DATA33
S:\ORACLE\QI1\SAPDATA3\SR3_34\SR3.DATA34
S:\ORACLE\QI1\SAPDATA3\SR3_35\SR3.DATA35
NAME
--------------------------------------------------------------------------------
S:\ORACLE\QI1\SAPDATA3\SR3_36\SR3.DATA36
S:\ORACLE\QI1\SAPDATA3\SR3_37\SR3.DATA37
S:\ORACLE\QI1\SAPDATA4\SR3USR_4\SR3USR.DATA4
S:\ORACLE\QI1\SAPDATA4\SR3USR_5\SR3USR.DATA5
S:\ORACLE\QI1\SAPDATA4\SR3USR_6\SR3USR.DATA6
S:\ORACLE\QI1\SAPDATA4\SR3USR_7\SR3USR.DATA7
S:\ORACLE\QI1\SAPDATA4\SR3USR_8\SR3USR.DATA8
S:\ORACLE\QI1\SAPDATA4\SR3USR_9\SR3USR.DATA9
S:\ORACLE\QI1\SAPDATA4\SR3USR_10\SR3USR.DATA10
S:\ORACLE\QI1\SAPDATA4\SR3USR_11\SR3USR.DATA11
S:\ORACLE\QI1\SAPDATA4\SR3USR_12\SR3USR.DATA12
NAME
--------------------------------------------------------------------------------
S:\ORACLE\QI1\SAPDATA4\SR3USR_13\SR3USR.DATA13
S:\ORACLE\QI1\SAPDATA4\SR3USR_14\SR3USR.DATA14
S:\ORACLE\QI1\SAPDATA4\SR3USR_15\SR3USR.DATA15
S:\ORACLE\QI1\SAPDATA4\SR3USR_16\SR3USR.DATA16
S:\ORACLE\QI1\SAPDATA4\SR3USR_17\SR3USR.DATA17
S:\ORACLE\QI1\SAPDATA4\SR3USR_18\SR3USR.DATA18
S:\ORACLE\QI1\SAPDATA4\SR3USR_19\SR3USR.DATA19
S:\ORACLE\QI1\SAPDATA4\SR3USR_20\SR3USR.DATA20
S:\ORACLE\QI1\SAPDATA4\SR3USR_21\SR3USR.DATA21
S:\ORACLE\QI1\SAPDATA4\SR3USR_22\SR3USR.DATA22
S:\ORACLE\QI1\SAPDATA4\SR3USR_23\SR3USR.DATA23
NAME
--------------------------------------------------------------------------------
S:\ORACLE\QI1\SAPDATA4\SR3USR_24\SR3USR.DATA24
S:\ORACLE\QI1\SAPDATA4\SR3USR_25\SR3USR.DATA25
S:\ORACLE\QI1\SAPDATA4\SR3USR_26\SR3USR.DATA26
91 rows selected.
Can I copy datafile from source to destionation?
e.g
R:\ORACLE\P11\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 to
S:\ORACLE\QI1\SAPDATA1\SYSTEM_1\SYSTEM.DATA1
Same way all datafiles and logfiles as source to destination.
Does it works after creating control file from PRD system? Still now I had restore using brtools only.
Please suggest me does it work? and also send me System refresh Pre and Post activity.
Regards,
Sahil K
Hello Sahil,
Why don't you go for a Backup-Restore? i mean, instead of messing up with the data files and it's permissions...you can simply take the backup of your Source sys(either online/offline - as per PRD backup policy) and restore it on Target sys.
Br-tools are the best tools provided by SAP to handle all the DB related activities.
regards,
pavan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Drive backup taken after DB shutdown and stoped all services.
Regards,
Sahil k
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If the files are copied from the source to the target when the DB is shutdown then it will work.
You will have to recreate the control files after the copying the data files.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sahil,
1st take full consistent DB and OS backup.
Delete SAPDATA*, ORALOG*, MIRRORLOG* of quality and replace that from production.
Get the control file from production and, place + edit it for the target system.
Recover your DB using control file + drop old OPS user and create a new for target.
Apart from that, do a search on SCN and google to get documents for reference + READ system copy guides before doing anything.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.