Re: RMAN question

Always take ControlFile backups with both

1. AUTOBACKUP ON
2. sql 'backup controlfile to ...' {in fact, I have both binary and trace backups ! going to filesystems and getting included as part of filesystem (/archlogs or /redo or /orasys, whichever is appropriate) backups }

You can use those controlfile backups to do a recovery whether or not you have a repository.

At 02:25 AM Saturday, Joe Armstrong-Champ wrote:

>Background: We go back and forth about whether it is better to use a
>repository or to just rely on the control files. I have read many
>emails on this list about this issue also. We have decided that
>using the catalog gives us more redundancy than relying on the cf
>alone. This is really the only reason we are using a catalog.
>However, we know that we can always use the cf if the catalog restore failed.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantscribbles.blogspot.com
and
http://hemantoracledba.blogspot.com

"First they ignore you, then they laugh at you, then they fight you, then you win" !"
Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html

--
http://www.freelists.org/webpage/oracle-l