RMAN> TRANSPORT TABLESPACE "TEST" tablespace destination '/u01/tts_test/td' auxiliary destination '/u01/tts_test/ad';

RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point in time

List of tablespaces expected to have UNDO segments
tablespace SYSTEM
tablespace UNDOTBS1

Creating automatic instance, with SID='wmoB'

initialization parameters used for automatic instance:
db_name=ORCL
compatible=10.2.0.1.0
db_block_size=8192
db_files=200
db_unique_name=tspitr_ORCL_wmoB
large_pool_size=1M
shared_pool_size=110M
#No auxiliary parameter file used
db_create_file_dest=/u01/tts_test/ad
control_files=/u01/tts_test/ad/cntrl_tspitr_ORCL_wmoB.f

starting up automatic instance ORCL

Oracle instance started

Total System Global Area 201326592 bytes
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of tranport tablespace command at 04/14/2014 18:13:52
RMAN-06136: ORACLE error from auxiliary database: ORA-02122: Message 2122 not found; product=RDBMS; facility=ORA

ORA-16009: remote archive log destination must be a STANDBY database
Mon Apr 14 20:17:34 2014
PING[ARC1]: Heartbeat failed to connect to standby 'orcls_192.168.1.223'. Error is 16009.

****************************************************************************************************************************
RMAN> transport tablespace example
2> tablespace destination '/u01/td'
3> auxiliary destination '/u01/ad';

using target database control file instead of recovery catalog
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point in time

List of tablespaces expected to have UNDO segments
tablespace SYSTEM
tablespace UNDOTBS1

Creating automatic instance, with SID='osxd'

initialization parameters used for automatic instance:
db_name=ORCLLDG
compatible=10.2.0.1.0
db_block_size=8192
db_files=200
db_unique_name=tspitr_ORCLLDG_osxd
large_pool_size=1M
shared_pool_size=110M
#No auxiliary parameter file used
db_create_file_dest=/u01/ad
control_files=/u01/ad/cntrl_tspitr_ORCLLDG_osxd.f

starting up automatic instance ORCLLDG

Oracle instance started

Total System Global Area 201326592 bytes

Fixed Size 1218508 bytes
Variable Size 146802740 bytes
Database Buffers 50331648 bytes
Redo Buffers 2973696 bytes
Automatic instance created

contents of Memory Script:
{
# set the until clause
set until scn 1441931;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log for tspitr to a resent until time
sql 'alter system archive log current';
# avoid unnecessary autobackups for structural changes during TSPITR
sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';
}
executing Memory Script

executing command: SET until clause