-
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
-
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.
-
This will be determined by executing list copy from RCAT,.
change datafilecopy 'users.dbf' uncatalog; or catalog
-
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