Restore backups to new host

Posted by satish on Jul 21, 2021; 7:27am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Restore-backups-to-new-host-tp9994.html

Hi erman,

Our dbversion:12.1.0.2

We are trying to restore our PROD backups to new host.

PROD database name:PRODDB

TEST database name:TEST

[test@erpsupportdb archives]$ export ORACLE_SID=TEST

 
[test@erpsupportdb archives]$ sqlplus "/as sysdba";

 
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 21 11:36:21 2021

 
Copyright (c) 1982, 2014, Oracle. All rights reserved.

 
Connected to an idle instance.

 
SQL> startup nomount;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

 
Total System Global Area 2.6844E+10 bytes

Fixed Size         2939560 bytes

Variable Size       738198872 bytes

Database Buffers     2.6038E+10 bytes

Redo Buffers        64167936 bytes

 
 
[test@erpsupportdb archives]$ rman target /

 
Recovery Manager: Release 12.1.0.2.0 - Production on Wed Jul 21 11:39:36 2021

 
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

 
connected to target database: TEST (not mounted)

 
RMAN> restore controlfile from '/ERPShareddrive/ERP/opm/archives/ora_df1078276005_s286837_s1';

 
Starting restore at 21-JUL-21

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=921 device type=DISK

 
channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:03

output file name=/u02/TEST_DATA/data/cntrl01.dbf

output file name=/u02/TEST_DATA/data/cntrl02.dbf

output file name=/u02/TEST_DATA/data/cntrl03.dbf

Finished restore at 21-JUL-21

 
RMAN> alter database mount;

 
RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of sql statement command at 07/21/2021 11:40:32

ORA-01103: database name 'PRODDB' in control file is not 'TEST'

 
RMAN>

 
 
Our pfile:

[test@erpsupportdb archives]$ cd $ORACLE_HOME/dbs

[test@erpsupportdb dbs]$ cat initTEST.ora

*.compatible='12.1.0'

*.control_files='/u02/TEST_DATA/data/cntrl01.dbf','/u02/TEST_DATA/data/cntrl02.dbf','/u02/TEST_DATA/data/cntrl03.dbf'#Restore Controlfile

*.db_create_file_dest='/u02/TEST_DATA/data'

*.db_name='TEST'

*.local_listener='TEST_LOCAL'

*.log_archive_dest_1='LOCATION=/u02/TEST_DATA/data/archive'

*.undo_management='AUTO'# Required 11i setting

*.undo_tablespace='APPS_UNDOTS1'# Required 11i setting

*.utl_file_dir='/usr/tmp','/usr/tmp','/u02/TEST_DATA/12.1.0/appsutil/outbound/TEST_erpsupportdb','/usr/tmp'

*.workarea_size_policy='AUTO'# Required 11i setting

[test@erpsupportdb dbs]$

 
Please let us know how to avoid this error:

ORA-01103: database name 'PRODDB' in control file is not 'TEST'

Thanks,

SG