This discussion is archived
0 Replies Latest reply: Apr 27, 2013 7:11 PM by 975354 RSS

恢复报错ORA-01139

975354 Newbie
Currently Being Moderated
恢复报错ORA-01139
从oracle 10g RAC (操作系统Enterprise Linux Enterprise Linux AS release 4 64bit),数据库版本10.2.0.4环境中将数据备份恢复到相同环境的异机。
向各位大牛请教!
在做完不完全恢复时。
recover database是正常的
RMAN> sql'alter database open resetlogs';

sql statement: alter database open resetlogs
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
ORA-01092: ORACLE instance terminated. Disconnection forced
RMAN-03009: failure of sql command on default channel at 04/28/2013 09:09:05
RMAN-11003: failure during parse/execution of SQL statement: alter database open resetlogs
ORA-01041: internal error. hostdef extension doesn't exist
ORACLE error from target database:
ORA-03114: not connected to ORACLE

接着我
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery。
警告日志如下alter.log
alter database recover logfile '/home/backup/flash_recovery_area/LD/archivelog/2013_04_28/o1_mf_2_47509_8qrwzjdm_.arc'
Sun Apr 28 08:57:23 2013
Media Recovery Log /home/backup/flash_recovery_area/LD/archivelog/2013_04_28/o1_mf_2_47509_8qrwzjdm_.arc
ORA-279 signalled during: alter database recover logfile '/home/backup/flash_recovery_area/LD/archivelog/2013_04_28/o1_mf_2_47509_8qrwzjdm_.arc'...
Sun Apr 28 08:57:23 2013
alter database recover logfile '/home/backup/flash_recovery_area/LD/archivelog/2013_04_28/o1_mf_1_85650_8qrwz1b1_.arc'
Sun Apr 28 08:57:23 2013
Media Recovery Log /home/backup/flash_recovery_area/LD/archivelog/2013_04_28/o1_mf_1_85650_8qrwz1b1_.arc
ORA-279 signalled during: alter database recover logfile '/home/backup/flash_recovery_area/LD/archivelog/2013_04_28/o1_mf_1_85650_8qrwz1b1_.arc'...
Sun Apr 28 08:57:31 2013
alter database recover logfile '/home/backup/flash_recovery_area/LD/archivelog/2013_04_28/o1_mf_1_85651_8qrwz1hk_.arc'
Sun Apr 28 08:57:31 2013
Media Recovery Log /home/backup/flash_recovery_area/LD/archivelog/2013_04_28/o1_mf_1_85651_8qrwz1hk_.arc
ORA-279 signalled during: alter database recover logfile '/home/backup/flash_recovery_area/LD/archivelog/2013_04_28/o1_mf_1_85651_8qrwz1hk_.arc'...
Sun Apr 28 08:57:31 2013
alter database recover logfile '/home/backup/flash_recovery_area/LD/archivelog/2013_04_28/o1_mf_2_47510_8qrwzjm2_.arc'
Sun Apr 28 08:57:31 2013
Media Recovery Log /home/backup/flash_recovery_area/LD/archivelog/2013_04_28/o1_mf_2_47510_8qrwzjm2_.arc
ORA-279 signalled during: alter database recover logfile '/home/backup/flash_recovery_area/LD/archivelog/2013_04_28/o1_mf_2_47510_8qrwzjm2_.arc'...
Sun Apr 28 08:57:31 2013
alter database recover cancel
Sun Apr 28 08:57:37 2013
Media Recovery Canceled
Completed: alter database recover cancel
Sun Apr 28 09:04:15 2013
alter database rename file '+DATADG/ld/redo01a.log' to '/home/backup/oradata/ld/redo1a.log'
Sun Apr 28 09:04:15 2013
Starting control autobackup
******************** WARNING ***************************
The errors during Server autobackup are not fatal, as it
is attempted after sucessful completion of the command.
However, it is recomended to take an RMAN control file
backup as soon as possible because the Autobackup failed
with the following error:
ORA-00236: snapshot operation disallowed: mounted control file is a backup

