Forum Discussion

MihammadSafi's avatar
MihammadSafi
Level 2
7 months ago

Oracle instance

Try to take backup on oracle instance database always appear partial successfully please find the details:
Jul 10, 2024 4:17:21 PM - Info bphdb (pid=325041) INF - ORA-27206: requested file not found in media management catalog
Jul 10, 2024 4:17:21 PM - Info bphdb (pid=325041) INF - continuing other job steps, job failed will not be re-run
Jul 10, 2024 4:17:28 PM - Info bphdb (pid=325041) INF - RMAN-03009: failure of backup command on ch02 channel at 07/10/2024 16:17:27
Jul 10, 2024 4:17:28 PM - Info bphdb (pid=325041) INF - ORA-19513: failed to identify sequential file
Jul 10, 2024 4:17:28 PM - Info bphdb (pid=325041) INF - ORA-27206: requested file not found in media management catalog
Jul 10, 2024 4:17:28 PM - Info bphdb (pid=325041) INF - continuing other job steps, job failed will not be re-run
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - released channel: ch00
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - released channel: ch01
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - released channel: ch02
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - released channel: ch03
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - released channel: ch04
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - released channel: ch05
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - RMAN-00571: ===========================================================
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - RMAN-00571: ===========================================================
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - RMAN-03009: failure of backup command on ch00 channel at 07/10/2024 16:18:12
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - ORA-19513: failed to identify sequential file
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - ORA-27206: requested file not found in media management catalog
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - Recovery Manager complete.
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - End of Recovery Manager output.
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) INF - End Oracle Recovery Manager.
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) ERR - Unable to get information on policy, test_linux.
Jul 10, 2024 4:18:13 PM - Error bpbrm (pid=216571) from client exacc0102cl03bkp.automation.com: ERR - bphdb exit status = 1: the requested operation was partially successful
Jul 10, 2024 4:18:13 PM - Info bpbrm (pid=216571) validating image for client exacc0102cl03bkp.automation.com
Jul 10, 2024 4:18:13 PM - Info bphdb (pid=325041) done. status: 1: the requested operation was partially successful
Jul 10, 2024 4:18:13 PM - end writing
The requested operation was partially successful. (1)
12.x and Earlier
Linux
  • garyy's avatar
    garyy
    Level 3
    6 months ago

    Hi MihammadSafi 

    This error is the clue; 
    ORA-27206: requested file not found in media management catalog

    We need to see the rman .out file (usually in same location as the rman script file). This is the output of rman process and will show what file rman is expecting but hasn't found.

    We can then cross reference the missing backup piece/file from rman out file with NetBackup catalog via bplist command;

    /usr/openv/netbackup/bin/bplist -C client_name -S master_server_name -t 4 -l -R /

  • Will_Hunting's avatar
    Will_Hunting
    Level 4
    7 months ago

    hi, 

    1. Please post the Rman scripts

    2. Check the date time on the master and client

    3.  From the client, run the command:
    /usr/openv/netbackup/bin/bpclntcmd -pn

    expecting response from server master_server_name
    client_name   client_name   ip_address   port_number

     

    thanks.