用Oracle备份集在测试机上做不完全恢复

         export ORACLE_SID=xxx
        sqlplus / as sysdba
        startup nomount pfile='/home/oracle/init_xxx.ora';
        create spfile from pfile='/home/oracle/init_xxx.ora';

        exit

        RMAN target sys/xxx
        restore controlfile from '...';
        startup mount
        --crosscheck backup;
        list backup;

        run
        {
        set newname for datafile 1 to '/oracle/oradata/xxx/system01.dbf';
        set newname for datafile 2 to '/oracle/oradata/xxx/undo01.dbf';
        set newname for datafile 3 to '/oracle/oradata/xxx/sysaux01.dbf';
        set newname for datafile 6 to '/oracle/oradata/xxx/pay_ts01.dbf';
        restore datafile 1;
        restore datafile 2;
        restore datafile 3;
        restore datafile 6;
        }
        (注：发现单个datafile恢复不如整库恢复快！)
        sql 'alter database backup controlfile to trace';
        shutdown immediate;
        exit

--------------------next---------------------