Home » RDBMS Server » Backup & Recovery » User restoration
User restoration [message #572573] Thu, 13 December 2012 05:42 Go to next message
mj080967
Messages: 1
Registered: December 2012
Location: Brazil
Junior Member
Hi.
I'm in doubt if I can restore user's data to 2 days past, using only physical backup made with RMAN commands.
Is there any manner to restore this information if I don't have logical backup ?

Report message to a moderator

Re: User restoration [message #572576 is a reply to message #572573] Thu, 13 December 2012 06:00 Go to previous message
Michel Cadot
Messages: 68455
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't directly restore a user with RMAN.
You have to restore elsewhere the database with the SYSTEM, SYSAUX, UNDO and this user's tablespaces then export the user you can, in the end, import in the original database.

Regards
Michel

Report message to a moderator

Previous Topic: New to Oracle - NEED HELP IMMEDIATELY
Next Topic: RMAN backup error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 09 00:10:19 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.