AnsweredAssumed Answered

Aveksa DBBackup Fails

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

Like • Show 0 Likes0
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

Aug 30, 2016 10:32 AM

Correct Answer

Resolution_1

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

2 Replies

Ece YILDIRIM Aug 30, 2016 10:20 AM
Mark Correct
Correct Answer
Anyone has any comment?
Like • Show 0 Likes0
Actions
Subash Chandra Behera Aug 30, 2016 10:32 AM
Unmark Correct
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
2 people found this helpful
Like • Show 3 Likes3
Actions