Rman restore problem

I took rman backup from RAC server to restore to another (new) RAC server.

I faced some problem while restoring database. Steps are follows

RMAN> restore database;
Starting restore at 30-OCT-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=108 instance=prod1 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=107 instance=prod1 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=106 instance=prod1 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=105 instance=prod1 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /oradata1/datafile/prod/newrbtbs.360.742358543
restoring datafile 00008 to /oradata1/datafile/prod/tools.366.742358297
restoring datafile 00011 to /oradata1/datafile/prod/rcaremagnum_data.336.742357289
restoring datafile 00015 to /oradata1/datafile/prod/rcaremagnum_fodata.394.742357835
restoring datafile 00017 to /oradata1/datafile/prod/rcaremagnum_bodata.401.742357283
restoring datafile 00020 to /oradata1/datafile/prod/sadata.370.742358295
restoring datafile 00028 to /oradata1/datafile/prod/lob_data.391.742357911
restoring datafile 00033 to /oradata1/datafile/prod/rcaremagnum_fodata.338.742357289
restoring datafile 00038 to /oradata1/datafile/prod/rcaremagnum_fodata.416.742357283
restoring datafile 00042 to /oradata1/datafile/prod/undotbs2.320.742357281
restoring datafile 00048 to /oradata1/datafile/prod/rcaremagnum_boindex.312.742385097
restoring datafile 00049 to /oradata1/datafile/prod/sysaux.359.796228931
restoring datafile 00052 to /oradata1/datafile/prod/rcaremagnum_fodata.318.797253465
restoring datafile 00056 to /oradata1/datafile/prod/rcaremagnum_foindex.302.797260165
restoring datafile 00058 to /oradata1/datafile/prod/undotbs1.300.797269689
channel ORA_DISK_1: reading from backup piece /nfshisdb/ORABKP/rman/db_797997673_18197_p1
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /oradata1/datafile/prod/sysaux.412.742357287
restoring datafile 00009 to /oradata1/datafile/prod/users.367.742358295
restoring datafile 00010 to /oradata1/datafile/prod/rcaremagnum_data.335.742357287
restoring datafile 00013 to /oradata1/datafile/prod/rcaremagnum_fodata.341.742357833
restoring datafile 00014 to /oradata1/datafile/prod/rcaremagnum_fodata.343.742357835
restoring datafile 00019 to /oradata1/datafile/prod/sadata.378.742358199
restoring datafile 00027 to /oradata1/datafile/prod/rcaremagnum_boindex.340.742357709
restoring datafile 00032 to /oradata1/datafile/prod/rcaremagnum_fodata.377.742358199
restoring datafile 00034 to /oradata1/datafile/prod/sadata.376.742358201
restoring datafile 00037 to /oradata1/datafile/prod/rcaremagnum_fodata.323.742357281
restoring datafile 00041 to /oradata1/datafile/prod/undotbs1.321.742357281
restoring datafile 00045 to /oradata1/datafile/prod/rcaremagnum_fodata.328.742357283
restoring datafile 00053 to /oradata1/datafile/prod/rcaremagnum_fodata.411.797254741
restoring datafile 00057 to /oradata1/datafile/prod/rcaremagnum_data.301.797265739
channel ORA_DISK_2: reading from backup piece /nfshisdb/ORABKP/rman/db_797997673_18199_p1
ORA-19870: error reading backup piece /nfshisdb/ORABKP/rman/db_797997673_18197_p1
ORA-19505: failed to identify file “/nfshisdb/ORABKP/rman/db_797997673_18197_p1”
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-19870: error reading backup piece /nfshisdb/ORABKP/rman/db_797997673_18199_p1
ORA-19505: failed to identify file “/nfshisdb/ORABKP/rman/db_797997673_18199_p1”
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
channel ORA_DISK_3: starting datafile backupset restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oradata1/datafile/prod/system.361.742358409
restoring datafile 00005 to /oradata1/datafile/prod/newrbtbs.387.742357285
restoring datafile 00016 to /oradata1/datafile/prod/rcaremagnum_bodata.371.742358293
restoring datafile 00022 to /oradata1/datafile/prod/rcaremagnum_foindex.342.742357835
restoring datafile 00023 to /oradata1/datafile/prod/rcaremagnum_foindex.363.742358409
restoring datafile 00026 to /oradata1/datafile/prod/rcaremagnum_boindex.399.742357285
restoring datafile 00030 to /oradata1/datafile/prod/lob_data.329.742357965
restoring datafile 00035 to /oradata1/datafile/prod/rcaremagnum_fodata.402.742357283
restoring datafile 00039 to /oradata1/datafile/prod/rcaremagnum_fodata.264.742357285
restoring datafile 00043 to /oradata1/datafile/prod/rcaremagnum_fodata.337.742357289
restoring datafile 00046 to /oradata1/datafile/prod/newrbtbs1.375.742358815
restoring datafile 00047 to /oradata1/datafile/prod/rcaremagnum_bodata.313.742384637
restoring datafile 00050 to /oradata1/datafile/prod/rcaremagnum_fodata.357.796924001
restoring datafile 00054 to /oradata1/datafile/prod/rcaremagnum_fodata.356.797255811
channel ORA_DISK_3: reading from backup piece /nfshisdb/ORABKP/rman/db_797997673_18200_p1
channel ORA_DISK_4: starting datafile backupset restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /oradata1/datafile/prod/newrbtbs.372.742358201
restoring datafile 00004 to /oradata1/datafile/prod/newrbtbs.374.742358201
restoring datafile 00006 to /oradata1/datafile/prod/newrbtbs.362.742358409
restoring datafile 00012 to /oradata1/datafile/prod/rcaremagnum_data.339.742357435
restoring datafile 00018 to /oradata1/datafile/prod/rcaremagnum_bodata.398.742357285
restoring datafile 00021 to /oradata1/datafile/prod/sadata.369.742358295
restoring datafile 00024 to /oradata1/datafile/prod/rcaremagnum_foindex.333.742357287
restoring datafile 00025 to /oradata1/datafile/prod/rcaremagnum_boindex.368.742358295
restoring datafile 00029 to /oradata1/datafile/prod/lob_data.390.742357941
restoring datafile 00031 to /oradata1/datafile/prod/rcaremagnum_fodata.322.742357281
restoring datafile 00036 to /oradata1/datafile/prod/rcaremagnum_fodata.334.742357287
restoring datafile 00040 to /oradata1/datafile/prod/rcaremagnum_fodata.400.742357285
restoring datafile 00044 to /oradata1/datafile/prod/rcaremagnum_fodata.327.742357287
restoring datafile 00051 to /oradata1/datafile/prod/rcaremagnum_fodata.319.796927011
restoring datafile 00055 to /oradata1/datafile/prod/rcaremagnum_fodata.303.797259137
channel ORA_DISK_4: reading from backup piece /nfshisdb/ORABKP/rman/db_797997673_18198_p1
ORA-19870: error reading backup piece /nfshisdb/ORABKP/rman/db_797997673_18200_p1
ORA-19505: failed to identify file “/nfshisdb/ORABKP/rman/db_797997673_18200_p1”
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-19870: error reading backup piece /nfshisdb/ORABKP/rman/db_797997673_18198_p1
ORA-19505: failed to identify file “/nfshisdb/ORABKP/rman/db_797997673_18198_p1”
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
failover to previous backup
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /oradata1/datafile/prod/newrbtbs.360.742358543
restoring datafile 00008 to /oradata1/datafile/prod/tools.366.742358297
restoring datafile 00011 to /oradata1/datafile/prod/rcaremagnum_data.336.742357289
restoring datafile 00015 to /oradata1/datafile/prod/rcaremagnum_fodata.394.742357835
restoring datafile 00017 to /oradata1/datafile/prod/rcaremagnum_bodata.401.742357283
restoring datafile 00020 to /oradata1/datafile/prod/sadata.370.742358295
restoring datafile 00028 to /oradata1/datafile/prod/lob_data.391.742357911
restoring datafile 00033 to /oradata1/datafile/prod/rcaremagnum_fodata.338.742357289
restoring datafile 00038 to /oradata1/datafile/prod/rcaremagnum_fodata.416.742357283
restoring datafile 00042 to /oradata1/datafile/prod/undotbs2.320.742357281
restoring datafile 00048 to /oradata1/datafile/prod/rcaremagnum_boindex.312.742385097
restoring datafile 00049 to /oradata1/datafile/prod/sysaux.359.796228931
restoring datafile 00052 to /oradata1/datafile/prod/rcaremagnum_fodata.318.797253465
restoring datafile 00056 to /oradata1/datafile/prod/rcaremagnum_foindex.302.797260165
restoring datafile 00058 to /oradata1/datafile/prod/undotbs1.300.797269689
channel ORA_DISK_1: reading from backup piece /ora_backup/rman/db_797911272_18184_p1
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /oradata1/datafile/prod/sysaux.412.742357287
restoring datafile 00009 to /oradata1/datafile/prod/users.367.742358295
restoring datafile 00010 to /oradata1/datafile/prod/rcaremagnum_data.335.742357287
restoring datafile 00013 to /oradata1/datafile/prod/rcaremagnum_fodata.341.742357833
restoring datafile 00014 to /oradata1/datafile/prod/rcaremagnum_fodata.343.742357835
restoring datafile 00019 to /oradata1/datafile/prod/sadata.378.742358199
restoring datafile 00027 to /oradata1/datafile/prod/rcaremagnum_boindex.340.742357709
restoring datafile 00032 to /oradata1/datafile/prod/rcaremagnum_fodata.377.742358199
restoring datafile 00034 to /oradata1/datafile/prod/sadata.376.742358201
restoring datafile 00037 to /oradata1/datafile/prod/rcaremagnum_fodata.323.742357281
restoring datafile 00041 to /oradata1/datafile/prod/undotbs1.321.742357281
restoring datafile 00045 to /oradata1/datafile/prod/rcaremagnum_fodata.328.742357283
restoring datafile 00053 to /oradata1/datafile/prod/rcaremagnum_fodata.411.797254741
restoring datafile 00057 to /oradata1/datafile/prod/rcaremagnum_data.301.797265739
channel ORA_DISK_2: reading from backup piece /ora_backup/rman/db_797911272_18186_p1
channel ORA_DISK_3: starting datafile backupset restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oradata1/datafile/prod/system.361.742358409
restoring datafile 00005 to /oradata1/datafile/prod/newrbtbs.387.742357285
restoring datafile 00016 to /oradata1/datafile/prod/rcaremagnum_bodata.371.742358293
restoring datafile 00022 to /oradata1/datafile/prod/rcaremagnum_foindex.342.742357835
restoring datafile 00023 to /oradata1/datafile/prod/rcaremagnum_foindex.363.742358409
restoring datafile 00026 to /oradata1/datafile/prod/rcaremagnum_boindex.399.742357285
restoring datafile 00030 to /oradata1/datafile/prod/lob_data.329.742357965
restoring datafile 00035 to /oradata1/datafile/prod/rcaremagnum_fodata.402.742357283
restoring datafile 00039 to /oradata1/datafile/prod/rcaremagnum_fodata.264.742357285
restoring datafile 00043 to /oradata1/datafile/prod/rcaremagnum_fodata.337.742357289
restoring datafile 00046 to /oradata1/datafile/prod/newrbtbs1.375.742358815
restoring datafile 00047 to /oradata1/datafile/prod/rcaremagnum_bodata.313.742384637
restoring datafile 00050 to /oradata1/datafile/prod/rcaremagnum_fodata.357.796924001
restoring datafile 00054 to /oradata1/datafile/prod/rcaremagnum_fodata.356.797255811
channel ORA_DISK_3: reading from backup piece /ora_backup/rman/db_797911272_18187_p1
channel ORA_DISK_4: starting datafile backupset restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /oradata1/datafile/prod/newrbtbs.372.742358201
restoring datafile 00004 to /oradata1/datafile/prod/newrbtbs.374.742358201
restoring datafile 00006 to /oradata1/datafile/prod/newrbtbs.362.742358409
restoring datafile 00012 to /oradata1/datafile/prod/rcaremagnum_data.339.742357435
restoring datafile 00018 to /oradata1/datafile/prod/rcaremagnum_bodata.398.742357285
restoring datafile 00021 to /oradata1/datafile/prod/sadata.369.742358295
restoring datafile 00024 to /oradata1/datafile/prod/rcaremagnum_foindex.333.742357287
restoring datafile 00025 to /oradata1/datafile/prod/rcaremagnum_boindex.368.742358295
restoring datafile 00029 to /oradata1/datafile/prod/lob_data.390.742357941
restoring datafile 00031 to /oradata1/datafile/prod/rcaremagnum_fodata.322.742357281
restoring datafile 00036 to /oradata1/datafile/prod/rcaremagnum_fodata.334.742357287
restoring datafile 00040 to /oradata1/datafile/prod/rcaremagnum_fodata.400.742357285
restoring datafile 00044 to /oradata1/datafile/prod/rcaremagnum_fodata.327.742357287
restoring datafile 00051 to /oradata1/datafile/prod/rcaremagnum_fodata.319.796927011
restoring datafile 00055 to /oradata1/datafile/prod/rcaremagnum_fodata.303.797259137
channel ORA_DISK_4: reading from backup piece /ora_backup/rman/db_797911272_18185_p1
ORA-19870: error reading backup piece /ora_backup/rman/db_797911272_18187_p1
ORA-19599: block number 1486928 is corrupt in backup piece /ora_backup/rman/db_797911272_18187_p1
channel ORA_DISK_1: restored backup piece 1
piece handle=/ora_backup/rman/db_797911272_18184_p1 tag=WHOLE_DATABASE_OPEN
channel ORA_DISK_1: restore complete, elapsed time: 01:01:25
channel ORA_DISK_2: restored backup piece 1
piece handle=/ora_backup/rman/db_797911272_18186_p1 tag=WHOLE_DATABASE_OPEN
channel ORA_DISK_2: restore complete, elapsed time: 01:20:30
channel ORA_DISK_4: restored backup piece 1
piece handle=/ora_backup/rman/db_797911272_18185_p1 tag=WHOLE_DATABASE_OPEN
channel ORA_DISK_4: restore complete, elapsed time: 01:31:15
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/30/2012 13:23:37
RMAN-06026: some targets not found – aborting restore
RMAN-06023: no backup or copy of datafile 43 found to restore
RMAN-06023: no backup or copy of datafile 39 found to restore
RMAN-06023: no backup or copy of datafile 35 found to restore
RMAN-06023: no backup or copy of datafile 30 found to restore
RMAN-06023: no backup or copy of datafile 26 found to restore
RMAN-06023: no backup or copy of datafile 23 found to restore
RMAN-06023: no backup or copy of datafile 22 found to restore
RMAN-06023: no backup or copy of datafile 16 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
RMAN>

 

