HelloDBA [中文]
Search Internet Search HelloDBA
Favorite
  Oracle Technology Site. email: fuyuncat@gmail.com  MSN: fuyuncat@hotmail.com Add to circle

 

        Rescue data in the worst situation (2)

 

In this case, the situation is more complicated. It's an Oracle 10.2.0.1 database running in Linux. The database was shutdown abnormally; There are only 3 data files can be used, 2 of them are system files, whose file IDs are not in sequence; the other one is the data file contain the data to be rescued. The control files, redo logs, undo files, temp files and other data files are lost. During this process, I encoutered more problems, but I work it out finally.
[Read]

 

 

New Articles

 

 

  • Rescue data in the worst situation (2)
  • Rescue data in the worst situation (1)
  • Understand Buffer Cache in further --- Build up queryable Buffer Cache Chain data
  • Oracle SQL Hints --- Contents
  • Oracle SQL Hints --- Other Hints
  • Oracle SQL Hints --- Model Query And Partition Hints
  • Oracle SQL Hints --- Distributed Query And Parallel Query Hints
  • Oracle SQL Hints --- Hierarchy Query And XML Query Hints
  • Oracle SQL Hints --- Run Time And Data Maniplulation Hints
  • Oracle SQL Hints --- Statistics Data And Optimizer Hints
  • Oracle SQL Hints --- Quert Transformation Hints
  • Oracle SQL Hints --- Outline Data Hints
  • Oracle SQL Hints --- Join Hints
  • Oracle SQL Hints --- Access Path Hints
  • Oracle SQL Hints --- Abstraction
  • Coming Soon ...
  • Recover Truncated Data utilizing PLSQL
  • Oracle 11g Direct IO Auto Tune
  • Test Around Small Table Threshold
  • Oracle Sorting Algorithm
  • Approximate NDV based on hash algorithm in Oracle 11g
  • Distinct Aggregate Transformation
  • NULL or NOT NULL --- NOT NULL constraint impacts on execution plan and performance
  • Current Mode and Consistent Gets (2)
  • Current Mode and Consistent Gets
  • Select For Update and performance
  • Look Oracle from inside (tracing internal calls) --- Latches
  • Look Oracle from inside (tracing internal calls) --- Lock (Enqueue)
  • Look Oracle from inside (tracing internal calls) --- Logical IOs
  • Look Oracle from inside (tracing internal calls) --- Execution Plan
  • Query Execution Call Stack Trace
  • Execution Plan process analysis
  • SQL Rolling Invalidation
  • Bloom Filter
  • All about oracle sorting
  • TIPS: Build OUTLINE agilely
  • Adjusted MBRC formual in CBO
  • CBO Cost estimation
  • NULL IS NOT NULL in execution plan
  • CBO Statistics data gathering and internal arithmetic analysis -- Sampling
  • CBO Statistics data gathering and internal arithmetic analysis -- Calculating NDV and Density
  • CBO Statistics data gathering and internal arithmetic analysis -- Converting to endpoint value
  • CBO Statistics data gathering and internal arithmetic analysis -- Frequency or Height Balanaced?
  • CBO Statistics data gathering and internal arithmetic analysis -- when will gather histogram data
  • TIPS: How to get physical size of objects
  • [En] Oracle Row Shipping
  • Oracle Redo Strand
  • HowTo: Trace the statistics data gathtering
  • Oracle In Memory Undo
  • Secret of oracle logical IO: Index Scan
  • Secret of oracle logic IO: Sorting
  • Secret of oracle logic IO: Current Mode
  • Secret of oracle logic IO: Consistent Gets
  • Secret of oracle logic IO: Full Table Scan: Part 3
  • Secret of oracle logic IO: Full Table Scan: Part 2
  • Secret of oracle logic IO: Full Table Scan: Part 1
  • Transaction Enqueue analysis --- Other Contentions
  • Transaction Enqueue analysis --- Foreign Key
  • Transaction Enqueue analysis --- Bitmap Index Mantanence
  • Transaction Enqueue analysis --- Unique Constraint
  • Transaction Enqueue analysis --- Index Contention
  • Transaction Enqueue analysis --- ITL Contention
  • B*Tree Index block split --- Wait Events
  • B*Tree Index block split --- Block Allocation
  • B*Tree Index block split --- Split Transaction
  • B*Tree Index block split --- Storage Parameters
  • B*Tree Index block split --- Tree Growth
  • B*Tree Index block split --- How to split
  • Build "High" index in 10g
  • Q&A: Why there is not value peeked in 10053 trace file.
  • Transaction Enqueue analysis --- Row Lock
  • 11g new feature --- more flexible partition strategy
  • Row Movement impact
  • Q&A: Relationship between Table and Segment
  • 11g new feature --- Index Invisible
  • TIPS: ROWID Convertion
  • TIPS: Get lock wait in RAC
  • Full Table Scan cost formula cracking(1)
  • Full Table Scan cost formula cracking(2)
  • Full Table Scan cost formula cracking(3)
  • Full Table Scan cost formula cracking(4)
  • Full Table Scan cost formula cracking(5)
  • Full Table Scan cost formula cracking(6)
  • Q&A --- Multiple Buffer Cache
  • Consistent Reads And Buffer Cache
  • Performance trap of ROWNUM
  • analysis parallel process via Parallel Trace
  • Parallel your SQL --- Huge data update performance tuning
  • Oracle IO analysis(1)
  • Oracle IO analysis(2)
  • Oracle IO analysis(3)
  • Oracle IO analysis(4)
  • Oracle IO analysis(5)
  • Oracle IO analysis(6)
  • Oracle IO analysis(7)
  • Oracle IO analysis(8)
  • Oracle IO analysis(9)
  • Oracle IO analysis(10)
  • New hint in Oracle 10gR2 --- opt_param
  • Oracle SCN explanation
  • Tips of Oracle ROWNUM
  • Merge Join Cartesian in Execution Plan
  • How to capture the long operations
  • How to monitor the index usage
  • Capture top SQLs and their execution plans using statspack
  • Oracle bug --- zero date
  • Oracle 11g New features
  • Oracle Memory Management analysis(1)
  • Oracle Memory Management analysis(2)
  • Oracle Memory Management analysis(3)
  • Oracle Memory Management analysis(4)
  • Oracle Memory Management analysis(51)
  • Oracle Memory Management analysis(6)
  • Oracle Memory Management analysis(7)
  • Oracle Memory Management analysis(8)
  • Oracle Memory Management analysis(9)
  • Oracle Memory Management analysis(10)
  • Oracle Memory Management analysis(11)
  • Oracle Memory Management analysis(12)
  • When will bind variable peeking draw back performance?
  • How to calculate Cardinality in execution plan
  • Transaction Lock
  • Build personal desktop search engine utilizing Ultra Search
  • Install and configure ultra search
  • Dual table tuning
  • Testing cases and analys about operations on data block in transaction(1)
  • Testing cases and analys about operations on data block in transaction(2)
  • Testing cases and analys about operations on data block in transaction(3)
  • Study Oracle temporary table cache
  • Oracle streams replication between Oracle and SQL Server(1)
  • Oracle streams replication between Oracle and SQL Server(2)
  • Build logic stand by database
  • Create a trigger to monitor table
  • Configure load balance and failover in RAC
  • Oracle Hints(1)
  • Oracle Hints(2)
  • Oracle Hints(3)
  • Oracle Hints(4)
  • Oracle Hints(5)
  • Oracle Hash Join
  • Comparation of Normal Table Temporary Table and Table function
  • Rewrite SQL
  • Oracle 10g New feature --- Regular Expression
  • Oracle 10g New feature --- Code Wrap
  • Oracle 10g New feature --- Chooseful Compile
  • Oracle 10G New feature --- ADDM and SQL Tuning Advisor
  • Oracle 10G New feature --- Materialized View
  • Oracle 10G New feature --- Tablespace Management
  • Oracle 10G New feature --- Flashback
  • Oracle 10G New feature --- Connect By clause enhancement
  • Oracle 10G New feature --- RMAN
  • Oracle 10G New feature --- SQL*Plus
  • Oracle 10G New feature --- AWR
  • Oracle 10G New feature --- Audit
  • Oracle 10G New feature --- Waits
  • Oracle10g ADDM Guideline(1)
  • Oracle10g ADDM Guideline(2)
  • Oracle10g ADDM Guideline(3)
  • Tune SQL via Oracle 10g SQL Tuning Assistant (STA) (1)
  • Tune SQL via Oracle 10g SQL Tuning Assistant (STA) (2)
  • Tune SQL via Oracle 10g SQL Tuning Advisor (STA) (3)
  • Skip Scan Index
  • Configure Rotating in hacmp5.2
  • Oracle XML DB
  • How to identify lock type
  • ORA-01555 analysis(1)
  • ORA-01555 analysis(2)
  • ORA-01555 analysis(3)
  • Data Segment Compression
  •  


     

    Top

    Copyright ©2005, HelloDBA.Com All reseverd.

    Declaration
    by fuyuncat