Home » RDBMS Server » Backup & Recovery » Restore/Recover RAC 2 instances with RMAN (Oracle all versions)
icon1.gif  Restore/Recover RAC 2 instances with RMAN [message #686417] Thu, 08 September 2022 17:25 Go to next message
Messages: 15
Registered: April 2012
Junior Member
Could you approach me to the procedure to perform a complete or incomplete restore (in case of loss of a datafile, for example), on the same server, from Oracle RAC with 2 instances.

I have doubts about how to handle each instance and the way they should be started, MOUNT or NOMOUNT.

Linux S.O

Thanks in advanced.
Re: Restore/Recover RAC 2 instances with RMAN [message #686418 is a reply to message #686417] Fri, 09 September 2022 01:11 Go to previous message
John Watson
Messages: 8916
Registered: January 2010
Location: Global Village
Senior Member
The procedure is exactly the same as non-RAC. Keep the database open. Unless the file is part of SYSTEM or UNDO% tablespaces, in which case mount it.

However, I think you may need to do a bit more studying. Incomplete recovery because you lose few datafiles??? You'll lose your job as well if you do that.
Previous Topic: cannot export dmp
Next Topic: RMAN backups not registering in repository
Goto Forum:

Current Time: Thu Feb 29 19:33:46 CST 2024