Shulou(Shulou.com)05/31 Report--

This article mainly explains "what is the meaning of% in MAN backup FORMAT format". The content in the article is simple and clear, and it is easy to learn and understand. Please follow Xiaobian's train of thought to study and learn "what is the meaning of% in MAN backup FORMAT format".

Use RMAN > show all

It can be shown that the RMAN configuration parameters 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'% favored; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # 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 SNAPSHOT CONTROLFILE NAME TO'CRAVORACLES. SNCFTEST.ORANCES; # default 1.configure retention policy to redundancy 1:

Is used to determine which backups are no longer needed, and there are three options, namely

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS

CONFIGURE RETENTION POLICY TO REDUNDANCY 5

CONFIGURE RETENTION POLICY TO NONE

The first recover window is to maintain all sufficient backups to restore the database system to any time in the last seven days. Any database backups that exceed the last seven days will be marked as obsolete. The second type of redundancy is to maintain the latest five database backups that can be recovered, and any backup that exceeds the last five will be marked as redundancy. Its default value is 1 copy. Third, no retention policy is required, and clear will revert to the default retention policy. In general, the safest way is to use the second retention strategy. 2.CONFIGURE BACKUP OPTIMIZATION OFF

The default value is off, and if on, rman will optimize the backed-up data files, archives and other files.

3.Configure default device type to disk:

Is to specify that the device type for all Icano operations is hard disk or tape, and the default value is hard disk

The setting of the tape is CONFIGURE DEFAULT DEVICE TYPE TO SBT; 4.CONFIGURE CONTROLFILE AUTOBACKUP OFF

Force the database to automatically back up the control files after backing up the files or executing the command to change the database structure. The default value is off. This avoids that the control file can still be recovered after the control file and catalog are lost. 5.CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO'% F'

Is the backup path and backup format of the configuration control file 6.CONFIGURE DEVICE TYPE DISK PARALLELISM 1

Is the degree of parallelism of the configuration database device type. 7.CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1

Is the number of copy for each backup of the configuration database, and each backup of oracle can have multiple identical copies. 8.CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1

Is the type of storage device 9.CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:ORACLE … SNCFTEST.ORA' that sets the archive logs of the database

Is the storage path and file name of the snapshot file of the configuration control file, which is generated during the backup and is used to control the read consistency of the file. 10.CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT'Corel.% dudes DBMS% upright% slots% p'

Is to configure the backup path and backup format of the backup file CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR; to clear the channel configuration CONFIGURE EXCLUDE FOR TABLESPACE [CLEAR] above; this command is used to not back up the specified tablespace to the backup set and is useful for read-only tablespaces.

-

1. Save backup files to a specified path, such as e:\ backupb

Configure channel device type disk format'e:\ backupb\% dumbDBMS% u'

The last% d_db_%u is in storage format.

two。 We can also specify separately that control file is stored in another path, such as e:\ backupcontrol

Configure controlfile autobackup format for device type disk to'e:\ backupcontrol\% F'

The last% F is in storage format.

=

Configure commands commonly used in RMAN 2007-06-21 15:37

1 display current configuration information

= =

1.01 RMAN > show all

1.02 query non-default values in RMAN settings:

SQL > select name,value from v$rman_configure

two。 Common configure options

= =

2.01 Save Policy (retention policy)

Configure retention policy to recovery window of 3 days

Configure retention policy to redundancy 3

Configure retention policy clear

2.02 backup optimized backup optimization

Configure backup optimization on

Configure backup optimization off

Configure backup optimization clear

2.03 default device default device type

Configure default device type to disk

Configure default device type to stb

Configure default device type clear

2.04 Control File controlfile

Configure controlfile autobackup on

Configure controlfile autobackup format for device type disk to'/ cfs01/backup/conf/conf_%F'

Configure controlfile autobackup clear

Configrue controlfile autobackup format for device type disk clear

Configrue snapshot controlfile name to'/ cfs01/backup/snapcf/scontrofile.snp'

Configrue snapshot controlfile name clear

2.05 number of parallel (number of channels) device type disk | stb pallelism n

