PROTECTED]]
Sent: Tuesday, February 13, 2001 8:02 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Urgent Help me !!!**
You will have to use your last Hot Backup file set and
create a new database (use the alter database backup controlfile to trace
Hi,
Try restoring an old backup first. Make sure that the newest datafile is
older than the point you want to return to.
Than do your PITR again.
MAKE OFFLINE BACKUP FIRST BEFORE ANY CHANGES.
ANother option is to restore on a different machine, export the table and
import the table on the
Did you restore the data files from the last hot backup?
Praveen
"Dash, Saroj (CAP,CEF)" wrote:
Dear All,
In one of database the developer had deleted a table and
commited it.
database is in online backup but no export backup or table backup
Please tell me how can I recover the the
You will have to use your last Hot Backup file set and
create a new database (use the alter database backup controlfile to trace
for the create db statement). Then apply all the arch. redo files since
THAT backup, UPTO the point before
the Table was dropped. Then extract the Table data and