Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export command error

985942Jan 20 2013 — edited Feb 3 2013
hi
everyone

I am very new to this field,since 20 days i am having one problem in my databases,i have 2 database in my windows server environment ,recently i have upgrade my both the database from 10g to 11g.Why i upgrade means in 10g i am getting error ora-07445 access violation,in my alertlog file (when iam going to take full database backup through export getting this error in log file too and export stops in middle with error) so i thought to apply the patch,but with discussion with my manager and team, we all thought this is the time to upgrade so we changed to 11g
then 11g upgrade is 100% successfully completed, to verify the export on 11g ,i thought to take logical backup of my 2 database's
C:\Users\Administrator>exp system/password@tnsname file=full_05_1_2013.dmp log=05_1_2013.log full=y

Export: Release 11.2.0.1.0 - Production on Sat Jan 19 09:18:06 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
server uses AR8MSWIN1256 character set (possible charset conversion)

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
. exporting system procedural objects and actions,
.
.
.
what happening here is it just coming to this point and stopping here for hours............more than 10 hours (I have to kiill this session manually).I tried with single user its working but when i take full backup of database export , then it not working,,, i have cross check every possibilities by giving full privileges,space check,and many other but no solution, i was unable to take full backup ,(but i can take single user backup)
i have even applied bundle patch (Oracle® Database Server Version 11.2.0.1 Patch 16) 100% successfully
Bundle Patch Update Note
Release 11.2.0.1 for Microsoft Windows (x64)
Released: November, 2011
NOTE:___one more twist here is , when i bounce the database then i can take full database backup with out error and warnings for 6 to 7 times then again at 8th time its again stopping at above point.......................................................(when i need full logical backup again i need to bounce the db)
what for its stopping here, why it is not going forward,,, its issue with both the database's same,
NOTE:ERROR IN MY ALERTLOG FILE AND TRACEFILE IS
trace file d:\app\admin\diag\rdbms\memfa\memfa\trace\memfa_j000_7844.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.0 Service Pack 2
CPU : 16 - type 8664, 16 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:1148M/16379M, Ph+PgF:17118M/32914M
Instance name: memfa
Redo thread mounted by this instance: 1
Oracle process number: 22
Windows thread id: 7844, image: ORACLE.EXE (J000)

*** 2013-01-17 12:00:00.124
*** SESSION ID:(196.16104) 2013-01-17 12:00:00.124
*** CLIENT ID:() 2013-01-17 12:00:00.124
*** SERVICE NAME:(SYS$USERS) 2013-01-17 12:00:00.124
*** MODULE NAME:(DBMS_SCHEDULER) 2013-01-17 12:00:00.124
*** ACTION NAME:(PURGE_LOG) 2013-01-17 12:00:00.124

purge queue_table SYS.SCHEDULER_FILEWATCHER_QT
purge queue_table SYS.SCHEDULER$_EVENT_QTAB

alertlogfile___________________________
Thread 1 cannot allocate new log, sequence 123
Private strand flush not complete
Current log# 4 seq# 122 mem# 0: D:\APP\ADMIN\ORADATA\memfa\REDO04.LOG
Thread 1 advanced to log sequence 123 (LGWR switch)
Current log# 5 seq# 123 mem# 0: D:\APP\ADMIN\ORADATA\memfa\REDO05.LOG

already i have change my redo log to 50 to 500 each(3) and increase retention time too
i have tried for more than 50 time by running full database export command ,but its not working ,sometimes 24 hours till at that point only(if i bounce the both the database's then,full database export completes in 9 min(successfully without error and without warnings
)
these are very new databases size nearly 8gb each
please assist/help me in solving this issue,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2013
Added on Jan 20 2013
6 comments
1,983 views