Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

errors while configuring oracle dataguard and solution

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'

solution:- don't open  primdb after  taken conrolfile backups and data backups
           u need to open prm_db after stdby db opened

2)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 find the server is whether standby (slave) or primary(master) in Postgresql replication ?

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

Postgres Streaming Replication Configuration

vacuumlo - removing large objects orphans from a database PostgreSQL