Cause: Command RESYNC CATALOG FROM DB_UNIQUE_NAME was executed and the database ID of the remote database was different than the connected target database. Action: The remote database should have…
Read MoreCause: The specified datafile name is not the name of a datafile that is currently part of the target database, or an UNTIL clause has been specified and the file…
Read MoreCause: the user specified known DB_UNIQUE_NAME value when renaming a DB_UNIQUE_NAME in the recovery catalog. Action: change the database DB_UNIQUE_NAME to an known DB_UNIQUE_NAME value; or unregister the new DB_UNIQUE_NAME…
Read MoreCause: A RESTORE or RECOVER of a datafile was requested, but recovery of the datafile would require applying redo logs that were generated before the most recent OPEN RESETLOGS. Action:…
Read MoreCause: During the restore process, one or more backup files were unavailable locally for the restore operation. Action: This message should be accompanied with the list of remote backup files.…
Read MoreCause: Two or more databases in the source recovery catalog database match this name. Action: Use DBID option in IMPORT CATALOG command to specify the source database.
Read MoreCause: Source database was already registered in the recovery catalog. Action: If the source database is really registered, there is no need to register it again. Note that the recovery…
Read MoreProblem: While doing import got te below error. ORA-39358: Export dump file version 12.1.0.2.0 not compatible with target version 11.2.0.4.0 . Solution: 1. Check the compatible parameter of both source…
Read MoreProblem: While applying latest PSU patch on oracle 12c RAC database, execution of opatchauto apply command got below error. $ORACLE_HOME/OPatch/opatchauto apply /patch/Jan2018/26635880 -oh /oracle/app/oracle/product/12.2.0.1/grid OPatchauto session is initiated at Wed…
Read MoreFind audit information about dropped users “DROP USER” is audited by default from Oracle 12c onwards. Use the below query to take information if you have not turned off standard…
Read More