Name

ALTER DATABASE ARCHIVELOG

Synopsis

ALTER DATABASE [dbname] ARCHIVELOG |
NOARCHIVELOG

Specifies whether Oracle will attempt to archive redo log files for the database dbname after a redo log switch.

Keywords

ARCHIVELOG

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.

NOARCHIVELOG

Specifies that redo log groups will not be archived and may be reused immediately by Oracle.

Notes

The database must be mounted in EXCLUSIVE mode and not open in order to issue this command. You must have the OSDBA role to issue this command.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset