Thanks for the reply. while i am performing RMAN duplicate target database using active database. I am getting the below errors.
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-10041: Could not re-create polling channel context following failure.
RMAN-10024: error setting up for rpc polling
RMAN-10005: error opening cursor
RMAN-10002: ORACLE error: ORA-03114: not connected to ORACLE
RMAN-03002: failure of Duplicate Db command at 08/06/2014 11:48:22
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 20877
Session ID: 1 Serial number: 5
Source database is on RHEL5 and Oracle 220.127.116.11
Target database is on RHEL6 and Oracle 18.104.22.168.
I tried to start the startup the database with upgrade option but i am getting media recovery error.
SQL> startup upgrade;
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2253664 bytes
Variable Size 603983008 bytes
Database Buffers 989855744 bytes
Redo Buffers 7319552 bytes
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u02/oradata/NBFDEV1/system01.dbf'
It would be great if you can help me to fix the issue.
Pl post RMAN related questions in the RMAN forum - https://community.oracle.com/community/database/high_availability/recovery_manager_%28rman%29_2
Are you restoring a RMAN backup to a higher database version ? In that case, you will need to perform an upgrade before you can open the database. Pl see MOS Doc 790559.1
Thanks Srini, I was trying to use clone the database using active database feature. Let me try try other ways if this does not work.