『紧急』数据库出现问题，请大侠们帮帮忙

ALLSTARS_ORACLE

SQL> startup
ORACLE instance started.

Total System Global Area 1417674752 bytes
Fixed Size                   790556 bytes
Variable Size             342093796 bytes
Database Buffers         1073741824 bytes
Redo Buffers                1048576 bytes
Database mounted.
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:\ORADATA\OMSAMMIC\SYSTEM01.DBF'


SQL>
谢谢


如何恢复呀？ 谢谢


recover database时候，出下面的错误

AUTO
ORA-00283: recovery session canceled due to errors
ORA-12801: error signaled in parallel query server P001
ORA-00600: internal error code, arguments: [3020], [8], [80], [33554512], [],
[], [], []
ORA-10567: Redo is inconsistent with data block (file# 8, block# 80)
ORA-10564: tablespace OMSIDX
ORA-01110: data file 8: 'E:\ORADATA\OMSAMMIC\OMSIDX01.ORA'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 52819


ORA-01112: media recovery not started

如何解决？


刚才的错没报，报下面的错误，谢谢

SQL> recover standby database parallel 1
ORA-00279: change 1290620 generated at 10/03/2006 23:00:39 needed for thread 1
ORA-00289: suggestion : F:\ARCHIVELOG\ARC00160_0602789216.001
ORA-00280: change 1290620 for thread 1 is in sequence #160


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Auto
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [2], [343], [8388951], [],
[], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 343)
ORA-10564: tablespace UNDOTBS1
ORA-01110: data file 2: 'E:\ORADATA\OMSAMMIC\UNDOTBS01.DBF'
ORA-10560: block type 'KTU UNDO BLOCK'


ORA-01112: media recovery not started


SQL>


现在硬盘没有空间了，我删除了三天前的，三天前肯定应用了把？
对嘛？


下面是部分alert.log文件
Sun Oct 08 10:22:46 2006
RFS[4]: Archive log thread 1 sequence 601 available in 30 minute(s)
Controlfile has resized from 204 to 222 blocks.
RFS[4]: Archived Log: 'F:\ARCHIVELOG\ARC00602_0602789216.001'
Committing creation of archivelog 'F:\ARCHIVELOG\ARC00602_0602789216.001'
Sun Oct 08 10:23:00 2006
RFS[4]: Archive log thread 1 sequence 602 available in 30 minute(s)
RFS[4]: Archived Log: 'F:\ARCHIVELOG\ARC00603_0602789216.001'
Committing creation of archivelog 'F:\ARCHIVELOG\ARC00603_0602789216.001'
Sun Oct 08 10:23:14 2006
RFS[4]: Archive log thread 1 sequence 603 available in 30 minute(s)
RFS[4]: Archived Log: 'F:\ARCHIVELOG\ARC00604_0602789216.001'
Committing creation of archivelog 'F:\ARCHIVELOG\ARC00604_0602789216.001'
Sun Oct 08 10:23:28 2006
RFS[4]: Archive log thread 1 sequence 604 available in 30 minute(s)
RFS[4]: Archived Log: 'F:\ARCHIVELOG\ARC00605_0602789216.001'
Committing creation of archivelog 'F:\ARCHIVELOG\ARC00605_0602789216.001'

感觉今天archive log 已经应用了，大师说的最后一个 是哪个呀？


版主，这三步都能正常的执行。现在数据库处于mount状态。
但是数据库不能 只读方式打开
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:\ORADATA\OMSAMMIC\SYSTEM01.DBF'

现在primary db 正常运行着，我可以依什么方式打开 dataguard 数据库呀？谢谢


SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS from v$managed_s
tandby;

PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH      CONNECTED             0          0          0          0
ARCH      CONNECTED             0          0          0          0
RFS       RECEIVING             0          0          0          0

是不是表名 dataguard 还没有应用呀？谢谢

如何应用？



stanby的 logfile的状态

           GROUP#        STATUS        TYPE        MEMBER        IS_RECOVERY_DEST_FILE
1        3        STALE        ONLINE        E:\ORADATA\OMSAMMIC\REDO03.LOG        NO
2        2                ONLINE        E:\ORADATA\OMSAMMIC\REDO02.LOG        NO
3        1                ONLINE        E:\ORADATA\OMSAMMIC\REDO01.LOG        NO
4        4                STANDBY        E:\ORADATA\OMSAMMIC\REDO04.LOG        NO
5        5                STANDBY        E:\ORADATA\OMSAMMIC\REDO05.LOG        NO
6        6                STANDBY        E:\ORADATA\OMSAMMIC\REDO06.LOG        NO
7        7                STANDBY        E:\ORADATA\OMSAMMIC\REDO07.LOG        NO

仅仅主库switch不起作用，从库 由于数据库没有open，不能switch。
不知道怎么解决？

           SEQUENCE#        APPLIED
1        153        YES
2        154        YES
3        155        YES
4        156        YES
5        157        YES
6        158        YES
7        159        YES
8        160        NO
9        161        NO
10        162        NO

其中160是 10月3号的archive log，没有应用。
不知道什么原因？是不是这个archive log文件坏掉了。


版主，继续呀
standby alert.log

