Recovering oracle datafile without archived logs

Posted by PDSERVICE on Mar 07, 2020 In

I have an issue on my Oracle 10.2.0.4 instance where the archived logs have been deleted but I have managed to restore the datafiles from the FRA.

Is there any way to recover the datafiles without the archive logs please ?

I am quite familiar with the RMAN commands but can't seem to get it to work.

Well... if you do not have archived redo log files, is going to be difficult to recover your database until now or time when database failed.

But, you can restore and recover your database (all datafiles) until cancel. This is going to happen when your database does not find more archived redo logs to apply. At this point, you open your database using RESETLOGS.

ALTER DATABASE OPEN RESETLOGS;

how were the archived redo logs deleted from the FRA? Are you sure that the archived redo logs were not copied to tape or another location firrst?

- -

If the rman backup is a normal hot backup then without the archived redo logs the database cannot be made consistent. The database will be corrupt and may well be completely unusable.

- -

If the database is lost there are potential alternates to successful restore/recovery to salvage some of the data.

1 - There are Oracle and third-party tools/services which can be purchased to extract data directly from Oracle database files.

2 - Look for a full export file. It will be a point in time in the past but a full export would provide a starting point for recreating the database and trying to re-apply activity manually through job reruns and screen re-entry.

You can not move forward if you dont have archives.

You can try to open with current state.

if the below query returns 8192 and 0, you can open the database with resetlogs

select count(*),fhsta from x$kcvfh group by fhsta;

if not, you may have to choose unsupported method to open (alone with oracle support) , or you can look for some tool,, example DUL

You are here

Recovering oracle datafile without archived logs

Recovering oracle datafile without archived logs