Configure setting in RMAN

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd\

C:\>rman target /

Recovery Manager: Release 9.2.0.1.0 - Production

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

connected to target database: IACM (DBID=1202858792)

RMAN> report schema;

using target database controlfile instead of recovery catalog
Report of database schema
File K-bytes    Tablespace           RB segs Datafile Name
---- ---------- -------------------- ------- -------------------
1        409600 SYSTEM               ***     H:\ORACLE\ORADATA\IACM\SYSTEM01.DBF

2        204800 UNDOTBS1             ***     H:\ORACLE\ORADATA\IACM\UNDOTBS01.DB
F
3         20480 CWMLITE              ***     H:\ORACLE\ORADATA\IACM\CWMLITE01.DB
F
4         20480 DRSYS                ***     H:\ORACLE\ORADATA\IACM\DRSYS01.DBF
5        152320 EXAMPLE              ***     H:\ORACLE\ORADATA\IACM\EXAMPLE01.DB
F
6         25600 INDX                 ***     H:\ORACLE\ORADATA\IACM\INDX01.DBF
7         20480 ODM                  ***     H:\ORACLE\ORADATA\IACM\ODM01.DBF
8         10240 TOOLS                ***     H:\ORACLE\ORADATA\IACM\TOOLS01.DBF
9         25600 USERS                ***     H:\ORACLE\ORADATA\IACM\USERS01.DBF
10        39040 XDB                  ***     H:\ORACLE\ORADATA\IACM\XDB01.DBF

RMAN> show all;

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 '%F'; # 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 'H:\ORACLE\ORA92\DATABASE\SNCFIACM.ORA';
# default

 RMAN> configure channel device type disk format 'c:\backup\%u_%c';

new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'c:\backup\%u_%c';
new RMAN configuration parameters are successfully stored


RMAN> configure device type disk parallelism 3;

new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3;
new RMAN configuration parameters are successfully stored

RMAN> configure default device type to disk;

new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored


RMAN> configure channel device type disk maxpiecesize 2g;

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'c:\backup\%u_%c';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;
new RMAN configuration parameters are successfully stored

RMAN> configure retention policy to redundancy 3;

new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
new RMAN configuration parameters are successfully stored

RMAN> configure datafile backup copies for device type disk to 2;

new RMAN configuration parameters:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
new RMAN configuration parameters are successfully stored

RMAN> configure backup optimization on;

new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'H:\ORACLE\ORA92\DATABASE\SNCFIACM.ORA';
# default

RMAN>


RMAN>



RMAN> show channel;

RMAN configuration parameters are:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;

RMAN> show device type;

RMAN configuration parameters are:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3;

RMAN> show default device type;

RMAN configuration parameters are:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;

RMAN> show retention policy;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

RMAN> show datafile backup copies;

RMAN configuration parameters are:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK T

RMAN> show maxsetsize;

RMAN configuration parameters are:
CONFIGURE MAXSETSIZE TO UNLIMITED; # default

RMAN> show backup optimization;

RMAN configuration parameters are:
CONFIGURE BACKUP OPTIMIZATION ON;

RMAN> show exclude;

RMAN configuration parameters are:
RMAN configuration has no stored or default parameters

RMAN>