Recovery SAP Database from brtools ...

[former_member309601]

Hi gurus, I have a problem with my SAP system, database no startup, I have two SAP backups made from DB13, when I try to restore with option "whole database reset" from brtools, show me an error:

BR0701I BRRECOVER 7.00 (18)

BR0705I Start of database recovery: vebhjttl.drs 2009-08-21 23.50.45

BR0101I Parameters

Name Value

oracle_sid DES

oracle_home E:\oracle\product\10.2.0\db_1

oracle_profile E:\oracle\product\10.2.0\db_1\database\initDES.ora

sapdata_home E:\oracle\DES

sap_profile E:\oracle\product\10.2.0\db_1\database\initDES.sap

recov_type reset

recov_copy_dir E:\oracle\DES\sapbackup

recov_interval 30

scroll_lines 20

backup_dev_type disk

system_info desadm SELCOSAP2 Windows 5.2 Build 3790 Service Pack 2 Intel

oracle_info DES 10.2.0.2.0

make_info NTintel OCI_10201_SHARE Oct 27 2006

command_line E:\usr\sap\DES\SYS\exe\uc\NTI386\brrecover.exe -p initDES.sap -t reset -i 30 -s 20 -l E -U

BR0280I BRRECOVER time stamp: 2009-08-21 23.50.45

BR0707I Recovery of database: DES

BR0708I BRRECOVER action ID: vebhjttl

BR0709I BRRECOVER function ID: drs

BR0710I Recovery type: reset

BR0280I BRRECOVER time stamp: 2009-08-21 23.50.45

BR0655I Control menu 109 - please decide how to proceed

-

---

Whole database reset main menu

1 = Select consistent database backup

2 * Check the status of database files

3 * Restore control files and redolog files

4 * Restore data files

5 * Restore and apply incremental backup

6 * Apply archivelog files

7 * Open database and post-processing

8 * Exit program

9 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

BR0280I BRRECOVER time stamp: 2009-08-21 23.50.47

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0699I Reading log file E:\oracle\DES\sapbackup\backDES.log ...

BR0730W No appropriate backup created since 2009-07-23 00.00.00 found in E:\oracle\DES\sapbackup\backDES.log

BR0417E No files found for restore/verification

Regards

[ashish_vikas]

Hi,

 BR0699I Reading log file E:\oracle\DES\sapbackup\backDES.log ...
BR0730W No appropriate backup created since 2009-07-23 00.00.00 found in E:\oracle\DES\sapbackup\*backDES.log* 

Can you please check if you have this file present phically .. also check in E:\oracle\DES\sapbackup\ if you have old backups (sort files created date wise..) ..

For consistent backup, you need to have all off line redo log files..

Same thing can be checked from SAP DB12 > Recovery reports..

thanks

ashish

[Former Member]

Hello All,

I am facing the same issue as Jose.

Our QAS system crashed due to SAN issues and we decided to restore the backup. I have installed the new ECC 6.0 system and later trying to restore with the backup we had a week before. I have changed the int<SID>.sap and copied the backup.and file also but still the issue is same. The options selected are as follows

BR0701I BRRECOVER 7.00 (32)

BR0705I Start of database recovery: veblfcim.drs 2009-09-11 11.17.48

BR0484I BRRECOVER log file: H:\oracle\QAS\sapbackup\veblfcim.drs

BR0101I Parameters

Name Value

oracle_sid QAS

oracle_home E:\oracle\QAS\102

oracle_profile E:\oracle\QAS\102\database\initQAS.ora

sapdata_home H:\oracle\QAS

sap_profile E:\oracle\QAS\102\database\initQAS.sap

recov_type reset

recov_copy_dir H:\oracle\QAS\sapbackup

recov_interval 30

scroll_lines 20

backup_dev_type disk

system_info qasadm hostname Windows 5.2 Build 3790 Service Pack 2 AMD64

oracle_info QAS 10.2.0.2.0

make_info NTAMD64 OCI_10201_SHARE Feb 6 2008

