Home » RDBMS Server » Backup & Recovery » Media Recovery failed due to the missing Log files. (Oracle 9i)
Media Recovery failed due to the missing Log files. [message #469625] Thu, 05 August 2010 06:01 Go to next message
ejdrba
Messages: 27
Registered: May 2005
Location: Kolkata
Junior Member

Hi,

I am facing a problem (I am using Oracle 9i one Windows NT)
with Recovery. It was required due to the below -

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ROSDEV\SYSTEM01.DBF'

My Restoration went well, but when trying the below its returning error -

RMAN> recover database;

archive log thread 1 sequence 50 is already on disk as file D:\ROSDEV_ARCH\ARCH\ARC00050.001
archive log thread 1 sequence 51 is already on disk as file D:\ROSDEV_ARCH\ARCH\ARC00051.001
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/05/2010 01:02:51
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 49 scn 8519738158609 found to restore
RMAN-06025: no backup of log thread 1 seq 48 scn 8519738157490 found to restore
RMAN-06025: no backup of log thread 1 seq 47 scn 8519738156886 found to restore
RMAN-06025: no backup of log thread 1 seq 46 scn 8519738156511 found to restore
RMAN-06025: no backup of log thread 1 seq 45 scn 8519738156141 found to restore
RMAN-06025: no backup of log thread 1 seq 44 scn 8519738155744 found to restore
RMAN-06025: no backup of log thread 1 seq 43 scn 8519738155321 found to restore
RMAN-06025: no backup of log thread 1 seq 42 scn 8519738154915 found to restore
RMAN-06025: no backup of log thread 1 seq 41 scn 8519738154537 found to restore
RMAN-06025: no backup of log thread 1 seq 40 scn 8519738154108 found to restore
RMAN-06025: no backup of log thread 1 seq 39 scn 8519738153737 found to restore
RMAN-06025: no backup of log thread 1 seq 38 scn 8519738153352 found to restore
RMAN-06025: no backup of log thread 1 seq 37 scn 8519738152972 found to restore
RMAN-06025: no backup of log thread 1 seq 36 scn 8519738152356 found to restore
RMAN-06025: no backup of log thread 1 seq 35 scn 8519738151937 found to restore
RMAN-06025: no backup of log thread 1 seq 34 scn 8519738151520 found to restore
RMAN-06025: no backup of log thread 1 seq 33 scn 8519738151118 found to restore
RMAN-06025: no backup of log thread 1 seq 32 scn 8519738150693 found to restore
RMAN-06025: no backup of log thread 1 seq 31 scn 8519738150294 found to restore
RMAN-06025: no backup of log thread 1 seq 30 scn 8519738149892 found to restore
RMAN-06025: no backup of log thread 1 seq 29 scn 8519738149507 found to restore
RMAN-06025: no backup of log thread 1 seq 28 scn 8519738147253 found to restore
RMAN-06025: no backup of log thread 1 seq 27 scn 8519737981726 found to restore
RMAN-06025: no backup of log thread 1 seq 26 scn 8519737605261 found to restore

But all the files are in place.
Then I tried below to check -

RMAN> LIST BACKUP OF DATAFILE 1;

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
29 Full 283M DISK 00:00:32 24-JUL-10
BP Key: 23 Status: AVAILABLE Tag: TAG20100724T000026
Piece Name: D:\BACKUP\RMAN_BKP\ORA_DF725155226_S39_S1
List of Datafiles in backup set 29
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 8519737605228 24-JUL-10 C:\ORACLE\ORADATA\ROSDEV\SYSTEM01.DBF

Its all present there.
Note: I changed the Archivelog destination recently and deleted the obsolete RMAN backups!

I am new to the Administration, Could you please help!

Thanks and Regards,
Debraj
Re: Media Recovery failed due to the missing Log files. [message #469654 is a reply to message #469625] Thu, 05 August 2010 06:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You need to recover to a point in time/scn just prior to last backup.
RMAN> recover database;

Will try to recover to latest and your backup is as of
>>29 Full 283M DISK 00:00:32 24-JUL-10
Re: Media Recovery failed due to the missing Log files. [message #469683 is a reply to message #469654] Thu, 05 August 2010 08:11 Go to previous messageGo to next message
ejdrba
Messages: 27
Registered: May 2005
Location: Kolkata
Junior Member

Hi Mahesh,

It is also not working, as I tried below -

RMAN> RESTORE DATABASE UNTIL TIME "to_date('07/23/2010 00:00:00' , 'mm/dd/yy hh24:mi:ss')";

Starting restore at 05-AUG-10

using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/05/2010 06:04:54
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 12 found to restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

Thanks and Regards,
Debraj
Re: Media Recovery failed due to the missing Log files. [message #469767 is a reply to message #469683] Thu, 05 August 2010 14:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>RMAN> RESTORE DATABASE UNTIL TIME "to_date('07/23/2010 00:00:00' , 'mm/dd/yy hh24:mi:ss')";
It is supposed to yyyy.
Could you check the database incarnation also?
Re: Media Recovery failed due to the missing Log files. [message #469842 is a reply to message #469767] Fri, 06 August 2010 02:11 Go to previous messageGo to next message
ejdrba
Messages: 27
Registered: May 2005
Location: Kolkata
Junior Member

Hi Mahesh, I am sorry, even the YYYY is not working.
Apart from the DB Incarnation, I am also sending you some other detials, which may help you to understand how I should aproach further Smile

RMAN> list backup;

using target database controlfile instead of recovery catalog

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
29 Full 1G DISK 00:00:32 24-JUL-10
BP Key: 23 Status: AVAILABLE Tag: TAG20100724T000026
Piece Name: D:\BACKUP\RMAN_BKP\ORA_DF725155226_S39_S1
List of Datafiles in backup set 29
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 8519737605228 24-JUL-10 C:\ORACLE\ORADATA\ROSDEV\SYSTEM01.DBF
2 Full 8519737605228 24-JUL-10 C:\ORACLE\ORADATA\ROSDEV\UNDOTBS01.DBF
3 Full 8519737605228 24-JUL-10 C:\ORACLE\ORADATA\ROSDEV\DRSYS01.DBF
4 Full 8519737605228 24-JUL-10 C:\ORACLE\ORADATA\ROSDEV\EXAMPLE01.DBF
5 Full 8519737605228 24-JUL-10 C:\ORACLE\ORADATA\ROSDEV\INDX01.DBF
6 Full 8519737605228 24-JUL-10 C:\ORACLE\ORADATA\ROSDEV\ODM01.DBF
7 Full 8519737605228 24-JUL-10 C:\ORACLE\ORADATA\ROSDEV\TOOLS01.DBF
8 Full 8519737605228 24-JUL-10 C:\ORACLE\ORADATA\ROSDEV\USERS01.DBF
9 Full 8519737605228 24-JUL-10 C:\ORACLE\ORADATA\ROSDEV\XDB01.DBF
10 Full 8519737605228 24-JUL-10 C:\ORACLE\ORADATA\ROSDEV\JIRA_TS.ORA
11 Full 8519737605228 24-JUL-10 C:\ORACLE\ORADATA\ROSDEV\PBASE_TS.ORA
12 Full 8519737605228 24-JUL-10 C:\ORACLE\ORADATA\ROSDEV\PBASE_TS.DBF

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
30 26K DISK 00:00:01 24-JUL-10
BP Key: 24 Status: AVAILABLE Tag: TAG20100724T000103
Piece Name: D:\BACKUP\RMAN_BKP\ORA_DF725155263_S40_S1

List of Archived Logs in backup set 30
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 25 8519737605174 23-JUL-10 8519737605261 24-JUL-10

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
31 Full 1M DISK 00:00:00 24-JUL-10
BP Key: 25 Status: AVAILABLE Tag:
Piece Name: D:\BACKUP\RMAN_BKP\ORA_CFC-3682766146-20100724-00
SPFILE Included: Modification time: 20-JUL-10

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
32 62M DISK 00:00:02 04-AUG-10
BP Key: 26 Status: AVAILABLE Tag: TAG20100804T034624
Piece Name: D:\BACKUP\RMAN_BKP\ORA_DF726119184_S42_S1

List of Archived Logs in backup set 32
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 50 8519738380964 02-AUG-10 8519738556135 04-AUG-10
1 51 8519738556135 04-AUG-10 8519738556251 04-AUG-10

RMAN> LIST COPY;


List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
67 1 50 A 02-AUG-10 D:\ROSDEV_ARCH\ARCH\ARC00050.001
68 1 51 A 04-AUG-10 D:\ROSDEV_ARCH\ARCH\ARC00051.001

RMAN> list expired backup;


RMAN> LIST INCARNATION OF DATABASE;


List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ROSDEV 3682766146 NO 1 02-JUL-10
2 2 ROSDEV 3682766146 NO 496882 07-JUL-10
3 3 ROSDEV 3682766146 YES 497913 07-JUL-10


Thanks and Regards,
Debraj
Re: Media Recovery failed due to the missing Log files. [message #469845 is a reply to message #469842] Fri, 06 August 2010 02:15 Go to previous message
ejdrba
Messages: 27
Registered: May 2005
Location: Kolkata
Junior Member

Also, LIST COPY; is not showing my other archive log files, which starts from 25!!
Previous Topic: Lost current online log file
Next Topic: RMAN : format specifier %F
Goto Forum:
  


Current Time: Tue Jul 29 19:14:08 CDT 2014

Total time taken to generate the page: 0.08765 seconds