-
I am recovering a database that lost all its control files and data files. A tablespace that was just created 8:30 am this morning was also lost. The last good backup was taken at 2:00am this morning. That backup doesn't have that tablespace (prodx) that was created after the backup.
Now, What I did is restore the good backup and re-build the controlfile from the trace file. Now, I started the recovery process. Accroding to the docs, I also create the new datafiles for the tablespace that was created after the 2:00 am backup. Everything went pretty well.
The only problem is that the recovery process keep asking new archived logs even after all archived logs have been applied. I tried to cancel the recovery and tried open the database resetlogs. It failed. Now, I am going nowhere.
What could be wrong?
-
you have to recover using backup controlfile until cancel. once you have applied all your archived logs, you can cancel.
Jeff Hunter
-
recover database using backup controlfile;
Yes, I did that. And I can cancel the recovery at the end. However, when I tried open resetlogs, Oracle complained the system tablespace need recovery.
-
As Jeff Said, you should use,
recover database using backup controlfile until cancel;
Note that there is a differance between,
recover database using backup controlfile; and the above command.
Then
open database resetlogs;
It should work.
Thanks
Kishore Kumar
-
"recover database using backup controlfile until cancel;
Note that there is a differance between,
recover database using backup controlfile; and the above command. "
What's the difference? I have never heard of that and will be appreciate if you can explain.
The problem that I got was on Solaris on Intel platform. When I duplicate the same scenario on SPARC Solaris, there is no such problems. Do you think there is a differen between Oracle for Intel Solaris and Oracle for SPARC Solaris?
-
if you dont use until cancel oracle will go on recovering until last archive log he can find and if redo logs are online then it will recover until there
-
Until cancel....
Recovering untill you cancelled/crashed the databse not after that.Once all logs are applied you can,
Cancel;
open with resetlogs.
If you know approx time you can recover until time too...
If the tablespace is not backed up....obviously it will ask for recover...
for that follow the steps...
Try to open the database.....it will ask for the datafile....
try...
alter database create datafile 'same datafile path';...no size
statement processed
recover datafile 'filepath';
media recovery complete.
alter databse open;(if required reset log)
statement processed. hope this help.
Thanks.
Thanigaivasan...
-
thanigai,
My god! The db can be recovered without resetlogs.
-
if you have you online redo logs intact you can recover until time of failure, i.e a complte recover and there is not need to resetlogs
-
Yes we can.
we tested it in our Oracle Traing class...I have the report on that too.
By the by you are asking questions for discussion purpose or
you have real senario at work.....
Thanigaivasan.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|