Step 2: Recoverd the database until last archive logs available

[oracle@prod1 rman]$ rman target /
Recovery Manager: Release 10.2.0.4.0 – Production on Thu Nov 1 11:50:57 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: prod (DBID=2755122049, not open)
RMAN> recover database;
Starting recover at 01-NOV-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=113 instance=prod1 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=116 instance=prod1 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=110 instance=prod1 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=111 instance=prod1 devtype=DISK
starting media recovery
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=8554
channel ORA_DISK_2: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=8555
channel ORA_DISK_2: restoring archive log
archive log thread=2 sequence=8556
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=8556
channel ORA_DISK_1: reading from backup piece /ora_backup/rman/al_798011838_18205_p1
channel ORA_DISK_2: restoring archive log
archive log thread=2 sequence=8557
channel ORA_DISK_2: restoring archive log
archive log thread=2 sequence=8558
channel ORA_DISK_2: reading from backup piece /ora_backup/rman/al_798011838_18204_p1
channel ORA_DISK_1: restored backup piece 1
piece handle=/ora_backup/rman/al_798011838_18205_p1 tag=TAG20121030T055717
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
archive log filename=/u01/app/oracle/product/10.2.0/db_1/dbs/arch1_8554_742358737.dbf thread=1 sequence=8554
channel ORA_DISK_2: restored backup piece 1
piece handle=/ora_backup/rman/al_798011838_18204_p1 tag=TAG20121030T055717
channel ORA_DISK_2: restore complete, elapsed time: 00:00:45
archive log filename=/u01/app/oracle/product/10.2.0/db_1/dbs/arch2_8556_742358737.dbf thread=2 sequence=8556
archive log filename=/u01/app/oracle/product/10.2.0/db_1/dbs/arch1_8555_742358737.dbf thread=1 sequence=8555
archive log filename=/u01/app/oracle/product/10.2.0/db_1/dbs/arch2_8557_742358737.dbf thread=2 sequence=8557
archive log filename=/u01/app/oracle/product/10.2.0/db_1/dbs/arch2_8558_742358737.dbf thread=2 sequence=8558
archive log filename=/u01/app/oracle/product/10.2.0/db_1/dbs/arch1_8556_742358737.dbf thread=1 sequence=8556
unable to find archive log
archive log thread=1 sequence=8557
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/01/2012 11:52:30
RMAN-06054: media recovery requesting unknown log: thread 1 seq 8557 lowscn 8556870433
RMAN>

 

