Database Backup and Recovery (MOSC)

MOSC Banner

datafiles on nfs mount

edited May 18, 2011 1:45AM in Database Backup and Recovery (MOSC) 6 commentsAnswered
 I am trying to create a database with several of its datafiles on an nfs mount.  This was created from a hot backup of an exising database. 

When I try to recover the database, I get an error:

ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: '/adamprd/oracle/data2/dtest/system01.dbf'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/adamprd/oracle/data2/dtest/system01.dbf'

The trace file shows that the following error happens on all the nfs mounted files.

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center