Mir Sayeed Hassan – Oracle Blog

Failover by using the DGMGRL

On Primary Database

[oracle@pr ~]$ !sq
sqlplus / as sysdba

SQL>  SELECT NAME,DB_UNIQUE_NAME, OPEN_MODE,DATABASE_ROLE FROM V$DATABASE;
NAME      DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE
-------- ------------------------------ --------------------... 
Read more..			

Perform the Incremental backup from the primary database

Take the current control file backup for the standby database from the primary db

• As shown below:

$rman target /
RMAN> backup current controlfile for standby format '/tmp/stby.ctl';

Than give the full permisstion for the stby.ctl...
Read more..

RAC Testing Scenario in our Test ENV

Node 1 – 10.20.0.90

Node 2 – 10.20.0.91

FAILURE SCENARIO:

1 – Test case is node failure

It can be planned, unplanned or all the nodes it could be any scenario

Let us start the workload & shutdown the node

The expected result will be:

• Resources...
  Read more..

Error while starting of Oracle Single instance ASM Database

1^st Error – Starting ASM

[code] [root@asmdb ~]#su – grid [/code]

[code] [grid@asmdb ~]$ asmcmd [/code]

Connected to an idle instance

[code] ASMCMD> ls [/code]

ASMCMD-08102: no connection to ASM; command requires ASM...

ORA-01110: data file 1: ‘/oradata/datafiles/system01.dbf’

Error occur while restoring the database from the backup of RMAN

RMAN> alter database open resetlogs;

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
 RMAN-00569: ===============... 
Read more..			

ORA-Error – 01111/ORA-01110/ORA-01157 name the datafile is unknown

Cause:

This error will occur on standby database after adding the new datafile into primary database

Solution: If you’re standby database is file system storage

View the error in alert log

[oracle@db-std ~]$ cd /u01/app/oracle/diag/rdbms/teststdby/teststdby/trace/