OraFAQ Forum: Backup & Recovery » backup utility problems

Home » RDBMS Server » Backup & Recovery » backup utility problems

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

backup utility problems [message #588187]

Sun, 23 June 2013 02:18

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

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 1950 times)

Report message to a moderator

Re: backup utility problems [message #588188 is a reply to message #588187]

Sun, 23 June 2013 02:27

John Watson
Messages: 8960
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.

Report message to a moderator

Re: backup utility problems [message #588189 is a reply to message #588188]

Sun, 23 June 2013 02:39

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

Report message to a moderator

Re: backup utility problems [message #588190 is a reply to message #588189]

Sun, 23 June 2013 02:46

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

hamdan.aljaafreh@gmail.co
Messages: 15
Registered: July 2011
Location: jordan

Junior Member

okay ; do you have some rman script

Report message to a moderator

Re: backup utility problems [message #588192 is a reply to message #588191]

Sun, 23 June 2013 02:49

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

Report message to a moderator

Re: backup utility problems [message #588193 is a reply to message #588192]

Sun, 23 June 2013 02:57

hamdan.aljaafreh@gmail.co
Messages: 15
Registered: July 2011
Location: jordan

Junior Member

?????????

Report message to a moderator

Re: backup utility problems [message #588197 is a reply to message #588193]

Sun, 23 June 2013 03:38

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Quote:

?????????

What is this meant to mean?

Report message to a moderator

Re: backup utility problems [message #588198 is a reply to message #588197]

Sun, 23 June 2013 03:42

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

Report message to a moderator

Re: backup utility problems [message #588199 is a reply to message #588198]

Sun, 23 June 2013 03:52

John Watson
Messages: 8960
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.

Report message to a moderator

Re: backup utility problems [message #588204 is a reply to message #588191]

Sun, 23 June 2013 10:10

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: backup utility problems [message #588226 is a reply to message #588204]

Mon, 24 June 2013 01:00

hamdan.aljaafreh@gmail.co
Messages: 15
Registered: July 2011
Location: jordan

Junior Member

Michel Cadot and John Watson

thank you so mutch

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 06:42:35 CST 2024