ORACLE DBA BLOG

 1) Basic information of database (primary or standby) SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; 2) Check for messages/errors SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS; 3) To display current status information for specific physical standby database background processes. SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY ; 4) Show received archived logs on physical standby -Run this query on physical standby SQL> select registrar, creator, thread#, sequence#, first_change#, next_change# from v$archived_log; 5) To check the log status  select 'Last Log applied : ' Logs, to_char(next_time,'DD-MON-YY:HH24:MI:SS') Time from v$archived_log where sequence# = (select max(sequence#) from v$archived_log where applied='YES') union select 'Last Log received : ' Logs, to_char(next_time,'DD-MON-YY:HH24:MI:SS') Time from v...

When you use the Database Configuration Assistant to create a database, Oracle automatically creates the data dictionary.  Thereafter, whenever the database is in operation, Oracle updates the data dictionary in response to every DDL statement. The data dictionary base tables are the first objects created in any Oracle database. They are created in the  SYSTEM  tablespace and must remain there. The data dictionary base tables store information about all user-defined objects in the database. catalog.sql ---> Creates the data dictionary and public synonyms for many of its views. Grants   PUBLIC   access to the synonyms catproc.sql --> Runs all scripts required for, or used with, PL/SQL catclust.sql--> Creates Oracle Real Application Clusters data dictionary views Script Name Needed For Run By Description catblock.sql Performance management SYS Creates views that can dynamically display lock dependency graphs caths.sql ...

EXP_TAB_cmprss.sh $Header: EXP_TAB_cmprss.sh   # *====================================================================================+ # |  Author - DBACLASS ADMIN TEAM # |                                                       | # +====================================================================================+ # | # | FILENAME # |     EXP_table_bkp_cmprss_dbaclass.sh # | # | DESCRIPTION # |     Daily Export backup script of a list of table # | PLATFORM # |     Linux/Solaris   # +===========================================================================+ #!/bin/bash echo Set Oracle Database Env ...