oracle治理的一些常用令

sqlplus /nologconn / as sysdba

shutdown immediatestartup mount;alter database open;

ORA-00313和ORA-00312:oracle initialization or shutdown in progressalter 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;

#ORA-00257解决alter system set DB_RECOVERY_FILE_DEST_SIZE=10g;#关闭闪回日志的功能alter database flashback offshell下运行rman管理rman target /configure retention policy to recovery window of 7 days;crosscheck backup;delete archivelog all completed before 'sysdate-7';