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

tracing user
regarding lob column
import only rows
root.sh
How to extend temp segments
Database buffer cashe and process
In 2 Node RAC clients always connect to Node 2...
Which user is running the oracle database software?
Looking RAC Courses
How to check which query is consuming most resources....
Can I access data from second database while working in first database
query regarding Core_dump_dest
oracle does not start automatically on AIX
Database Performance.
Sql loder
regarding undo tablespace