Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


FLASHBACK DATABASE USING SCN


Well now i am working on FLASHBACK DATABSE USING SCN......my question is that ... Hi!  i did "FLASHBACK DATABASE TO SCN  546242....and open database with resetlog option so database went into new incarnation....as below....  List of database Incarnations  DB Key           Inc key        DB name       DB ID                            STATUS                         Reset Scn         Reset Time  1                      1              ORCL           1219380061                   PARENT                             1                    30-AUG-05  2                      2              ORCL           1219380061                   PARENT                             534907           20-JUL-05  3                      3              ORCL           1219380061                   CURRENT                           546250           20-JUL-05  Now Problem is that after flashback database to scn 546242........... i came to know that it was wrong scn i didn't achieve my target ....so now can i flashback again prior to scn "546242" or after this scn.........without using these below  1)FLASHBACK DATABASE BEFORE RESETLOG 2)FLASHBACK DATABASE TO RIGHT OF RESET LOG "in which we reset database to previous incarnation and then flashback database again with scn"  Edited by: Muhammad.Usman on Jul 23, 2009 10:56 PM  Edited by: Muhammad.Usman on Jul 23, 2009 10:58 PM

does any one ever used flashback database feature in their entire working experience?  Edited by: SMH on Jul 23, 2009 11:02 PM

Hi,  i didnt use it in real enviroment but you can check this site http://www.psoug.org/reference/flash_db.html  or metalink 565535.1 Flashback Database Best Practices & Performance  Regards, Tom http://oracledba.cz

Thanks


Related Links

sqlnet.ora parameter value overridden
ORA-12505: TNS:listener does not currently know of SID given in connect des
Listener status shows 2 instances when only 1 exists
Dreaming in virtual
Enable and disable auditing using trigger
sqlset loading plans from trace file
ORA-01652
Using EM to set up user-defined metric for DG. SQL error
SQL Tuning max + group by
error during dropping index
query issue
segment space management
Database performing slow at small number of users
setting utl_file_dir
How to monitor DROP USER
Errors in alert log