本文共 1480 字,大约阅读时间需要 4 分钟。
SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 3月 28 22:42:03 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. 请输入用户名: / as sysdba 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> select open_mode from v$database; OPEN_MODE ---------- MOUNTED SQL> alter database open; alter database open * 第 1 行出现错误: ORA-16038: 日志 3 序列号 93 无法归档 ORA-19809: 超出了恢复文件数的限制 ORA-00312: 联机日志 3 线程 1: 'D:/ORACLE/ORADATA/MYORACLE/REDO03.LOG' |
SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS ---------- ---------- ---------- ---------- ---------- --- ---------------- FIRST_CHANGE# FIRST_TIME ------------- -------------- 1 1 95 52428800 1 NO CURRENT 3719462 07-3月 -08 3 1 93 52428800 1 NO INACTIVE 3668109 07-3月 -08 2 1 94 52428800 1 NO INACTIVE 3692924 07-3月 -08 |
SQL> recover database until cancel; 完成介质恢复。 SQL> alter database open resetlogs; 数据库已更改。 SQL> select * from scott.dept; DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON |
转载地址:http://aavdi.baihongyu.com/