control file backup/multiplexing 1

[mkey]

HI All,
Right now we have 3 control files for a database that are duplicate of each other and reciding on the same drive. What I want to do is automate the oracle processes so that the control files will be backup in another drive.
I have never done something like this before.
Any thoughts or suggestion will be of great help!
Thank you!

 

[karluk]

The standard ways to backup your control files are

alter database backup controlfile to trace;

and

alter database backup controlfile to 'full path name of backup file';

The first method generates a human readable 'create controlfile' statement in the directory specified by your background_dump_destination, the second makes a duplicate of the actual control file in the specified location. Both methods can be useful in recovery.

You can create jobs that execute these commands and run them nightly.

It is also possible to backup contol files using rman.

 

[mkey]

Thank you so much for your input. I'm reading about RMAN utility which I think is a better choice because it will automate the backup process. Can you give me some step by step instruction on how I could set up this utility first in my local server. So that I could first check how it works and then I could implement that on our main server?

Thank you!

 

[karluk]

That's too broad a question for this forum. Please read the rman documentation about setting up a repository then look at the sample scripts that come with your server installation. You can modify them for your own needs.