with the following error:
ORA-00236: snapshot operation disallowed: mounted control file is a backup
******************** END OF WARNING *******************
Completed: alter database rename file '+DATADG/ld/redo03a.log' to '/home/backup/oradata/ld/redo3a.log'
Sun Apr 28 09:05:32 2013
alter database rename file '+DATADG/ld/redo03b.log' to '/home/backup/oradata/ld/redo3b.log'
Starting control autobackup
******************** WARNING ***************************
The errors during Server autobackup are not fatal, as it
is attempted after sucessful completion of the command.
However, it is recomended to take an RMAN control file
backup as soon as possible because the Autobackup failed
with the following error:
ORA-00236: snapshot operation disallowed: mounted control file is a backup
******************** END OF WARNING *******************
Completed: alter database rename file '+DATADG/ld/redo03b.log' to '/home/backup/oradata/ld/redo3b.log'
Sun Apr 28 09:05:42 2013
alter database rename file '+DATADG/ld/redo04a.log' to '/home/backup/oradata/ld/redo4a.log'
Sun Apr 28 09:05:42 2013
Starting control autobackup
******************** WARNING ***************************
The errors during Server autobackup are not fatal, as it
is attempted after sucessful completion of the command.
However, it is recomended to take an RMAN control file
backup as soon as possible because the Autobackup failed
with the following error:
ORA-00236: snapshot operation disallowed: mounted control file is a backup
******************** END OF WARNING *******************
Completed: alter database rename file '+DATADG/ld/redo04a.log' to '/home/backup/oradata/ld/redo4a.log'
Sun Apr 28 09:05:50 2013
alter database rename file '+DATADG/ld/redo04b.log' to '/home/backup/oradata/ld/redo4b.log'
Starting control autobackup
******************** WARNING ***************************
The errors during Server autobackup are not fatal, as it
is attempted after sucessful completion of the command.
However, it is recomended to take an RMAN control file
backup as soon as possible because the Autobackup failed
with the following error:
ORA-00236: snapshot operation disallowed: mounted control file is a backup
。。。。
Sun Apr 28 09:10:00 2013
Successful mount of redo thread 1, with mount id 2474343140
Sun Apr 28 09:10:00 2013
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sun Apr 28 09:10:09 2013
alter database open resetlogs
ORA-1139 signalled during: alter database open resetlogs...

xx_ora_30570.trc日志如下
/opt/app/oracle/admin/ld/udump/xx_ora_30570.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /opt/app/oracle/product/10.2.0/db_1
System name:     Linux
Node name:     ldTest
Release:     2.6.9-67.0.0.0.1.ELsmp
Version:     #1 SMP Sun Nov 18 01:06:10 EST 2007
Machine:     x86_64
Instance name: ld
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 30570, image: oracle@ldTest (TNS V1-V3)

