Go to Target Server & Stop all services (oracle & SAP both).
Now Delete the All files inside the following Directories.
SAPDATA_HOME\sapdata1\sysaux
SAPDATA_HOME\sapdata1\system
SAPDATA_HOME\sapdata1\temp
SAPDATA_HOME\sapdata1\undo
SAPDATA_HOME\sapdata1\cntrl
SAPDATA_HOME\sapdata2\ sr3_1 ………sr3_n
SAPDATA_HOME\sapdata3\ sr3702_1 ……… sr3702_n
SAPDATA_HOME\sapdata4\sr3usr_1
SAPDATA_HOME\origlogA\cntrl
SAPDATA_HOME\origlogB\cntrl
SAPDATA_HOME\sapdata1\cntrl
Place the xxxxxxxx.and File In Sap backup Folder
SAPDATA_HOME \sapbackup
The File Name Will Be Like This belerzpm.and
BRRESTORE –m full –b xxxxxxxx.and –d disk –c
Now The Restoration Process Has Started
SAPDATA_HOME \origlogA\cntrl
SAPDATA_HOME \origlogB\cntrl
SAPDATA_HOME \sapdata1\cntrl
SQL>Alter database backup controlfile to trace;
Copy this trace file to target server and rename to control.sql.
Now modify this control.sql
Delete all before “startup mount” & after “CHARACTER SET UTF8;” in control.sql
Change
Now, Put this Control.sql to C drive on <TARGET SID> SYSTEM.
Start Oracle Services
SQL> @C:\CONTROL.SQL;
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
SQL>ALTER DATABASE OPEN RESETLOGS;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |