Home » RDBMS Server » Backup & Recovery » why can not recover this datafile? (Solaris10 + Oracle10gR2 RAC)
why can not recover this datafile? [message #321736] Wed, 21 May 2008 03:34 Go to next message
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 #321741 is a reply to message #321736] Wed, 21 May 2008 03:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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

If you have no backup of these ones somewhere, I'm afraid you can't recover.

Regards
Michel
Re: why can not recover this datafile? [message #321764 is a reply to message #321736] Wed, 21 May 2008 04:55 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You have missed log. So you have to do
set until
clause.

Search on google.
http://www.google.com.bd/search?num=100&hl=en&safe=off&q=RMAN-06053%3A+RMAN-06025%3A&btnG=Search&meta=lr%3Dlang_e n
Re: why can not recover this datafile? [message #322044 is a reply to message #321736] Thu, 22 May 2008 04:47 Go to previous messageGo to next message
wxfjordan
Messages: 92
Registered: December 2006
Member

RMAN-06053: unable to perform media recovery because of missing log


I see. I also don't backup archivelog file and all archivelog file was corrupttd in ASM diskgroup. So this file can not recover.

Althrough this file can not reocver. How can I startup database?

[Updated on: Thu, 22 May 2008 04:51]

Report message to a moderator

Re: why can not recover this datafile? [message #322057 is a reply to message #322044] Thu, 22 May 2008 05:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You may only start it from the last backup (if it is consistent).

Regards
Michel
Re: why can not recover this datafile? [message #322282 is a reply to message #321736] Fri, 23 May 2008 00:19 Go to previous messageGo to next message
wxfjordan
Messages: 92
Registered: December 2006
Member

But it is not consistent now. How to startup database in this situation?
Re: why can not recover this datafile? [message #322291 is a reply to message #322282] Fri, 23 May 2008 00:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I'm afraid you can't recover.


I recommend you to hire a senior consultant or call Oracle support to help you in this.

Regards
Michel
Re: why can not recover this datafile? [message #322572 is a reply to message #322291] Sat, 24 May 2008 09:25 Go to previous messageGo to next message
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;
Re: why can not recover this datafile? [message #322579 is a reply to message #322572] Sat, 24 May 2008 09:43 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't offline a SYSTEM tablespace file.

Regards
Michel
Previous Topic: Cannot connect to target database
Next Topic: Changing backup location in RMAN backups
Goto Forum:
  


Current Time: Mon Dec 05 08:41:54 CST 2016

Total time taken to generate the page: 0.13141 seconds