Skip to Content
author's profile photo Former Member
Former Member

Regarding the Oracle restore

Dear Experts,

I have small query on oracle restore using BR TOOLS.

we are facing the below issue while restoring the production backup on the quality system.

our production backup location is /oracle/PRD/sapbackup

Quality backup location is /oracle/QRD/SAPBACKUP.

these mounts are not attached to all servers.

we have taken the backup its created three files 1. one folder with all data files. 2 backupprd. log 3. zyx.fnd file

I have moved the above thee files and archive log to target backup folder and renamed the backup<PRD>.log to backup<QRD>.log

Now when i restore on quality system saying that backup files not found... actually its searching the backup on /oracle/PRD/sapbackup from fnd file.

is there any way to avoid it. Or do I need to change path anywhere in backup files

I have seen so many blogs nowhere exact resolution is not mentioned


Log :


BR0443W File '/oracle/PRD/sapbackup/besukhbi/sr3.data12.Z' to be restored not found

BR0443W File '/oracle/PRD/sapbackup/besukhbi/sr3.data13.Z' to be restored not found

BR0443W File '/oracle/PRD/sapbackup/besukhbi/sr3.data14.Z' to be restored not found

BR0443W File '/oracle/PRD/sapbackup/besukhbi/sr3.data15.Z' to be restored not found

BR0443W File '/oracle/PRD/sapbackup/besukhbi/sr3.data16.Z' to be restored not found

BR0443W File '/oracle/PRD/sapbackup/besukhbi/sr3.data17.Z' to be restored not found

But i have copied the files to /oracle/QRD/sapbackup/besukhbi with full permissions

Thanks,

Reddy

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    Posted on Mar 27, 2016 at 03:17 AM

    Hi,

    Could you share backup_<SID>.log , zyx.fnd along with alert_<SID>.log file from the system ? Addition to it are you getting restore code BR0460W during the restore process .

    For the code you could follow SAP Note 17163 - BRARCHIVE/BRBACKUP messages and codes


    BR0460W Termination message not found in %s - log file incomplete.

    BR0460W Ende-Meldung nicht gefunden in %s - Protokoll unvollstaendig.

    Explanation: The message about the termination of the backup was not found in the backup log.

    Case 1: The volume restored the log.

    Case 2: You changed the log manually.

    Program reaction: Waits for confirmation that the process should continue.

    User action: Case 1: Continue processing. Case 2: Undo the manual changes, cancel the processing, and then repeat the process.

    Hope this will help you.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2016 at 06:20 AM

    Hi All,

    Thanks for your inputs. The issue has been resovled.

    Regards,
    Damodar

    Add comment
    10|10000 characters needed characters exceeded