-
编辑 删除
Checkpoint not complete
alert日志ALTER SYSTEM ARCHIVE LOGSUCCESS: diskgroup ARCHDG was mountedSUCCESS: diskgroup ARCHDG was dismountedSUCCESS: diskgroup ARCHDG was mountedSUCCESS: diskgroup ARCHDG was dismountedSUCCESS: diskgroup ARCHDG was mountedTue Nov 4 17:55:03 2014Thread 1 cannot allocate new log, seque...
-
编辑 删除
redo log
1.创建新的日志文件组alter database add logfile group 5 ('/u01/app/oracle/oradata/orcl/redo11.log') size 100m;alter database add logfile group 6 ('/u01/app/oracle/oradata/orcl/redo21.log') size 100m;2.切换日志alter system switch logfile;3.增加日志组成员alter da...
-
编辑 删除
Oracle常用脚本
Oracle常用脚本1 查看所有数据文件select file_name from dba_data_filesunionselect file_name from dba_temp_filesunionselect name from v$controlfileunionselect value from v$parameter where name='...
