Home » RDBMS Server » Server Administration » loss of a table
loss of a table [message #58340] Sat, 16 August 2003 01:31
rkumar
Messages: 9
Registered: July 2003
Junior Member
hi all,

i got a critical problem. one of my table in the production database was dropped by someone. The table is the crucial one. I want to restore the table back. The following is my situation.

.......I dont have the export backup
.......My Database running in archive mode
.......I have the RMAN closed backup on the previous day.
...... I have other tables in the tablespace, in which i lost the table. If i restore the datafile thru RMAN, what would be the impact. After restoring the datafile, what should i do to restore the Table.

Please provide me the complete solutions, and treat this as an urgent.
All the replies r welcome
Previous Topic: pfile
Next Topic: how can i know the DB size
Goto Forum:
  


Current Time: Fri Sep 20 06:34:47 CDT 2024