RESTORE RMAN BACKUP FROM ONE SERVER TO ANOTHER SERVER IN 10G:

[oracle@localhost dbs]$ export ORACLE_SID=prodb
[oracle@localhost dbs]$
[oracle@localhost dbs]$
[oracle@localhost dbs]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Sep 21 11:13:06 2016

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

connected to target database (not started)

RMAN> startup nomount

Oracle instance started

Total System Global Area    1073741824 bytes

Fixed Size                     2026296 bytes
Variable Size                754975944 bytes
Database Buffers             314572800 bytes
Redo Buffers                   2166784 bytes


RMAN> restore controlfile from '/u02/hotbackup/54rgbtcg_1_1';

Starting restore at 21-SEP-16
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
output filename=/u01/oradata/proddb/control01.ctl
output filename=/u02/oradata/proddb/control02.ctl
output filename=/u03/oradata/proddb/control03.ctl
Finished restore at 21-SEP-16

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_4irg9sfe_1_1';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of catalog command on default channel at 09/21/2016 11:21:42
ORA-01507: database not mounted


RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_4irg9sfe_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_4irg9sfe_1_1 recid=88 stamp=923138535

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_4drg9s5j_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_4drg9s5j_1_1 recid=89 stamp=923138545

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_48rg9rjj_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_48rg9rjj_1_1 recid=90 stamp=923138558

RMAN>  catalog backuppiece '/u02/hotbackup/hotbackup_4frg9s8d_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_4frg9s8d_1_1 recid=91 stamp=923138626

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_4brg9s3d_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_4brg9s3d_1_1 recid=92 stamp=923138631

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_4grg9sae_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_4grg9sae_1_1 recid=93 stamp=923138639

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_4hrg9sdd_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_4hrg9sdd_1_1 recid=94 stamp=923138645

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_47rg9rfc_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_47rg9rfc_1_1 recid=95 stamp=923138651

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_49rg9roe_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_49rg9roe_1_1 recid=96 stamp=923138656

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_44rg9quu_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_44rg9quu_1_1 recid=97 stamp=923138663

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_4crg9s4g_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_4crg9s4g_1_1 recid=98 stamp=923138667

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_4arg9rtu_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_4arg9rtu_1_1 recid=99 stamp=923138672

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_4erg9s6m_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_4erg9s6m_1_1 recid=100 stamp=923138679

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_45rg9r4e_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_45rg9r4e_1_1 recid=101 stamp=923138685

RMAN> catalog backuppiece '/u02/hotbackup/hotbackup_46rg9rb5_1_1';

cataloged backuppiece
backup piece handle=/u02/hotbackup/hotbackup_46rg9rb5_1_1 recid=102 stamp=923138691


RMAN> restore database;

Starting restore at 21-SEP-16
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/oradata/proddb/system01.dbf
restoring datafile 00003 to /u01/oradata/proddb/sysaux.dbf
restoring datafile 00018 to /u02/oradata/proddb/undotbs14.dbf
restoring datafile 00019 to /u03/oradata/proddb/undotbs15.dbf
channel ORA_DISK_1: reading from backup piece /u03/hotbackup_44rg9quu_1_1

channel ORA_DISK_1: restored backup piece 1
failover to piece handle=/u02/hotbackup/hotbackup_44rg9quu_1_1 tag=TAG20160920T161006
channel ORA_DISK_1: restore complete, elapsed time: 01:17:09
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /u02/oradata/proddb/proddb_data_ts_01.dbf
restoring datafile 00017 to /u03/oradata/proddb/undotbs13.dbf
channel ORA_DISK_1: reading from backup piece /u03/hotbackup_45rg9r4e_1_1
channel ORA_DISK_1: restore complete, elapsed time: 00:42:49
Finished restore at 30-SEP-16

database opened

RMAN> quit


Recovery Manager complete.
[oracle@localhost ~]$ export ORACLE_SID=primdb
[oracle@localhost ~]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 21 13:48:58 2016

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

Enter user-name: /as sysdba

Connected to:
Oracle Database 10g Release 10.2.0.1.0 - 64bit Production

SQL>

Request you all to put your valuable comments on  posts of  this blog, will motivate me to write more good post.