Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Restore RMAN backup from PROD to PRD1?

Beauty_and_dBestMay 31 2020 — edited Jun 3 2020

11gR2

OL6

Hi ALL,

We have RMAN backup of our PROD database.

We are using pfile and not spfile.

I want to restore it with newname from 'PROD' to 'PRD1' database on the same server.

I already created separate home and dbname 'PRD1'.

This means the target database pre-existed, I only want to replace it with new data from 'PROD'.

First, I run rman target / and startup nomount:

pastedImage_0.png

Then restore controlfile:

pastedImage_2.png

But when I tried to mount it for recovery, I got error below

pastedImage_3.png

How do I change dbname from PROD to PRD1?

Please help....

Kind regards,

jc

Comments
Post Details
Added on May 31 2020
18 comments
756 views