on 10-11-2010 1:50 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
Good going PR, Appreciate your awards/points
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.