-------------------------------------------------------------------
How to move a database from one node to another manually in 10g r2
-------------------------------------------------------------------
in rac1 Node:
------------
take ethe backup of ocr & voting disk backup
note down the service name & instance name to recreate.
create pfile manually from spfile
shutdown the database
copy the initfile & pwd file to node 2
As a oracle user srvctl remove database -d hp
in rac2 Node:
------------
create adump,bdump.......folders in the respective location
add the entry in the /etc/oratab file
srvctl add instance -d hp -i hp1 -n rac2
srvctl add database -d hp -o /u01/app/oracle/product/10.2.0/db_1
srvctl add service -d hp -s hp_prod
srvctl start database -d hp
Errors:
------------
in node 2
SQL> startup nomount;
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENERS_HP'
Solution:
------------
change the init parameter in node 2
*.remote_listener=''
--------------------------------------------------------------------------------
