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”
相关新闻>>
- 发表评论
-
- 最新评论 更多>>