.管理员身份连接数据库

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     228

Current log sequence           230


3.关闭数据库


SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down


启动数据库到mount状态


SQL> startup mount;

ORACLE instance started.


Total System Global Area 3423965184 bytes

Fixed Size                  2180544 bytes

Variable Size            2013268544 bytes

Database Buffers         1392508928 bytes

Redo Buffers               16007168 bytes

Database mounted.


5.启动归档模式

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     228

Next log sequence to archive   230

Current log sequence  


6.启动数据库


SQL> alter database open;

Database altered


.关闭归档模式


SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.


Total System Global Area 3423965184 bytes

Fixed Size                  2180544 bytes

Variable Size            2013268544 bytes

Database Buffers         1392508928 bytes

Redo Buffers               16007168 bytes

Database mounted.

SQL> alter database noarchivelog;


Database 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     228

Current log sequence           230

SQL>