Database Software

Hi All,

We have a 3-Node RAC Production database and I got a requirement to refresh the UAT database from the backup taken from production.

I have taken a backup from prod and I am have created a database with the same name RACDB like production in UAT server.

I have started the database in nomount mode and restored the controlfile and mounted the database.

My production database is having ASM and UAT is having local filesystem. First I am cataloging the backuppieces one by one and I am getting the below error:-


oracle@blrqpappdem02:RACDB [orabackup/backup_09_DEC_12] > rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Dec 17 13:08:34 2012

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

connected to target database: RACDB (DBID=731306481, not open)

RMAN> run {
2>
3> allocate channel t1 type disk;
4> catalog backuppiece '/orabackup/backup_09_DEC_12/arch_RACDB_6qnsf347_2266';
5> release channel t1;
6> }

using target database control file instead of recovery catalog
allocated channel: t1
channel t1: SID=222 device type=DISK

Starting implicit crosscheck backup at 17-DEC-12
ORA-03113: end-of-file on communication channel
ORA-01403: no data found
ORA-01403: no data found

Please suggest.

Regards,
Arijit