About Database archiving
--See if the database is in archive mode
Sql> select Name,log_mode from V$database;
NAME Log_mode
--------- ------------
Enmo Noarchivelog
sql> archive log list;
Database log mode No Archive mode
Automatic Archival Disabled
Archive Destination/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch
Oldest online log sequence 6
Current Log Sequence 8
--To shut down the database start the database under Mount
sql> shutdown Immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
Sql> Startup Mount
ORACLE instance started.
Total System Global area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 541068368 bytes
Database buffers 289406976 bytes
Redo buffers 2371584 bytes
Database mounted.
Sql>
Sql>
--Change Database to archive mode
sql> ALTER DATABASE Archivelog;
Database altered.
---Open the database
sql> ALTER DATABASE open;
Database altered.
--Start automatic archiving
Sql> alter system archive log start;
System altered.
Sql>
About Database archiving