{リカバリ}表領域をPITRリカバリ

 

https://docs.oracle.com/cd/F19136_01/bradv/performing-rman-tspitr.html

alter database default tablespace AAA;

rman target /

report schema;

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;

 

RECOVER TABLESPACE users
  until scn 12301443
  AUXILIARY DESTINATION '/tmp';

 

BACKUP TABLESPACE users;

ALTER TABLESPACE users ONLINE;