oracle 笔记

归档日志满：

ora-00257:archivererror.Connct intenal only.until freed

 

 

[root@tfcsmap2 ~]#su - oracle        --切换到oracle用户

[oracle@tfcsmap2 ~]$lsnrctl start    --启动监听

[oracle@tfcsmap2 ~]$sqlplus /nolog  

SQL> conn / assysdba;

Connected to an idleinstance.

然后输入

Sql> rman

Rman>connect target /

在命令窗口里面执行

DELETEARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';

crosscheckarchivelog all;

deleteexpired archivelog all;