Monday, July 4, 2011

Backup and Recovery Scenerio-9 (How to perform a point in time tablespace recovery)

How to perform a point in time tablespace recovery? In this exercise, tablespace name is CT_COMMON_DATA?
$ export ORACLE_SID=PrimeDG
$ rman target /
RMAN> sql 'alter tablespace CT_COMMON_DATA offline';

RMAN> run

{

set until time "to_date('FEB 28 2008 13:59:00','Mon DD YYYY HH24:MI:SS')";

recover tablespace CT_COMMON_DATA;

}

RMAN> sql 'alter tablespace CT_COMMON_DATA online';
RMAN> exit;

No comments:

Post a Comment

Followers