[Oracle-l] Archivelog on Rac 11gr2

As a general rule for RAC you have to stop the database (srvctl stop
database -d <DB_NAME>
then start a single instance srvctl start instance -d <DB_NAME> -n <local
node> - o MOUNT
and connect as sysdba using sqlplus:
sqlplus "/ as sysdba"
SQL> alter database archivelog;
SQL> shutdown immediate;
-- this needs to be done in single instance mode. if you are worried that
someone might start the database while you are working you can set
cluster_database init parameter to false. Just remember to set it to true
before attempting to start all the instances.
then startup the database again:
srvctl start database -d DB_NAME.
In order to maintain resilience in the RAC you should send archivelogs to a
shared location so they can be used by RMAN for backup an restore
operations. This can be either a ASM diskgroup (generally you want
archivelogs in a different diskgroup from redologs and data) or a shared
filesystem (OCFS2, NFS, some propietary cluster filesystem). I usually go
with ASM for archivelogs and NFS for backups (if there isn't a tape
infrastructure).

hth
Alan.-

Sounds like you're using ASM for data files - I'd put archive logs in ASM as well. There are a couple of ways to do this but I'd enable FRA by setting db_recovery_file_dest to an ASM disk group name, then do this:
Shutdown instances and then startup one of them. Then

SQL> startup mount
SQL> alter database archivelog
SQL> alter database open

You only need to do this from one instance. When it's done, just start the other instance (srvctl start instance �).

I'm assuming you're using RAC based on your "each node" comment.

-----------------
John Clarke
www.centroid.com


From: Alex Cwb <[email protected]
Reply-To: "[email protected] " <[email protected]
Date: Sat, 14 Jan 2012 10:11:08 -0500
To: "[email protected] " <[email protected]
Subject: Archivelog on Rac 11gr2

Hi,
I have a rac database on 11gr2 for study purposes, and I would like to put
this db on archivelog mode in order to study backup with Rman.
However, my doubt is related to the location of those archive log ... if I
have to put in a shared are, such as ASM (sth like +DATA/arch) or if I have
to enable arch on each node but in local disk (sth like /u02/arch for n1
and n2).

And the last doubt, the procedure to enable, do I have to execute on each
node?
I found out the steps on this page:
http://www.toadworld.com/Newsletter/TWPIPELINESept2008/PIPESept08Oracle/tabid/450/Default.aspx

Any suggestion is very welcome.
Thanks in advance for the help.

Alex

Hi. There is no requirement that archivelogs be stored in a shared location, but in a production system its a good idea.
Sent from my Kindle Fire

_____________________________________________
From: Alex Cwb <[email protected]>
Sent: Sat Jan 14 09:11:08 CST 2012
To: [email protected]
Subject: Archivelog on Rac 11gr2


Hi,
I have a rac database on 11gr2 for study purposes, and I would like to put
this db on archivelog mode in order to study backup with Rman.
However, my doubt is related to the location of those archive log ... if I
have to put in a shared are, such as ASM (sth like +DATA/arch) or if I have
to enable arch on each node but in local disk (sth like /u02/arch for n1
and n2).

And the last doubt, the procedure to enable, do I have to execute on each
node?
I found out the steps on this page:
http://www.toadworld.com/Newsletter/TWPIPELINESept2008/PIPESept08Oracle/tabid/450/Default.aspx

Any suggestion is very welcome.
Thanks in advance for the help.

Alex