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 1st 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… Read more..

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