Wednesday, November 27, 2013

Oracle - Alter database to archivelog mode


SQL> archive log list;

Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     208
Current log sequence           218
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 5745586176 bytes
Fixed Size                  2238736 bytes
Variable Size            3791652592 bytes
Database Buffers         1946157056 bytes
Redo Buffers                5537792 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     208
Next log sequence to archive   218
Current log sequence           218


0 comentários:

Post a Comment