Database Backup and Recovery (MOSC)

MOSC Banner

ORA-01110: data file system01.dbf

edited Jun 7, 2010 2:20AM in Database Backup and Recovery (MOSC) 4 commentsAnswered
Hi

Mi database is:

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
ORACLE_HOME = /export/home/users/oracle/app/oracle/product/8.1.7
System name: SunOS
Node name: per-ell2
Release: 5.7
Version: Generic_106541-23
Machine: sun4u

1. The datafile   '/database2/lms_data/lmsbdell.dmp'  was eliminated in hot because i hhough was a backup file..but the file is datafile

2. I elimated the file in logic way and then i recreated the controlfile

3. I executed  ALTER DATABASE RECOVER and the result was:

            Media Recovery Log /export/home/users/oracle/app/oracle/product/8.1.7/dbs/arch1_899590.dbf

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