How to take oracle 10g backup? [duplicate]

Posted on

Question :

Possible Duplicate:
How to take oracle 10g backup?

I followed this 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.

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.

Leave a Reply

Your email address will not be published. Required fields are marked *