When does the RMAN backup automatically back up the control file?

Source: Internet
Author: User

Target DB/RMAN Client: 11.2.0.1.0

1. When configure controlfile autobackup off;, only system01.dbf is backed up, the control file is automatically backed up;

2. When configure controlfile autobackup on; is enabled, any files (data files/archive logs) backed up will be automatically backed up to control files.

RMAN> show all;

RMAN configuration parameters for database with db_unique_name T11A 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 'd: \ ORA11G \ ORASOFT \ DATABASE \ SNCFT11A. ORA '; # default

RMAN> backup datafile 1;

Starting backup at 05-JUN-12
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 = D: \ ORA11G \ ORADATA \ T11A \ SYSTEM01.DBF
Channel ORA_DISK_1: starting piece 1 at 05-JUN-12
Channel ORA_DISK_1: finished piece 1 at 05-JUN-12
Piece handle = D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ tags tag = TAG20120605T151702 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
Including current control file in backup set
Including current SPFILE in backup set
Channel ORA_DISK_1: starting piece 1 at 05-JUN-12
Channel ORA_DISK_1: finished piece 1 at 05-JUN-12
Piece handle = D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ tags tag = TAG20120605T151702 comment = NONE
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 05-JUN-12

RMAN> list backup;


List of Backup Sets
==============================


BS Key Type LV Size Device Type Elapsed Time Completion Time
-------------------------------------------------------------
2 Full 186.25 m disk 00:00:12 05-JUN-12
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20120605T151702
Piece Name: D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NNNDF_TAG20120605T151702_7WVDMHGW_.BKP
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---------------------------------
1 Full 664502 05-JUN-12 D: \ ORA11G \ ORADATA \ T11A \ SYSTEM01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
-------------------------------------------------------------
3 Full 9.36 m disk 00:00:04 05-JUN-12
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20120605T151702
Piece Name: D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NCSNF_TAG20120605T151702_7WVDN1PN_.BKP
SPFILE encoded ded: Modification time: 05-JUN-12
SPFILE db_unique_name: T11A
Control File Included: Ckp SCN: 664507 Ckp time: 05-JUN-12

RMAN> delete backup;

Using channel ORA_DISK_1

List of Backup Pieces
BP Key BS Key Pc # Cp # Status Device Type Piece Name
----------------------------------------------------
2 2 1 1 available disk d: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NNNDF_TAG20120605T151702_7WVDMHGW_.BKP
3 3 1 1 available disk d: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NCSNF_TAG20120605T151702_7WVDN1PN_.BKP

Do you really want to delete the above objects (enter YES or NO )? Y
Deleted backup piece
Backup piece handle = D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NNNDF_TAG20120605T151702_7WVDMHGW_.BKP RECID = 2 STAMP =
Deleted backup piece
Backup piece handle = D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NCSNF_TAG20120605T151702_7WVDN1PN_.BKP RECID = 3 STAMP =
Deleted 2 objects


RMAN> backup datafile 2;

Starting backup at 05-JUN-12
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 = 00002 name = D: \ ORA11G \ ORADATA \ T11A \ SYSAUX01.DBF
Channel ORA_DISK_1: starting piece 1 at 05-JUN-12
Channel ORA_DISK_1: finished piece 1 at 05-JUN-12
Piece handle = D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ tags tag = TAG20120605T151753 comment = NONE
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 05-JUN-12

RMAN> list backup;


List of Backup Sets
==============================


BS Key Type LV Size Device Type Elapsed Time Completion Time
-------------------------------------------------------------
4 Full 132.41 m disk 00:00:08 05-JUN-12
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20120605T151753
Piece Name: D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NNNDF_TAG20120605T151753_7WVDO1TY_.BKP
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---------------------------------
2 Full 664556 05-JUN-12 D: \ ORA11G \ ORADATA \ T11A \ SYSAUX01.DBF

RMAN> delete backup;

Using channel ORA_DISK_1

List of Backup Pieces
BP Key BS Key Pc # Cp # Status Device Type Piece Name
----------------------------------------------------
4 4 1 1 available disk d: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NNNDF_TAG20120605T151753_7WVDO1TY_.BKP

Do you really want to delete the above objects (enter YES or NO )? Y
Deleted backup piece
Backup piece handle = D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NNNDF_TAG20120605T151753_7WVDO1TY_.BKP RECID = 4 STAMP =
Deleted 1 objects

  • 1
  • 2
  • Next Page

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.