CLLDG_osxd.f deleted
auxiliary instance file /u01/ad/TSPITR_ORCLLDG_OSXD/datafile/o1_mf_system_9nscb9cf_.dbf deleted
auxiliary instance file /u01/ad/TSPITR_ORCLLDG_OSXD/datafile/o1_mf_undotbs1_9nscb9kv_.dbf deleted
auxiliary instance file /u01/ad/TSPITR_ORCLLDG_OSXD/datafile/o1_mf_sysaux_9nscb9ft_.dbf deleted
auxiliary instance file /u01/ad/TSPITR_ORCLLDG_OSXD/datafile/o1_mf_temp_9nschf73_.tmp deleted
auxiliary instance file /u01/ad/TSPITR_ORCLLDG_OSXD/onlinelog/o1_mf_1_9nscgpy1_.log deleted
auxiliary instance file /u01/ad/TSPITR_ORCLLDG_OSXD/onlinelog/o1_mf_2_9nscgzkl_.log deleted
auxiliary instance file /u01/ad/TSPITR_ORCLLDG_OSXD/onlinelog/o1_mf_3_9nsch314_.log deleted
[oracle@localhost ~]$ cd /u01/td/
[oracle@localhost td]$ ls
dmpfile.dmp example01.dbf explog.log impscrpt.sql
[oracle@localhost td]$ cd ../ad/
[oracle@localhost ad]$ ls
TSPITR_ORCLLDG_OSXD
重新测试： 含有数据文件的备份和有效的归档文件
SQL> show user
USER is "SYS"
SQL> create tablespace TTS
2 datafile '/u01/app/oracle/oradata/orclstd/tts.dbf'
3 size 20m;
Tablespace created.
SQL> alter user test default tablespace TTS;
User altered.
SQL> conn test/oracle
Connected.
SQL> select username,default_tablespace from user_users;
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
TEST TTS
SQL> create table tts as select * from test;
Table created.
SQL> commit;
Commit complete.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
TTS TABLE
TEST TABLE
2.检查备份：
RMAN> configure controlfile autobackup on;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
备份：
RMAN> backup database;
Starting backup at 14-APR-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/orclstd/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/orclstd/sysaux01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/orclstd/example01.dbf
input datafile fno=00007 name=/u01/dmp/tests.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/orclstd/undotbs01.dbf
input datafile fno=00008 name=/u01/app/oracle/oradata/orclstd/tts.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/orclstd/users01.dbf
channel ORA_DISK_1: starting piece 1 at 14-APR-14
channel ORA_DISK_1: finished piece 1 at 14-APR-14
piece handle=/u01/app/oracle/flash_recovery_area/ORCLLDG/backupset/2014_04_14/o1_mf_nnndf_TAG20140414T235610_9nsp0cbd_.bkp tag=TAG20140414T235610 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:06
Finished backup at 14-APR-14
Starting Control File and SPFILE Autobackup at 14-APR-14
piece handle=/u01/scripts/controlfile_c-939793073-20140414-0b comment=NONE
Finished Control File and SPFILE Autobackup at 14-APR-14
生成传输集：
RMAN> transport tablespace tts
2> tablespace destination '/u01/tts/td'
3> auxiliary destination '/u01/tts/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
Creat