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 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 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
http://www.cnoug.org