ORA-01219: database not open: queries allowed on fixed tables/views only
823860Feb 5 2011 — edited Feb 5 2011Dear All
I am working in Oracle database 10G using O.S (window xp). and i have 2 database and both were working fine, but i took physical backup of my server machine
do the fellowing sreps.
1- shutdown immediate
2-take the followinf file
---------------------------------
1- C:\Oracle\product\10.2.0\oradata\abc (complete folder)
2- C:\Oracle\product\10.2.0\admin\abc\pfile (take onle pfile)
3- i- F:\ORADATA\a1.dbf ( 6 table Spaces)
ii- F:\ORADATA\a2.dbf
iii- F:\ORADATA\a3.dbf
iv- F:\ORADATA\a4.dbf
v- F:\ORADATA\a5.dbf
vi- F:\ORADATA\a6.dbf
3- startup mount
4- alter database open
5- i got message my database alter successfully
but after some time, when i connect my abc database sys/****@abc as sysdba via toad then i got message
ORA-01219: database not open: queries allowed on fixed tables/views only
and if i connect another user under abc database then i got below message
ERROR: ORA-01033: ORACLE initialization or shutdown in progress
i had search solution on OTN and find some queries:
Firstly i check my database state:
1- select open_mode from v$database;
OPEN_MODE
----------
MOUNTED
then i put other queries
2- recover database until cancel;
Media recovery complete.
3- alter database open resetlogs;
database open successfully.
and i got login with other user and even can work in sys user normally.
but when i system shutdown and again restart then my abc database open in Mount state.
My default database working still fine.
any help, will be appreciated.
Thanks in advance...