Just a quick one - in RAC "ALTER DATABASE ARCHIVELOG" needs to be done
only once from any instance. At that moment, none of RAC instances can
be open, but don't trust me - just test it.
Also make sure your archive log destination doesn't get full.
Otherwise, your DB will freeze on any DML.
2005/12/24, Onkar N Tiwary :
> thanx a lot for the suggestion and help guys. I have done it various times
> but all those I had done in non-clustered environment but not the cluster
> one. I was planning the same step but I thought there might be some more
> things I may need to take care of. So I thought to discuss this in forum
> just to clarify my doubts which is now more or less clear. Since its
> active-passive so do i need to shutdown both the nodes before doing this ?
> because the binary is on nodes but database is on san and spfile is existing
> in the $ORACLE_HOME/dbs folder on both the nodes. so if anyone can tell me
> the steps in this situation. I am thinking of doing the activity as :
> 1) SHUTDOWN IMMEDIATE;
> 2)Modify both spfile on both the nodes as the spfile location has been
> left in the binary home
> 3)STARTUP MOUNT
> 4)ALTER DATABASE ARCHIVELOG
> 5)ALTER DATABASE OPEN
> 6) ARCHIVE LOG LIST
> 7)Will check V$ARCHIVE% data dictionary for the archive log information
> 8) SHUTDOWN IMMEDIATE
> 9) taking cold backup.
> 10) STARTUP
>
> Is this step. ok????
>
> thanx once again. and plz. do suggest
>
>
--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Dec 25 2005 - 10:25:13 CST
