How to find alert file location in Oracle

There are many ways to find alert file location but i have simplified some ways and pasted below: SQL>show parameter dump; or SQL>show parameter background_dump_dest; or SQL>show parameter diag; or SQL>select value from v$diag_info where name=’Diag Trace’; or From server level you can fire below command: $ locate alert_dbname

Using RMAN Incremental Backups to Refresh a Standby Database

On DR fire below command: If log apply services are running, cancel them as shown below: alter database recover managed standby database cancel; Take Current SCN number from standby database: select current_scn from v$database; On DR side fire below command and see the checkponit_change and checkpoint date for Information: set numformat 9999999999999 select FILE#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME […]

Fast Insert and Delete operation method in Oracle

Performing the insert and delete operation in short span of time if one wants to perform bulk load of insert or delete operation on a table (Oracle Database). Following steps needs to be followed for carrying out the activity: 1. Mark the Indexes unusable 2. Disable primary key, if any 3. Do an Delete 4. […]

How to find hostname from ip in linux

We can find hostname from ip-address in multiple ways but some of useful and short commands are mentioned below: $ nslookup <ip> or $ host <ip> Example: test1@dev[~]$ nslookup Server: Address: name = or test1@dev[~]$ host domain name pointer Above marked in green is hostname

How to check database is in cluster

Fire below command and if ‘Value’ column display as TRUE then you are accessing a cluster database and if it FALSE your database is not in Cluster. SQL> select name, value from v$parameter where name=’cluster_database’; NAME                      VALUE ———————   ——————— cluster_database     TRUE

Fariddin Shaikh's Oracle DBA Blog © 2016 Being DBA