ALTER DATABASE ARCHIVELOG
ALTER DATABASE [dbname
] ARCHIVELOG |
NOARCHIVELOG
Specifies whether Oracle will attempt to archive redo log files for the database dbname after a redo log switch.
Specifies that a redo log group must be archived before it can be reused. If the group has not been archived, the database halts until archiving occurs successfully. This mode is required in order to perform media recovery.
Specifies that redo log groups will not be archived and may be reused immediately by Oracle.