RMAN configuration_clear_all (RESET ALL SETTINGS TO DEFAULT)

% rman target / nocatalog @rman_configuration_clear_all_9i.rcv

Recovery Manager: Release 9.2.0.5.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: ORA920 (DBID=2542143170)
using target database controlfile instead of recovery catalog

RMAN> # +----------------------------------------------------------------------------+
2> # |                          Jeffrey M. Hunter                                 |
3> # |                      jhunter@idevelopment.info                             |
4> # |                         www.idevelopment.info                              |
5> # |----------------------------------------------------------------------------|
6> # |      Copyright (c) 1998-2009 Jeffrey M. Hunter. All rights reserved.       |
7> # |----------------------------------------------------------------------------|
8> # | DATABASE : Oracle                                                          |
9> # | FILE     : rman_configuration_clear_all_9i.rcv                             |
10> # | CLASS    : Recovery Manager                                                |
11> # | PURPOSE  : Provides an RMAN script used to clear all persistent RMAN       |
12> # |            configuration parameters to their default value.                |
13> # | NOTE     : As with any code, ensure to test this script in a development   |
14> # |            environment before attempting to run it in production.          |
15> # +----------------------------------------------------------------------------+
16>
17> # +----------------------------------------------------------------------------+
18> # |                  <<<    RMAN DEFAULT SETTING    >>>                        |
19> # |----------------------------------------------------------------------------+--------------------------+
20> # | CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default                                                 |
21> # | CONFIGURE BACKUP OPTIMIZATION OFF; # default                                                          |
22> # | CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default                                                      |
23> # | CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default                                                       |
24> # | CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default                       |
25> # | CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default                                                   |
26> # | CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default                                 |
27> # | CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default                               |
28> # | CONFIGURE MAXSETSIZE TO UNLIMITED; # default                                                          |
29> # | CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/9.2.0/dbs/snapcf_ORA920.f'; # default |
30> # +-------------------------------------------------------------------------------------------------------+
31>
32> CONFIGURE RETENTION POLICY CLEAR;
33>
34> CONFIGURE BACKUP OPTIMIZATION CLEAR;
35>
36> CONFIGURE DEFAULT DEVICE TYPE CLEAR;
37>
38> CONFIGURE CONTROLFILE AUTOBACKUP CLEAR;
39> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;
40> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT CLEAR;
41>
42> CONFIGURE DEVICE TYPE DISK CLEAR;
43>
44> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK CLEAR;
45> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT  CLEAR;
46> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK CLEAR;
47> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT CLEAR;
48>
49> CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR;
50> CONFIGURE CHANNEL DEVICE TYPE SBT CLEAR;
51>
52> CONFIGURE MAXSETSIZE CLEAR;
53>
54> CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR;
55>
56> # CONFIGURE EXCLUDE FOR TABLESPACE USERS_READ_TBS;
57>
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
RMAN configuration parameters are successfully reset to default value

RMAN configuration parameters are successfully reset to default value

old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
RMAN configuration parameters are successfully reset to default value

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN configuration parameters are successfully reset to default value

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/orabackup/rman/ORA920/%F.ctl';
RMAN configuration parameters are successfully reset to default value

RMAN configuration parameters are successfully reset to default value

RMAN configuration parameters are successfully reset to default value

RMAN configuration parameters are successfully reset to default value

RMAN configuration parameters are successfully reset to default value

RMAN configuration parameters are successfully reset to default value

RMAN configuration parameters are successfully reset to default value

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/orabackup/rman/ORA920/backup_db_%d_S_%s_P_%p_T_%t' MAXPIECESIZE 1024 M;
old RMAN configuration parameters are successfully deleted

old RMAN configuration parameters are successfully deleted

RMAN configuration parameters are successfully reset to default value

RMAN configuration parameters are successfully reset to default value

Recovery Manager complete.

%
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s