dataguard implementation on same machine(windows -oracle 11g)
774768Jul 1 2010 — edited Jul 6 2010Hello Guys
Can you help me i am setting up datagurad for testing on windows same machine primary and standby have below issues
oracle 11g (both primary and standby on same windows machine different drives)
I followed steps as
1)installed 2 oracle on same machine different drives
2)for instance to be used as standby (drop database)
3)from primary sent datafiles,standby controlfile,init file to standby location/directories
modified init file for standby,rename datafiles
4)at primary modified init file
5)modified listener and tnsnames.ora files for both primary and seconday
6)created password file and copied same to oracle_home/database both primary and secondary
7 open primary and
for standby:
startup nomount
alter database mount standby database;
alter database recover managed standby database disconnect from session;
8 it work without any issue but recovery not taking place below error in alert of primary
ORA-01031: insufficient privileges
PING[ARC1]: Heartbeat failed to connect to standby 'FC_LOCALTES'. Error is 1031.
1)on standby v$instance showing output database role as primary for standby database
(is it ok or v$instance on standby database should show database role as standby)
please let me know where i am going wrong