Re: Is my database recoverable ?

A document I wrote a while ago is still apparently available at www.geocities.com/lydian_third

Books link, Backup and Recovery.

The fact that any file needs recovery is, I suppose, a "serious" problem, but problems are only problems if you have no solution: and Oracle's solution to files needing recovery is redo. So, provided you have an extensive array of archive redo logs, recovery is relatively straightforward. It's all a question of protecting redo: if you archive, and if you look after your archives, then there is extremely rarely any situation you can't recover completely from.

Regards
HJR "cpchan" <cpchaney_at_netvigator.com> wrote in message news:b78bpg$i2m38_at_imsp212.netvigator.com...
> I did a backup and restore process on an Oracle 8i RDBMS (only the user
data
> directory, not included the program directory) running on SUN Solaris 9
> machine with the following 2 commands :
>
> tar -cvf /dev/rmt/0 <the directory of user data record>
>
> tar -xvf /dev/rmt/0 <the same directory>
>
> But since this was my first time to do Oracle backup and restore with tar
> command, I had not shutdown the database during the process, that means
> throughout the whole processes, the database was open.
>
> After that, I started it with 'startup open' command, it said : media
> recovery is required, and said 'system01.dbf needs recovered'.
>
> Someones told me this was a very serious problem and was impossible to fix
> it with just one or two commands.
> Is this true ?
> Can you tell me what things should I do now ?
> Or, are there any documents on the internet or metalink talking about this
> problem and teach us how to fix it though the process may be quite
> complicated.
> Thanks.
>
> By the way, we also use Oracle 11i Application, Oracle Finance.
>
>
>
Received on Sat Apr 12 2003 - 03:45:32 CDT