Java代码

sqlplus /nolog

conn / as sysdba

Java代码

shutdown immediate

startup mount;

alter database open;

Java代码

ORA-00313和ORA-00312:oracle initialization or shutdown in progress

alter database clear logfile group 1;

alter database clear logfile group 2;

alter database clear logfile group 3;

alter database clear unarchived logfile group 1;

alter database clear unarchived logfile group 2;

alter database clear unarchived logfile group 3;

ALTER SYSTEM SWITCH LOGFILE;

alter database open resetlogs;

select group#,sequence#,archived,status from v$log;

Java代码

#ORA-00257解决

alter system set DB_RECOVERY_FILE_DEST_SIZE=10g;

#关闭闪回日志的功能

alter database flashback off

shell下运行rman管理

rman target /

configure retention policy to recovery window of 7 days;

crosscheck backup;

delete archivelog all completed before 'sysdate-7';

作者“szgaea”