Recover Oracle database and standby db examples

Just some handy quick syntax references for Oracle database recovery.

-- Recover Oracle standby database
select to_char(sysdate, 'dd/mm/yyyy hh24:mi:ss') AS start_time from dual;
ALTER DATABASE RECOVER automatic standby database until time '2006-02-24:09:00:00';
select to_char(sysdate, 'dd/mm/yyyy hh24:mi:ss') AS end_time from dual;


-- Recover database until certain time:
recover database until time '2006-02-24:09:00:00';


-- Recover database after RMAN restore until certain time:
recover database using backup controlfile until time '2006-02-24:09:00:00';