-查看实例进程看是否有归档的进程[oracle@edsir1p8-PROD4~]$ps-ef|grepPROD4SQL>archiveloglist;DatabaselogmodeNoArchiveModeAutomaticarchivalDisabledArchivedestination/u01/app/oracle/product/11.2.0/db_1/dbs/archOldestonlinelogsequence6Currentlogsequence8sql>showparameterlog_archive--在mount状态下做--关闭数据库SQL>shutdownimmediate---必须是immediate一至性关闭数据库SQL>startupmountSQL>altersystemsetlog_archive_dest_1='location=/home/oracle/arch';---目录提前创建好SQL>alterdatabasearchivelog;Databasealtered.SQL>alterdatabaseopen;Databasealtered.SQL>archiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination/home/oracle/archOldestonlinelogsequence6Nextlogsequencetoarchive8Currentlogsequence8--生成归档（需要切redo日志）QL>selectgroup#,memberfromv$logfile;GROUP#----------MEMBER-----------------------------------------------------------------------------3/u01/app/oracle/oradata/PROD4/PROD4/redo03.log2/u01/app/oracle/oradata/PROD4/PROD4/redo02.log1/u01/app/oracle/oradata/PROD4/PROD4/redo01.logSQL>selectgroup#,statusfromv$log;GROUP#STATUS--------------------------1INACTIVE2CURRENT3INACTIVE--切redoSQL>altersystemswitchlogfile;Systemaltered.SQL>selectgroup#,statusfromv$log;GROUP#STATUS--------------------------1INACTIVE2INACTIVE3CURRENT--三种状态current：当前用的active：正在归档时的状态，inactive：归档完毕，不用的状态--查看归档目录下生成的归档文件[oracle@edsir1p8-PROD4~]$ls/home/oracle/arch/1_8_861102502.dbf[oracle@edsir1p8-PROD4~]$ps-ef|grepPROD4oracle85511010:29?00:00:00ora_arc0_PROD4oracle85541010:29?00:00:00ora_arc1_PROD4oracle85561010:29?00:00:00ora_arc2_PROD4oracle85581010:29?00:00:00ora_arc3_PROD4