OraFAQ Forum: Backup & Recovery » Restoring Oracle db to new server

Home » RDBMS Server » Backup & Recovery » Restoring Oracle db to new server (Oracle, 12.1.0.2, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restoring Oracle db to new server [message #683553]

Fri, 29 January 2021 16:48

patdev
Messages: 74
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

Report message to a moderator

Re: Restoring Oracle db to new server [message #683554 is a reply to message #683553]

Sat, 30 January 2021 00:28

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No feedback no help.

Report message to a moderator

Re: Restoring Oracle db to new server [message #683555 is a reply to message #683553]

Sat, 30 January 2021 01:31

John Watson
Messages: 8963
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.

Report message to a moderator

Re: Restoring Oracle db to new server [message #683556 is a reply to message #683555]

Sat, 30 January 2021 13:57

patdev
Messages: 74
Registered: August 2008

Member

Hello,

I was able to create new db with same name

what would be next step to restore?

Thanks

Report message to a moderator

Re: Restoring Oracle db to new server [message #683557 is a reply to message #683556]

Sat, 30 January 2021 14:05

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Restoring Oracle db to new server [message #683558 is a reply to message #683557]

Sat, 30 January 2021 14:31

patdev
Messages: 74
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

Report message to a moderator

Re: Restoring Oracle db to new server [message #683559 is a reply to message #683558]

Sat, 30 January 2021 14:59

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

John Watson wrote on Sat, 30 January 2021 08:31

You need to:
...
Alternatively, hire a consultant.

Report message to a moderator

Re: Restoring Oracle db to new server [message #683560 is a reply to message #683558]

Sun, 31 January 2021 01:41

John Watson
Messages: 8963
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.

Report message to a moderator

Previous Topic:	Failover with Oracle Standard Edition 2 19c
Next Topic:	Incremental level backup 1 without level 0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 21 22:36:46 CST 2025