基于时间点的恢复：

1，编辑配置文件

DB_NAME=PROD
DB_UNIQUE_NAME=tspitr_PROD
CONTROL_FILES=/bigtmp/tspitr_cntrl.dbf'
DB_CREATE_FILE_DEST=/bigtmp
COMPATIBLE=11.0.0
BLOCK_SIZE=8192
REMOTE_LOGIN_PASSWORD=exclusive

2，启动到nomount

STARTUP NOMOUNT PFILE=/bigtmp/init_tspitr_prod.ora

4,

rman target / auxiliary sys/syspwd@pitprod

RUN
{

Specify NEWNAME for recovery set datafiles

SET NEWNAME FOR TABLESPACE clients

                    TO '?/oradata/prod/rec/%b';

Specify NEWNAMES for some of the auxiliary set

datafiles that have a valid image copy to avoid restores:

SET NEWNAME FOR DATAFILE '?/oradata/prod/system01.dbf'

                    TO '/backups/prod/system01_monday_noon.dbf';

SET NEWNAME FOR DATAFILE '?/oradata/prod/system02.dbf'

                    TO '/backups/prod/system02_monday_noon.dbf';

SET NEWNAME FOR DATAFILE '?/oradata/prod/sysaux01.dbf'

                    TO '/backups/prod/sysaux01_monday_noon.dbf';

SET NEWNAME FOR DATAFILE '?/oradata/prod/undo01.dbf'

                    TO '/backups/prod/undo01_monday_noon.dbf';

Specify the types of channels to use

ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL t1 DEVICE TYPE sbt;

Recover the clients tablespace to 24 hours ago:

RECOVER TABLESPACE clients UNTIL TIME 'sysdate-1';
}