Recovering lost table and data before TSPITR |
 |
EXPERT RESPONSE FROM: Brian Peasland
|
|
|
|
| > |
QUESTION POSED ON: 21 July 2003
I'm attempting a 9iR2(9.2.0.3) user-managed TSPITR test.
After creating auxiliary database, the export of
tablespace fails with ORA-1552. Using the
v$datafile, you see: C:ORADATAAUXDBUNDOTBS01.DBF
ONLINE. Then using:
select segment_name, tablespace_name, status from
dba_rollback_segs,
_SYSSMU1$ UNDOTBS1 OFFLINE. The SYSTEM LMT is
online, but the instance undo segments are offline.
As of now, user-managed TSPITR by exporting
tablespaces is not a viable option - Metalink bug
2621039. Before the new way of TSPITR (8i,9i), how
did one recover a lost table and its data?
|
|
|
To continue reading for free, register below or login
To read more you must become a member of SearchOracle.com
Before TSPITR, one used Oracle exports to recover a
lost table and its data. Every night, the DBA's
scripts would export the entire database. To restore a
lost table, one just imported from the nightly export.
Unfortunately, one could not then roll forward from
the time the export was taken to recover any
transactions since the export up until right before
the table was dropped. This shortcoming led to the
introduction of TSPITR in recent Oracle releases.
For More Information
|
|
|
|
|
|
|
|
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
|
|
|
|
|
|
|
|
|
|
|
