RMAN

tema enviado por cicutrino en ORACLE
tema iniciado el 04/08/2006

Hola buenos dias,

Alguien m epuede explicar como usar los comandos de recuperacion en timepo en RMAN ??

He encontrado estas tres formas pero no consigo hacer funcionar ninguna XD

Desde SQL*PLUS:
SQL> recover database [using backup controlfile] until cancel;

Desde RMAN:
RMAN> recover database set until scn <scn matching logfile>;                                                                                   
à scn se obtiene  select max(next_change#)-1 from v$archived_log
 
RMAN> run{                                                                                                                                                          Sql’alter session set nls_date_format=”dd-mm-yy:hh24:mi:ss”’;                                                                                Set until time=’03-08-06:10:15:00’;                                                                                                        Restore database;                                                                                                                                  Recover database;                                                                                                                                               Alter database open resetlogs;                                                                                                                            }