473,508 Members | 2,295 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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
startup
now it gives message
ora-01113 file 3 need media recovery
ora-01110 datafile 'user01'

what's the reason of problem.

bye
Jul 19 '05 #1
0 8665

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
26695
by: Galina | last post by:
Hello I have created a trigger not to let records with certain fields null to be inserted into the table: BEGIN IF :new.RUL_CODE is null or :new.FES_UINS_CODE is null or :new.FES_UIO_CALOCC is...
1
5126
by: Adam Ruth | last post by:
I'm using OCI on Mac OS X and I've run into a strange problem with my TNSNAMES.ORA file. My TNSNAMES.ORA file has one entry INV4II and it works fine. However, it will only work if that is the...
6
4672
by: bdj | last post by:
Hello! I have at set of tnsnames.ora. I wich to make an union, e.g. a single file of it. How can I do that easy? Greetings Bjørn
1
10418
by: Brett Baloun | last post by:
Hello, I received this error message when I issue the drop statement. We are using a 9.2.0.3 DB on UNIX OS. I have been able to drop other users within the same session, but this particular...
3
22757
by: Michael John | last post by:
Hey, how can I get ORA-..... error messages in languages other than english. I did a alter session set NLS_LANG='GERMAN_GERMANY.WE8ISO8859P1'; but this only threw an ORA-00922. Or I'm wrong...
2
6285
by: hemantmudaliar | last post by:
The Trigger is giving following exception java.sql.SQLException: ORA-04091: table PSCONTENT.VGNASCHANNEL is mutating, trigger/function may not see it ORA-06512: at...
0
2453
by: ravishankars | last post by:
Hi, I have made the following declarations I created an object as below. create or replace type emp_obj as object( emp_id number(6), email varchar2(25)
2
5122
by: amoldiego | last post by:
Hi I have encountered the error ORA-01536 . I have earlier grant sysdba to SCOTT & then I revoked the sysdba role from SCOTT a couple of days later. After that, I encountered the error...
3
8564
by: darrenttl | last post by:
Hi, I am getting the following error: ORA-00604:error occurred at recursive sql level 1. ORA-06519:active automous transaction detected and rolled back. This error occurred when I was trying...
1
3312
by: dabikerdevil | last post by:
I was getting this error: ORA-12545 I changed the host name to numerical IP address in TnsNames.Ora Now I am getting the following error: ORA-12500. how do I solve these errors. Kindly Reply.
0
7225
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7123
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7326
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
7046
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
1
5053
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3194
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3182
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1557
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
766
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.