| restore database [message #609279] |
Wed, 05 March 2014 02:09  |
 |
kakakoko
Messages: 22
Registered: March 2014
|
Junior Member |
|
|
I want to test database recovery but I have a problem.the testing scenario is as follow;
Table name is TestTable and it is contains 10 records.
when the database is open, create a backup .
RMAN> BACKUP DATABASE;
I delete the all records from the TestTable.
Now I want to restore the database.
RMAN>Shutdown Immediate;
RMAN>Startup Mount;
RMAN>Restore Database;
RMAN>Recover Database;
RMAN>Alter Database open;
But after restoring the database, the deleted records are not back.Why?
|
|
|
|
| Re: restore database [message #609281 is a reply to message #609279] |
Wed, 05 March 2014 02:11  |
John Watson
Messages: 8968
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
You performed complete recovery, which re-instates all work (including your deletion). You need to perform an incomplete recovery up to the moment before you committed the deletion of the rows.
(by the way, please do not use the word "record" when you mean "row" or you will cause confusion).
[Updated on: Wed, 05 March 2014 02:12] Report message to a moderator |
|
|
|
|
|
| Re: restore database [message #609310 is a reply to message #609281] |
Wed, 05 March 2014 05:34 |
|
kakakoko
Messages: 22
Registered: March 2014
|
Junior Member |
|
|
Thank you very much John Watson,
You were right, my mistake was doing complete recovery, the rows retrieved by incomplete recovery.
Also thank you gazzag for your link.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
