Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Join Date
    Aug 2009
    Posts
    5

    Question Unanswered: RMAN Configure Settings

    I am currently attending classes for Oracle DBA, and we are currently working with RMAN. I have a question in which my instructor was unable to give me an answer to.

    When I do a "show all" which shows my configure settings, I have settings I would like to remove due to typos. For example...


    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISH TO '%F'; # default


    The second line has "DEVICE TYPE DISH" instead of "DEVICE TYPE DISK". How do I delete the second line?

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Read the manual

    Tell your instructor to read the fine Oracle® Database Backup and Recovery Reference manual.

    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISH CLEAR;

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Aug 2009
    Posts
    5
    Thanks LKBrwn_DBA. I did the following...

    RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISH CLEAR;

    RMAN configuration parameters are successfully reset to default value

    However, when I do a "show all", the line still exists. Any other recommendations?

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Ooops.

    Ooops, then maybe you need to clear both:

    Code:
    CONFIGURE CONTROLFILE AUTOBACKUP CLEAR;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';

    PS: With what Oracle version did you test the other command? I tested with 10.2 and 11g and it works!.
    Last edited by LKBrwn_DBA; 08-11-09 at 15:11.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Aug 2009
    Posts
    5
    Still not doing the trick.

    Show All...

    CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISH TO '%F'; # default

    I then did "CONFIGURE CONTROLFILE AUTOBACKUP ON;" to turn it back on.

    Are these parameters stored in a data dictionary? Is there a way to delete the entry if so?

  6. #6
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool What are you doing?

    With what Oracle version did you test the commands? I tested with 10.2 and 11g and it works!.
    Here is 10.2 example:
    Code:
    RMAN> show all;
    
    RMAN configuration parameters are:
    #-- etc --
    CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'DISH' TO 'KK%F';
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    #-- etc --
    
    RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'DISH' CLEAR;
    
    old RMAN configuration parameters:
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'DISH' TO 'KK%F';
    RMAN configuration parameters are successfully reset to default value
    starting full resync of recovery catalog
    full resync complete
    
    RMAN> show all;
    
    RMAN configuration parameters are:
    #-- etc --
    CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    #-- etc --
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  7. #7
    Join Date
    Aug 2009
    Posts
    5
    SQL> select * from v$version;

    BANNER
    --------------------------------------------------------------------------------
    Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
    PL/SQL Release 11.1.0.6.0 - Production
    CORE 11.1.0.6.0 Production
    TNS for Linux: Version 11.1.0.6.0 - Production
    NLSRTL Version 11.1.0.6.0 - Production


    The only thing I see different is that your DISH is in parenthesis, or did you add that when posting your message?

    RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISH CLEAR;

    RMAN configuration parameters are successfully reset to default value

    RMAN> show all;

    RMAN configuration parameters for database with db_unique_name ORCL are:
    #-- etc --
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISH TO '%F'; # default
    #-- etc --

  8. #8
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Thumbs down Not using rman catalog?

    Are you not using rman catalog? How come it does not work for you?
    With 11g it also works with nocatalog:

    Code:
    Recovery Manager: Release 11.1.0.7.0 - Production on Tue Aug 11 15:43:19 2009
    
    Copyright (c) 1982, 2007, Oracle.  All rights reserved.
    
    connected to target database: ORCL (DBID=1459347352)
    using target database control file instead of recovery catalog
    
    RMAN> show all;
    
    RMAN configuration parameters for database with db_unique_name ORCL are:
    #-- etc --
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    #-- etc --
    
    RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISH TO '%F';
    
    new RMAN configuration parameters:
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'DISH' TO '%F';
    new RMAN configuration parameters are successfully stored
    
    RMAN> show all;
    
    RMAN configuration parameters for database with db_unique_name ORCL are:
    #-- etc --
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'DISH' TO '%F';
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    #-- etc --
    
    RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISH CLEAR;
    
    old RMAN configuration parameters:
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'DISH' TO '%F';
    RMAN configuration parameters are successfully reset to default value
    
    RMAN> show all;
    
    RMAN configuration parameters for database with db_unique_name ORCL are:
    #-- etc --
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    #-- etc --
    RMAN>
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  9. #9
    Join Date
    Aug 2009
    Posts
    5
    Weird. Don't know why it's not working.

    In class we used RMAN using a catalog repository, and the control file repository. When I was going back over what we did in class is when I noticed the "DISH" in my configuration settings; I have Enterprise Linux and Oracle 11g installed on my laptop, and is what I use in class. Next class, last night, I had asked my instructor about it, and he didn't have an answer for me, and said I needed to research it. Tried finding some info online, but couldn't find anything, so here I am.

    What you've given me seems like it should work. Maybe a bug? Maybe another setting is causing a conflict?

    I do appreciate the time you have taken in helping me tho. I'd buy you a beer if I could.

  10. #10
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking Weird...yes

    Yes, it's weird, I tested both on RedHat EE and they worked.

    But still, you can tell the instructor that the command to correct that issue does exist.

    This is the link to the 11g Oracle® Database Backup and Recovery Reference

    Last edited by LKBrwn_DBA; 08-11-09 at 17:16.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  11. #11
    Join Date
    Aug 2009
    Posts
    5
    Holy Sh*t! I just found the problem. Shoot me now, k?

    This line was there too...

    CONFIGURE CHANNEL DEVICE TYPE 'DISH' FORMAT '/home/oracle/rman_backup/bks_%d_%s_%p_%t';

    Once I cleared that, all DISH lines disappeared. Well that was a learning experience.

    Thanks again!!

  12. #12
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Wink K

    No problemo.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  13. #13
    Join Date
    Jan 2008
    Posts
    4
    Hi,

    I was trying to clear off all the following configurations referring to SBT_TYPE. Clearing off each one separately didn't work.

    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
    CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default


    Then, from trail-and-error, I found the following single command which cleared everything.

    RMAN> configure device type 'SBT_TAPE' clear;

    old RMAN configuration parameters:
    CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
    RMAN configuration parameters are successfully reset to default value
    starting full resync of recovery catalog
    full resync complete

    RMAN>

    Regards,
    Senthil Kumaravel
    ERP DBA

  14. #14
    Join Date
    Jan 2008
    Posts
    4

    oops..

    Looks like my above conclusion may be wrong if we configured channel ....

    In the following examble, that single command didn't help me. But finally I found the cause and cleared the channel. It worked fine then.

    RMAN> configure device type 'SBT_TAPE' clear;

    RMAN configuration parameters are successfully reset to default value

    RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE clear;

    RMAN configuration parameters are successfully reset to default value

    RMAN> configure device type 'SBT_TAPE' clear;

    RMAN configuration parameters are successfully reset to default value

    RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' clear;

    old RMAN configuration parameters:
    CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_CLIENT=v490e,NB_ORA_POLICY=Oracle_Adv Arch_tooldev,NB_ORA_SERV=capone)';
    old RMAN configuration parameters are successfully deleted
    starting full resync of recovery catalog
    full resync complete

    Regards,
    Senthil Kumaravel

  15. #15
    Join Date
    Jan 2008
    Posts
    4

    2nd Ooops..

    In another database, I had to execute CONFIGURE .. CLEAR for all the configurations to make the SBT_TYPE get ride from the configuration.

    I am pretty much sure that all databases I tried have similar "CONFIGURE" for SBT_TYPE.

    Though I could succeed in achieving my goal, I couldn't understand why CLEAR process is differing in two similar environments.

    RMAN> CONFIGURE device type 'SBT_TAPE' clear;

    old RMAN configuration parameters:
    CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
    RMAN configuration parameters are successfully reset to default value
    starting full resync of recovery catalog
    sfull resync complete

    RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' clear;

    old RMAN configuration parameters:
    CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_CLIENT=db-ontario-lvl,NB_ORA_POLICY=Oracle_AdvArch_RMANcat,NB_ORA_SE RV=capone)';
    old RMAN configuration parameters are successfully deleted
    starting full resync of recovery catalog
    full resync complete

    RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' clear;

    old RMAN configuration parameters:
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
    RMAN configuration parameters are successfully reset to default value
    starting full resync of recovery catalog
    full resync complete

    RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' clear;

    old RMAN configuration parameters:
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
    RMAN configuration parameters are successfully reset to default value
    starting full resync of recovery catalog
    full resync complete

    Regards,
    Senthil Kumaravel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •