unable to restore a test oracle fiole after 1 day using RMAN - Veritas Net Backup

This is a discussion on unable to restore a test oracle fiole after 1 day using RMAN - Veritas Net Backup ; Using RMAN, I succesfuuly backed up a test Oracle datafile, I then turn aroud and retore it with out any problem. However, if I try to restore the same data file after 1 or 2 days old, I got the ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: unable to restore a test oracle fiole after 1 day using RMAN

  1. unable to restore a test oracle fiole after 1 day using RMAN


    Using RMAN, I succesfuuly backed up a test Oracle datafile, I then turn aroud
    and retore it with out any problem. However, if I try to restore the same
    data file after 1 or 2 days old, I got the immage not found error even NB
    indiate correct retention time in its log:

    09:22:20 [8230] <4> sbtinfo2: File Ordering Mode :
    09:22:20 [8230] <4> sbtinfo2: Media ID :
    09:22:20 [8230] <4> sbtinfo2: File Creation Date and Time : <1051539570>
    09:22:20 [8230] <4> sbtinfo2: File Expiration Date and Time : <1052749170>
    09:22:20 [8230] <4> sbtinfo2: Comment :

    Below is error from RMAN log and from NB log in dbclient directory:

    ***** RMAN error:

    RMAN-00571: ================================================== =========
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ================================================== =========
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: restore
    RMAN-03007: retryable error occurred during execution of command: IRESTORE
    RMAN-07004: unhandled exception during command execution on channel t1
    RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential
    file, handle="user_RMDEV_171_1_492513562", parms"
    ORA-27029: skgfrtrv: sbtrestore returned error
    ORA-19511: sbtrestore: Backup file not found.
    RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE

    ****** NB error:

    09:17:48.009 [3852] <4> sbtinit: support for Proxy Copy enabled
    09:17:48.592 [3852] <4> sbtcommand: Policy will be used
    for this API session.
    09:17:48.592 [3852] <4> sbtcommand: Client will be used for this API
    session.
    09:17:48.593 [3852] <4> sbtcommand: Server will be used for this
    API session.
    09:17:48.593 [3852] <4> sbtcommand: Schedule will
    be used for this API session.
    09:17:50.218 [3852] <4> get_bfs_date_range: Start Time = 04/27/03 09:19:22
    09:17:50.218 [3852] <4> get_bfs_date_range: End Time = 04/29/03 09:19:22
    09:17:50.226 [3852] <2> logconnections: BPRD CONNECT FROM 10.192.129.26.63376
    TO 10.192.129.30.13720
    09:17:50.678 [3852] <2> logconnections: BPRD CONNECT FROM 10.192.129.26.63377
    TO 10.192.129.30.13720
    09:17:50.836 [3852] <4> find_backup_image: user_RMDEV_171_1_492513562 not
    found
    09:17:50.836 [3852] <16> sbtrestore: Backup file not found.


  2. Re: unable to restore a test oracle fiole after 1 day using RMAN

    http://support.veritas.com/docs/239283
    "minh nguyen" wrote in message
    news:3eaebaf3$1@hronntp01....
    >
    > Using RMAN, I succesfuuly backed up a test Oracle datafile, I then turn

    aroud
    > and retore it with out any problem. However, if I try to restore the same
    > data file after 1 or 2 days old, I got the immage not found error even NB
    > indiate correct retention time in its log:
    >
    > 09:22:20 [8230] <4> sbtinfo2: File Ordering Mode :
    access>
    > 09:22:20 [8230] <4> sbtinfo2: Media ID :
    > 09:22:20 [8230] <4> sbtinfo2: File Creation Date and Time : <1051539570>
    > 09:22:20 [8230] <4> sbtinfo2: File Expiration Date and Time :

    <1052749170>
    > 09:22:20 [8230] <4> sbtinfo2: Comment :
    >
    > Below is error from RMAN log and from NB log in dbclient directory:
    >
    > ***** RMAN error:
    >
    > RMAN-00571: ================================================== =========
    > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    > RMAN-00571: ================================================== =========
    > RMAN-03002: failure during compilation of command
    > RMAN-03013: command type: restore
    > RMAN-03007: retryable error occurred during execution of command: IRESTORE
    > RMAN-07004: unhandled exception during command execution on channel t1
    > RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve

    sequential
    > file, handle="user_RMDEV_171_1_492513562", parms"
    > ORA-27029: skgfrtrv: sbtrestore returned error
    > ORA-19511: sbtrestore: Backup file not found.
    > RMAN-10031: ORA-19624 occurred during call to

    DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
    >
    > ****** NB error:
    >
    > 09:17:48.009 [3852] <4> sbtinit: support for Proxy Copy enabled
    > 09:17:48.592 [3852] <4> sbtcommand: Policy will be used
    > for this API session.
    > 09:17:48.592 [3852] <4> sbtcommand: Client will be used for this

    API
    > session.
    > 09:17:48.593 [3852] <4> sbtcommand: Server will be used for

    this
    > API session.
    > 09:17:48.593 [3852] <4> sbtcommand: Schedule will
    > be used for this API session.
    > 09:17:50.218 [3852] <4> get_bfs_date_range: Start Time = 04/27/03 09:19:22
    > 09:17:50.218 [3852] <4> get_bfs_date_range: End Time = 04/29/03 09:19:22
    > 09:17:50.226 [3852] <2> logconnections: BPRD CONNECT FROM

    10.192.129.26.63376
    > TO 10.192.129.30.13720
    > 09:17:50.678 [3852] <2> logconnections: BPRD CONNECT FROM

    10.192.129.26.63377
    > TO 10.192.129.30.13720
    > 09:17:50.836 [3852] <4> find_backup_image: user_RMDEV_171_1_492513562 not
    > found
    > 09:17:50.836 [3852] <16> sbtrestore: Backup file not found.
    >