This discussion is archived
3 Replies Latest reply: Sep 27, 2013 9:34 AM by cjmurray RSS

Error in Oracle® Database Backup and Recovery User's Guide 12c Release 1 (12.1) E17630-13

Marco V. Expert
Currently Being Moderated

on page 88 of the "Backup and Recovery User's Guide 12c Release 1 (12.1) E17630-13", the example 5-1 SHOW ALL Command is the same of the "Backup and Recovery User's Guide 11g Release 2 (11.2) E10642-06" on page 82 and that output is related to a Oracle Database 11g version (the 10g doesn't print the first line "RMAN configuration parameters for database with db_unique_name PROD1 are:").

  • 1. Re: Error in Oracle® Database Backup and Recovery User's Guide 12c Release 1 (12.1) E17630-13
    Marco V. Expert
    Currently Being Moderated

    My test cases here:

    Database administrator workshop: Differences in default RMAN configuration settings between 12c and 11g

     

    {code}[oracle@vsi08devpom ~]$ export ORACLE_SID=CDB001

    [oracle@vsi08devpom admin]$ sqlplus system/oracle@CDB001

     

    SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 26 09:10:50 2013

     

    Copyright (c) 1982, 2013, Oracle.  All rights reserved.

     

    Last Successful login time: Tue Jul 16 2013 13:43:48 +02:00

     

    Connected to:

    Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

    With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

     

    SQL> show con_name

     

    CON_NAME

    ------------------------------

    CDB$ROOT

     

    [oracle@vsi08devpom ~]$ rman target /

     

    Recovery Manager: Release 12.1.0.1.0 - Production on Thu Sep 26 09:12:42 2013

     

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

     

    connected to target database: CDB001 (DBID=4134963396)

     

    RMAN> show all;

     

    using target database control file instead of recovery catalog

    RMAN configuration parameters for database with db_unique_name CDB001 are:

    CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

    CONFIGURE BACKUP OPTIMIZATION OFF; # default

    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

    CONFIGURE CONTROLFILE AUTOBACKUP ON; # 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 RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/app/oracle/product/12.1.0/db_1/dbs/snapcf_CDB001.f'; # default{code}

     

    {code}

    [oracle@localhost orcl]$ rman target /

     

    Recovery Manager: Release 11.2.0.2.0 - Production on Wed Sep 25 08:12:17 2013

     

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

     

    connected to target database: ORCL (DBID=1229390655)

     

    RMAN> show all;

     

    using target database control file instead of recovery catalog

    RMAN configuration parameters for database with db_unique_name ORCL 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 CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE 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 DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE 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 '/home/oracle/app/oracle/product/11.2.0/dbhome_2/dbs/snapcf_orcl.f'; # default

    {code}

  • 2. Re: Error in Oracle® Database Backup and Recovery User's Guide 12c Release 1 (12.1) E17630-13
    cjmurray Explorer
    Currently Being Moderated

    Thank you. I have sent a pointer to this thread to the appropriate writer.

  • 3. Re: Error in Oracle® Database Backup and Recovery User's Guide 12c Release 1 (12.1) E17630-13
    cjmurray Explorer
    Currently Being Moderated

    The writer is investigating and will determine what updates need to be made to the book.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points