Home » RDBMS Server » Backup & Recovery » Restoring Oracle db to new server (Oracle, 12.1.0.2, Linux)
Restoring Oracle db to new server [message #683553] Fri, 29 January 2021 16:48 Go to next message
patdev
Messages: 59
Registered: August 2008
Member
Hello,

I am not a Oracle DBA but have one server with failing drive.

I have Rman backup of DB and controlfile ( oracle version 12.1.02 on Linux)

i have other server with same version installed but running another intance?

How can I restore the RMAN to new server with same db?

Please help and guide.

Thanks
Re: Restoring Oracle db to new server [message #683554 is a reply to message #683553] Sat, 30 January 2021 00:28 Go to previous messageGo to next message
Michel Cadot
Messages: 67850
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No feedback no help.
Re: Restoring Oracle db to new server [message #683555 is a reply to message #683553] Sat, 30 January 2021 01:31 Go to previous messageGo to next message
John Watson
Messages: 8547
Registered: January 2010
Location: Global Village
Senior Member
You need to:

A. Create an instance
B. Restore the controlfile
C. Restore the database
D. Recover the database
E. Open with resetlogs.

Alternatively, hire a consultant.
Re: Restoring Oracle db to new server [message #683556 is a reply to message #683555] Sat, 30 January 2021 13:57 Go to previous messageGo to next message
patdev
Messages: 59
Registered: August 2008
Member
Hello,

I was able to create new db with same name

what would be next step to restore?

Thanks
Re: Restoring Oracle db to new server [message #683557 is a reply to message #683556] Sat, 30 January 2021 14:05 Go to previous messageGo to next message
Michel Cadot
Messages: 67850
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://www.orafaq.com/forum/m/610363/#msg_610363

Re: Restoring Oracle db to new server [message #683558 is a reply to message #683557] Sat, 30 January 2021 14:31 Go to previous messageGo to next message
patdev
Messages: 59
Registered: August 2008
Member
Hello,,

thanks.

so i don't need to restore controlfile? also, i have only full backup on diferent location and i do not have the archive log either due to drive failure on other server.

thanks
Re: Restoring Oracle db to new server [message #683559 is a reply to message #683558] Sat, 30 January 2021 14:59 Go to previous messageGo to next message
Michel Cadot
Messages: 67850
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

John Watson wrote on Sat, 30 January 2021 08:31
You need to:
...
Alternatively, hire a consultant.
Re: Restoring Oracle db to new server [message #683560 is a reply to message #683558] Sun, 31 January 2021 01:41 Go to previous message
John Watson
Messages: 8547
Registered: January 2010
Location: Global Village
Senior Member
Quote:
i do not have the archive log either due to drive failure on other server.
In that case, say "Goodbye" to your database. You may be able to restore it, but you will never be able to recover and open it.
Previous Topic: Failover with Oracle Standard Edition 2 19c
Next Topic: impdp bypassing DUMPFILE
Goto Forum:
  


Current Time: Thu May 13 22:37:38 CDT 2021