Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Possible Duplicate:
How to take oracle 10g backup?

I followed this http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php link to create a db backup. I used this command to create db backup:

expdp scott/tiger@db10g full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=expdpDB10G.log 

but I have this error message:

UDE-00008: operation generated ORACLE error 1033          

ORA-01033: ORACLE initialization or shutdown in progress

please help me to resolve this issue.

share|improve this question
1  
An export is a logical backup and should normally only be used to supplement physical backups. See docs.oracle.com/cd/E11882_01/server.112/e25789/… –  Leigh Riffel Jul 12 '12 at 15:16
add comment

marked as duplicate by JNK Jul 12 '12 at 19:19

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer

Try shutting down the database and then issuing the startup command. Then try your script.

If you get the same error verify basic connectivity by connecting from sqlplus with the same name and password.

Check your log file location and the any operating system error logs as well.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.