Oracle 归档与非归档的切换方法
SQL*Plus: Release 9.2.0.1.0 - Production on Sun Dec 16 19:58:29 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: sys/xxxx as sysdba
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 965812724 bytes
Fixed Size 455156 bytes
Variable Size 385875968 bytes
Database Buffers 578813952 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> archive log list ;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +vgexternal
Oldest online log sequence 153
Next log sequence to archive 155
Current log sequence 155
SQL> alter database noarchivelog;
Database altered.
SQL> archive log list ;
Database log mode No Archive Mode
Automatic archival Enabled
Archive destination +vgexternal
Oldest online log sequence 153
Current log sequence 155
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 965812724 bytes
Fixed Size 455156 bytes
Variable Size 385875968 bytes
Database Buffers 578813952 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> archive log list ;
Database log mode No Archive Mode
Automatic archival Enabled
Archive destination +vgexternal
Oldest online log sequence 153
Current log sequence 155
SQL> alter database archivelog;
Database altered.
SQL> archive log list ;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +vgexternal
Oldest online log sequence 153
Next log sequence to archive 155
Current log sequence 155
SQL> alter database open;
Database altered.
