Skip to Content
avatar image
Former Member

Db13 No Detail for Brbackup and Brarchive job

Hi,

i did a whole database online & redo log backup thru db13 on my bi 7 running on oracle 10.2g.

after the job, i can see 1 arch file (....3718....dbf) in oraarch folder. The job show as finish. I can view the detail log for both brbackup and brarchive.

when i did a restore to a new server, the restore job ask for arch file 3719 that doesn't exist in the oraarch folder.

when i startup, i can see the last brbackup and brarchive, but the job show as finish with error. No detail log for both brbackup and brarchive. I check, both sapbackup and saparchive folders exist.

My question:

- why did the job show as finish with error?

- why no detail shown for brbackup and brarchive?

- why did the restore job ask for arch file that doesn't exist?

- how so that i can see the same view as in the original?

thank you.

regards,

zl

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Mar 23, 2009 at 10:19 AM

    ZL,

    I would suggest you to go through the sapbackup directory (on source server) for the log information. In the meantime, if you know the exact timings you may want to try for oracle time based recovery. Remember this time has to be just before 3719 dbf.

    Example:

    SQL> STARTUP MOUNT

    SQL> RECOVER DATABASE UNTIL TIME '2009-03-21:11:00:00';

    SQL> ALTER DATABASE OPEN RESETLOGS;

    Hope this helps.

    Manoj

    Add comment
    10|10000 characters needed characters exceeded