Usage of RMAN crosscheck and obsolete

I have never been clear about the usage of rman crosschcek and obsolete, and it is a bit confusing. This will have a great impact on the management of rman backup sets and even backups. I will test it in time today, make up for this important link in time

-------------------------------------- Split line --------------------------------------

Recommended reading:

RMAN: Configure an archive log deletion policy

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

-------------------------------------- Split line --------------------------------------

RMAN> show all;
 
RMAN configuration parameters for database with db_unique_name XUPENG are:
Configure retention policy to redundancy 1; # default
Configure backup optimization off; # default
Configure default device type to disk; # default
Configure controlfile autobackup off; # default
Configure controlfile autobackup format for device type disk to '% F'; # default
Configure device type disk parallelism 1 backup type to backupset; # default
Configure datafile backup copies for device type disk to 1; # default
Configure archivelog backup copies for device type disk to 1; # default
Configure maxsetsize to unlimited; # default
Configure encryption for database off; # default
Configure encryption algorithm 'aes128 '; # default
Configure compression algorithm 'basic 'as of release 'default' optimize for load true; # DEFAULT
Configure archivelog deletion policy to none; # default
Configure snapshot controlfile name to '/u01/app/oracle/product/11.2.0.3/db_1/dbs/snapcf_xupeng.f'; # default
--- Retain a copy of the Default policy
 
--- No backup set is available for the current database
RMAN> list backup summary;
 
Specification does not match any backup in the repository
 
Make a full backup!
RMAN> backup database format'/u01/backup/ora_full _ % U ';
 
Starting backup at 10-MAR-14
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: SID = 38 device type = DISK
Channel ORA_DISK_1: starting full datafile backup set
Channel ORA_DISK_1: specifying datafile (s) in backup set
Input datafile file number = 00004 name =/u01/app/oracle/oradata/XUPENG/users01.dbf
Input datafile file number = 00001 name =/u01/app/oracle/oradata/XUPENG/system01.dbf
Input datafile file number = 00002 name =/u01/app/oracle/oradata/XUPENG/sysaux01.dbf
Input datafile file number = 00003 name =/u01/app/oracle/oradata/XUPENG/undotbs01.dbf
Input datafile file number = 00005 name =/u01/app/oracle/oradata/XUPENG/tools. dbf
Input datafile file number = 00006 name =/u01/app/oracle/oradata/XUPENG/test. dbf
Input datafile file number = 00008 name =/u01/app/oracle/oradata/XUPENG/xupeng. dbf
Channel ORA_DISK_1: starting piece 1 at 10-MAR-14
Channel ORA_DISK_1: finished piece 1 at 10-MAR-14
Piece handle =/u01/backup/ora_full_01p2qnrf_1_1 tag = TAG20140310T105231 comment = NONE
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Channel ORA_DISK_1: starting full datafile backup set
Channel ORA_DISK_1: specifying datafile (s) in backup set
Input datafile file number = 00007 name =/u01/app/oracle/oradata/XUPENG/fuck. dbf
Channel ORA_DISK_1: starting piece 1 at 10-MAR-14
Channel ORA_DISK_1: finished piece 1 at 10-MAR-14
Piece handle =/u01/backup/ora_full_02p2qnrm_1_1 tag = TAG20140310T105231 comment = NONE
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
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
Including current SPFILE in backup set
Channel ORA_DISK_1: starting piece 1 at 10-MAR-14
Channel ORA_DISK_1: finished piece 1 at 10-MAR-14
Piece handle =/u01/backup/ora_full_03p2qnrn_1_1 tag = TAG20140310T105231 comment = NONE
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-MAR-14
 
-- Backup Data File system
RMAN> backup datafile 1 format'/u01/backup/ora_system _ % U ';
 
Starting backup at 10-MAR-14
Using channel ORA_DISK_1
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/XUPENG/system01.dbf
Channel ORA_DISK_1: starting piece 1 at 10-MAR-14
Channel ORA_DISK_1: finished piece 1 at 10-MAR-14
Piece handle =/u01/backup/ora_system_04p2qnuc_1_1 tag = TAG20140310T105404 comment = NONE
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
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
Including current SPFILE in backup set
Channel ORA_DISK_1: starting piece 1 at 10-MAR-14
Channel ORA_DISK_1: finished piece 1 at 10-MAR-14
Piece handle =/u01/backup/ora_system_05p2qnuf_1_1 tag = TAG20140310T105404 comment = NONE
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-MAR-14
---- All backups will include control files and spfiles.

For more details, please continue to read the highlights on the next page:

1 2 3 Next Page