471,092 Members | 1,432 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

ora-01033.oracle initialized or shutdown in progress

i face problem in oracle backup.
i take oracle logical backup after 3-4 days.
but now the database is run 24*7 days

so i set the oracle on archive mode

at last night i take the hot backup by

alter tablespace user begin backup;
hot ocopy E:\ORACLE\ORADATA\SAFEDB\USERS01.DBF d:\ora_data;
alter tablespace user end backup;

similar on other tablespaces

after it i take control file backup
alter database backup controlfile to trace;

and alse on archive log file
host ocopy c:\oracle\ora81\arc01223.001 d:\ora_data

every thing if fine.
due to some reason i shutdown the system(database)

at next morning when i start the database
it gives error
ora-01033.oracle initialized or shutdown in progress
after connect / as sysdba

shutdown immediate
now it gives message
ora-01113 file 3 need media recovery
ora-01110 datafile 'user01'

what's the reason of problem.

Jul 19 '05 #1
0 8499

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Adam Ruth | last post: by
6 posts views Thread by bdj | last post: by
3 posts views Thread by Michael John | last post: by
1 post views Thread by dabikerdevil | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.