{リカバリ}不完全リカバリ

 

https://docs.oracle.com/cd/F19136_01/bradv/rman-performing-flashback-dbpitr.html#GUID-7D3EE2F7-77A2-4264-8875-CC0AEC64ABE0

時間ベース
変更ベース
ログ順序番号
リストアポイント
AVAILABLE REDO

export NLS_LANG=American_America.AL32UTF8
export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'

rman target /

delete noprompt backup;
BACKUP DATABASE plus archivelog delete input ;

LIST RESTORE POINT ALL;

DROP RESTORE POINT rp1;
CREATE RESTORE POINT rp1;
LIST RESTORE POINT ALL;

 

          時間ベース

shutdown immediate;
startup mount;
restore database until time '2025-02-08 19:37:02';
recover database until time '2025-02-08 19:37:02';
alter database open resetlogs;

 

          変更ベース
select current_scn from v$database;

shutdown immediate;
startup mount;
restore database until scn 13217941;
recover database until scn 13217941;
alter database open resetlogs;

          ログ順序番号
select * from v$log;

shutdown immediate;
startup mount;
restore database until sequence 6;
recover database until sequence 6;
alter database open resetlogs;

          リストアポイント

shutdown immediate;
startup mount;
restore database to restore point rp1;
recover database to restore point rp1;
alter database open resetlogs;

          AVAILABLE REDO

shutdown immediate;
startup mount;
restore database;
recover database UNTIL AVAILABLE REDO;
alter database open resetlogs;