8 added for thread 1 sequence 112 ID 0xebe3b9d9 dest 1:
SYS@ bys001>conn bys/bys
Connected.
BYS@ bys001>exit
[oracle@oel-01 ~]$ sqlplus bys/bys
BYS@ bys001>truncate table test1;
Table truncated.
最后要对归档日志进行备份和删除。
使用备份归档脚本如下：
[oracle@oel-01 ~]$ cat archback.sh
#!/bin/sh
#su - oracle
source /home/oracle/.bash_profile
##########
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman log /home/oracle/rman-arch`date +%Y%m%d-%H%M`.log <
connect target /;
run{
backup archivelog all delete input
format '/backup/archlog/arch_%d_%T_%s';
}
exit