Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39

  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

    Database Administrators

Physical standby data Guard Failover steps

Posted by Mir Sayeed Hassan on October 2nd, 2017

Manually Perform Physical standby data Guard Failover steps

In case of worst situation with data guard primary database, or not available for production than we can activated standby database as a primary production database.

standby Database:

Verify...

Read more..

Posted in DataGuard (DR) | Comments Off on Physical standby data Guard Failover steps

Perform the expdp (fulldb/schema/table) by using the ASM Storage

Posted by Mir Sayeed Hassan on October 2nd, 2017

Perform the expdp (fulldb/schema/table) by using the ASM Storage

Step 1 – Create the Directory in ASM location (Example – +DATA/mir_exp)

[grid@asmdb ~]$ asmcmd
ASMCMD> ls
 CRS/
 DATA/
 FRA/
ASMCMD> cd DATA
ASMCMD> mkdir mir_exp
ASMCMD>... 
Read more..

Posted in Datapump (Expdp/Impdp) | Comments Off on Perform the expdp (fulldb/schema/table) by using the ASM Storage

Register the archivelog Manually for single & multiple/bulk archivelog

Posted by Mir Sayeed Hassan on October 2nd, 2017

Register the archivelog Manually for single & multiple/bulk  archivelog in Oracle Database

Fallow the below simple steps to perform the operation

Register the archive log manually in a database

sql> alter database register logfile '/u01/app/oracle/FRA/arch_1_101.arc';

Bulk register the archive lo

rman> catalog start with '/var/arch';

Posted in RMAN | Comments Off on Register the archivelog Manually for single & multiple/bulk archivelog

RMAN Backup Compressions tested in our Test ENV

Posted by Mir Sayeed Hassan on October 2nd, 2017

RMAN Backup Compressions tested in our Test ENV

RMAN Backup Compressions

The compression levels are BASIC, HIGH, MEDIUM and LOW

To use this option, we can run the following RMAN commands

RMAN>... 
Read more..

Posted in RMAN | Comments Off on RMAN Backup Compressions tested in our Test ENV

Verify Primary & Standby Database are sync & applied logs

Posted by Mir Sayeed Hassan on October 2nd, 2017

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

Posted in DataGuard (DR) | Comments Off on Verify Primary & Standby Database are sync & applied logs

Move the datafile into the new location

Posted by Mir Sayeed Hassan on September 27th, 2017

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

Posted in DBA Administration | Comments Off on Move the datafile into the new location

« Previous Entries
Next Entries »