cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Database Point intime recovery with File System backup.

pr_srinivas
Contributor
0 Kudos

Hi.. Experts...

We have shutdown the database and have take a file system backup on

09.10.2010 @ 10 AM.

We started the database and all the archive logs generated after that are already

available in archive directory till now.

We discovered there were some deletions took place. Yesterday evening at 4 PM.

Requirement.

-


We want to recover the database till yesterday 3.30 PM.

Can any one send steps to recover with above backup and available archive logs till 3.30 PM Yesterday.

Regards

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Missed some thing

Restore offline backup

Mount your DB

Recover your database using archivelogs

Open you DB

At recovery point you can apply archivelogs.

Regards,

Nick Loy

pr_srinivas
Contributor
0 Kudos

Experts

I restored offline Backup.

and i restored all archived logs till the time recovery i need.

according it should apply 300 files.

--

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1224736768 bytes

Fixed Size 2083664 bytes

Variable Size 620758192 bytes

Database Buffers 587202560 bytes

Redo Buffers 14692352 bytes

Database mounted.

SQL> recover database until time '2010-10-10:11:59:59';

Media recovery complete.

SQL>

---

In a flash of second - i got Media Recovery Complerted.

I think recovery not done.

Any adivise to move further.

Rgds

volker_borowski2
Active Contributor
0 Kudos

Hi,

most likely, you also restored the controlfiles as well in your Filesystem Restore.

As you did not tell Oracle that for recovery, it assumes, that your controlfile is

the CURRENT controlfile and thus it finds no transactions to recover for your given timeframe.

Make sure, that your controlfiles are consistent in all mirror locations (should be three of them).

Then do

recover database using backup controlfile until time ...

This should proceed with a recovery of loginformation that has been written AFTER the current SCN in the controlfile.

In the end you need to do an "ALTER DATABASE OPEN RESETLOGS" due to incomplete recovery.

Volker

pr_srinivas
Contributor
0 Kudos

Experts...

startup mount

recover database until time '2010-10-10:11:59:59' USING BACKUP CONTROLFILE;

-


Recovery started -


I will update one everything in place & done..

-


pr_srinivas
Contributor
0 Kudos

Experts.....Nick Loy, Varadharajan M, Mark & Volker.............Thanks U Very Much.

-


TAIL END MESSAGE OF RECOVERY COMMAND

-


ORA-00279: change 11331655931 generated at 10/10/2010 11:30:56 needed for

thread 1

ORA-00289: suggestion : /oracle/D10/oraarch/D10arch1_123487_607825009.dbf

ORA-00280: change 11331655931 for thread 1 is in sequence #123487

ORA-00278: log file '/oracle/D10/oraarch/D10arch1_123486_607825009.dbf' no

longer needed for this recovery

Log applied.

Media recovery complete.

SQL>

SQL>

-


SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL>

-


 SYSTEM RECOVERED TO DEMAND & RELEASED

T H A N K S -- T O -- E V E R Y O N E .

RGDS

Answers (5)

Answers (5)

Former Member
0 Kudos

Good going PR, Appreciate your awards/points

Former Member
0 Kudos

Good news to hear.

But why can't you give points to above techies who helped you in the reported issue?

Points are not only for being on top, Can motivate the contributors and helps others too.

Regards,

Nick Loy

pr_srinivas
Contributor
0 Kudos

Hi...Nick.....

I awarded ,,,but i missed to add for other techies... i did

Rgds

Edited by: PR Srinivas on Oct 12, 2010 11:11 AM

Former Member
0 Kudos

Yes as told by Volker aboove,

You should recover your DB using below commands

sql> recover database using backup controlfile until Date and time:

OR

sql>recover database using backup contorlfile until cancel;

Regards,

Nick Loy

Former Member
0 Kudos

It should work

Restore offline backup

Mount your DB

Recover your database utill time

Open you DB

Doesn't matter which backup you restored, You can recover it in mount stage.

Regards,

Nick Loy

Former Member
0 Kudos

Hi,

I would restore the last full backup prior your problem, the run

SQL> recover database until time '2004-03-21:22:59:04' <<<<<=== Format example only

Mark

pr_srinivas
Contributor
0 Kudos

The Full backup which i am restoring is already a offline backup , which does not demand recovery.

What i Understand is

Restore offline backup

put the db in mount state

and issue recover copmmand.

will it work on a database state which does not demand at all recovery :?

Rgds

Former Member
0 Kudos

Hi,

Here you go,

startup mount;
recover database until time <''time'>;
or
recover database until change <SCN>;
alter database open;

Regards,

Varadharajan M