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.
Raffaell wrote:Yes You can drop Schema. That should be fine.
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.
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.