oracle管理的一些常用命令

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”