oracle 日志切换归档模式查看归档文件的产生

（1）启动数据库到mount模式
SQL> startup mount
ORACLE instance started.

Total System Global Area  422670336 bytes
Fixed Size                  1336960 bytes
Variable Size             297798016 bytes
Database Buffers          121634816 bytes
Redo Buffers                1900544 bytes
Database mounted.


（2）设置数据库到归档模式
SQL> alter database archivelog;

Database altered.

（3）打开数据库

SQL> alter database open;

Database altered.

（4）查看是否设置成功

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     132
Next log sequence to archive   135
Current log sequence           135

（5)查看恢复文件所在的位置
SQL> show parameter db_recovery_file_dest;

SQL> show parameter db_recovery_file_dest;

NAME                                 TYPE                 VALUE
------------------------------------ -------------------- ------------------------------
db_recovery_file_dest                string               /oracle/app/oracle/flash_recov
                                                          ery_area
db_recovery_file_dest_size           big integer          3852M

（6）进入数据恢复目录

[oracle@songfucai ~]$ cd /oracle/app/oracle/flash_recovery_area
[oracle@songfucai flash_recovery_area]$ ls
orcl  ORCL
[oracle@songfucai flash_recovery_area]$ cd ORCL
[oracle@songfucai ORCL]$ ls
archivelog  onlinelog


（7）查看日志组的情况
SQL> select group#,sequence#,members,archived,status from v$log;

   GROUP#  SEQUENCE#    MEMBERS ARC STATUS
---------- ---------- ---------- --- ----------------
         1        132          1 YES INACTIVE
         3        133          1 YES INACTIVE
         4        135          1 NO  CURRENT
         5        134          1 YES INACTIVE

（8）强制进行日志切换

SQL> alter system switch logfile;

System altered.

（9）查看当前的日志组

SQL> select group#,sequence#,members,archived,status from v$log;

      GROUP#  SEQUENCE#    MEMBERS ARC STATUS
---------- ---------- ---------- --- ----------------
         1        136          1 NO  CURRENT
         3        133          1 YES INACTIVE
         4        135          1 YES ACTIVE
         5        134          1 YES INACTIVE


（10）查看归档文件的产生
[oracle@songfucai ORCL]$ ls
archivelog  onlinelog
[oracle@songfucai ORCL]$ cd archivelog
[oracle@songfucai archivelog]$ ls
2013_01_27  2013_03_22  2013_05_07
[oracle@songfucai archivelog]$ cd 2013_05_07
[oracle@songfucai 2013_05_07]$ ls
o1_mf_1_135_8rkwfy46_.arc