ORA-31634: job already exists

Error: ORA-31634: job already exists ORA-31664: unable to construct unique job name when defaulted

Details: Error occurs when running a full data pump export

Cause:The table dba_datapump_jobs contains 99 orphaned jobs: The SQL below returns 99 rows:

select owner_name, job_name, state from dba_datapump_jobs order by job_name;

Solution:Remove the jobs that are not ruuning and purge them from recycle bin:

DROP TABLE OWNER_NAME.JOB_NAME;


PURGE DBA_RECYCLEBIN;


or


DROP TABLE OWNER_NAME.JOB_NAME PURGE;

ORA-19705: tag value exceeds maximum length of 31 characters

Error: ORA-19705: tag value exceeds maximum length of 31 characters

Details: This error occurs when running a backup

Cause:The database either crashed or was shutdown with the ABORT option. Media recovery cannot be enabled because the online logs may not be sufficient to recover the current datafiles.

Solution:Supply a shorter tag in the backup script and retry the operation.

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Error: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Details: This error occurs when switch databas eto ARCHIVELOG mode by executing:
ALTER DATABASE ARCHIVELOG;

Cause:The database either crashed or was shutdown with the ABORT option. Media recovery cannot be enabled because the online logs may not be sufficient to recover the current datafiles.

Solution:Open the database and then enter the SHUTDOWN command with the NORMAL or IMMEDIATE option:

>ALTER DATABASE OPEN;

>SHUTDOWN IMMEDIATE;