A reader, July 16, 2001 - 2:03 pm UTC
cleared my confusion
Alter Database Recover Vs Recover Database - Reg
A reader, July 16, 2001 - 9:52 pm UTC
It was very useful for me and recently i faced the same problem. Thanks TOM.
Yanis Siminelakis, November 17, 2003 - 7:44 am UTC
Totally confused
Anil Pant, December 11, 2003 - 12:07 am UTC
hi,
Your response has confused me. Can u explain it ?
December 11, 2003 - 5:43 am UTC
it is relatively straightforward
a) use ALTER DATABASE if you want to do the recoverying step by step, manually -- issueing each and every single solitary command to recover the database (apply logfiles).
b) use the SQLPLUS 'recover' command to have sqlplus automate the steps in a) for you.
Scripting
A reader, June 03, 2004 - 2:13 pm UTC
So, if I am scripting the recovery, I have no choice but to use the ALTER DATABASE RECOVER, right?
June 03, 2004 - 2:49 pm UTC
depends on what you use to "script" the recovery.
you can use sqlplus commands (recover), rman commands, or straight sql (alter)
Shivdeep Modi, June 04, 2004 - 6:31 am UTC
Cleared the doubt between the two commands
recover command that worked ...
A reader, August 24, 2004 - 9:42 am UTC
ALTER DATABASE RECOVER automatic database until time '2004-08-10-01:00:00' using backup controlfile;
this worked for me. Only different thing I had to do was put 'automatic' there.
thanks
Using "Alter Database Recover Vs Recover Database - Reg.", version 8.1.7.0.0
Alex, August 01, 2012 - 8:56 pm UTC
Hi Tom,
we had a crash on our Server Oracle (8.1.7 on W2K o.s.) during the night (no electricity for a while and the ups switch off after time). We do not have archivelog mode on and our backup is crashed too. Is it possible to use the "alter database recover vs recover data" functionality in this example? or it works only under archivelog mode? one more tip: Oracle istance can be started, mount but can't open database.
I'm sorry for my question, but I'm trainer. If it is not correct to post here my question, pls can you tell me where to post it.
Thanks in advanced and regards,
Alex
August 02, 2012 - 9:05 am UTC
if you are in noarchivelog mode, there is no recovery from media failure at all - none.
what error do you get when you try to open the database?
Using "Alter Database Recover Vs Recover Database - Reg.", version 8.1.7.0.0
Alex, August 03, 2012 - 2:04 am UTC
Hi,
When I try to open database I have ORA-01113 "necessary to repair support 2" and ORA-01110 "file of data 2: path\RBS01.DBF". Then I start the "recover datafile 2", but it asking/searching for a file "ARC56199.001" that there isn't anywhere in the support.
If you need the log, pls tell me.
Thnks a lot,
Alex
Dragutin Jastrebic, August 11, 2012 - 6:10 am UTC
Since Tom seems to be to busy these days, I will
try to help you, if you are still on the problem (and I hope
Tom don't mind)
You probably won't be able to recover (because you're
in noarchivelog) , but let's
try to put some light on what's happening with your
database.
Can you execute the commands below and post the result:
alter session set nls_date_format='dd/mm/yyyy hh24:mi:ss';
select * from v$log;
select file#,checkpoint_time,to_char(checkpoint_change#) from v$datafile_header;
select to_char(checkpoint_change#) from v$database;
Dragutin
Dragutin Jastrebic, August 11, 2012 - 6:27 am UTC
I wanted to type "too busy" and "Tom does not mind"
Using "Alter Database Recover Vs Recover Database - Reg.", version 8.1.7.0.0
Alex, October 07, 2012 - 11:39 am UTC
First of all, I would like to excuse myself to Mr. Dragutin for the delay of my answer: I'M VERY SORRY!
At the end we solved the problem: we contacted an Oracle consultant and after 5 hours of hard work, he resumed the database and saved all the data.
Thank you very much for your support. Your forum always give us good tips!
A big "ciao",
Alex