How Oracle restores the Rman initial configuration

Source: Internet
Author: User

[Oracle@ggos ~]$ Rman Target/

Recovery manager:release 11.2.0.4.0-production on Fri Dec 6 00:17:59 2013

Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.

Connected to target Database:oraprod (dbid=9124528)

Rman> Show All;

Using target database control file instead of recovery catalog

RMAN configuration parameters for database with Db_unique_name Oraprod 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 '%F '; # 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/APP/ORACLE/PRODUCT/11.2.0/DBHOME_1/DBS/SNAPCF_ORAPROD.F '; # Default

rman> CONFIGURE Archivelog BACKUP copies for DEVICE TYPE DISK to 2;

New RMAN configuration parameters:

CONFIGURE Archivelog BACKUP copies for DEVICE TYPE DISK to 2;

New RMAN configuration parameters are successfully stored

Rman> Show All;

RMAN configuration parameters for database with Db_unique_name Oraprod 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 '%F '; # 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 2;

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/APP/ORACLE/PRODUCT/11.2.0/DBHOME_1/DBS/SNAPCF_ORAPROD.F '; # Default

Rman>

CONFIGURE Archivelog BACKUP copies for DEVICE TYPE DISK to 2;

rman> CONFIGURE Archivelog BACKUP copies for DEVICE TYPE DISK clear;

Old RMAN configuration parameters:

CONFIGURE Archivelog BACKUP copies for DEVICE TYPE DISK to 2;

RMAN configuration parameters are successfully reset to default value

Rman> Show All;

RMAN configuration parameters for database with Db_unique_name Oraprod 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 '%F '; # 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/APP/ORACLE/PRODUCT/11.2.0/DBHOME_1/DBS/SNAPCF_ORAPROD.F '; # Default

CONFIGURE Archivelog BACKUP copies for DEVICE TYPE DISK clear;

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.