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

Thread: rman and datafilecopy

  1. #1
    Join Date
    Jun 2000
    Posts
    41

    Angry rman and datafilecopy

    Hi

    has anyone used datafilecopy in rman 9i?

    I get this error

    RMAN> BACKUP DATAFILECOPY '/tmp/users.dbf';

    Starting backup at 17/06/03
    using channel ORA_DISK_1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of backup command at 06/17/2003 08:46:33
    RMAN-06004: ORACLE error from recovery catalog database: RMAN-20230: datafile copy not found in the recovery catalog
    RMAN-06015: error while looking up datafilecopy name: /tmp/users.dbf

  2. #2
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96
    Hello, there
    Oracle it says : The specified datafile is not in the recovery catalog or it has been marked deleted.
    So try the following
    select db_key, tablespace_name,name, included_in_database_backup from
    rman.rc_datafile;


    make sure that the datafile is there and is set to YES on the included_in_database_backup field.

    I hope it will help.
    In god i trust

  3. #3
    Join Date
    Jul 2001
    Posts
    181
    This will be determined by executing list copy from RCAT,.


    change datafilecopy 'users.dbf' uncatalog; or catalog

  4. #4
    Join Date
    Jun 2000
    Posts
    41
    it doesnt work

    Code:
    Report of database schema
    File K-bytes    Tablespace           RB segs Datafile Name
    ---- ---------- -------------------- ------- -------------------
    1        337920 SYSTEM               YES     /u02/oradata/acdb920/system01.dbf
    2         10240 UNDOTBS1             YES     /u02/oradata/acdb920/undotbs01.dbf
    3          5120 DRSYS                NO      /u02/oradata/acdb920/drsys01.dbf
    4        133120 EXAMPLE              NO      /u02/oradata/acdb920/example01.dbf
    5          1024 INDX                 NO      /u02/oradata/acdb920/indx01.dbf
    6          1024 TOOLS                NO      /u02/oradata/acdb920/tools01.dbf
    7         10240 USERS                NO      /u02/oradata/acdb920/users01.dbf
    8         39040 XDB                  NO      /u02/oradata/acdb920/xdb01.dbf
    
    RMAN> change datafilecopy '/u02/oradata/acdb920/drsys01.dbf' catalog;
    
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00558: error encountered while parsing input commands
    RMAN-01005: syntax error: found "catalog": expecting one of: "available, comma, crosscheck, delete, device, keep, nokeep, unavailable, uncatalog, validate"
    RMAN-01007: at line 1 column 55 file: standard input
    
    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: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, spool, startup, shutdown, send, show, test, upgrade, validate"
    RMAN-01007: at line 1 column 62 file: standard input
    
    RMAN> catalog datafilecopy '/u02/oradata/acdb920/drsys01.dbf';
    
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03009: failure of catalog command on default channel at 06/17/2003 18:50:21
    ORA-19657: cannot inspect current datafile /u02/oradata/acdb920/drsys01.dbf
    
    RMAN> backup datafilecopy '/u02/oradata/acdb920/drsys01.dbf' ;
    
    Starting backup at 17/06/03
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=10 devtype=DISK
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of backup command at 06/17/2003 18:51:20
    RMAN-06004: ORACLE error from recovery catalog database: RMAN-20230: datafile copy not found in the recovery catalog
    RMAN-06015: error while looking up datafilecopy name: /u02/oradata/acdb920/drsys01.dbf
    it´s Rman 9.2.0

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