Step 3:  Open the database

RMAN> alter database open resetlogs;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 11/01/2012 12:41:16
ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
RMAN> exit
Solution:
This is a bug ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
I have applied patch 7207932 and resolve the issue.

How to Apply patch

I am apply patch only on Node as I restoring rman backup from node1.

[oracle@prod1 7207932]$ cd /u01/app/oracle/product/10.2.0/db_1/OPatch/
[oracle@prod1 7207932]$export PATH=$PATH:/u01/app/oracle/product/10.2.0/db_1/OPatch
[oracle@prod1 OPatch]$ ls -rlt
total 48
-rw-r–r– 1 oracle oinstall 2571 Aug 8 2006 opatch.pl
-rw-r–r– 1 oracle oinstall 19263 Dec 26 2006 emdpatch.pl
-rwxr-xr-x 1 oracle oinstall 6315 Nov 23 2007 opatch
drwxr-x— 4 oracle oinstall 4096 Oct 3 11:07 opatchprereqs
-rw-r–r– 1 oracle oinstall 49 Oct 3 11:07 opatch.ini
drwxr-x— 2 oracle oinstall 4096 Oct 3 11:07 jlib
drwxr-x— 2 oracle oinstall 4096 Oct 3 11:07 docs
[oracle@prod1 OPatch]$ cd –
/home/oracle/psu/7207932
[oracle@prod1 7207932]$ export PATH=$PATH:/u01/app/oracle/product/10.2.0/db_1/OPatch
[oracle@prod1 7207932]$ opatch apply
Invoking OPatch 10.2.0.4.2
Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2012-11-01_14-47-26PM.log
ApplySession applying interim patch ‘7207932’ to OH ‘/u01/app/oracle/product/10.2.0/db_1’
Running prerequisite checks…
OPatch detected the node list and the local node from the inventory. OPatch will patch the local system then propagate the patch to the remote nodes.
This node is part of an Oracle Real Application Cluster.
Remote nodes: ‘srv01-061’
Local node: ‘prod1’
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/oracle/product/10.2.0/db_1’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch ‘7207932’ for restore. This might take a while…
Backing up files affected by the patch ‘7207932’ for rollback. This might take a while…
Patching component oracle.rdbms, 10.2.0.4.0…
Updating archive file “/u01/app/oracle/product/10.2.0/db_1/lib/libserver10.a” with “lib/libserver10.a/kfn.o”
Updating archive file “/u01/app/oracle/product/10.2.0/db_1/lib/libserver10.a” with “lib/libserver10.a/kfnc.o”
Running make for target ioracle
ApplySession adding interim patch ‘7207932’ to inventory
Verifying the update…
Inventory check OK: Patch ID 7207932 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7207932 are present in Oracle Home.
The local system has been patched. You can restart Oracle instances on it.
Patching in rolling mode.
The node ‘prod2’ will be patched next.
Please shutdown Oracle instances running out of this ORACLE_HOME on ‘prod2’.
(Oracle Home = ‘/u01/app/oracle/product/10.2.0/db_1’)
Is the node ready for patching? [y|n]
n
User Responded with: N
ApplySession exits on request
You may exit the patching session and patch remaining nodes later from an un-patched node. Do you want to continue?
Do you want to proceed? [y|n]
n
User Responded with: N
Patching aborted on node “prod2”, remaining nodes are
OPatch failed to propagate the patch to the remote node(s).
Run the patch again on each of the remote node(s) using -local option.
Details: Patching aborted on node “prod2”, remaining nodes are
ApplySession failed: OUI-67081:OPatch failed to propagate the patch to the remote node(s).
Run the patch again on each of the remote node(s) using -local option.
Details: Patching aborted on node “prod2”, remaining nodes are
System intact, OPatch will not attempt to restore the system
OPatch failed with error code 73
[oracle@prod1 7207932]$

