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 ?
Re: User restoration [message #572576 is a reply to message #572573] Thu, 13 December 2012 06:00 Go to previous message
Michel Cadot
Messages: 68625
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
Previous Topic: New to Oracle - NEED HELP IMMEDIATELY
Next Topic: RMAN backup error
Goto Forum:
  


Current Time: Thu Mar 28 14:20:56 CDT 2024