on 06-07-2011 12:31 PM
hi All,
I took Whole Database Offline backup with DB13 now i want to restore this backup. the size of backup is 49GB while there is only 30GB free space in main SAP data directory. if I put backup on external directory then please tell me which parameter i have to change for this.
befvlvhy afd 2011-05-08 22.03.38 2011-05-09 03.17.02 0
5.0867:1 34 34 0 42745 636474713 42745
636474713 ALL offline_force disk ---k-c 7.00 (43)
please tell me in above log, which number i will use as a sequence in restore command.
Regards,
majamil
Hi Majamil,
hi All,
> I took Whole Database Offline backup with DB13 now i want to restore this backup. the size of backup is 49GB while there is only 30GB free space in main SAP data directory. if I put backup on external directory then please tell me which parameter i have to change for this.
>
>
befvlvhy afd 2011-05-08 22.03.38 2011-05-09 03.17.02 0 > 5.0867:1 34 34 0 42745 636474713 42745 > 636474713 ALL offline_force disk ---k-c 7.00 (43)
>
> please tell me in above log, which number i will use as a sequence in restore command.
>
> Regards,
> majamil
In order to change the target location, check the link, below;
http://help.sap.com/saphelp_45b/helpdata/en/a0/897415dc4ad111950d0060b03c6b76/content.htm
brrestore -m /oracle/C11/sapdata1=/oracle/C11/sapdata5
Restore all the database data files from the subdirectories of
/oracle/C11/sapdata1 into the directory /oracle/C11/sapdata5.
> please tell me in above log, which number i will use as a sequence in restore command.
You don't need to import offline redolog files into the system, if you just want to open the database. But, if you would like to come to the specific time, you need to find the correct log sequence in the backup log file, near the "Next log sequence to archive" string. However, the system will request the correct sequence number when you are importing offline redolog files in to the system.
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Karan,
It is correct, also. But, with the patch 20 of BRTools 7.00 you don't need to have any modification on neither a log file nor configuration file. Check the note 1003028 - Enhanced support for database copy in BRTools. This is the easiest way to redirect restore target to another location.
Best regards,
Orkun Gedik
By default the backup will be taken to /oracle/<SID>/sapbackup (UNIX) and <drive>\oracle\<SID>\sapbackup (windows)
if this the case then if you want to restore the database then you should be able to do it as you need to delete the existing database before you start restoring. Mean you will get disk space back if you delete. If not then you need to change the parameter in /oracle/<SID>/<db_version>/dbs/init<SID>.sap and change the parameter backup_root_dir.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
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.