Mir Sayeed Hassan – Oracle Blog

Verify Primary & Standby Database are sync & applied logs

ON PRIMARY:

col MEMBER FORMAT A100
set linesize 200

sql> SELECT   a.thread#,  b. last_seq, a.applied_seq, a. last_app_timestamp, b.last_seq-a.applied_seq   ARC_DIFF FROM (SELECT  thread#, MAX(sequence#) applied_seq, MAX(next_time) last_app_timestamp FROM gv$archived_log... 
Read more..			

Move the datafiles (System, SYSAUX, UNDOTBS, TEMP, REDO LOGFILES) into the new location:

========

USERS TBS

=========

Note:

It does not require the database to be bonce or in mount stage for USERS tablespace

Get the datafile location exist

SQL> select name from v$datafile;     (Old Location of al the... 
Read more..			

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...