Oracle 19c Physical standby DataGuard
Introduction This article, will cover Oracle 19c restart data-guard physical standby configuration, but before we start, you need to have two oracle 19c restart servers one as Primary server and…
Introduction This article, will cover Oracle 19c restart data-guard physical standby configuration, but before we start, you need to have two oracle 19c restart servers one as Primary server and…
Check the status of online or offline for datafile in Oracle Check the status of datafile Select file#, status from v$datafile; OR SELECT FILE_NAME,ONLINE_STATUS FROM DBA_DATA_FILES; Take the data file…
Check the Undo tablespace total, free and used space usage in Oracle Check the undo tablespace total, free and used space(Size in MB) in Oracle SELECT a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB…
Check datafiles and tablespace information in Oracle Check information about datafiles SQL> select * from dba_data_files; SQL> select * from v$datafile; Check information about tablespace SQL> select * from dba_tablespaces SQL>…
Find the date and patch number applied in Oracle Database. List the patches applied in Oracle Database Go to directory CD %ORACLE_HOME%\OPatch opatch lspatches List the patches with lsinventory –…
Check SGA total size and free space usage in Oracle Check the Usage of SGA select round(used.bytes /1024/1024 ,2) used_mb , round(free.bytes /1024/1024 ,2) free_mb , round(tot.bytes /1024/1024 ,2) total_mb…
Check and Change Default Tablespace for User in Oracle Check the User default tablespace select username,default_tablespace from dba_users where username = ‘MDSYS’; USERNAME DEFAULT_TABLESPACE ——– —————— MDSYS SYSAUX In this…
Monitor the gap between data guard physical Standby with email alert Create a database link between the primary and standby link: — Create a database line on primary server linking…
ORA-1653: unable to extend table HR.TEST by 8192 in tablespace DATA_1 An error occurs during the insertion operation: ORA-1653: unable to extend table HR.TEST by 8192 in tablespace DATA_1 Error:…
Useful SQL script for Data guard environment Check the data guard information on primary and Standby SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE Check the error or…