SQL> DROP TABLESPACE rcat INCLUDING CONTENTS AND DATAFILES;
Tablespace dropped.
SQL>
Saturday, May 24, 2025
How backup database using rman keep forever ?
RMAN> backup database keep forever ;
Starting backup at 24-MAY-25
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/24/2025 14:12:06
RMAN-06522: KEEP FOREVER option is not supported without the recovery catalog
RMAN>
RMAN> backup database keep until time 'sysdate+1';
Starting backup at 24-MAY-25
using channel ORA_DISK_1
backup will be obsolete on date 25-MAY-25
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=/u01/app/oracle/oradata/DB1/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/DB1/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/DB1/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/DB1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAY-25
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/24/2025 14:13:04
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/DB1/pdb/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/DB1/pdb/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/DB1/pdb/undotbs01.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/DB1/pdb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAY-25
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/24/2025 14:13:06
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00017 name=/u01/app/oracle/oradata/demo1/sysaux01.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/demo1/system01.dbf
input datafile file number=00018 name=/u01/app/oracle/oradata/demo1/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAY-25
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/24/2025 14:13:07
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/DB1/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/DB1/pdbseed/system01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/DB1/pdbseed/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAY-25
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/24/2025 14:13:08
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
RMAN>
RMAN> backup database keep until time 'sysdate+1';
Starting backup at 24-MAY-25
using channel ORA_DISK_1
backup will be obsolete on date 25-MAY-25
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=/u01/app/oracle/oradata/DB1/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/DB1/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/DB1/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/DB1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAY-25
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/24/2025 14:13:04
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/DB1/pdb/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/DB1/pdb/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/DB1/pdb/undotbs01.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/DB1/pdb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAY-25
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/24/2025 14:13:06
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00017 name=/u01/app/oracle/oradata/demo1/sysaux01.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/demo1/system01.dbf
input datafile file number=00018 name=/u01/app/oracle/oradata/demo1/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAY-25
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/24/2025 14:13:07
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/DB1/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/DB1/pdbseed/system01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/DB1/pdbseed/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAY-25
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/24/2025 14:13:08
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
RMAN>
RMAN>
RMAN> backup database format '/u01/app/oracle/%U' keep until time 'sysdate+1';
Starting backup at 24-MAY-25
using channel ORA_DISK_1
backup will be obsolete on date 25-MAY-25
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=/u01/app/oracle/oradata/DB1/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/DB1/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/DB1/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/DB1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAY-25
channel ORA_DISK_1: finished piece 1 at 24-MAY-25
piece handle=/u01/app/oracle/2n3q8ulb_1_1 tag=TAG20250524T141402 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/DB1/pdb/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/DB1/pdb/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/DB1/pdb/undotbs01.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/DB1/pdb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAY-25
channel ORA_DISK_1: finished piece 1 at 24-MAY-25
piece handle=/u01/app/oracle/2o3q8um4_1_1 tag=TAG20250524T141402 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00017 name=/u01/app/oracle/oradata/demo1/sysaux01.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/demo1/system01.dbf
input datafile file number=00018 name=/u01/app/oracle/oradata/demo1/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAY-25
channel ORA_DISK_1: finished piece 1 at 24-MAY-25
piece handle=/u01/app/oracle/2p3q8umj_1_1 tag=TAG20250524T141402 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/DB1/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/DB1/pdbseed/system01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/DB1/pdbseed/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAY-25
channel ORA_DISK_1: finished piece 1 at 24-MAY-25
piece handle=/u01/app/oracle/2q3q8un3_1_1 tag=TAG20250524T141402 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
current log archived
using channel ORA_DISK_1
backup will be obsolete on date 25-MAY-25
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=20 RECID=15 STAMP=1201961707
channel ORA_DISK_1: starting piece 1 at 24-MAY-25
channel ORA_DISK_1: finished piece 1 at 24-MAY-25
piece handle=/u01/app/oracle/2r3q8unc_1_1 tag=TAG20250524T141402 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
using channel ORA_DISK_1
backup will be obsolete on date 25-MAY-25
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 24-MAY-25
channel ORA_DISK_1: finished piece 1 at 24-MAY-25
piece handle=/u01/app/oracle/2s3q8und_1_1 tag=TAG20250524T141402 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
using channel ORA_DISK_1
backup will be obsolete on date 25-MAY-25
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 24-MAY-25
channel ORA_DISK_1: finished piece 1 at 24-MAY-25
piece handle=/u01/app/oracle/2t3q8unf_1_1 tag=TAG20250524T141402 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 24-MAY-25
RMAN>
RMAN-06603: TO DESTINATION option must be specified with RECOVERY AREA, RECOVERY FILES or DB_RECOVERY_FILE_DEST on disk device
RMAN> backup recovery area;
Starting backup at 24-MAY-25
using channel ORA_DISK_1
specification does not match any datafile copy in the repository
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/24/2025 13:47:36
RMAN-06603: TO DESTINATION option must be specified with RECOVERY AREA, RECOVERY FILES or DB_RECOVERY_FILE_DEST on disk device
RMAN> backup recovery files;
Starting backup at 24-MAY-25
using channel ORA_DISK_1
specification does not match any datafile copy in the repository
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/24/2025 13:47:50
RMAN-06603: TO DESTINATION option must be specified with RECOVERY AREA, RECOVERY FILES or DB_RECOVERY_FILE_DEST on disk device
Note : we have to specify the destination directory path where we need to take backup
BACKUP RECOVERY AREA TO DESTINATION 'u01/app/oracle/backup';
Subscribe to:
Posts (Atom)