How to Restore backup and archive

[Former Member]

Hi there,

I am doing backup and archive using these commands:

Oracle 10g, under windows 2003

ONLINE BACKUP: BRBACKUP -u system/************ -c force -t online -m all -p initbiq.sap

ONLINE ARCHIVE: BRARCHIVE u2013u system/************ -c u2013sd

How to Restore backup and archive

Please kindly advise

Regards,

[Former Member · Accepted solution]

Q1 - I have to take weekley OFFLINE backup what is the command line under windows (BACKUP in Network Drive "D")
A1 - BRTOOLS -u system/********** -p initMTDp -d disk -t offline_force -m all -c -k no -e 0 -l E

Here you can simplify your command as below:

brbackup -d disk -t offline_force -m full -u system/password

Q2 - How to restore OFFline backup
A2 - BRRESTORE -b xxxxxx..and (backup log file) -m all -p initMTD.sap

here also you can simplify as below:

brrestore -b filename -m full

Q3 - Database + controlfiles are saved in "F" drive, If I delete all database files+controlfiles+logs from "F" can I recover/restore from "D" drive ??? how

Yes this is a normal restoration process, Go through systemcopy guide or backup restore guides on SMP

Regards,

Nick Loy

[Former Member]

First need some clarification on below message from you

1) DATABASE BACKUP (OFFLINE)?
- Shutdown SAP Instance (SAP-MMC) + DB (user: sqlplus /as sysdba - shutdown abort;)

Why you are using shutdown abort ? Is there any reason/requirement behind this use instead of shutdown or shutdown immediate?

And on your latest query: You have to read system copy guide to find the reason why system is asking for controlfile.

Regards,

Nick Loy

[Former Member]

Thanks for Reply!!!

let me summarize my questions:- and some asnswers, please tell me if i am wrong...

Q1 - I have to take weekley OFFLINE backup what is the command line under windows (BACKUP in Network Drive "D")

A1 - BRTOOLS -u system/********** -p initMTDp -d disk -t offline_force -m all -c -k no -e 0 -l E

Q2 - How to restore OFFline backup

A2 - BRRESTORE -b xxxxxx..and (backup log file) -m all -p initMTD.sap

Q3 - Database + controlfiles are saved in "F" drive, If I delete all database filescontrolfileslogs from "F" can I recover/restore from "D" drive ??? how

regards,

[volker_borowski2]

Hi

the logfile of the online backup should have two entries for

a "current log sequence" number. Record the last one (the one,

after the logswitch enforced at the end of the backup).

brrecover -seq {number recorded - 1}

This should do all the steps required to get you DB operational again.

This should contain the following steps (in case you like to do it manually)

restore of onlinebackup                    brrestore -m all|full ...
restore of required archive logs           brrestore -a ....
recovery of archive logs                   sqlplus , mount,  recover database ..., open resetlogs
recreation of required tempfiles           create tempfile

May be you should do it with brrecover to see all the steps it takes to do it,

and then do the steps manually again, esp. the recover part just to see how

it works in sqlplus.

Volker

[Former Member]

thanks you sooooooo much....

I am taking online backup when I done I will try to restore for testing...

[Former Member]

BACKUP & RESTORE REQUIREMENT

Coluld anyone provide these answer will be really appriciated

1) DATABASE BACKUP (OFFLINE)?

- Shutdown SAP Instance (SAP-MMC) + DB (user: sqlplus /as sysdba - shutdown abort;)

- Execute BRTOOLS option 4 - 1 - 5-user & pass 6-offline

- BRBACKUP -p initBIQ.sap -d disk -t offline -m all -k no -e 0 -l E

DONE

1) DATABASE RESTORE (OFFLINE)?

- Shutdown SAP + Database

- Select xxxxxx.and file from E:\oracle\BIQ\sapbackup

- BRRESTORE -b xxxxxx..and (backup log file) -m all -p initSID.sap

DONE

2) COMPLETE DATABASE BACKUP (ONLINE) ARCHIVED?

BRBACKUP -u system/*********** -c force -t online -m all -p initbiq.sap*

DONE

2) COMPLETE RESTORE DATABASE WITH ARCHIVED?

ANS:

3) DISASTER RECOVERY?

ANS:

[Former Member]

Hi,

2) COMPLETE RESTORE DATABASE WITH ARCHIVED?

ANS:

brrestore -b <backup_log_filename> -m full

(For Complete Database restore)

brrestore -a <Seq.No.From>-<Seq.No.To>

(To Restore the archived redo log files with the log sequence numbers FROM and TO into the archiving directory.)

3) DISASTER RECOVERY ?

ANS: with BRTOOLS

[http://help.sap.com/saphelp_nw70/helpdata/en/72/96d34c435c3c4ca5894749ef1435ac/content.htm|http://help.sap.com/saphelp_nw70/helpdata/en/72/96d34c435c3c4ca5894749ef1435ac/content.htm]

Regards.

Rajesh Narkhede

[Former Member]

Thank you so much I will be try and let you know that....

thank again

[volker_borowski2]

>

> Hi,
> 
> 

2) COMPLETE RESTORE DATABASE WITH ARCHIVED?

> ANS:

> brrestore -b <backup_log_filename> -m full

> (For Complete Database restore)

>

> brrestore -a <Seq.No.From>-<Seq.No.To>

> (To Restore the archived redo log files with the log sequence numbers FROM and TO into the archiving directory.)

>

Hi,

and after this RESTORE part, you still need to RECOVER!

sqlplus / as sysdba
startup mount
recover database using backup controlfile until cancel

... providing logs up tp <Seq.No.To>

cancel
alter database open resetlogs

Volker

[Former Member]

Hi again,

I am trying to now OFFLINE backup, stop sap and shutdown database.

BRTOOLS -u system/********** -p initBIQ.sap -d disk -t offline_force -m all -c -k no -e 0 -l E

Take offline backup in "D" drive and in C drive Oracle\database which is sapdata1, sapdata2 some files are deleteed... and try to restore back from "D" drive... using this command

BRRESTORE -b xxxxxx..and (backup log file) -m all -p initSID.sap

Why its asking me control files while restore... ???

I am looking for Offline backup with control files....

please help

[Former Member]

Hi Angeline,

Could you please check the below link.

http://help.sap.com/saphelp_nw70/helpdata/en/0d/d3077b4a0c11d182b80000e829fbfe/frameset.htm

Hope this helps you.

Thanks,

Nick S

[Former Member]

Check brrestore -h

Kind regards,

Mark