ORACLE error 29308 encountered

Got this error while doing TSPITR:


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported

About to export Tablespace Point-in-time Recovery objects...
EXP-00008: ORACLE error 29308 encountered
ORA-29308: view TS_PITR_CHECK failure
ORA-06512: at "SYS.DBMS_PITR", line 889
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
host command complete

Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/14/2013 14:08:50
RMAN-03015: error occurred in stored script Memory Script
RMAN-06135: error executing host command: Additional information: 256
Additional information: 11

RMAN>

Basically what it is telling is there are some objects in the tablespace that are dependent on some other tablespace which is not in the TSPITR list.

Running the following query shows me that there are some indexes those belong in SYSTEM.

TSPITR Check Query:

SELECT * 

FROM SYS.TS_PITR_CHECK 

WHERE (

        TS1_NAME IN ('DATA_8K') 

        AND TS2_NAME NOT IN ('DATA_8K')

      )

OR    (

        TS1_NAME NOT IN ('DATA_8K') 

        AND TS2_NAME IN ('DATA_8K')

      ); 

But that is not true because if I run dbms_tts.transport_set_check it wont show any violations:

begin
 sys.dbms_tts.transport_set_check('DATA_8K',TRUE,TRUE);
end;

select * from sys.transport_set_violations; -- returns no rows means DATA_8K tablespace objects are all self contained...

So, what is the issue with RMAN TSPITR!!!!

Its a bug identified and the issue is fixed in 11g. RMAN TSPITR has issues when IOT (Index Organized Tables) are present in the tablespace.

Bug#6620517: DO TSPITR SUPPORT IOT IN 10.2 Database.

Bug Attributes

---

Type	B - Defect	Fixed in Product Version	11.2
Severity	2 - Severe Loss of Service	Product Version	10.2.0.3.0
Status	80 - Development to QA/Fix Delivered Internal	Platform	268 - z*OBSOLETE: Microsoft Windows Server 2003 R2 (64-bit AMD64 and Intel EM64T)
Created	Nov 9, 2007	Platform Version
Updated	Sep 15, 2011	Base Bug	N/A
Database Version	10.2.0.3.0	Affects Platforms	Generic
Product Source	Oracle

Related Products

---

Line	Oracle Database Products	Family	Oracle Database
Area	Oracle Database	Product	5 - Oracle Database - Enterprise Edition

TNS-04404: no error caused by: oracle.net.config.ConfigException: TNS-04414: File error

Got this error while trying to create a database using DBCA.

TNS-04404: no error caused by: oracle.net.config.ConfigException: TNS-04414: File error caused by: TNS-04612

Nothing to worry or panic. Just check your tnsnames.ora file for entries and am pretty sure it will have some syntax errors like missing closed parenthesis etc., 

ORA-19550: cannot use backup/restore functions while using dispatcher

Your RMAN connection is going thru SHARED SERVER Mode.
Make a TNS entry with DEDICATED Mode ( (server=dedicated) ) and try again.


19550, 00000, "cannot use backup/restore functions while using dispatcher"
// *Cause:  Attempted to use backup/restore functions while connected to the
//          dispatcher in a shared server.
//          This is not allowed because the device that is
//          used for backup and restore must remain allocated to a single
//          process.
// *Action: Connect directly to the instance then re-execute the backup or
//          restore function.