command_line E:\usr\sap\QAS\SYS\exe\uc\NTAMD64\brrecover.exe -p initQAS.sap -t reset -i 30 -s 20 -l E -U

BR0280I BRRECOVER time stamp: 2009-09-11 11.17.48

BR0707I Recovery of database: QAS

BR0708I BRRECOVER action ID: veblfcim

BR0709I BRRECOVER function ID: drs

BR0710I Recovery type: reset

BR0280I BRRECOVER time stamp: 2009-09-11 11.17.48

BR0655I Control menu 109 - please decide how to proceed

-

---

Whole database reset main menu

1 = Select consistent database backup

2 * Check the status of database files

3 * Restore control files and redolog files

4 * Restore data files

5 * Restore and apply incremental backup

6 * Apply archivelog files

7 * Open database and post-processing

8 * Exit program

9 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

BR0280I BRRECOVER time stamp: 2009-09-11 11.18.01

BR0663I Your choice: '1'

BR0699I Reading log file H:\oracle\QAS\sapbackup\backQAS.log ...

BR0730W No appropriate backup found in H:\oracle\QAS\sapbackup\backQAS.log

BR0417E No files found for restore/verification

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

BR0280I BRRECOVER time stamp: 2009-09-11 11.18.01

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Do i miss anything? How should i fix the same?

Regards,

Anand

[fidel_vales]

I do not know if you have read my previous answer. I recommend that you do so and you think about it.

the information you provide says nothing.

The main question, that you should know if you had readed the previous posts is

DO YOU HAVE A CONSISTENT BACKUP?

[Former Member]

Hello Fidel,

Thanks for your time and reply

I have read your reply in the post and I have tried the complete database recovery option as well but still the same issue. I donot have a consistent backup. Its a online backup to the local disk.

Regards,

Anand

[Former Member]

All of your backups are online and not online_cons

I see four backups and for any ot the backups do you have any archive logs

In the and file it will mention the archive log first and and last ones

If you happen to have any archive logs which were generated after that number then possibly you can try to recover.

Pravin

[fidel_vales]

>

> I donot have a consistent backup. Its a online backup to the local disk. 

If you do not have any consistent backup then you are in trouble.

without a consistent backup you cannot do a complete database recovery.

without a consistent backup you have NOTHING!, a lot of datafiles in a consistent stated that cannot be opened properly.

When will the people realize that it is not enough to "make backups", the important is to be able to restore/recover with those backups.

Sorry, but your backup is useless

[markus_doehr2]

> BR0699I Reading log file E:\oracle\DES\sapbackup\backDES.log ...

> BR0730W No appropriate backup created since 2009-07-23 00.00.00 found in E:\oracle\DES\sapbackup\backDES.log

> BR0417E No files found for restore/verification

It seems that this logfiles does not contain a consistent backup.

Markus

[former_member309601]

Hi, I have 2 backups and my backDES.log is:

bebdizfx and 2009-07-31 16.14.29 2009-07-31 17.15.23 5 ............... 44 40 0 1344 12470522 0 0 ALL online disk -

---

c 7.00 (18)

bebdsfeb and 2009-08-02 13.17.41 2009-08-02 14.17.04 5 ............... 44 40 0 1355 12787509 0 0 ALL online disk -

---

c 7.00 (18)

bebesdyx and 2009-08-07 20.00.27 2009-08-07 20.59.52 5 ............... 44 40 0 1370 13119938 0 0 ALL online disk -

---

c 7.00 (18)

bebfzbdx and 2009-08-14 12.35.37 2009-08-14 13.28.26 5 ............... 44 26 0 1399 13648585 0 0 ALL online disk -

---

c 7.00 (18)

bebhgzqp dbv 2009-08-21 10.18.19 2009-08-21 10.18.38 2 ............... 0 0 0 0 0 0 0 ............ ............... ................ ...... 7.00 (18)

