oracle 归档模式下删除current日志不完全恢复
发布时间:2020-12-12 13:29:04 所属栏目:百科 来源:网络整理
导读:归档模式 [email?protected] archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/archOldest online log sequence 5Next log sequence to archive 7Current log se
归档模式
[email?protected]> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch Oldest online log sequence 5 Next log sequence to archive 7 Current log sequence 7 查看日志组 [email?protected]> select group#,status from v$log; GROUP# STATUS ---------- ---------------- 1 INACTIVE 2 CURRENT 3 INACTIVE 查看current日志组文件路径 select member from v$logfile; MEMBER ------------------------------------------------------------------------------------------------------------------------ /u01/app/oracle/oradata/orcl/redo03.log /u01/app/oracle/oradata/orcl//redo02.log /u01/app/oracle/oradata/orcl//redo01.log 删除日志文件 [email?protected]> startup ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2257840 bytes Variable Size 536874064 bytes Database Buffers 289406976 bytes Redo Buffers 6565888 bytes Database mounted. ORA-03113: end-of-file on communication channel Process ID: 2821 Session ID: 125 Serial number: 查看trace alert日志,提示找不到文件 ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: ‘/u01/app/oracle/oradata/orcl/redo02.log‘ ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 进行恢复 recover database until cancel; alter database open resetlogs; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |