Re: RMAN Restore/Duplicate without Catalog

Hi Sanjay

You can keep the current instance online, but you need to use the same db_name on your init.ora and the ORACLE_SID and db_unique_name must be different.

You also need to remember to do a "set newname" /"switch datafile" for the database on your rman script and an "alter database rename file" for all your redo logs before you do a resetlogs.

Em dom, 27 de nov de 2022 20:21, Sanjay Mishra <dmarc-noreply_at_freelists.org> escreveu:

> Mladen
>
> Thanks for the update. The issue is in restoring the existing database
> with a different name on the same server. So it looks like we can only
> restore if another database is stopped. Is it correct?
>
> Tx
> Sanjay
>
> On Saturday, November 26, 2022 at 01:38:54 AM EST, Mladen Gogala <
> gogala.mladen_at_gmail.com> wrote:
>
>
> On 11/25/22 16:07, Sanjay Mishra wrote:
>
> Thank Mladen
>
> Does this mean that we cannot restore the database to a different name on
> the same server when Catalog is not used?
>
> You can always change the name once your database is open. Just re-create
> controlfile and change the parameter db_name. Don't forget to clean up the
> old directory structure of $ORACLE_BASE/diag/rdbms after renaming the
> database. It doesn't take long to do that.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
>

--
http://www.freelists.org/webpage/oracle-l