Home » RDBMS Server » Backup & Recovery » User restoration
User restoration [message #572573] Thu, 13 December 2012 05:42 Go to next message
Messages: 1
Registered: December 2012
Location: Brazil
Junior Member
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 ?
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.

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

Current Time: Fri Jun 09 00:10:19 CDT 2023