cancel
Showing results for 
Search instead for 
Did you mean: 

SAP System refresh with offline drive back up

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

Drive backup taken after DB shutdown  and stoped all services.

Regards,

Sahil k

Reagan
Advisor
Advisor
0 Kudos

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.

Former Member
0 Kudos

Hi Reagn,

Should I have to change path in Control file ? or Can I copy entrire drive backup and jusr rename Oracle\SID to quality system SID?

Regards,

Sahil k

Reagan
Advisor
Advisor
0 Kudos

The procedure is same as in backup and restore. The difference is you are copying the files manually instead of restoring it. You will need to recreate the control files with the correct path.

Former Member
0 Kudos

Hi,

Our PRD server oracle version is 11.2.0.4.0 & qas 11.2.0.3.0. Can We restore  Orace 11.2.0.3.0  on oracle 11.2.0.4.0 ?

Reagan
Advisor
Advisor
0 Kudos

Patch the QAS to the same level and then do the restore.

Former Member
0 Kudos

QAS is higher version

Reagan
Advisor
Advisor
0 Kudos

According to your previous reply the production is having a higher patch level. I am not sure what the exact patch levels are, you will need to bring the systems to the same patch level for backup and restore.

Former Member
0 Kudos

Hi,

Our PRD server oracle version is 11.2.0.3.0 & qas 11.2.0.4.0.

So patch level must be same for backup restore? Is there any work around?

Reagan
Advisor
Advisor
0 Kudos

Yes

Former Member
0 Kudos

Hi,

I have restore file.I am getting

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file 'E:\ORACLE\sid\11204\DATABASE\INIT<SID.ORA'

error

Pls.reply

Thanks & Regards,

Sahil K

divyanshu_srivastava3
Active Contributor
0 Kudos

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,