Disaster recovery command?

Hi All,

In NW2004s Oracle 10g, under windows 2003 server,

Only Database on "F" drive and Offline backup files in network dirve "Y"

Offline backup

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

Some database files are deleted / removed from "F" drive...

How do I restore or disaster recovery

is anyone explain me how to do that brtools step by step options, I really appriciated

Thank in advance

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

to restore a datafile:

brrestore -u / -c -b bdvpmssy.aff -p initBIQ.sap -m F:\ORACLE\BIQ\SAPDATA1\FACTD_3\FACTD.DATA3

you will also need to restore redologs for recovery:

brrestore -u / -c -a 1832-1999 -p initBIQ.sap

then, recovery will be needed, so, stop SAP, stop database

sqlplus / as sysdba

startup mount

recover database using backup controlfile

auto

alter database open resetlogs;

read:

https://service.sap.com/sap/support/notes/0000096848?nlang=E

https://service.sap.com/sap/support/notes/0000605062?nlang=E

you can also use BRRECOVER which is menu based.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello,

Erics suggestion is valid if you have some experience and can evaluate the

situation you are in. As you ask for a step by step list, I have my doubts if it

is quite ok for you to simply type in what is and will be written here.

I.E. I disagree with Eric, because according to your description

"some file have been lost", I'd never choose an approach which would

require the use of a backup controlfile, as you should have a valid controlfile

still mirrored somewhere else if your system had been installed properly.

In this case I'd rather go for a complete recovery without resetlogs.

In your situation, I'd recommend you do a native NTBACKUP of

what's left of your system before you do anything else.

Use brtools then interactively (guided by help.sap.com, dba-chapter) and go for a complete recovery.

It should analyze everything that is needed and ask for backups available and

do all steps required to repair your system.

BTW: "desater recovery" usually refers to the situation when the system is

completely destryed including OS and all files on it.

Good luck

Volker

Thank you so much for your time and good information

but I am little confouse...

While restore database should be stop or start ?

brrestore -u / -c -b bdvpmssy.aff -p initBIQ.sap -m F:\ORACLE\BIQ\SAPDATA1\FACTD_3\FACTD.DATA3

Config file extention is not aff my case its .and ?

Should I have to give complete path liek F:\oracle\biq\sapdata1\ ??????????? I have different name

About archived logs sequence number start "BIQARCHARC09665_0676065164.001" what should I do in this case

please advise

Hi,

if you extension of the backup logfile is *.and your backup had been an online backup to disk...

Not the offline backup you refered to before. So in case you restore and overwrite something

existing with files from this backup, be sure you have the required online redologs available...

Is the system still running? At least partly?

Try

sqlplus / as sysdba

select status,name from v$datafile;

That might give us some information about your situation.

Somewhere you should have an initBIQ.ora file where one

parameter refers to the control_files. Check if all of them are in place

and accesible and have the same timestamp.

Volker

Hi there,

Hey buddy,

1) Done offline backup

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

2) Done ONLINE Backup:

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

How to restore online backup and how to restore offline backup ???

Please advise

Thats my question

Edited by: AngelinePurnama on May 13, 2010 12:38 AM

Hi,

If you see Eric already answered your question...

to restore a complete backup:

brrestore -u / -c -b <backup_log.ext> -p initBIQ.sap -m full

Visit the below link for brrestore command line options.

