Oracle 11 GB backup and recovery example of using RMAN to create backup Sets

Oracle 11 GB backup and recovery example of using RMAN to create backup Sets

Oracle 11 GB backup and recovery example of using RMAN to create backup Sets

-- % D: Specifies the name of the database

-- % S: Specifies the backup set number. This number is a counter in the control file that is incremented for each backup set.

-- The counter value starts at 1 and is unique for the lifetime of the control file.

-- If you restore a backup control file, then duplicate values can result.

-- Also, create controlfile initializes the counter back to 1

-- % P: Specifies the piece number within the backup set.

-- This value starts at 1 for each backup set and is incremented by 1 as each backup piece is created.

 

RMAN> backup as backupset format'/backup01/df _ % d _ % s _ % p. bus' tablespace users;

 

Starting backup at 09-AUG-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 = 00004 name = + DISKGROUP01/testdb11/users01.dbf

Channel ORA_DISK_1: starting piece 1 at 09-AUG-14

Channel ORA_DISK_1: finished piece 1 at 09-AUG-14

Piece handle =/backup01/df_TESTDB11_31_1.bus tag = tag20140809t0000346 comment = NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 09-AUG-14

 

-- View the generated backup file

[Oracle@OL54.cuug.net:/backup01] $ ls-l

Total 18248

-Rw-r ----- 1 oracle dba 9830400 Aug 9 02pfgdr4_1_1

-Rw-r ----- 1 oracle dba 5251072 Aug 9 data_D-TESTDB11_I-2620210741_TS-USERS_FNO-4_0mpfgjqi

-Rw-r ----- 1 oracle dba 3571712 Aug 9 df_TESTDB11_31_1.bus

 

-- Delete all backups

RMAN> delete backup;

 

Using channel ORA_DISK_1

 

List of Backup Pieces

BP Key BS Key Pc # Cp # Status Device Type Piece Name

----------------------------------------------------

575 574 1 1 available disk/backup01/df_TESTDB11_31_1.bus

 

Do you really want to delete the above objects (enter YES or NO )? Yes

Deleted backup piece

Backup piece handle =/backup01/df_TESTDB11_31_1.bus RECID = 26 STAMP = 855139427

Deleted 1 objects

-------------------------------------- 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 --------------------------------------