Re: Is my database recoverable ?

On Sat, 12 Apr 2003 14:42:17 +0800, cpchan wrote:

> 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.

Do you run your database in archivelog mode? Do you have some offline redo logs. ?
Any older backup ?

It is a seriuos problem, if you do not have any other backups your data might be lost.
Do not do anything. Open a case at oracle (you are under support aren't you?)
Get profesional help, _now_.

Juergen Received on Sat Apr 12 2003 - 03:25:08 CDT