-View the instance process to see if there is an archived process [[email protected] ~]$ ps -ef | grep prod4sql> archive log list;database log mode no archive modeautomatic archival disabledarchive Destination /u01/app/oracle/product/11.2.0/db_1/dbs/archoldest online log sequence 6Current log sequence 8sql> show parameter log_archive--in Mount state-close database Sql> shutdown immediate ---must be immediate one to close the database sql> startup mountsql> alter system set log_archive_dest_1= ' Location=/home/oracle/arch ' ; ---Directory to create sql> alter database archivelog;database altered in advance. Sql> alter database open;database&nBsp;altered. sql> archive log list;database log mode archive modeautomatic archival enabledarchive destination /home/oracle/archoldest online log sequence 6next log sequence to archive 8current log sequence 8--Generate archive (need to cut redo log) QL> select group#,member from v$logfile; group#---------- MEMBER----------------------------------------------------------------------------- 3/u01/app/oracle/ oradata/prod4/prod4/redo03.log 2/u01/app/oracle/oradata/prod4/prod4/redo02.log 1/u01/app/oracle/ oradata/prod4/prod4/redo01.logsql> select group#,status from v$log; group# status---------- ---------------- 1 inactive 2 current 3 inactive --Cut Redosql> alter system switch logfile; System altered. Sql> select group#,status from v$log; group# status---------- ---------------- 1 inactive 2 inactive 3 current--of three states current &NBSP: Current active : Status in the archive, inactive: Archive complete, unused state -- View archived files generated under the archive directory [[email protected] ~]$ ls /home/oracle/arch/1_8_861102502.dbf[[email protected] ~]$ ps -ef | grep prod4oracle 8551 1 0 10:29 ? 00:00:00 ora_arc0_prod4oracle 8554 1 &nBsp;0 10:29 ? 00:00:00 ora_arc1_prod4oracle 8556 1 0 10:29 ? 00:00:00 ora_arc2_PROD4oracle 8558 1 0 10:29 ? 00:00:00 ora_ Arc3_prod4
This article is from the "Yangwang" blog, make sure to keep this source http://yangwang.blog.51cto.com/10855137/1943766
Manually start the database archive