Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Errors while configuring oracle datagurard --solution 11gr2

1)two server std_by
SQL> recover managed standby database disconnect from session;
Media recovery complete.
SQL> alter database open;
alter database open
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/home/oracle/k2/oradata/data/system01.dbf'

don't open  primdb when taking backup or after took stand control file because scn mismatch that is why error occurs

SQL> recover managed standby database disconnect from session;
ORA-01153: an incompatible media recovery is active
Solution :
alter database recover managed standby database cancel;
alter database recover managed standby database using current logfile disconnect;

3)prim_db alert_log
 Heartbeat failed to connect to standby 'k2tns'. Error is 1031.

Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
      returning error ORA-16191

Solution :
serv 1:-
export ORACLE_SID=k1
orapwd file=orapwk1 password=sys force=y

cp $ORACLE_HOME/dbs/orapwk1 /home/oracle/orapwk2
cp $ORACLE_HOME/dbs/orapwk1 /home/oracle/orapwk3

scp /home/oracle/orapwk2   oracle@
scp /home/oracle/orapwk3   oracle@

rm orapwk2
export ORACLE_SID=k2      
mv /home/oracle/orapwk2 $ORACLE_HOME/dbs

rm orapwk3
export ORACLE_SID=k3
mv /home/oracle/orapwk3 $ORACLE_HOME/dbs

4)Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2

All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-04-26_12-25-06PM. Please wait ...[oracle@server2 database]$ Oracle Universal Installer, Version Production

[oracle@server2 ~]$ vi /etc/redhat-release
Red Hat Enterprise Linux Server release 4 (Tikanga)


Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

7 Steps to configure BDR replication in postgresql

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

PostgreSQL Monitoring Tools

PostgreSQL pgBadger