| |
Posted: Feb 21, 2008 05:20:23 AM |
Total Post: 46
Joined: Sep, 2007
|
Hi all
my oracle version is oracle 9i. I deleted some rows from a particular table and commited it.
Now i want to retrieve those datas after some days which includes several shutdown of the server machine.
can i able to recover those data?
Thanks in advance |
|
|
Murtuja |
| Posted: Feb 21, 2008 07:25:06 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
if you have backup then you can recover ..
|
|
|
|
|
|
| Posted: Feb 21, 2008 10:19:54 AM | |
|
Total Post: 46
Joined: Sep, 2007
|
hi murtuja,
if i connect through RMAN, AND give the command like,
1.RMAN> RESTORE DATABASE
2. RMAN> RECOVER DATABASE
THEN i can recover the database with deleted tables.
is it right?
but i want to only recover these tables , not recover the database , is it possible? if yes ,plz tell me the steps:
Thanks in advance.
|
|
|
|
|
Vidar |
| Posted: Mar 11, 2008 04:57:00 AM | |
|
Total Post: 1
Joined: Jul, 2005
|
In Oracle 9i you can only restore datafiles, tablespace or the whole database through RMAN. In oracle 10g and above - it is possible to restore tables.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |