Mir Sayeed Hassan – Oracle Blog

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

Configure the Multiple Listener Port in Oracle Database

Posted by Mir Sayeed Hassan on October 2nd, 2017

Configure the Multiple Listener Port in Oracle DB & Tested in our Environment

Configure Port 1521 – Default port

Configure Port 1522   – Port Added by request from client

$cd $ORACLE_HOME/network/admin/vi listener.ora
 

LISTENER1 =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
 (ADDRESS_LIST =
 (ADDRESS =
 (PROTOCOL... 
Read more..

Posted in DBA Administration | Comments Off on Configure the Multiple Listener Port in Oracle Database

Expdp from Higher version 12c (12.1.0.2) to lower version 11g (11.2.0.4)

Posted by Mir Sayeed Hassan on October 2nd, 2017

Expdp from Higher version 12c (12.1.0.2) to lower version 11g (11.2.0.4)

Export on 12c (12.1.0.2)   – Tested in our env : 10.20.0.82

SQL> select instance_name,version from v$instance;

INSTANCE_NAME    VERSION 
---------------- -----------------
... 
Read more..

Posted in Datapump (Expdp/Impdp) | Comments Off on Expdp from Higher version 12c (12.1.0.2) to lower version 11g (11.2.0.4)

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

« Previous Entries
Next Entries »