Rman-- backup command
RMAN complete
/ / Parameter files, control files, data files, archive logs, do not back up online log files
RMAN > backup database
RMAN backup is divided into copy physical backup: the source file is as large as the file after backup.
Backup logical backup, based on block level backup. Blocks that have been used, hot blocks.
Back up only a single file
RMAN > backup spfile
RMAN can only back up binary files, text files cannot be backed up, so pfile cannot be backed up.
RMAN > backup current controlfile
RMAN > backup datafile 2
A tablespace has a maximum of 1024 data files
RMAN > backup tablespace users
RMAN > backup archivelog all
/ / back up the entire library, including archive logs
RMAN > backup full database plus archivelog
Delete the original archive log
RMAN > backup archivelog all delete input
Back up the tablespace, not a data file
(1) do not back up that one set to read only
Skip read-only
Backup database skip readonly
Skip offline
Backup database skip offline
The backup set is saved by default:
/ oracle/orcl/flash_recovery_area/ORCL/backupset
Change the backup set save location:
Backup database format'/ oracle/db_full_%U'
Format of the backup file:
Backup files can be customized in a variety of formats:
C number of copies of backup slices
D database name
% D is located on the day of the month (DD)
% M is located in the month of the year (MM)
% F A unique name based on DBID, in the form of c-IIIII-YYYYMMDD-QQ
Where IIIII is the DBID,YYYYMMDD of the database is the date, and QQ is a sequence of 1Mui 256.
% n database name, fill to the right up to eight characters
% u an eight-character name represents the backup set and creation time
% p the backup slice number in this backup set, starting from 1 to the number of files created
% U A unique file name representing% u_%p_%c
Number of% s backup set
T backup set timestamp
% T month and day format (YYYYMMDD)
SQL > show parameter db_rec
NAME TYPE VALUE
-
Db_recovery_file_dest string / oracle/orcl/flash_recovery_ar
Ea
Db_recovery_file_dest_size big integer 3882M
Db_recycle_cache_size big integer 0
Db_recovery_file_dest_size: size of the flashback area
Backup specified assignment channel, custom assignment
Run {...}
Run {backup database;}
Copy datafile 1 to'/...'
The following command has the same effect:
RMAN > copy current controlfile to'/ oracle/back.ctl'
SQL > alter database backup controlfile to'/ oracle/bac1.ctl'
The following command has the same effect:
RMAN > copy datafile 4 to'/ oracle/db4.dbf'
SQL > alter tablespace users begin backup
SQL > ho cp / oracle/orcl/oradata/orcl/users01.dbf / oracle/users01_bak.dbf
SQL > alter tablespace users end backup
RMAN > backup as copy database
How to check the backups that have been made
RMAN > list backup
List copy
List backup of database
List backup of datafile 1
