Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
Some FLASHBACK DATABASE examples using RMAN and SQL*PLUS | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Some FLASHBACK DATABASE examples using RMAN and SQL*PLUS

  • Posted by Gavin Soorma
  • On June 18, 2009
  • 1 Comments

Wrong Update

SQL> update customers set credit_limit=100000;

 Shutdown the database

 Startup mount the database

 invoke rman

 $ rman target /

 Flashback database to time one hour prior to current time

 RMAN>  FLASHBACK DATABASE TO TIME ‘(SYSDATE-1/24)’;

 Starting flashback at 27-JUN-05

using target database controlfile instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=156 devtype=DISK

 starting media recovery

media recovery complete

 Finished flashback at 27-JUN-05

 Using SQL*PLUS

 SQL> flashback database to timestamp TO_TIMESTAMP(‘2005-06-27 09:00:00′,’YYYY-MM-DD HH24:MI:SS’);

 Flashback complete.

 SQL> alter database open  resetlogs;

Check the application

 SQL> select credit_limit from customers where rownum < 5;
 CREDIT_LIMIT

————

        2400

        2400

        2400

        1200

 1

1 Comments

Logic Gates
  • Jan 25 2011
**' I am very thankful to this topic because it really gives great information :*;

Leave Reply

Your email address will not be published. Required fields are marked *