ARCHIVELOG to NOARCHIVELOG

-+12 development databases, all in archivelog mode, consumed all the available disk space on a drive causing the instances to shutdown at the same time. So I put all the databases into NOARCHIVELOG mode.

In each database, I ran the following:

SHUTDOWN IMMEDIATE;
STARTUP MOUNT EXCLUSIVE;
ALTER DATABASE NOARCHIVELOG;
ALTER DATABASE OPEN;

Once done, I adjusted the generic rman backup script to be geared toward NOARCHIVELOG mode - a cold backup:

run{ 

   configure backup optimization on; 

   sql 'alter system switch logfile';

   shutdown immediate;

   startup mount;

   allocate channel backup_disk1 type disk format '%U.rman'; 

   backup as compressed backupset database include current controlfile tag 'COLD_BACKUP'; 

   crosscheck backupset; 

   delete noprompt expired backupset; 

   release channel backup_disk1;

   sql 'alter database open';

   }