Home » RDBMS Server » Backup & Recovery » backup utility problems
backup utility problems [message #588187] Sun, 23 June 2013 02:18 Go to next message
hamdan.aljaafreh@gmail.co
Messages: 15
Registered: July 2011
Location: jordan
Junior Member
Hell every body ,

My issue is , i think , a Bug in DB 11.2.0.1 ; about taken a backup of my DB via two utilities ( expdb , exp ) ?

i didn't have backup yet for my database since installation Sad Embarassed

My Platform : Redhat Linux 5 - 32bit
DB : Oracle Database 11.2.0.1 g

the problem :

when i type this command :

exp system/******@myoracle file=/backup/full_dmp.dmp log=/backup/full_dmp.log full=y

this command hang in this statment " . exporting system procedural objects and actions"
then when i press CTL+c this error is reported
" EXP-0008 : ORACLE error 1013 encountered
ORA-01013 : user requested cancel of current operation
ORA-06512 : at " SYS.DBMS_SERVER_ALERT_EXPORT" line 10
......... "

OR

when i tried this

expdp system/******@myoracle directory=backup_dir dumpfile=full_dmp.dmp logfile=full_dmp.log full=y


it is also hang at this line " Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ"




please , any help , it' s urgent i didnt have backup since 3 months
  • Attachment: Untitled2.jpg
    (Size: 135.25KB, Downloaded 57 times)
Re: backup utility problems [message #588188 is a reply to message #588187] Sun, 23 June 2013 02:27 Go to previous messageGo to next message
John Watson
Messages: 4669
Registered: January 2010
Location: Global Village
Senior Member
First, an export is not a backup. I blogged about this age ago,
http://orafaq.com/node/2392
you need to investigate backups either with RMAN or user managed facilities.

Secondly, why do you think it is hanging? Perhaps it merely busy exporting lots of procedural objects.

Re: backup utility problems [message #588189 is a reply to message #588188] Sun, 23 June 2013 02:39 Go to previous messageGo to next message
hamdan.aljaafreh@gmail.co
Messages: 15
Registered: July 2011
Location: jordan
Junior Member
"Secondly, why do you think it is hanging? Perhaps it merely busy exporting lots of procedural objects."
No sir , I have 8 pkg 10 functions ,4 procedures 100 tables that is all

"user managed facilities." can you explain this
Re: backup utility problems [message #588190 is a reply to message #588189] Sun, 23 June 2013 02:46 Go to previous messageGo to next message
Michel Cadot
Messages: 59399
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you think it is a bug then raise a SR to Oracle.
We have nothing to diagnose with what you posted.

In the end, why do you use exp to export an 11g database?

Quote:
i didn't have backup yet for my database since installation


And you won't have after an export.
Use RMAN to backup.

Regards
Michel

[Updated on: Sun, 23 June 2013 02:46]

Report message to a moderator

Re: backup utility problems [message #588191 is a reply to message #588190] Sun, 23 June 2013 02:48 Go to previous messageGo to next message
hamdan.aljaafreh@gmail.co
Messages: 15
Registered: July 2011
Location: jordan
Junior Member
okay ; do you have some rman script
Re: backup utility problems [message #588192 is a reply to message #588191] Sun, 23 June 2013 02:49 Go to previous messageGo to next message
hamdan.aljaafreh@gmail.co
Messages: 15
Registered: July 2011
Location: jordan
Junior Member
and , suppose I want to restore table from RMAN backup is it possible
Re: backup utility problems [message #588193 is a reply to message #588192] Sun, 23 June 2013 02:57 Go to previous messageGo to next message
hamdan.aljaafreh@gmail.co
Messages: 15
Registered: July 2011
Location: jordan
Junior Member
?????????
Re: backup utility problems [message #588197 is a reply to message #588193] Sun, 23 June 2013 03:38 Go to previous messageGo to next message
John Watson
Messages: 4669
Registered: January 2010
Location: Global Village
Senior Member
Quote:
?????????
What is this meant to mean?
Re: backup utility problems [message #588198 is a reply to message #588197] Sun, 23 June 2013 03:42 Go to previous messageGo to next message
hamdan.aljaafreh@gmail.co
Messages: 15
Registered: July 2011
Location: jordan
Junior Member
suppose I want to restore table from RMAN backup is it possible
Re: backup utility problems [message #588199 is a reply to message #588198] Sun, 23 June 2013 03:52 Go to previous messageGo to next message
John Watson
Messages: 4669
Registered: January 2010
Location: Global Village
Senior Member
Quote:
suppose I want to restore table from RMAN backup is it possible

You need to ask a different question: how will you restore and recover with zero data loss?
Quote:
I have 8 pkg 10 functions ,4 procedures 100 tables that is all

You have forgotten that there are many more objects in a database than those you have created.

You have already been given suggestions for the tool you should use for backup. But, as you have not said "thank you", presumably my help is not appreciated Sad
Best of luck to your clients with this problem.
Re: backup utility problems [message #588204 is a reply to message #588191] Sun, 23 June 2013 10:10 Go to previous messageGo to next message
Michel Cadot
Messages: 59399
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
hamdan.aljaafreh@gmail.co wrote on Sun, 23 June 2013 09:48
okay ; do you have some rman script


rman target / <<EOF
backup database;
exit;
EOF

Regards
Michel
Re: backup utility problems [message #588226 is a reply to message #588204] Mon, 24 June 2013 01:00 Go to previous message
hamdan.aljaafreh@gmail.co
Messages: 15
Registered: July 2011
Location: jordan
Junior Member

Michel Cadot and John Watson

thank you so mutch
Previous Topic: Droping tablespace including contents and datafiles, will delete Rman contents also?
Next Topic: ora-01578: Oracle data block corruption (file#1, block#134144)
Goto Forum:
  


Current Time: Mon Oct 20 00:15:19 CDT 2014

Total time taken to generate the page: 0.03982 seconds