MARK's DBA Blog
  • Home

Oracle Flashback

11/23/2016

0 Comments

 
sqlplus / as sysdba
show parameter db_recovery;

sys@EM13REP> show parameter db_recovery;

NAME                                 TYPE        VALUE
==================================== =========== ==============================
db_recovery_file_dest                string      /u07/flashback
db_recovery_file_dest_size           big integer 17G

to change to different directory
sys@EM13REP> alter system set db_recovery_file_dest='/u07/flashback';

to change recovery file size
sys@EM13REP> alter system set db_recovery_file_dest_size='17g';

database is open
sys@EM13REP> alter database flashback on;

ls /u07/flashback

list restore points
SQL> SELECT NAME, SCN, TIME, DATABASE_INCARNATION#, GUARANTEE_FLASHBACK_DATABASE,STORAGE_SIZE FROM V$RESTORE_POINT;

SQL> CREATE RESTORE POINT before_upgrade;

​sys@EM13REP> select flashback_on from v$database;

​
Reference: 
​http://docs.oracle.com/database/122/BRADV/using-flasback-database-restore-points.htm#BRADV71000

0 Comments



Leave a Reply.

    Picture
    Picture

    Author

    There are some that call me Tim.

    Categories

    All
    Oracle Database 12c
    Oracle Enterprise Manager
    Ubuntu Samba
    Ubuntu Server
    Ubuntu VNC

    Archives

    November 2016
    July 2015
    May 2015
    December 2014

    RSS Feed

Powered by Create your own unique website with customizable templates.
  • Home