Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What is the default configuration of configuration in RMAN

2025-03-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

This article is about what the default configuration of configuration in RMAN is. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Use the backup command to back up the database. RMAN backs up data to the default device in a specified manner. By default, it is backed up to disk. If the FORMAT parameter is not specified, RMAN is backed up to the quick recovery area. RMAN creates a backup with a unique name in the recovery area.

By default, RMAN creates backup sets instead of mirrors. A backup set contains one or more backup slices, which are made up of physical files that can only be read by RMAN. RMAN can be backed up to disk or tape.

If you specify BACKUP AS COPY,RMAN, a copy image of these files is created. Because the copies of these mirrors are actually the same as the cp command, except that cp is not recorded in RMAN so it cannot be referenced by RMAN, these images are actually copies of these database files. You can use RMAN to create a copy mirror when the database is open

Before using rman backup, you should review the default configuration of the current target database

View default configuration

RMAN > show all

Using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name TEST 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 BACKUP TYPE TO BACKUPSET; # 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 ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE' DEFAULT' OPTIMIZE FOR LOAD TRUE; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/ u01 CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/ u01 apprenticespact oracleash produce 11.2 Universe dbsAccord snapcfharmtest.fishes; # default

You can also use the configuration specified by show, such as

RMAN > show retention policy

RMAN configuration parameters for database with db_unique_name TEST are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

RMAN > show controlfile autobackup

RMAN configuration parameters for database with db_unique_name TEST are:

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

Restore the default configuration

Use CONFIGURE... CLEAR restores the specified configuration to the default

RMAN > configure retention policy clear

RMAN configuration parameters are successfully reset to default value

Thank you for reading! This is the end of the article on "what is the default configuration of configuration in RMAN". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report