DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Rman Assistance

  1. #1
    Join Date
    Feb 2006
    Posts
    37

    Rman Assistance

    Coming across and RMAN error and can not figure what it means. Any help is appreciated

    RMAN-03009: failure of backup command on ch01 channel at 05/05/2006 16:49:40
    ORA-19506: failed to create sequential file, name="bk_6872_1_589653255", parms="
    ORA-27028: skgfqcre: sbtbackup returned error
    ORA-19511: Error received from media manager layer, error text:
    VxBSACreateObject: Failed with error:
    Server Status: Communication with the server has not been iniatated or the .

    1. using NetBackUp
    2. backing up to a SBT_TAPE
    3. the script:

    RMAN> RUN {
    ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
    BACKUP
    SKIP INACCESSIBLE
    TAG hot_db_bk_level0
    FILESPERSET 5
    FORMAT 'bk_%s_%p_%t'
    DATABASE;
    sql 'alter system archive log current';
    RELEASE CHANNEL ch01;
    ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
    BACKUP
    filesperset 20
    FORMAT 'al_%s_%p_%t'
    ARCHIVELOG ALL DELETE INPUT;
    RELEASE CHANNEL ch01;
    ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
    BACKUP
    FORMAT 'cntrl_%s_%p_%t'
    CURRENT CONTROLFILE;
    RELEASE CHANNEL ch00;
    }

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    does netbackup not require any parameters to the channel?

  3. #3
    Join Date
    Apr 2006
    Posts
    377
    Yes, I believe you have to set something similar to the following:

    parms="ENV=(NB_ORA_POLICY=your_policy, NB_ORA_SERV=your_server)";

  4. #4
    Join Date
    Feb 2006
    Posts
    37
    The parameters are required in NetBackup, but it is set is the .ksh script:

    echo "NB_ORA_FULL: $NB_ORA_FULL" >> $RMAN_LOG_FILE
    echo "NB_ORA_INCR: $NB_ORA_INCR" >> $RMAN_LOG_FILE
    echo "NB_ORA_CINC: $NB_ORA_CINC" >> $RMAN_LOG_FILE
    echo "NB_ORA_SERV: $NB_ORA_SERV" >> $RMAN_LOG_FILE
    echo "NB_ORA_POLICY: $NB_ORA_POLICY" >> $RMAN_LOG_FILE
    echo >> $RMAN_LOG_FILE

    if [ "$NB_ORA_FULL" = "1" ]
    then
    echo "Full backup requested" >> $RMAN_LOG_FILE
    BACKUP_TYPE="INCREMENTAL LEVEL=0"

    elif [ "$NB_ORA_INCR" = "1" ]
    then
    echo "Differential incremental backup requested" >> $RMAN_LOG_FILE
    BACKUP_TYPE="INCREMENTAL LEVEL=1"

    elif [ "$NB_ORA_CINC" = "1" ]
    then
    echo "Cumulative incremental backup requested" >> $RMAN_LOG_FILE
    BACKUP_TYPE="INCREMENTAL LEVEL=1 CUMULATIVE"

    elif [ "$BACKUP_TYPE" = "" ]
    then
    echo "Default - Full backup requested" >> $RMAN_LOG_FILE
    BACKUP_TYPE="INCREMENTAL LEVEL=0"
    fi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width