Home » RDBMS Server » Backup & Recovery » Exp hangs. unable to take backup. Need help
Exp hangs. unable to take backup. Need help [message #218776] Sat, 10 February 2007 02:08 Go to next message
rajdev_mag
Messages: 1
Registered: February 2007
Location: Bangalore
Junior Member
Hi,

I am facing a problem while taking backup. Plz see belove

C:\>exp system/manager@rct file=c:\rct.dmp log=c:\log.log full=yes

Export: Release 9.2.0.1.0 - Production on Sat Feb 10 13:11:41 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions



after this it just hangs unable to take the backup. But users have connected and working. There is no problem in working for then.

Need a solution soon. Plz help me

Regards
Raj
Re: Exp hangs. unable to take backup. Need help [message #218778 is a reply to message #218776] Sat, 10 February 2007 02:49 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
after this it just hangs unable to take the backup.

If your using exp or imp tools for BACKUP JUST STOP. it is not BACKUP option you must use RMAN OR USER MANAGED BACKUP.
if is just data transfer tool.

But users have connected and working. There is no problem in working for then.
There is no connection between connected user or exp tools you should check ALERT<SID>.log FILE for more information.

regards
Taj
Previous Topic: need for hot backup script.and schedule
Next Topic: 1 table Import from Full User Backup
Goto Forum:
  


Current Time: Sun Dec 04 10:25:57 CST 2016

Total time taken to generate the page: 0.07582 seconds