Dataguard oracle Archive Management script

Management part

If database force logging is not enabled, the slave library will report bad blocks for / * + append * / operation and nologging operation.

Recommended tablespace force logging or database force logging

-- force logging / nologging testing

Alter database force logging;select force_logging from dba_tablespaces;select force_logging from vested database alter tablespace test force logging;select logging,table_name,tablespace_name from user_tables where table_name = 'TEST';alter tablespace test no force logging;select tablespace_name,logging,force_logging from dba_tablespaces

# # configure the archive deletion policy of the main database

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY

-- delete as soon as you pass it.

CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO STANDBY

Prepare the library delete script

Vi delete_archive.sh

#! / bin/shsource / home/oracle/.bash_profileexport ORACLE_SID=standbyTABLE='v$archived_log'$ORACLE_HOME/bin/sqlplus-silent "/ as sysdba"