Switch a RAC database into archivelog mode:
1 | srvctl stop database -d dbname |
3 | alter database archivelog |
5 | srvctl start database -d dbname |
And switch it into noarchivelog mode:
1 | srvctl stop database -d dbname |
3 | alter database noarchivelog |
5 | srvctl start database -d dbname |
Above method from Bhavin Hingu. It is also possible to do it this way:
1 | alter system set log_archive_dest_1='location=/ORA_DISK/redoarch/arch_' scope=both sid='*' ; |
2 | alter system set cluster_database=false scope=spfile sid='mydb1'; |
3 | srvctl stop database -d mydb |
5 | alter database archivelog ; |
6 | alter system set cluster_database=true scope=spfile sid='mydb1'; |
8 | srvctl start database -d mydb |
And switch it into noarchivelog mode:
1 | alter system reset log_archive_dest_1 scope=spfile sid='*' ; |
2 | alter system set cluster_database=false scope=spfile sid='mydb1'; |
3 | srvctl stop database -d mydb |
5 | alter database noarchivelog ; |
6 | alter system set cluster_database=true scope=spfile sid='mydb1'; |
8 | srvctl start database -d mydb |
Leave a Reply