Oracle联机日志文件归档

Oracle联机日志文件归档

//查询归档模式
SQL> select archiver from v$instance;

 

ARCHIVE
-------
STOPPED

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            D:/oracle/product/10.1.0/Db_1/RDBMS
Oldest online log sequence     39
Current log sequence           40

 

//关闭数据库
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

 

//以mount方式启动数据库
SQL> startup mount

ORACLE instance started.

Total System Global Area  163577856 bytes
Fixed Size                   787948 bytes
Variable Size             111933972 bytes
Database Buffers           50331648 bytes
Redo Buffers                 524288 bytes
Database mounted.

 

//查询归档模式
SQL> archive log list

Database log mode              No Archive Mode
Automatic archival               Disabled
Archive destination              D:/oracle/product/10.1.0/oradata/DB3/arc
Oldest online log sequence   39
Current log sequence           40

 

//更改归档模式
SQL> alter database archivelog;

 

Database altered.

 

//归档模式打开
SQL> archive log list
Database log mode                Archive Mode
Automatic archival                 Enabled
Archive destination                D:/oracle/product/10.1.0/oradata/DB3/arc
Oldest online log sequence     39
Next log sequence to archive   40
Current log sequence              40

//查看联机日志文件
SQL> select * from v$logfile;

 

    GROUP# STATUS  TYPE    MEMBER                                                                 IS_
---------- ------- ------- ---------------------------------------------------------------------- ---
         1         ONLINE  D:/ORACLE/PRODUCT/10.1.0/ORADATA/DB3/REDO01A.LOG                       NO
         1         ONLINE  D:/ORACLE/PRODUCT/10.1.0/ORADATA/DB3/REDO01B.LOG                       NO
         3         ONLINE  D:/ORACLE/PRODUCT/10.1.0/ORADATA/DB3/REDO03A.LOG                       NO
         3         ONLINE  D:/ORACLE/PRODUCT/10.1.0/ORADATA/DB3/REDO03B.LOG                       NO

//打开数据库
SQL> alter database open;

 

Database altered.

 

//强制归档
SQL> alter system archive log current;

 

System altered.

 

//查询联机日志归档细节，查看物理文件
SQL> select * from v$log;

  GROUP#  THREAD#  SEQUENCE#     BYTES  MEMBERS ARC STATUS            FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- -------------     ----------
         1          1                  40   10485760          2    YES ACTIVE                     131015     09-12月-09
         3          1                  41   10485760          2     NO CURRENT                   131570     09-12月-09

 

//更改联机日志文件状态，日志切换必定归档，查看物理文件
SQL> alter system switch logfile;

 

System altered.

 

//查看联机日志状态细节
SQL> select * from v$log;

GROUP#    THREAD#  SEQUENCE#      BYTES MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------
         1          1                  42   10485760          2    NO   CURRENT                 131624   09-12月-09
         3          1                  41   10485760          2    YES  INACTIVE                131570   09-12月-09