archive log 모드로 변경하기

아래꺼 그냥 따라하세요!
하지만
SQL> alter system archive log start; 와
SQL> alter database archivelog; 두개의 차이


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 289406976 bytes
Fixed Size 2020224 bytes
Variable Size 92277888 bytes
Database Buffers 188743680 bytes
Redo Buffers 6365184 bytes
Database mounted.

SQL> alter system archive log start;

System altered.


SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 58
Current log sequence 59
SQL> alter database archivelog;

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 58
Next log sequence to archive 59
Current log sequence 59
SQL> alter database open;

Database altered.

SQL> alter system switch logfile;