Database Backup and Recovery (MOSC)

MOSC Banner

11gR2 TSPIT with User defined datatypes.

edited Sep 27, 2010 5:21PM in Database Backup and Recovery (MOSC) 2 commentsAnswered ✓
Do let us know if there are any restrictions on TSPITR when Users defined datatypes is used. TSPIT recovery Impdp failed with error ORA-31684:

    EXPDP> ******************************************************************************
   EXPDP> Dump file set for SYS.TSPITR_EXP_pbds is:
   EXPDP>   /oradata/app/oracle/product/11.2.0.1/orasw/aux_dest/tspitr_pbds_73812.dmp
   EXPDP> ******************************************************************************
   EXPDP> Datafiles required for transportable tablespace SYN:
   EXPDP>   /oradata/app/oracle/product/11.2.0.1/orasw/database/orasw/datafile/o1_mf_syn_6b0xc
k65_.dbf
   EXPDP> Job "SYS"."TSPITR_EXP_pbds" successfully completed at 10:56:58
Export completed


contents of Memory Script:
{
# shutdown clone before import
shutdown clone immediate
# drop target tablespaces before importing them back
sql 'drop tablespace  SYN including contents keep datafiles';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center