FAQ
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

Search Discussions

  • Guillermo Alan Bort at Jan 14, 2012 at 4:00 pm
    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 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
  • John Clarke at Jan 14, 2012 at 4:01 pm
    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 <ab80cwb@gmail.com
    Reply-To: "ab80cwb@gmail.com " <ab80cwb@gmail.com
    Date: Sat, 14 Jan 2012 10:11:08 -0500
    To: "oracle-l@freelists.org " <oracle-l@freelists.org
    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
  • Andrew Kerber at Jan 14, 2012 at 4:28 pm
    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 <ab80cwb@gmail.com>
    Sent: Sat Jan 14 09:11:08 CST 2012
    To: oracle-l@freelists.org
    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJan 14, '12 at 3:11p
activeJan 14, '12 at 4:28p
posts4
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase