Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.