Database Software

Hi All,

Please help me out since i am creating duplicate DB from rman backup it failed as all steps is as below:


$ vi pfile.ora
$
$
$ export ORACLE_SID=tim
$
$
$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 8 10:35:10 2012

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

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> !pwd
/oracle1/oraerp/tech_st/dbhome_1/dbs

SQL>
SQL>
SQL> startup nomount pfile=/oracle1/oraerp/tech_st/dbhome_1/dbs/pfile.ora
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size 2213632 bytes
Variable Size 616564992 bytes
Database Buffers 444596224 bytes
Redo Buffers 5562368 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$
$
$
$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jul 8 10:36:53 2012

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

connected to target database: TIM (not mounted)

RMAN> exit
Recovery Manager complete.
$
$
$ rman auxiliary /

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jul 8 10:37:07 2012

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

connected to auxiliary database: TIM (not mounted)

RMAN> duplicate target database to "tim" nofilenamecheck
2> backup location '/oracle1/integrity/rman';

Starting Duplicate Db at 08-JUL-12

contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 1068937216 bytes

Fixed Size 2213632 bytes
Variable Size 620759296 bytes
Database Buffers 440401920 bytes
Redo Buffers 5562368 bytes

contents of Memory Script:
{
sql clone "alter system set db_name =
''TESTDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''TIM'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile from '/oracle1/integrity/rman/c-2567536562-20120628-03';
alter clone database mount;
}
executing Memory Script

sql statement: alter system set db_name = ''TESTDB'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set db_unique_name = ''TIM'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area 1068937216 bytes

Fixed Size 2213632 bytes
Variable Size 620759296 bytes
Database Buffers 440401920 bytes
Redo Buffers 5562368 bytes

Starting restore at 08-JUL-12
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=156 device type=DISK

channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/oracle1/integrity/cont.ctl
Finished restore at 08-JUL-12

database mounted
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=156 device type=DISK

contents of Memory Script:
{
set until scn 988720;
set newname for datafile 1 to
"/ora_data/testdb/system01.dbf";
set newname for datafile 2 to
"/ora_data/testdb/sysaux.dbf";
set newname for datafile 3 to
"/ora_data/testdb/undotbs1.dbf";
set newname for datafile 4 to
"/ora_data/testdb/userdata01.bdf";
set newname for datafile 5 to
"/ora_data/testdb/rman01.bdf";
restore
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 08-JUL-12
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /ora_data/testdb/system01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00002 to /ora_data/testdb/sysaux.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /ora_data/testdb/undotbs1.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to /ora_data/testdb/userdata01.bdf
channel ORA_AUX_DISK_1: restoring datafile 00005 to /ora_data/testdb/rman01.bdf
channel ORA_AUX_DISK_1: reading from backup piece /oracle1/integrity/rman/37nelog3_1_1
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /oracle1/integrity/rman/37nelog3_1_1
ORA-19504: failed to create file "/ora_data/testdb/rman01.bdf"
ORA-27040: file create error, unable to create file
IBM AIX RISC System/6000 Error: 2: No such file or directory

failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/08/2012 10:38:35
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>

Kindly suggest solution.

Best Regards,