『紧急』数据库出现问题，请大侠们帮帮忙
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: , , , , [],
[], [], []
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: , , , , [],
[], [], []
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: Archive log thread 1 sequence 601 available in 30 minute(s)
Controlfile has resized from 204 to 222 blocks.
RFS: Archived Log: 'F:\ARCHIVELOG\ARC00602_0602789216.001'
Committing creation of archivelog 'F:\ARCHIVELOG\ARC00602_0602789216.001'
Sun Oct 08 10:23:00 2006
RFS: Archive log thread 1 sequence 602 available in 30 minute(s)
RFS: Archived Log: 'F:\ARCHIVELOG\ARC00603_0602789216.001'
Committing creation of archivelog 'F:\ARCHIVELOG\ARC00603_0602789216.001'
Sun Oct 08 10:23:14 2006
RFS: Archive log thread 1 sequence 603 available in 30 minute(s)
RFS: Archived Log: 'F:\ARCHIVELOG\ARC00604_0602789216.001'
Committing creation of archivelog 'F:\ARCHIVELOG\ARC00604_0602789216.001'
Sun Oct 08 10:23:28 2006
RFS: Archive log thread 1 sequence 604 available in 30 minute(s)
RFS: 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: 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: 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: 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: 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: 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: 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)
......
其余都是些 空间不足的错误了。
这边的生产数据库就不能停的。
现在 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: , , , , [],
[], [], []
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
。。。。。。
页:
[1]