bebhjsma dbv 2009-08-21 23.36.16 2009-08-21 23.36.17 3 ............... 0 0 0 0 0 0 0 ............ ............... ................ ...... 7.00 (18)

I have availible : bebfzbdx and bebesdyx on disk

I look at hard disk and I have all datafiles backup.

Regards.

[anindya_bose]

What kind of backup you have?

Whole online database backup to local disk? Do you have redolog backup? You can try point-in-time recovery then.

Does your initSID.sap file contain the backup location ?

Check the link below..

http://help.sap.com/saphelp_erp2004/helpdata/en/31/f8e63bed8a6126e10000000a114084/content.htm

Edited by: Anindya Bose on Aug 22, 2009 11:41 PM

[former_member309601]

Hi, my backup is online on disk. I have some redologs, but not all. I would like recover all from my backups.

In initSID.sap is path to disk.

Regards.

[fidel_vales]

hi,

I assume that the problem is the type of backup available:

i take a look at the last 3 letters (and the [documentation|http://help.sap.com/saphelp_nw70/helpdata/en/0d/d30ec54a0c11d182b80000e829fbfe/content.htm])

a: Whole database was backed up (backup_mode = all|all_data).

n: The backup was performed online (backup_type = online|online_cons|online_split|online_mirror).

d: Local disk (backup_device_type = disk|disk_copy|disk_standby).

The important one is the second one. The backup type could be

> online|online_cons|online_split|online_mirror

but at the end of the line it specifies which one is:

> bebfzbdx and 2009-08-14 12.35.37 2009-08-14 13.28.26 5 ............... 44 26 0 1399 13648585 0 0 ALL online disk -

---

c 7.00 (18)

An Online backup is not a consistent one (you should have done an "online_cons"

I have to say that I used BRRESTORE a million years ago so I'm not much familiar with it anymore. But lets check what the [documentation |http://help.sap.com/saphelp_nw70/helpdata/en/cd/80e67d94460e4fb0b3e9ca89967e47/frameset.htm]says.

you are trying to do a [whole database reset|http://help.sap.com/saphelp_nw70/helpdata/en/f1/9d0712466515469d42b8c2c6aeb669/content.htm] (extension of the log file drs)

Probably for that reason it ask for a consistent backup (that you do not have as mentioned before)

Well, may be you should choose other option but may be interesting to know what problems you have to start the database

> I have a problem with my SAP system, database no startup

and depending on the problem we may help to solve without recovery or you may choose instead the option "[Complete database recovery|http://help.sap.com/saphelp_nw70/helpdata/en/73/029e8ddd57f5408b62204da040bf8e/content.htm]" in which you will not need a CONSISTENT backup

[fidel_vales]

>

> Hi, my backup is online on disk. I have some redologs, but not all. I would like recover all from my backups.
> 
> In initSID.sap is path to disk.
> 
> Regards.

new information while I was posting.

You are in BIG trouble.

You only have an ONLINE backup and

> some redologs, but not all

Do you have all redolongs generated in the time between the online backup was started and finished?

If you do not have them all, then the backup is useless.

If you have ALL then you can do a PIT recovery (read the BRRECOVER [documentation|http://help.sap.com/saphelp_nw70/helpdata/en/33/87a687da77cb4486422f47cb816a9c/content.htm])

[anindya_bose]

>I would like recover all from my backups.

is your backup online_consistent? if not, then how can you restore them from backup?

In this situation I would try for PIT, upto a time just before my last available redolog generated.

[Former Member]

Hi ,

Please try to restore by the commandline :

1) brrestore -r <utlfile> -b <backup ID> -m full -c

2) if you have the archive logs backed up then you use the following command at sql for recovery

RECOVER AUTOMATIC DATABASE UNTIL TIME 'YYYY-MM-DD:HH:MM:SS' USING BACKUP CONTROLFILE;

3) After a successful recovery atleast recover the databse for the time the backup ran the do a reset logs by controlfiles trace.

If you donot have a trace of the controlfile then you might have to make it manually.

Regards,

Debo