ORA-38760: This database instance failed to turn on flashback database

Error

Starting recover at 24-APR-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1072 device type=DISK

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/24/2018 14:54:07
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-38760: This database instance failed to turn on flashback database


Cause

Database was in flashback mode.

Solution

trun off flashback mode and rerun recovery.

SQL> alter database flashback off;

Database altered.

SQL>

RMAN> run
{
set until sequence 576;
recover database;
}2> 3> 4> 5>

executing command: SET until clause

Starting recover at 24-APR-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1072 device type=DISK

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=573
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=574
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=575
channel ORA_DISK_1: reading from backup piece /d02/dbbackup/RMAN_backup1/RMAN_BKPMon_23Apr18/ar_974238549_2165_1
channel ORA_DISK_1: errors found reading piece handle=/d02/dbbackup/RMAN_backup1/RMAN_BKPMon_23Apr18/ar_974238549_2165_1
channel ORA_DISK_1: failover to piece handle=/d01/oracln/backup/RMAN_BKPMon_23Apr18/ar_974238549_2165_1 tag=TAG20180423T211704
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:25
archived log file name=/d01/oracln/data/archive1_573_970862557.dbf thread=1 sequence=573
archived log file name=/d01/oracln/data/archive1_574_970862557.dbf thread=1 sequence=574
archived log file name=/d01/oracln/data/archive1_575_970862557.dbf thread=1 sequence=575
media recovery complete, elapsed time: 00:00:27
Finished recover at 24-APR-18

RMAN>

Recovery Manager complete.

Oracle Database Gateway Installation and configuration to connect SYBASE

Oracle Database Gateway: DB Link between oracle and sybase

Download Oracle Database 12c Database Gateway for Sybase from https://edelivery.oracle.com

 Configuring Oracle Database Gateway for Sybase

Configure Oracle Net for the Gateway.

The Oracle Net Listener listens for incoming requests from the Oracle database. For the Oracle Net Listener to listen for the gateway, information about the gateway must be added to the Oracle Net Listener configuration file.

Start the Oracle Net Listener for the Gateway home

Configure the Oracle Database for Gateway Access

To can access Sybase system, it must have an entry in its tnsnames.ora file to contact the listener we just created/modified, edit tnsnames.ora and add a connect descriptor for the gateway.

To access the Sybase server, you must create a database link. A public database link is the most common of database links.

Query Sybase object

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported

Error

Log file located at /u01/oradr/db_1/appsutil/log/TEST_azuredr/ApplyDBTier_03271707.log
  /      0% completed       RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.
Please make sure you have UnZip 5.X in your path and try again...

ERROR while running Apply...


ERROR: Failed to execute /u01/oradr/db_1/appsutil/clone/bin/adclone.pl

Solution

1. Check unzip version.
2. If 5.X version not exist then.
3. Take backup of existing unzip mv /usr/bin/unzip /usr/bin/unzip_Orig
4. Bring 5.X version from db home cp /u01/oradr/db_1/bin/unzip /usr/bin/unzip
5. Rerun clone and revert back the  /usr/bin/unzip to original one.

RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

Error

/u01/oradr/db_1/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/u01/oradr/db_1/oui -classpath /u01/oradr/db_1/appsutil/clone/jlib/xmlparserv2.jar:/u01/oradr/db_1/appsutil/clone/jlib/ojdbc5.jar:/u01/oradr/db_1/appsutil/clone/jlib/java:/u01/oradr/db_1/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/oradr/db_1/appsutil/clone/jlib/oui/ewt3.jar:/u01/oradr/db_1/appsutil/clone/jlib/oui/share.jar:/u01/oradr/db_1/appsutil/clone/jlib/oui/srvm.jar:/u01/oradr/db_1/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /u01/oradr/db_1/appsutil/TEST_azuredr.xml -stage /u01/oradr/db_1/appsutil/clone   -showProgress
APPS Password : Log file located at /u01/oradr/db_1/appsutil/log/TEST_azuredr/ApplyDBTier_03271654.log
  \      0% completed       RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

ERROR while running Apply...
Tue Mar 27 16:55:27 2018

 ERROR: Failed to execute /u01/oradr/db_1/appsutil/clone/bin/adclone.pl


Cause

log file reveled the information

"Perl lib version (5.10.1) doesn't match executable version (v5.10.0) at /usr/lib64/perl5/Config.pm line 50.
Compilation failed in require at /u01/oradr/db_1/appsutil/clone/ouicli.pl line 35.
BEGIN failed--compilation aborted at /u01/oradr/db_1/appsutil/clone/ouicli.pl line 35."

Solution

set perl to verion 5.10.0 as below and rerun the clone

export PERL5LIB=/u01/oradr/db_1/perl/lib/5.10.0:/u01/oradr/db_1/perl/lib/site_perl/5.10.0:/u01/oradr/db_1/appsutil/perl

export PATH=/u01/oradr/db_1/perl/bin:$PATH

ORA-39203: Partition selection is not supported over a network link.

Error

impdp xxxx/xxxxx directory=DBPUMP network_link=ARCH2CALLS tables=INCALLS:NOV201601 logfile=incalls_imp.log EXCLUDE=INDEX VERSION=11

Import: Release 11.2.0.4.0 - Production on Tue Apr 10 12:58:39 2018

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39001: invalid argument value

ORA-39203: Partition selection is not supported over a network link.

Cause

Although i'm in 11.2.X parameter VERSION=11 referred as 11.1.X and as of limitation on 11.1.X only whole tables can be exported over NETWORK_LINK parameter not partitions of tables.

Solution

The enhancement request has been implemented in the 11.2 release rerun impdp by removing VERSION parameter.