Re: ORA-01157 in Oracle 8.1.7.0.1 in Suse Linux 7.3

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 07 Oct 2002 19:15:58 +0200
Message-ID: <l6g3qugvl8i1slso7fmk46ppaa5cb7pa3s@4ax.com>

On 7 Oct 2002 00:57:04 -0700, alex.paris_at_tin.it (Alex Paris) wrote:

>After some hours Oracle crash. No command can be made and if I try to
>restart
>these errors occur:
>ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
>ORA-01110: data file 3:'/usr.../rbs01.dbf'
>
>Any Idea?

Do as instructed in the message and check the trace file of DBWR in the directory pointed to by the background_dump_dest parameter. You'll probably find you lost the file mentioned and you need to restore a backup and recover the database. Just looking up the error messages in the Oracle Server Messages manual would have told you about the same. Please try to do this before posting.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Oct 07 2002 - 12:15:58 CDT