Example of using RMAN to create a backup set for Oracle11g backup and recovery
Oracle 11 GB backup and recovery example of using RMAN to create backup Sets
Homepage → Database Technology
Background:
Read News
Oracle 11 GB backup and recovery example of using RMAN to create backup Sets
[Date:] Source: Linux Author: LuiseDalian [Font:]
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 --------------------------------------
0
MySQL builds a replication environment with filtering
Oracle Data Pump remote import file to local database
Related information rman backup
Image Information
Automatic Backup of RMAN in RHEL5
Reference for making RMAN backup policies
View All comments in this article (0)
Comments
Latest Information
Popular this week
Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.
Copyright©2006-2014 Linux community All rights reserved Zhejiang ICP backup No. 06018118