日期:2014-05-17  浏览次数:20638 次

oracle管理的一些常用令
sqlplus /nolog
conn / as sysdba


shutdown immediate

startup mount;

alter database open;

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;


#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';