Delete applied archivelog files

Oracle Database
, ,
12

RAC to Single Dataguard дээр залхуураад дараах байдлаар хийчихлээ…

ORACLE_SID=ORCL; export ORACLE_SID
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2/dbhome_1; export ORACLE_HOME

tmpfile=/tmp/arch_id.tmp

$ORACLE_HOME/bin/sqlplus -S /nolog <<EOF > $tmpfile
connect / as sysdba
set head off
set pages 0
select max(sequence#) from v\$archived_log where thread#=1 AND applied = 'YES';
exit
EOF

echo DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = `head -n 1  $tmpfile | awk '{print $1}'` ' thread 1;' > $tmpfile
#echo DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = `cat $tmpfile ` ';' > $tmpfile

$ORACLE_HOME/bin/rman target / <<EOF
 @$tmpfile
exit
EOF

$ORACLE_HOME/bin/sqlplus -S /nolog <<EOF > $tmpfile
connect / as sysdba
set head off
set pages 0
select max(sequence#) from v\$archived_log where thread#=2 AND applied = 'YES';
exit
EOF

echo DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = `head -n 1  $tmpfile | awk '{print $1}'` ' thread 2;' > $tmpfile
#echo DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = `cat $tmpfile ` ';' > $tmpfile

$ORACLE_HOME/bin/rman target / <<EOF
 @$tmpfile
exit
EOF

2 node той RAC -ийг Single instance руу явуулж байгаа юм. Дээрхээр шийдэхгүй бол нэг thread ийнхэн лог үлдээд байна… copy paste and add thread option. :smile: :smile: :smile:

1 Like