rman and datafilecopy

[doraemona]

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

[alexandre]

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.

[netbar]

This will be determined by executing list copy from RCAT,.


change datafilecopy 'users.dbf' uncatalog; or catalog

[doraemona]

it doesnt work

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