Skip to content

Instantly share code, notes, and snippets.

@Tracnac

Tracnac/Flashback database.md

Last active September 23, 2022 17:00
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Tracnac/e4cedac9c2b5a631edfc8e0845c98ea9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Tracnac/e4cedac9c2b5a631edfc8e0845c98ea9 to your computer and use it in GitHub Desktop.
Download ZIP
Flashback database #oracle #rman
Raw
Flashback database.md

Création du snapshot :

alter system archive log current;
shutdown immediate;
startup mount exclusive;
alter database flashback on;
create restore point DB_SNAP01 guarantee flashback database;
alter database open;
alter system archive log current;

Surveillance :

select begin_time, flashback_data, db_data, redo_data, estimated_flashback_size from v$flashback_database_stat;

En cas de retour :

alter system archive log current;
shutdown immediate;
startup mount exclusive;
flashback database to restore point DB_SNAP01;
alter database open resetlogs;

Destruction après opération :

drop restore point DB_SNAP01;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment