Skip to Content
avatar image
Former Member

Recovery SAP Database from brtools ...

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 22, 2009 at 03:17 PM

    > 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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Anindya Bose

      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

  • avatar image
    Former Member
    Aug 23, 2009 at 05:47 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • >

      > 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