Veritas-bu

[Veritas-bu] RMAN Problems (ORA-27206)

2001-03-30 07:18:24
Subject: [Veritas-bu] RMAN Problems (ORA-27206)
From: dvl AT 2scale DOT net (Dirk Vleugels)
Date: Fri, 30 Mar 2001 14:18:24 +0200
Hello,
[please CC me, i'm not subscribed to veritas-bu]

i'm trying to backup a 8.1.6.0.0 Database using 'NetBackup for Oracle8 -
Release 3.4GA (030800)'. When starting the initial level0 backup, i
encounter the following exception:

--cut

RMAN-08008: channel t1: starting incremental level 0 datafile backupset
RMAN-08502: set_count=46 set_stamp=425740441 creation_time=30-MAR-01
RMAN-08010: channel t1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00002 name=/data/oracle/files/rollback_01
RMAN-08522: input datafile fno=00005 name=/data/oracle/files/data_01
RMAN-08522: input datafile fno=00003 name=/data/oracle/files/temp_01
RMAN-08522: input datafile fno=00001 name=/data/oracle/files/system_01
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00004 name=/data/oracle/files/tools_01
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script backup_inc
RMAN-03006: non-retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-27206: requested file not found in
media management catalog
RMAN-10031: ORA-19583 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
 
 RMAN-00571: ===========================================================
 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 RMAN-00571: ===========================================================
 RMAN-00558: error encountered while parsing input commands
 RMAN-01005: syntax error: found ";": expecting one of: ällocate, alter,
beginline, catalog, change, connect, create, crosscheck, configure, debug,
delete, drop, exit, endinline, host, {, library, list, mount, open, print,
register, release, replace, report, renormalize, reset, resync, rman, rpctLµ¨"
RMAN-01007: at line 0 column 35 file: standard input

--cut

The recovery catalog for the target database reports the following (disk
based) backups:

RMAN-03022: compiling command: list
 
 List of Backup Sets
 Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
 ------- ---------- ---------- -- ---------- ---------- ----------------------
 106     25         425398575  0  425398435  34         26-MAR-01
  
      List of Backup Pieces
          Key     Pc# Cp# Status      Completion Time        Piece Name
              ------- --- --- ----------- ----------------------
------------------------
    110     1   1   AVAILABLE   26-MAR-01
/data/backup/oracle/INCR0_425398435_34_1.bck
    111     2   1   AVAILABLE   26-MAR-01
/data/backup/oracle/INCR0_425398435_34_2.bck
 
     List of Datafiles Included
         File Name                                  LV Type Ckp SCN    Ckp
Time
    ---- ------------------------------------- -- ---- ----------
-------------
    1    /data/oracle/files/system_01          0  Full 196241     26-MAR-01
        2    /data/oracle/files/rollback_01        0  Full 196241
26-MAR-01
    3    /data/oracle/files/temp_01            0  Full 196241     26-MAR-01
        4    /data/oracle/files/tools_01           0  Full 196241
26-MAR-01
    5    /data/oracle/files/data_01            0  Full 196241     26-MAR-01
     
     List of Backup Sets
     Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
     ------- ---------- ---------- -- ---------- ----------
----------------------
107     26         425398798  2  425398667  35         26-MAR-01
 
     List of Backup Pieces
         Key     Pc# Cp# Status      Completion Time        Piece Name
             ------- --- --- ----------- ----------------------
------------------------
    112     1   1   AVAILABLE   26-MAR-01
/data/backup/oracle/CUMU2_425398667_35_1.bck
 
     List of Datafiles Included
         File Name                                  LV Type Ckp SCN    Ckp
Time
    ---- ------------------------------------- -- ---- ----------
-------------
    1    /data/oracle/files/system_01          2  Incr 196249     26-MAR-01
        2    /data/oracle/files/rollback_01        2  Incr 196249
26-MAR-01
    3    /data/oracle/files/temp_01            2  Incr 196249     26-MAR-01
        4    /data/oracle/files/tools_01           2  Incr 196249
26-MAR-01
    5    /data/oracle/files/data_01            2  Incr 196249     26-MAR-01
    
Incarnations:

RMAN> list incarnation;
 
 RMAN-03022: compiling command: list
  
  List of Database Incarnations
  DB Key  Inc Key DB Name  DB ID            CUR Reset SCN  Reset Time
  ------- ------- -------- ---------------- --- ---------- ----------
  82      91      UNKNOWN  2203048905       NO  155576     22-MAR-01
  82      93      UNKNOWN  2203048905       NO  155689     22-MAR-01
  82      96      UNKNOWN  2203048905       NO  176026     26-MAR-01
  82      150     UNKNOWN  2203048905       NO  196172     26-MAR-01
  82      83      TESTDB   2203048905       YES 196242     26-MAR-01


The backup script used:

RMAN> print script backup_inc;
 
RMAN-03027: printing stored script: backup_inc
{
          execute script alloc_2_tape_channel;
                  backup
                          incremental level 0
                          skip offline
                          skip inaccessible
                          filesperset 10
                          tag bck_fullinc_lv0
                          format 'incr0_%U_%t.bck'
                          (database);
                          sql 'alter system archive log current';
                  backup
                          filesperset 20
                          format 'incr0_rl_%U_%t.bck'
                          (archivelog all
                          delete input);
         execute script release_2_tape_channel;
}


Any hints?

Regards,
Dirk

-- 
GPG Fingerprint: 6F4D 8A7C 1E1C 8BF5 6858  61B3 1DED CF7D 7638 0192

<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] RMAN Problems (ORA-27206), Dirk Vleugels <=