This discussion is archived
8 Replies Latest reply: Mar 23, 2012 3:54 AM by 925463 RSS

Rman move from Catalog mode to nocatalog mode

925463 Newbie
Currently Being Moderated
Hi All,

I would like to know what is the process step by step if I want to move my oracle database backup from catalog mode to non catalog mode (control file) on 11G RHEL.

What came on my mind are:

Connect to rman catalog
unregister the database
then drop the catalog
connect to database
remove the user and table space.

are these correct ?
and is there anyone can advise me what I need to config to optimize the control file other than configure control file autobackup on.

Cheers,
Raff
  • 1. Re: Rman move from Catalog mode to nocatalog mode
    NikolayIvankin Expert
    Currently Being Moderated
    I don't know why do you want to use nocatalog, but you are almost right, except: 'remove the user and table space'
    What if there is another catalog or useful tables in this tablespace?
  • 2. Re: Rman move from Catalog mode to nocatalog mode
    CKPT Guru
    Currently Being Moderated
    Raffaell wrote:
    Hi All,

    I would like to know what is the process step by step if I want to move my oracle database backup from catalog mode to non catalog mode (control file) on 11G RHEL.

    What came on my mind are:

    Connect to rman catalog
    unregister the database
    then drop the catalog
    connect to database
    remove the user and table space.

    are these correct ?
    and is there anyone can advise me what I need to config to optimize the control file other than configure control file autobackup on.

    Cheers,
    Raff
    Hello,

    If you stop using Catalog, it will acts as NoCatalog.
    All RMAN repository information exist not only in Catalog but also in Controlfile(nocatalog)

    But recommended to use CATALOG, if you still want to remove
    then check below link to unregister
    http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta064.htm

    Once you done this, its no more part of catalog.
  • 3. Re: Rman move from Catalog mode to nocatalog mode
    925463 Newbie
    Currently Being Moderated
    Hi,

    Thanks for the info.

    Since we are running less database, I didnt see the purpose using catalog.
    I agree we need to unregister the catalog.

    But do we need to remove all the others parts like I mentioned ?

    I just wanna have some tidy system.

    Cheers,
    Raff
  • 4. Re: Rman move from Catalog mode to nocatalog mode
    CKPT Guru
    Currently Being Moderated
    Raffaell wrote:
    Hi,

    Thanks for the info.

    Since we are running less database, I didnt see the purpose using catalog.
    I agree we need to unregister the catalog.

    But do we need to remove all the others parts like I mentioned ?

    I just wanna have some tidy system.

    Cheers,
    Raff
    Yes You can drop Schema. That should be fine.
    If you dont want even database, Then consider dropping database instead of users, tablespaces & so on.. Assuming there is no other repository information available in Catalog database.
  • 5. Re: Rman move from Catalog mode to nocatalog mode
    Talip Hakan Ozturk Oracle ACE
    Currently Being Moderated
    connect RMAN with catalog and unregister database.

    RMAN target / catalog rman_user/password@catalogdb

    RMAN> UNREGISTER DATABASE NOPROMPT;

    Then remove rman_user from catalog database with CASCADE clause.

    SQL> drop user rman_user cascade;


    Talip Hakan Ozturk
    http://taliphakanozturken.wordpress.com/
  • 6. Re: Rman move from Catalog mode to nocatalog mode
    925463 Newbie
    Currently Being Moderated
    Hi Both,

    Many thanks for the advise.

    Btw, it there anything I should need to take care if I want to backup using or nocatalog control file except ALTER SYSTEM SET control_file_record_keep_time=16; ?

    Cheers,
    Raff
  • 7. Re: Rman move from Catalog mode to nocatalog mode
    CKPT Guru
    Currently Being Moderated
    Btw, it there anything I should need to take care if I want to backup using or nocatalog control file except ALTER SYSTEM SET control_file_record_keep_time=16; ?
    Yes you have to care of this parameter as how many days of retention you want to keep.
    So that control file will holds that number of days as valid backups.

    Do not set high retention, there would be burden for control file.

    Close the thread if answered and keep the forum clean.
  • 8. Re: Rman move from Catalog mode to nocatalog mode
    925463 Newbie
    Currently Being Moderated
    Thanks everyone for the help

Legend

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