5 Replies Latest reply: Sep 23, 2013 8:13 PM by yxes2013 RSS

    RMAN SHOW ALL?

    yxes2013

      Hi all,

       

      11.2.0.1

      Aix 6.1

       

      We have 2 similar DB servers.

      But when I do SHOW ALL ins RMAN the have different setup?

       

      DB Server1:

       

      RMAN> show all ;

       

      using target database control file instead of recovery catalog

      RMAN configuration parameters for database with db_unique_name PROD are:

      CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;

      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 '/orauat/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_BNCTUAT.f'; # default

       

      DB Server2:

       

      RMAN> show all ;

       

       

       

      RMAN configuration parameters for database with db_unique_name PROD 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 '/oracle/app/oracle/product/11.2.0.3/dbhome_1/dbs/snapcf_batchsit.f'; # default

       

      How do I replace >CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;

      with the default CONFIGURE RETENTION POLICY TO REDUNDANCY 1   and save the config?

       

       

      Thanks a lot,

      zxy