[http://help.sap.com/saphelp_nw70/helpdata/en/0d/d3077b4a0c11d182b80000e829fbfe/frameset.htm|http://help.sap.com/saphelp_nw70/helpdata/en/0d/d3077b4a0c11d182b80000e829fbfe/content.htm]

Regards.

Rajesh Narkhede

Thnak you so much Rajesh and all others for your time

Could you please tell me where I am doing wrong: here is step by step procedure:

STEP1 ONLINE BACKUP

1 - Ensure SAP+DB is up and running

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

3 - Check the Logs file

STEP 2: OFFLINE DESASTER RECOVERY

1 - Shutdown SAP + Database

2 - Delete Oracle folder from F: drive

3 - Create database structure in F: drive only create 4 folders

Oracle

BIQ

F:\Oracle\BIQ\sapdata1

F:\Oracle\BIQ\sapdata2

F:\Oracle\BIQ\sapdata3

F:\Oracle\BIQ\sapdata4

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

5 - Trun the database then SAP instance

When I start database I am getting some errors

Screenshot here:

http://www.flickr.com/photos/38842895@N04/4606319787/sizes/o/

http://www.flickr.com/photos/38842895@N04/4606319849/sizes/o/in/photostream/

http://www.flickr.com/photos/38842895@N04/4606319917/sizes/o/in/photostream/

Regards

Oracle needs an older redolog.

restore older redologs and try to apply them. instead of enterring AUTO, you can give a path to a restore redolog file.

If would use this command:

BRRESTORE -a 9650-9660 -p initSID.sap

then, use you recovery command.

good luck.

Hi there,

Thanks you so much...

I copied all of archived which is i have different direcotry... anyway!!! I got same error messages again

I think some archived files are missing or corripted

basically I dont want archived I just want to open database.... so I am trying to resotre without archived files... using this command

BRRESTORE -b last -m all

let see what gonna be happend

I will let you know

Thanks again, and I really appriciated

Hi guys,

I am sending new screenshot; still database is not open;

I've checked SAP Notes, done various Google searches and tried many SAP help sites but have been unable to find anything relative to these topics

http://www.flickr.com/photos/38842895@N04/4607601584/sizes/o/

I don't know what should I do next...

I just want restore without archived, I dont care archived at time...

Please advise


> I just want restore without archived, I dont care archived at time... 
> 
> Please advise

Well, allthough you don't care for the logs, oracle does!

An ONLINE Backup ist not consistent with oracle. If you do not want to RECOVER,

you need to do an OFFLINE backup. In this case you get away with RESTORE only.

Be sure to exactly understand the difference between RESTORE and RECOVER.

You need to RECOVER when your restored online backup is not yet consistent.

It means to read the archived logs and apply the changes recorded in them to

the inconsistent restored datafiles and make them consistent.

You usually need archive logs to do this. With luck, you get along with

the online logs, if the information needed is still available in them, but you will

never have those in a desaster case.

You can change your brbackup command to "... -t online_cons"

This will save the online logs needed for recovery of this specific backup in addition.

The name of this option is missleading. It will not make the backup itself consistent, but it

will store the information needed to do this in addition.

But you will still need to restore those in addition and recover them as well.

Volker

Hi Eric,

Sorry to borther you again, I done offline backup and trying to recover back... I am using the procedure you told be but still having some porblem

Step: OFFLINE BACKUP

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

Step: RESTORE OFFLINE BACKUP

Shutdown SAP + Database

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

After done its show completed with warrining...

Start database through SQL

SQL> startup mount

ORACLE instance started.

Total System Global Area 219750092 bytes

Fixed Size 454348 bytes

Variable Size 134217728 bytes

Database Buffers 83886080 bytes

Redo Buffers 1191936 bytes

Database mounted.

SQL> recover database using backup controlfile

ORA-00279: change 100821935 generated at 05/26/2010 15:20:39 needed for thread

ORA-00289: suggestion : C:\ORACLE\DBD\ORAARCH\DBDARCHARC00255.001

ORA-00280: change 100821935 for thread 1 is in sequence #255

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 102875975 generated at 05/27/2010 09:23:59 needed for thread

ORA-00289: suggestion : C:\ORACLE\DBD\ORAARCH\DBDARCHARC00256.001

ORA-00280: change 102875975 for thread 1 is in sequence #256

ORA-00278: log file 'C:\ORACLE\DBD\ORAARCH\DBDARCHARC00255.001' no longer

needed for this recovery

ORA-00279: change 102905527 generated at 05/27/2010 21:00:31 needed for thread

ORA-00289: suggestion : C:\ORACLE\DBD\ORAARCH\DBDARCHARC00257.001

ORA-00280: change 102905527 for thread 1 is in sequence #257

ORA-00278: log file 'C:\ORACLE\DBD\ORAARCH\DBDARCHARC00256.001' no longer

needed for this recovery

ORA-00308: cannot open archived log 'C:\ORACLE\DBD\ORAARCH\DBDARCHARC00257.001'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

SQL> alter database open resetlogs;

alter database open resetlogs

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: 'C:\ORACLE\DBD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL> recover datafile 'c:\oracle\dbd\sapdata1\system_1\system.data1';

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> alter database open resetlogs;

alter database open resetlogs

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: 'C:\ORACLE\DBD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL> recover datafile 'c:\oracle\dbd\sapdata1\system_1\system.data1';

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database using backup controlfile

ORA-00279: change 102905527 generated at 05/27/2010 21:00:31 needed for thread

ORA-00289: suggestion : C:\ORACLE\DBD\ORAARCH\DBDARCHARC00257.001

ORA-00280: change 102905527 for thread 1 is in sequence #257

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto

ORA-00308: cannot open archived log 'C:\ORACLE\DBD\ORAARCH\DBDARCHARC00257.001'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

ORA-00308: cannot open archived log 'C:\ORACLE\DBD\ORAARCH\DBDARCHARC00257.001'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

SQL>

My Question

Why it looking archived logs, and why we need to recover database... I am just resotre offline database which is not part of archived....

please verify and give me some hints

Thanks

Edited by: AngelinePurnama on May 31, 2010 8:50 PM

Ask a Question

Top Q&A Solution Author

User

Count