physical standby

solved ORA-01187 ORA-01110 in standby database

We got the below error on a active standby databse ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 73: ‘/u02/oracle/oradata/test/temp_01.dbf’ so the sloutions is as…

Read More

The Data Guard status of xxxx is Error ORA-03135: connection lost contact from Primary database

We have got a error from OEM “The Data Guard status of xxxx is Error ORA-03135: connection lost contact.”After that, we have resolve the error using below steps, Step:1 Check the command…

Read More

Error: Primary database is in MAXIMUM PERFORMANCE mode

Error: RFS[4]: No standby redo logfiles of size 102400 blocks exist Fix: In standby database, standby redo logs on the standby database and the online redo logs on the primary database are…

Read More

ORA-28000 “the account is locked” in the standby database

Scenario: ======= The user attempts to logon and gets an error ORA-28000 “the account is locked” in the primary database which is configure with Dataguard.  The database administrator unlock this user’s…

Read More

Minimal downtime rolling database upgrade to 12c Release 1

Minimal downtime rolling database upgrade to 12c Release 1 This note describes the procedure used to perform a rolling database upgrade from 11.2.0.3 to Oracle 12c Release 1 using a…

Read More