IMPORT issue :Operation generated ORACLE error 1033
792396Oct 14 2010 — edited Oct 15 2010Hi ,
I have the exported the database .
expdp expo/expo directory=dir_dump dumpfile=expfull.dmp Full=Y logfile=expfull.log
My one sysux datafile has been corrupted and I have started the database :
SQL> startup
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 318768020 bytes
Database Buffers 209715200 bytes
Redo Buffers 5844992 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'C:\APP\SAROJSIKRI\ORADATA\ORCL\SYSAUX01.DBF'
==========================================================
When I have imported the database C:\Users\sarojsikri>impdp expo/expo directory=dir_dump dumpfile=expfull1.dmp ful
l=Y logfile=expfull.log
Import: Release 11.1.0.6.0 - Production on Friday, 15 October, 2010 7:48:30
Copyright (c) 2003, 2007, Oracle. All rights reserved.
UDI-01033: operation generated ORACLE error 1033
ORA-01033: ORACLE initialization or shutdown in progress
UDI-00003: all allowable logon attempts failed
============================================================
Plese asssit me how can we recover the datafile and database .
Thanks