Re: changing archive from noarchive

While you run alter database archivelog, I think you need to open your
database in exclusive mode.

that is, you need to comment cluster_database = true before you startup
mount and do alter database archivelog;

Just test it out.


On 12/24/05, Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx> wrote:
>
> 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<sid> 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.
>

--
Regards
Zhu Chao
www.cnoug.org

Other related posts: