flashback.docVIP

flashback performing user-managed database flashback and recovery 1. flashback database (physical level): has own logging mechanism , creating flashback logs and storing them in flash recovery area. a. configure flashback database: create flash recovery area and enable collection of flashback logs, and guaranteed restore point flash recovery area: can contain control file(permanent), online reod log(permanent), archived log, flashback logging file and RMAN backups. flashback logging: the path is flashback retention target flashback database window guaranteed restore point c. enable flash recovery area b. enable flashback logging 1 database mount shutdown immediate; startup mount; 2 alter system set db_flashback_retention_target=4320; #3days 3 alter database flashback on; 4 optional, disable flashback logging for specific tablespaces alter tablespace tbs flashback off; also, re-enable flashback alter tablespace tbs flashback on; DEMO: SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL startup mount ORACLE instance started. Total System Global Area 1071333376 bytes Fixed Size 1334380 bytes Variable Size 335545236 bytes Database Buffers 729808896 bytes Redo Buffers 4644864 bytes Database mounted. SQL alter system set db_flashback_retention_target=4320; System altered. SQL alter database flashback on; Database altered. c. creating normal and guaranteed restore points database status : opened or mounted SQLcreate restore point before_upgrade; #normal restore point SQLcreate restore point before_upgrade guarantee flashback database; # guarantee restore point DEMO: SQL create restore point before_upgrade guarantee flashback database; Restore point created. d. to perform flashback database operations 1 obtain the earliest scn in the flashback database window: select oldest_flashback_scn, oldest_flashback_time fro