Thursday, May 15, 2014

ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes



$ rman target "/" @rman_11.cmd |tee -a rman_11.log

Recovery Manager: Release 11.2.0.4.0 - Production on Thu May 15 06:56:16 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CVRMAN (DBID=657566608)

RMAN> run
2> {
3> backup as backupset
4> tag="keep_180"
5> keep until time "sysdate+180"
6> database;
7> }
8>
Starting backup at 15-MAY-2014 06:56:22
current log archived

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=52 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=40 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=54 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=47 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=24 device type=DISK
backup will be obsolete on date 11-NOV-2014 06:56:34
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
input datafile file number=00004 name=+DATA/cvrman/datafile/users.259.847354795
channel ORA_DISK_1: starting piece 1 at 15-MAY-2014 06:56:36
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
input datafile file number=00006 name=+DATA/cvrman/datafile/tbs1.294.847433665
channel ORA_DISK_2: starting piece 1 at 15-MAY-2014 06:56:36
channel ORA_DISK_3: starting full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/cvrman/datafile/example.308.847525493
input datafile file number=00003 name=+DATA/cvrman/datafile/undotbs1.258.847354795
channel ORA_DISK_3: starting piece 1 at 15-MAY-2014 06:56:36
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/15/2014 06:56:36
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
continuing other job steps, job failed will not be re-run
RMAN-03009: failure of backup command on ORA_DISK_2 channel at 05/15/2014 06:56:36
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
continuing other job steps, job failed will not be re-run
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/15/2014 06:56:37
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

Recovery Manager complete.


Solution:

Included format clause to provide different file location other thatn the db_recovery_file_dest. Keep attributes fails with the db_recovery_file_dest


Recovery Manager: Release 11.2.0.4.0 - Production on Thu May 15 06:59:03 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CVRMAN (DBID=657566608)

RMAN> run
2> {
3> backup as backupset
4> tag="keep_180"
5> keep until time "sysdate+180"
6> format="/SHARED/backup1/%U"
7> database;
8> }
9>
Starting backup at 15-MAY-2014 06:59:09
current log archived    #current log is archived

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=54 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=40 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=52 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=30 device type=DISK
backup will be obsolete on date 11-NOV-2014 06:59:19
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
input datafile file number=00004 name=+DATA/cvrman/datafile/users.259.847354795
channel ORA_DISK_1: starting piece 1 at 15-MAY-2014 06:59:21
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
input datafile file number=00006 name=+DATA/cvrman/datafile/tbs1.294.847433665
channel ORA_DISK_2: starting piece 1 at 15-MAY-2014 06:59:22
channel ORA_DISK_3: starting full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/cvrman/datafile/example.308.847525493
input datafile file number=00003 name=+DATA/cvrman/datafile/undotbs1.258.847354795
channel ORA_DISK_3: starting piece 1 at 15-MAY-2014 06:59:22
channel ORA_DISK_3: finished piece 1 at 15-MAY-2014 07:00:38
piece handle=/SHARED/backup1/5bp8avaa_1_1 tag=KEEP_180 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:01:16
channel ORA_DISK_1: finished piece 1 at 15-MAY-2014 07:01:08
piece handle=/SHARED/backup1/59p8ava9_1_1 tag=KEEP_180 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:47
channel ORA_DISK_2: finished piece 1 at 15-MAY-2014 07:01:08
piece handle=/SHARED/backup1/5ap8ava9_1_1 tag=KEEP_180 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:01:46
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
backup will be obsolete on date 11-NOV-2014 07:01:08
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 15-MAY-2014 07:01:08
channel ORA_DISK_1: finished piece 1 at 15-MAY-2014 07:01:10
piece handle=/SHARED/backup1/5cp8avdk_1_1 tag=KEEP_180 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
backup will be obsolete on date 11-NOV-2014 07:01:11
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=10 RECID=45 STAMP=847609270
channel ORA_DISK_1: starting piece 1 at 15-MAY-2014 07:01:11
channel ORA_DISK_1: finished piece 1 at 15-MAY-2014 07:01:12
piece handle=/SHARED/backup1/5dp8avdn_1_1 tag=KEEP_180 comment=NONE    # complete database is backed up
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
backup will be obsolete on date 11-NOV-2014 07:01:12
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 15-MAY-2014 07:01:14
channel ORA_DISK_1: finished piece 1 at 15-MAY-2014 07:01:15
piece handle=/SHARED/backup1/5ep8avdp_1_1 tag=KEEP_180 comment=NONE #archive logs required to recover this backup is backed up
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 15-MAY-2014 07:01:15

Recovery Manager complete.

No comments: