AnsweredAssumed Answered

Aveksa DBBackup Fails

Question asked by Ece YILDIRIM on Aug 29, 2016
Latest reply on Aug 30, 2016 by Subash Chandra Behera
  • Comment • 2

oracle@test4:~> avdbexport -t beforePatch04_1

 

Executing above command results in below error. We cannot get db backup. Any idea how fix this problem?

 

Export: Release 12.1.0.2.0 - Production on Mon Aug 29 20:36:29 2016

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "AVUSER.AVDB_EXPORT_AVUSER"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1048
ORA-00955: name is already used by an existing object


=========================================================================
Data Pump EXPORT Completed at:
Mon Aug 29 20:36:29 EEST 2016
Flashback_Time=systimestamp
Directory=Aveksa_ExportImport_Directory
DumpFile=Export_AVDB_avuserbeforePatch04_1.dmp
Schemas=avuser
LogFile=Export_AVDB_avuser.log
Job_Name=AVDB_Export_AVUSER.job


Mon Aug 29 20:36:29 EEST 2016
Error exporting!

Subash Chandra Behera
Subash Chandra Behera Employee Aug 30, 2016 10:32 AM
Correct Answer

Resolution_1

  • Login to sqlplus using avuser/password and run the following:
rename AVDB_EXPORT_AVUSER to AVDB_EXPORT_AVUSER_20071212;
  • AVDB_EXPORT_AVUSER is the name of the temporary table it created
  • This SQL basically makes a backup of it.
  • Run the export again

Work-around
If the above does not work, you can also do the following:

  • Edit /home/oracle/database/DBA/AVDB/export/Export_AVDB_avuser.sh
  • Comment out using "#"the line 122 (so that it looks like below):
    • #echo Job_Name=~UWC_TOKEN_START~1283961840263~UWC_TOKEN_END{EXP_JOB_NAME} >> ~UWC_TOKEN_START~1283961840264~UWC_TOKEN_END{EXP_PAR_FILE}
  • Run the export again
See the reply in context
No one else had this question

Outcomes