|
Category :
Backup and Recovery
Online backups on NAS -
A Quick way to do an online backup of the database on NAS disks.
New RMAN Feature -
An additional recovery option available in 9i through RMAN.
Corrupt Blocks -
Handling corrupt table and index blocks.
Database Refresh
- Making a copy of a database on a different machine.
Recovery with added datafile
- How to recover a database having added a datafile since the last
backup.
Recover Table -
Recovering a dropped table from a
full database backup.
SCN and Distributed transactions
- A little note on how SCNs are maintained by oracle during
distributed transactions.
Redo Allocation Latch
- A caveat to tuning redo allocation latch in 9i that you need to be
aware of.
Control file 101 - A few details
about the database control files.
A Few Basic Recovery Scenarios:
The first 3 scenarios listed
below are recovery procedures using complete database recovery while
scenario 4 is using incomplete database recovery.
Scenario 1 -
Recovery Of SYSTEM or ROLLBACK tablespace datafiles.
Scenario 2 -
Recovery for lost or corrupted non-system or non-rollback datafiles.
Scenario 3
- Recovery when an inactive redo log file is lost or corrupted.
Scenario 4
- Recovery when current and active redo log file is lost or corrupted. |
