How to restore backup data in Windows NT?
If you want to copy your running sap system as operating system backup method then use the following procedure.
1. Verify the source system installation my sm28.
2. Create control file by executing “alter database backup controlfile to trace as c:\control.sql”. (This command generate the create control file script as readable format).
3. Switch Archive log to next.
4. Shutdown the database and sap instance.
5. Copy the oracle datafiles from source system to target.
6. Copy the init<sid>.ora file from $oracle_home\database directory to target system in the new ext (like .old).
7. Install the Oracle Software in the target system with “Don’t create Database” option.
8. Install the Central Instance in the target system with same SID.
9. Install the Database Instance in the target system with same SID and change the Oracle installation with “system Copy / Oracle backup and recover” option.
10. During this stage the system inform you to recover the oracle database screen.
11. Login as <sid>adm. (remote login from other system)
12. Change the control files as per the target system directory structure.
13. Disable the lines *.Archive_log_dest=<directory> and *.Archive_log_start=True in init<sid>.old (which was copied from source system)
14. Change the control file script either in resetlog or noresetlog mode.
15. Execute the following scripts
a. Sqlplus / nolog
b. Connect /as sysdba;
c. Startup nomount pfile=g:\recover\init<sid>.old
d. @control.sql
e. If the control file created in noresetlog option then
i. Recover database using backup control file.
ii. This command request the archive log files with log no.
iii. Enter the path of the archive log (which was copied from source)
f. Alter system archive log;
g. Alter system archive log start;
h. Alter database open;
i. In sql prompt execute create spfile from pfile;
16. If the database is sucessfully restored then press ok and continue the installation.
17. After the Database Instance Installation, Install the GUI and login to the system.
If you want to copy your running sap system as operating system backup method then use the following procedure.
1. Verify the source system installation my sm28.
2. Create control file by executing “alter database backup controlfile to trace as c:\control.sql”. (This command generate the create control file script as readable format).
3. Switch Archive log to next.
4. Shutdown the database and sap instance.
5. Copy the oracle datafiles from source system to target.
6. Copy the init<sid>.ora file from $oracle_home\database directory to target system in the new ext (like .old).
7. Install the Oracle Software in the target system with “Don’t create Database” option.
8. Install the Central Instance in the target system with same SID.
9. Install the Database Instance in the target system with same SID and change the Oracle installation with “system Copy / Oracle backup and recover” option.
10. During this stage the system inform you to recover the oracle database screen.
11. Login as <sid>adm. (remote login from other system)
12. Change the control files as per the target system directory structure.
13. Disable the lines *.Archive_log_dest=<directory> and *.Archive_log_start=True in init<sid>.old (which was copied from source system)
14. Change the control file script either in resetlog or noresetlog mode.
15. Execute the following scripts
a. Sqlplus / nolog
b. Connect /as sysdba;
c. Startup nomount pfile=g:\recover\init<sid>.old
d. @control.sql
e. If the control file created in noresetlog option then
i. Recover database using backup control file.
ii. This command request the archive log files with log no.
iii. Enter the path of the archive log (which was copied from source)
f. Alter system archive log;
g. Alter system archive log start;
h. Alter database open;
i. In sql prompt execute create spfile from pfile;
16. If the database is sucessfully restored then press ok and continue the installation.
17. After the Database Instance Installation, Install the GUI and login to the system.
0 Comments