(8.0.21)
mkdir del_arc
cd del_arc
vim del_arc.sql
show binary logs;
purge binary logs before now();
vim del_arc.sh
#!/bin/sh
mysql < /root/del_arc/del_arc.sql > /root/del_arc/del_arc.log 2>&1
exit 0
chmod +x del_arc.sh
crontab -l
crontab -e
*/5 * * * * /root/del_arc/del_arc.sh
-- 動作確認
sudo tail -f /var/log/cron
flush logs;
show binary logs;
(19c)
mkdir del_arc
cd del_arc
vim del_arc.rman
list archivelog all;
crosscheck archivelog all;
delete noprompt archivelog until time 'sysdate';
vim del_arc.sh
#!/bin/sh
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export PATH=$ORACLE_HOME/bin:${PATH}
export NLS_LANG=JAPANESE_JAPAN.AL32UTF8
export ORACLE_SID=orcl
rman target / @/home/oracle/del_arc/del_arc.rman log=/home/oracle/del_arc/del_arc.log
exit 0
chmod +x del_arc.sh
crontab -l
crontab -e
*/5 * * * * /home/oracle/del_arc/del_arc.sh
-- 動作確認
sudo tail -f /var/log/cron
alter system archive log current;
list archivelog all;
(13)
mkdir del_arc
cd del_arc
vim del_arc.sh
#!/bin/sh
oldestkeptwalfile=`ls -tr1 /var/lib/pgsql/13/data/arc | tail -1`
: > /var/lib/pgsql/del_arc/del_arc.log
if [ -n "${oldestkeptwalfile}" ]; then
/usr/pgsql-13/bin/pg_archivecleanup -n /var/lib/pgsql/13/data/arc "${oldestkeptwalfile}" >> /var/lib/pgsql/del_arc/del_arc.log 2>&1
/usr/pgsql-13/bin/pg_archivecleanup /var/lib/pgsql/13/data/arc "${oldestkeptwalfile}" >> /var/lib/pgsql/del_arc/del_arc.log 2>&1
fi
exit 0
chmod +x del_arc.sh
crontab -l
crontab -e
*/5 * * * * /var/lib/pgsql/del_arc/del_arc.sh
-- 動作確認
sudo tail -f /var/log/cron
select pg_switch_wal();
ls -ltr /var/lib/pgsql/13/data/arc
(2019)
mkdir del_arc
cd del_arc
notepad del_arc.sql
use test;
go
backup log test
to disk = 'C:\del_arc\arc.bak'
with format,
medianame = 'arc',
name = 'log backup of test';
notepad del_arc.bat
sqlcmd -i C:\del_arc\del_arc.sql > C:\del_arc\del_arc.log 2>&1
タスクスケジューラに登録
-- 動作確認
select * from sys.fn_dblog(NULL,NULL)
select count(*) from sys.fn_dblog(NULL,NULL)