Startup mount again

SQL> startup mount pfile='/home/oracle/pfile-1-nov-2012-2.ora';
ORACLE instance started.
Total System Global Area 1048576000 bytes
Fixed Size 2088984 bytes
Variable Size 251662312 bytes
Database Buffers 759169024 bytes
Redo Buffers 35655680 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@prod1 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Nov 1 14:54:26 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn /as sysdba
Connected.
SQL> alter database rename file '+REDO/prod/onlinelog/group_2.260.766360501' to '/archive/oradata/redolog/group_2.260.766360501';
alter database rename file '+REDO/prod/onlinelog/group_2.260.766360501' to '/archive/oradata/redolog/group_2.260.766360501'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile
"+REDO/prod/onlinelog/group_2.260.766360501"

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@prod1 ~]$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Nov 1 14:55:03 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: prod (DBID=2755122049, not open)
RMAN> alter database open resetlogs;
using target database control file instead of recovery catalog
database opened
RMAN>

 

 

SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/archive/oradata/redolog/group_3.256.766359595
/archive/oradata/redolog/group_2.260.766360501
/archive/oradata/redolog/group_1.261.766360835
/archive/oradata/redolog/group_4.257.766359647
/archive/oradata/redolog/prod/onlinelog/o1_mf_5_894o8l51_.log
/archive/oradata/redolog/prod/onlinelog/o1_mf_6_894o8mlk_.log
6 rows selected.
SQL>

Startup 2nd instance
SQL> select instance_name from gv$instance;
INSTANCE_NAME
----------------
prod2
prod1
Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in rman. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s