*** 2013-04-27 20:39:32.112
*** ACTION NAME:(0000005 STARTED124) 2013-04-27 20:39:32.112
*** MODULE NAME:(rman@ldTest (TNS V1-V3)) 2013-04-27 20:39:32.112
*** SERVICE NAME:() 2013-04-27 20:39:32.112
*** SESSION ID:(542.8) 2013-04-27 20:39:32.112
Control file resized from 4322 to 4412 blocks
kccrsd_append: rectype = 13, lbn = 2161, recs = 1000
*** 2013-04-27 22:47:07.275
*** ACTION NAME:(0000139 STARTED60) 2013-04-27 22:47:07.275
2013-04-27 22:47:07.275: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:07.279: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:07.279: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:07.279: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:07.279: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/system01.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/system01.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000140 STARTED60) 2013-04-27 22:47:07.375
2013-04-27 22:47:07.375: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:07.375: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:07.375: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:07.375: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:07.375: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/undotbs01.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/undotbs01.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000141 STARTED60) 2013-04-27 22:47:07.462
2013-04-27 22:47:07.462: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:07.462: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:07.462: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:07.462: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:07.462: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/sysaux01.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/sysaux01.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000142 STARTED60) 2013-04-27 22:47:07.538
2013-04-27 22:47:07.538: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:07.538: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:07.538: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:07.538: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:07.538: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/undotbs02.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/undotbs02.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000143 STARTED60) 2013-04-27 22:47:07.603
2013-04-27 22:47:07.603: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:07.604: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:07.604: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:07.604: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:07.604: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/users01.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/users01.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000144 STARTED60) 2013-04-27 22:47:07.660
2013-04-27 22:47:07.660: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:07.660: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:07.660: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:07.660: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:07.660: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/sale_ix01.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/sale_ix01.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000145 STARTED60) 2013-04-27 22:47:07.741
2013-04-27 22:47:07.741: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:07.741: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:07.741: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:07.741: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:07.741: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/sale01.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/sale01.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000146 STARTED60) 2013-04-27 22:47:07.829
2013-04-27 22:47:07.829: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:07.829: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:07.829: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:07.829: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:07.829: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/cpc01.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/cpc01.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000147 STARTED60) 2013-04-27 22:47:07.974
2013-04-27 22:47:07.974: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:07.974: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:07.974: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:07.974: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:07.974: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/cpc_ix01.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/cpc_ix01.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000148 STARTED60) 2013-04-27 22:47:08.073
2013-04-27 22:47:08.073: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:08.073: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:08.073: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:08.073: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:08.073: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/sale02.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/sale02.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000149 STARTED60) 2013-04-27 22:47:08.168
2013-04-27 22:47:08.168: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:08.168: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:08.168: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:08.168: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:08.168: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/sale_ix02.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/sale_ix02.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000150 STARTED60) 2013-04-27 22:47:08.295
2013-04-27 22:47:08.295: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:08.295: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:08.295: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:08.295: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:08.295: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/sale03.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/sale03.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000151 STARTED60) 2013-04-27 22:47:08.396
2013-04-27 22:47:08.396: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:08.396: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:08.396: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:08.396: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:08.396: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/sale04.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/sale04.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000152 STARTED60) 2013-04-27 22:47:08.488
2013-04-27 22:47:08.488: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:08.488: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:08.488: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:08.488: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:08.488: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/sale05.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/sale05.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000153 STARTED60) 2013-04-27 22:47:08.587
2013-04-27 22:47:08.587: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:08.587: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:08.587: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:08.587: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:08.587: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/f_data01.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/f_data01.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000154 STARTED60) 2013-04-27 22:47:08.669
2013-04-27 22:47:08.669: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:08.669: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:08.669: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:08.669: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:08.670: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/f_data02.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/f_data02.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000155 STARTED60) 2013-04-27 22:47:08.771
2013-04-27 22:47:08.771: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:08.771: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:08.771: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:08.771: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:08.771: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/f_ix01.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/f_ix01.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000156 STARTED60) 2013-04-27 22:47:08.886
2013-04-27 22:47:08.886: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:08.886: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:08.886: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:08.886: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:08.886: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/f_ix02.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/f_ix02.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000157 STARTED60) 2013-04-27 22:47:08.999
2013-04-27 22:47:08.999: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:08.999: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:08.999: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:08.999: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:08.999: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/f_data03.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/f_data03.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000158 STARTED60) 2013-04-27 22:47:09.096
2013-04-27 22:47:09.096: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:09.096: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:09.096: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:09.096: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:09.096: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/f_data04.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/f_data04.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
*** ACTION NAME:(0000159 STARTED60) 2013-04-27 22:47:09.150
2013-04-27 22:47:09.150: [  OCROSD]utgdv:2:ocr loc file cannot be opened
2013-04-27 22:47:09.150: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2013-04-27 22:47:09.150: [  OCRRAW]proprinit: Could not open raw device
2013-04-27 22:47:09.150: [ default]a_init:7!: Backend init unsuccessful : [33]
2013-04-27 22:47:09.150: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-19625: error identifying file +DATADG/users02.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATADG/users02.dbf
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager

******************************************************
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/home/backup/oradata/ld/redo1b.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/home/backup/oradata/ld/redo1a.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/home/backup/oradata/ld/redo1b.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/home/backup/oradata/ld/redo1a.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
logfile 1 open failed:313
*** 2013-04-28 09:08:35.897 3950 kcrr.c
Archiving online redo logfile /home/backup/oradata/ld/redo2b.log
******************************************************
WARNING: Archival will be performed using 2 passes.
The first pass will attempt to determine the end-of-file
of the online redo logfile. The end-of-file is determined
by identifying what is described as a "corrupt" block
header. This will be reported as an ORA-00354 error.
However, this is not really a corrupt block - it is the
end of the redo data.
The second pass will then archive the online redo logfile
using the identified end-of-file information.
******************************************************
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/home/backup/oradata/ld/redo2b.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/home/backup/oradata/ld/redo2a.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/home/backup/oradata/ld/redo2b.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/home/backup/oradata/ld/redo2a.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
logfile 2 open failed:313
*** 2013-04-28 09:08:35.898 3950 kcrr.c
Archiving online redo logfile /home/backup/oradata/ld/redo3b.log
******************************************************
WARNING: Archival will be performed using 2 passes.
The first pass will attempt to determine the end-of-file
of the online redo logfile. The end-of-file is determined
by identifying what is described as a "corrupt" block
header. This will be reported as an ORA-00354 error.
However, this is not really a corrupt block - it is the
end of the redo data.
The second pass will then archive the online redo logfile
using the identified end-of-file information.



请教如何解决ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery。谢谢

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points