*** Oracle Dba - Flashback Feature

[ramana1212]

Anyone uses Flashback feature in their production databases to restore tables at certain timestamp.

[Power Star]

nope but have some idea

 

emaina restore cheyyala ?

[ramana1212]

Ya oka Mahanubavudu....Test DB anukoni Prod DB lo claims table update chesadu with commit.

 

Have to restore to yesterday timestamp. maa vaalu DB restore cheddam antunaru. But flashback feature use chesi reclybin ninchi restore cheyochu ani google lo undi kaani aa dairyam ravatle.

nope but have some idea

 

emaina restore cheyyala ?

 

[Power Star]

Ya oka Mahanubavudu....Test DB anukoni Prod DB lo claims table update chesadu with commit.

 

Have to restore to yesterday timestamp. maa vaalu DB restore cheddam antunaru. But flashback feature use chesi reclybin ninchi restore cheyochu ani google lo undi kaani aa dairyam ravatle.

 

yes chesey , test lo try chey same code update chesi flash back cheyyi

[ramana1212]

yes chesey , test lo try chey same code update chesi flash back cheyyi

 I did it mannnn....Successfully ga restore indi :)

 

flashback table &&schema.&&Table to timestamp to_timestamp('08-OCT-2015 08:00:00','DD-MON-YYYY HH24:MI:SS'');  

[DrPepper]

check this man... looks like it is covering your scenario. DB restore kanna flashback try cheyyi. worst case lo elagu DB restore ki prepare ayyi vunnaru kabatti, nothing to loose.

 

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9012.htm

[DrPepper]

congrats1

 I did it mannnn....Successfully ga restore indi :)

 

flashback table &&schema.&&Table to timestamp to_timestamp('08-OCT-2015 08:00:00','DD-MON-YYYY HH24:MI:SS'');  

 

[nakeytelvad]

you cannot use Flashback feature for table  if you dont have data in UNDO tablespace and you can try use below to check if flashback works or not.

 

CREATE TABLE ABC AS SELECT * FROM ABC_TEMP AS OF TIMESTAMP (TO_TIMESTAMP('17-07-2015 00:00:10','DD-MM-YYYY:HH24:MI:SS'));

 

 

but you can always do flashback of database if you have flashback enabled on database, but after that you have to open with resetlogs.

 

shutdown immediate;

startup mount;

flashback database to timestamp to_timestamp('16-07-2013 16:42:00', 'DD-MM-YYYY HH24:MI:SS');

alter database open resetlogs;

 

 

[ramana1212]

Ya saw that needs to create a seperate Tablespace for Flashback archive, then you can retireve the data historically.

 

Kaani drawback enti ante you have to enable row movement, if the change the table structure you have to setup it again.

 

But really worthy Feature.

 

 

 

 

you cannot use Flashback feature for table  if you dont have data in UNDO tablespace and you can try use below to check if flashback works or not.

 

CREATE TABLE ABC AS SELECT * FROM ABC_TEMP AS OF TIMESTAMP (TO_TIMESTAMP('17-07-2015 00:00:10','DD-MM-YYYY:HH24:MI:SS'));

 

 

but you can always do flashback of database if you have flashback enabled on database, but after that you have to open with resetlogs.

 

shutdown immediate;

startup mount;

flashback database to timestamp to_timestamp('16-07-2013 16:42:00', 'DD-MM-YYYY HH24:MI:SS');

alter database open resetlogs;

 

 

[MeetFriendz]

Asslu mundhu nee database lo flasback enabled iyevudho ledho choodu ... few commpanies disable it. if Yes .. then check if your UNDO still holds that information ...... instread of doing flash back restore try flash back query for that particular tables and populated that and verify ... then do a restore if needed ... ledhu ante mee vadu oke transaction lo anni update chesthe ...  you can use logminer and get the information too its a tedious work though ...