ERROR: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist ORA-02002: error while writing to audit trail ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist

SQL> CONN ashwani/ashwani

ERROR:

ORA-00604: error occurred at recursive SQL level 1

ORA-00942: table or view does not exist

ORA-02002: error while writing to audit trail

ORA-00604: error occurred at recursive SQL level 1

ORA-00942: table or view does not exist

This issue occur after final incremental recovery. After digging more i came to know there is a difference in the settings of audit trail.

At source DB:

SQL>  show parameter audit_trail

NAME                                 TYPE        VALUE

------------------------------------ ----------- ----------------

audit_trail                          string      NONE

At target DB:

SQL> show parameter audit_trail

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------

audit_trail                          string      DB

Now I have changed the setting same as in source database.

Logging to target database. start the database using spfile.

SQL> CREATE SPFILE FROM PFILE;

File created.

SQL> SHUTDOWN IMMEDIATE;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

SQL> STARTUP

ORACLE instance started.

Total System Global Area 5060792320 bytes

Fixed Size                  2289960 bytes

Variable Size            1006636760 bytes

Database Buffers         4043309056 bytes

Redo Buffers                8556544 bytes

Database mounted.

Database opened.

SQL> alter system set audit_trail='NONE' SCOPE=SPFILE;

System altered.

SQL> SHUT IMMEDIATE;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> STARTUP;

ORACLE instance started.

Total System Global Area 5060792320 bytes

Fixed Size                  2289960 bytes

Variable Size            1006636760 bytes

Database Buffers         4043309056 bytes

Redo Buffers                8556544 bytes

Database mounted.

Database opened.

SQL>

SQL> CONN ashwani/ashwani

Connected.