Is my database still recoverable ?

From: cpchan <cpchaney_at_netvigator.com>
Date: Sat, 12 Apr 2003 14:42:40 +0800
Message-ID: <b78bq7$i2r10_at_imsp212.netvigator.com>



[Quoted] 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 - 08:42:40 CEST

Original text of this message