Re: RAC Archivelog mode and RMAN

thanks for the advice. i wasn't able to find anything on worthwhile on metalink, so based what i did find and what i think the process should be, i've put together the following outline for enabling a 10g RAC db for archive log mode. the part that confused me is handling the cluster database parameter. the log_archive_start parameter is deprecated in 10g as well. i thought i would share it with everyone, in case they needed it...

1. Shut down all but one instances of the database
2. alter system set cluster_database=false scope=spfile;
3. shut down and mount the instance
4. Set the required parameters.

SQL>
ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' scope=SPFILE;  

System
altered.  

SQL>
ALTER SYSTEM SET log_archive_dest='<shared location>' scope=SPFILE;  

System
altered.  

5. Enable ARCHIVELOG mode  

SQL>
alter database archivelog;  

Database
altered.  

6. Set cluster_database=true again.

SQL>
alter system set cluster_database=true scope=spfile;  

System
altered.  

7. Shut down and restart all the instances.  

8. verify archive log mode
SQL> archive log list;

• Original Message ---- From: Robert Freeman <robertgfreeman_at_yahoo.com> To: haroon_a_qureshi_at_yahoo.com; oracle-l_at_freelists.org Sent: Tuesday, December 19, 2006 12:11:12 AM Subject: RE: RAC Archivelog mode and RMAN

Looks like you already got some good answers on this question. I'll add that these topics (RMAN and RAC) are covered in our new Oracle Database 10g RMAN Backup and Recovery book. :-)

Robert

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Haroon A. Qureshi Sent: Monday, December 18, 2006 9:43 AM
To: oracle-l_at_freelists.org
Subject: RAC Archivelog mode and RMAN

hello,

i'd like to use rman to take cold and hot backups of a RAC database. how should i register the database in the rman catalog? do i register each instance of the RAC or just one instance and back that up? also, does anyone have any notes on how to successfully enable archive logging in a RAC database?

i know i should know the answer to this, but i'm drawing a blank at the moment....

thanks in advance,
haroon

--

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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 19 2006 - 11:15:39 CST