| Accidentally delete a data file [message #495234] |
Thu, 17 February 2011 17:13  |
 |
primecontrol
Messages: 3
Registered: February 2011
Location: Brasil
|
Junior Member |
|
|
I have a database "BD001" for example, inside got 90 schemes, each
one has two tablespaces, see below script I use to create:
CREATE TABLESPACE TS_F_ORA9_027_DAT NOLOGGING DATAFILE
'E: \ DataBases \ ORACLE \ 92 \ DAT \ TS_F_ORA9_027_DAT.ora' SIZE 5M REUSE ON AUTOEXTEND
NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT
AUTO;
CREATE TABLESPACE TS_F_ORA9_027_IND NOLOGGING DATAFILE
'E: \ DataBases \ ORACLE \ 92 \ IND \ TS_F_ORA9_027_IND.ORA' SIZE 5M REUSE ON AUTOEXTEND
NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT
AUTO;
CREATE USER "F_ORA9_027" PROFILE DEFAULT IDENTIFIED BY prime DEFAULT
TABLESPACE QUOTA UNLIMITED ON TS_F_ORA9_027_DAT TS_F_ORA9_027_DAT SHARE
UNLIMITED ON ACCOUNT UNLOCK TS_F_ORA9_027_IND;
At one point I did a drop and delete user "F_ORA9_027," only the
files "TS_F_ORA9_027_DAT" and "TS_F_ORA9_027_IND.ORA" continued in the folder,
so I manually delete these two files and thereafter could not
Starting Oracle with more success when I try to get into the sqlplus
following message:
Enter the name of usußrio: system
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
When I try to force got the following message:
Enter the name of usußrio: sys as sysdba
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> shutdown abort
ORACLE InstÔncia disabled.
SQL> startup
ORACLE InstÔncia started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01157: noo Ú possÝvel identify / lock data file 187 - see
file anßlise DBWR
ORA-01110: data file 187:
'E: \ DATABASES \ ORACLE \ 92 \ DAT \ F_ORA9_027_DAT.ORA'
I have the dmp this scheme "F_ORA9_027" but have no way to restore it once
I can not connect to the service.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
