Tuesday, January 10, 2006

Restore tablespace by use until time

let me show rman command-line to restore tablespace (use UNTIL TIME)

RMAN> run{
set until time "to_date('Jan 10 2006 06:00:00', 'Mon DD YYYY HH:MI:SS') " ;
restore tablespace USERS ;
recover tablespace USERS ;
}

No comments: