| why can not recover this datafile? [message #321736] |
Wed, 21 May 2008 03:34  |
wxfjordan
Messages: 92
Registered: December 2006
|
Member |
|
|
Solaris10 + Oracle10gR2 RAC
When open database and prompt the following error:
SQL> startup mount;
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1279820 bytes
Variable Size 117442740 bytes
Database Buffers 167772160 bytes
Redo Buffers 2912256 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '+DATA/sba/datafile/system.264.655244061'
when I recover datafile 1 in RMAN and prompt the error message:
[oracle@rac1 ~]$ rman target / nocatalog
Recovery Manager: Release 10.2.0.2.0 - Production on Wed May 21 15:57:30 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: SBA (DBID=2242694518, not open)
using target database control file instead of recovery catalog
RMAN> recover datafile 1;
Starting recover at 21-MAY-08
using channel ORA_DISK_1
starting media recovery
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/21/2008 16:07:03
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 2 seq 1 lowscn 439628 found to restore
RMAN-06025: no backup of log thread 1 seq 29 lowscn 442052 found to restore
How to solve this problem in RAC?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: why can not recover this datafile? [message #322572 is a reply to message #322291] |
Sat, 24 May 2008 09:25  |
mao_ocp
Messages: 1
Registered: May 2008
Location: Oman
|
Junior Member |
|
|
Hi There,
You said ...
When open database and prompt the following error:
SQL> startup mount;
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1279820 bytes
Variable Size 117442740 bytes
Database Buffers 167772160 bytes
Redo Buffers 2912256 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '+DATA/sba/datafile/system.264.655244061'
And I say...
To startup your database without corrupted datafile.
1. MOUNT THE DATABASE
2. SQL> ALTER DATABASE DATAFILE /oracle_base/oradata/....dbf
OFFLINE;
SQL> ALTER DATABASE OPEN;
good luck;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
