Re: Archivelog on Rac 11gr2

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Sat, 14 Jan 2012 12:59:45 -0300
Message-ID: <CAJ2dSGTyETSrVt0aB_4zzrbCREKedqU_y2tObwCcNuvcuC4n9w_at_mail.gmail.com>

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.-

On Sat, Jan 14, 2012 at 12:11 PM, Alex Cwb <ab80cwb_at_gmail.com> wrote:

> 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
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Sat Jan 14 2012 - 09:59:45 CST