Home » RDBMS Server » Backup & Recovery » restore database (11.2 ,linux)
restore database [message #609279] Wed, 05 March 2014 02:09 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 4489
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 #609302 is a reply to message #609279] Wed, 05 March 2014 04:43 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
Investigate Point In Time Recovery.

HTH
-g
Re: restore database [message #609310 is a reply to message #609281] Wed, 05 March 2014 05:34 Go to previous message
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.


Previous Topic: O/S-Error: (OS 3) The system cannot find the path specified.
Next Topic: Oracle 11g Backup
Goto Forum:
  


Current Time: Fri Aug 22 23:03:31 CDT 2014

Total time taken to generate the page: 0.11013 seconds