Oracle System Copy
system refresh (or) restore (or) db refresh
How to do the restoration (or) recovery of offline backup:
1. Do the backup in the source machine with offline mode.
2. Copy the following folders and file from the source machine to target machine.
FOLDERS:xxxxxxxxxxxxxx, ssid
FILES: [Link]
.ffd file must reside in the sapbackup folder.
.sql file should be placed in the D: drive for further process.
3. next open .ffd file and change all SSID to Tsid .(ssid=source sid,tsid=target sid)
4. next change D:\oracle\TSID\SAPBACKUP (SSID TO TSID).
5. open the file [Link] and change the file name to [Link] in the
above path
6. then open the xxxxxxxxx folder and change SSID TO TSID path for all datafiles
which resides in folder (manually)
7. go to D:\ORACLE\ORA92\DATABASE\[Link],open this file and change
BACK_DEV_TYPE : DISK (CHANGE FROM TAPE TO DISK)
8. shut down the database by using sapdba option
[Link] services which are related to oracle and sap should b stopped.
1.oracleorahome92agent. [Link]
2.oracleorahome92tnslistner 2. sapsid_nr
[Link]
10.d:\> brrestore -m all -b [Link]
then the restoration process goes on successfully depending on the amount of data
what we have backed up.
11. at the end of restoration it displays the following text
brrestore terminated succesfully.
[Link] restart the system once.
13. here when u restart the system the services which we stopped manually will start
automatically they are
1.oracleorahome92agent. [Link]
2.oracleorahome92tnslistner 2. sapsid_nr
[Link]
[Link] go to [Link] file and do following changes
[Link] all source sid to target sid
[Link] NORESETLOGS TO RESETLOGS
[Link] REUSE DATABASE IN IIND LINE TO REUSE SET
DATABASE
then save the changes to control file
15. then connect to sql where u r CONTROL FILE resides(d:)
[Link] the control file
sql>@[Link]
created.
17. when we generate the control file the database status is in mount state and we
should change to open state by using following command
sql>select status from v$instance;
it displays status as mounted.
sql>ALTER DATABASE OPEN;
[Link] we use this command it prompts u that this command must go with one of
the following options
[Link]
[Link].
[Link] run the above command with one of the above options
sql>ALTER DATABASE OPEN RESETLOGS;
[Link] the database status will be in open state.
sql>SELECT STATUS FROM V$INSTANCE;
then database status will be shown as OPEN
[Link] we get any warnings when we complete the restoration we have to execute the
following file
SAPDBA_ROLE.SQL
[Link] execute the above file do the following process
[Link] that particular file from kernel directory (run folder) to d:/
drive
[Link] it and give execute:owner:'sapsid' and change that sapsid to
u r targetsid.
[Link] the above file as follows
d:/>sqlplus /no log @sapdba_role.sql tsid nt
d. here it will write the log file to the same directory where ur
sapdba_role.sql resides and it contains the log as permissions granted
[Link] it is R/3 4.7 box(server) then we need to change the schema of target host to
source schema i.e.., SAP<SID>
mycomp-->advance--->environmentvariables--
>ORA_DB_SCHEMA--->EDIT--->SAP<SOURCESID>--->OK.
NOTE
But if it is ECC or net weaver then no need to change the schema coz the schema
will be same it will not change the slandered schema is “SAPSR3”