Tue Oct 03 20:19:33 2006
RFS[1]: Successfully opened standby log 5: 'E:\ORADATA\OMSAMMIC\REDO05.LOG'
Tue Oct 03 20:19:39 2006
Committing creation of archivelog 'F:\ARCHIVELOG\ARC00158_0602789216.001'
Tue Oct 03 20:19:40 2006
ARC1: Archive log thread 1 sequence 158 available in 30 minute(s)
Tue Oct 03 20:27:34 2006
Media Recovery Log D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\OMSAMMIC\ARCHIVELOG\2006_10_03\O1_MF_1_157_2L4N17CC_.ARC
Media Recovery Delayed for 30 minute(s) (thread 1 sequence 158)
Media Recovery Log F:\ARCHIVELOG\ARC00158_0602789216.001
Media Recovery Waiting for thread 1 sequence 159 (in transit)
Tue Oct 03 22:56:54 2006
ARC1: Evaluating archive   log 5 thread 1 sequence 159
Tue Oct 03 22:56:54 2006
RFS[1]: Successfully opened standby log 4: 'E:\ORADATA\OMSAMMIC\REDO04.LOG'
Tue Oct 03 22:57:01 2006
Committing creation of archivelog 'F:\ARCHIVELOG\ARC00159_0602789216.001'
Tue Oct 03 22:57:01 2006
ARC1: Archive log thread 1 sequence 159 available in 30 minute(s)
Tue Oct 03 22:57:03 2006
Media Recovery Delayed for 30 minute(s) (thread 1 sequence 159)
Tue Oct 03 23:03:42 2006
ARC1: Evaluating archive   log 4 thread 1 sequence 160
Tue Oct 03 23:03:42 2006
RFS[1]: Successfully opened standby log 5: 'E:\ORADATA\OMSAMMIC\REDO05.LOG'
Tue Oct 03 23:03:49 2006
Committing creation of archivelog 'F:\ARCHIVELOG\ARC00160_0602789216.001'
Tue Oct 03 23:03:49 2006
ARC1: Archive log thread 1 sequence 160 available in 30 minute(s)
Tue Oct 03 23:05:24 2006
ARC1: Evaluating archive   log 5 thread 1 sequence 161
Tue Oct 03 23:05:25 2006
RFS[1]: Successfully opened standby log 4: 'E:\ORADATA\OMSAMMIC\REDO04.LOG'
Tue Oct 03 23:05:31 2006
Committing creation of archivelog 'F:\ARCHIVELOG\ARC00161_0602789216.001'
Tue Oct 03 23:05:32 2006
ARC1: Archive log thread 1 sequence 161 available in 30 minute(s)
Tue Oct 03 23:06:58 2006
ARC1: Evaluating archive   log 4 thread 1 sequence 162
Tue Oct 03 23:06:58 2006
RFS[1]: Successfully opened standby log 5: 'E:\ORADATA\OMSAMMIC\REDO05.LOG'
Tue Oct 03 23:07:05 2006
Committing creation of archivelog 'F:\ARCHIVELOG\ARC00162_0602789216.001'
Tue Oct 03 23:07:05 2006
ARC1: Archive log thread 1 sequence 162 available in 30 minute(s)
Tue Oct 03 23:08:45 2006
ARC1: Evaluating archive   log 5 thread 1 sequence 163
Tue Oct 03 23:08:45 2006
RFS[1]: Successfully opened standby log 4: 'E:\ORADATA\OMSAMMIC\REDO04.LOG'
Tue Oct 03 23:08:52 2006
Committing creation of archivelog 'F:\ARCHIVELOG\ARC00163_0602789216.001'
Tue Oct 03 23:08:52 2006
ARC1: Archive log thread 1 sequence 163 available in 30 minute(s)
......

其余都是些 空间不足的错误了。

ALLSTARS_ORACLE

这边的生产数据库就不能停的。
现在 standby 的logfile的状态

GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
1 3 STALE ONLINE E:\ORADATA\OMSAMMIC\REDO03.LOG NO
2 2 ONLINE E:\ORADATA\OMSAMMIC\REDO02.LOG NO
3 1 ONLINE E:\ORADATA\OMSAMMIC\REDO01.LOG NO
4 4 STANDBY E:\ORADATA\OMSAMMIC\REDO04.LOG NO


而数据库open read only的时候又出现
Database mounted.
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:\ORADATA\OMSAMMIC\SYSTEM01.DBF'

数据库恢复的时候
recover standby database出现
AUTO
ORA-00283: recovery session canceled due to errors
ORA-12801: error signaled in parallel query server P001
ORA-00600: internal error code, arguments: [3020], [8], [80], [33554512], [],
[], [], []
ORA-10567: Redo is inconsistent with data block (file# 8, block# 80)
ORA-10564: tablespace OMSIDX
ORA-01110: data file 8: 'E:\ORADATA\OMSAMMIC\OMSIDX01.ORA'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 52819


ORA-01112: media recovery not started


还有
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session;
还是很多archive log没有应用

SEQUENCE# APPLIED
1 153 YES
2 154 YES
3 155 YES
4 156 YES
5 157 YES
6 158 YES
7 159 YES
8 160 NO
9 161 NO
10 162 NO
11 163 NO
12 164 NO
13 165 NO
14 166 NO
15 167 NO
16 168 NO
17 169 NO
。。。。。。