Configure device type disk | stb parallelism 2

Configure device type disk | stb clear

Configure channel device type disk format'eUniver rmanbackgrounds% U'

Configure channel device type disk maxpiecesize 100m

Configure channel device type disk rate 1200K

Configure channel 1 device type disk format'eCompact rmanbackpacking% U'

Configure channel 2 device type disk format'eCompact rmanbackpacking% U'

Configure channel 1 device type disk maxpiecesize 100m

Configure channel 1 device type disk clear

Configure channel 2 device type disk clear; 2.06 make a backup copy datafile | archivelog backup copies

Configure datafile backup copies for device type disk | stb to 3

Configure archivelog backup copies for device type disk | stb to 3

Configure datafile | archivelog backup copies for device type disk | stb clear

BACKUP DEVICE TYPE DISK DATABASE

FORMAT'/ disk1/backup/%U','/ disk2/backup/%U','/ disk3/backup/%U'

2.07 exclusion option exclude

Configure exclude for tablespace 'users'

Configrue exclude clear

2.08 backup set size maxsetsize

Configure maxsetsize to 1G | 1000m | 1000000K | unlimited

Configure maxsetsize clear

2.09 other options auxiliary

CONFIGURE AUXNAME FOR DATAFILE 1 TO'/ oracle/auxfiles/aux_1.f'

CONFIGURE AUXNAME FOR DATAFILE 2 TO'/ oracle/auxfiles/aux_2.f'

CONFIGURE AUXNAME FOR DATAFILE 3 TO'/ oracle/auxfiles/aux_3.f'

CONFIGURE AUXNAME FOR DATAFILE 4 TO'/ oracle/auxfiles/aux_4.f'

-

CONFIGURE AUXNAME FOR DATAFILE 1 CLEAR

CONFIGURE AUXNAME FOR DATAFILE 2 CLEAR

CONFIGURE AUXNAME FOR DATAFILE 3 CLEAR

CONFIGURE AUXNAME FOR DATAFILE 4 CLEAR

The various substitution variables that can be used when using the FORMAT parameter are shown below (note case):

The activation ID of the a:Oracle database is RESETLOG_ID.

% c: the number of copies of the backup segment (numbered from 1, up to 256).

D:Oracle database name.

% D: day in the current time, formatted as DD.

% e: archive serial number.

% f: absolute file number.

% F: unique name determined based on DBID+ time, in the form of c-IIIIIIIIII-YYYYMMDD-QQ, where IIIIIIIIII is the DBID,YYYYMMDD of the database is the date, and QQ is a sequence of 1x 256.

% h: archive log thread number.

DBID of the I:Oracle database.

% M: month in the current time, formatted as MM.

% N: tablespace name.

% n: database name, and will be populated with x characters on the right to keep it at 8 in length. For example, if the database name is JSSBOOK, the generated name is JSSBOOKx.

% p: the number of the backup segment in the backup set, starting at 1.

% s: backup set number.

% t: backup set timestamp.

% T: the year, month and day format of the current time (YYYYMMDD).

% u: is an 8-character name composed of backup set number and establishment time compression. With% u, you can generate a unique name for each backup set.

% U: the default is the shorthand form of% u_%p_%c, which allows you to generate a unique name for each backup fragment (that is, disk file). This is the most commonly used naming method, and different rules are generated when performing different backup operations, as shown below:

% U=%u_%p_%c when generating backup fragments

% U=data-D-%d_id-%I_TS-%N_FNO-%f_%u when generating data file mirror replication

% U=arch-D_%d-id-%I_S-%e_T-%h_A-%a_%u when generating archive image replication

% U=cf-D_%d-id-%I_%u when generating control file mirror replication.

% Y: the year in the current time, formatted as YYYY.

Note: if the FORMAT option is not specified in the BACKUP command, RMAN uses% U to name the backup fragment by default.

Thank you for your reading, the above is "what is the meaning of% in MAN backup FORMAT format", after the study of this article, I believe you have a deeper understanding of what the meaning of% in MAN backup FORMAT format is, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.