【DB笔试面试801】在Oracle中，如何查询RMAN的配置信息？

SYS@orclasm > col value format a100
SYS@orclasm > select * from V$RMAN_CONFIGURATION;
     CONF# NAME                                                              VALUE
---------- ----------------------------------------------------------------- ---------------------------------------------------------------------
         1 BACKUP OPTIMIZATION                                               ON
         2 RETENTION POLICY                                                  TO RECOVERY WINDOW OF 2 DAYS
         3 CONTROLFILE AUTOBACKUP                                            ON
         4 CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE                     DISK TO '/home/oracle/oracle_bk/orclasm/ctlfile_autoback_%d_%F.bak'
         5 DEVICE TYPE                                                       DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET
         6 ARCHIVELOG DELETION POLICY                                        TO BACKED UP 1 TIMES TO DISK
         7 DEFAULT DEVICE TYPE TO                                            DISK
         8 CHANNEL                                                           DEVICE TYPE DISK FORMAT   '/home/oracle/oracle_bk/orclasm/%U_%d.bak'
[oracle@rhel6lhr ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Mon May 22 14:14:18 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: ORCLASM (DBID=3424884828)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCLASM are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/oracle_bk/orclasm/ctlfile_autoback_%d_%F.bak';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/home/oracle/oracle_bk/orclasm/%U_%d.bak';
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 BACKED UP 1 TIMES TO DISK;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orclasm.f'; # default