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

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

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

PostgreSQL pgBadger

Migrating From Oracle to PostgreSQL using ora2pg open source tools

PostgreSQL Pgbadger Installation On Linux