Shulou(Shulou.com)06/01 Report--

-check the instance process to see if there is an archiving process [oracle@edsir1p8-PROD4 ~] $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-- do it in mount state-- close database SQL > shutdown immediate-must be immediate to close database SQL > startup mountSQL > alter system set log_archive_dest_1='location=/home/oracle/arch' -create directories in advance: SQL > alter database archivelog;Database altered.SQL > alter database open;Database altered.SQL > archivelog 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 archives (need to cut redo logs) 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-- three states current: current active: status while archiving, inactive: archived Unused status-View the archive file generated under the archive directory [oracle@edsir1p8-PROD4 ~] $ls / home/oracle/arch/1_8_ 861102502.dbf [oracle @ edsir1p8-PROD4 ~] $ps-ef | grep PROD4oracle 8551 10 10:29? 00:00:00 ora_arc0_PROD4oracle 8554 10 10:29? 00:00:00 ora_arc1_PROD4oracle 8556 10 10:29? 00:00:00 ora_arc2_PROD4oracle 8558 10 10:29? 00:00:00 ora_arc3_PROD4

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.