ORACLE

You can find all standby databases for a primary database in data guard by using one of the queries below. [crayon-67d4ed9c03e13993929590/] or [crayon-67d4ed9c03e1a183825062/] Standby -> …

Check Data Guard Recovery Mode You can find database_mode, recovery mode and protection mode of your Data Guard as follows. [crayon-67d4ed9c0874c431828773/] Data Guard Recovery Modes …

This article contains scripts about checking Standby redo logs. You can use the below queries to check standby redo logs in Oracle. [crayon-67d4ed9c08941957123046/] or [crayon-67d4ed9c08946753898479/]

You can read this document to access the tables in the MSSQL database using the DBLINK architecture from the Oracle database. Please test in the …

When you create backups with rman in Oracle 12.2 databases, an “RMAN-10038: database session for channel d1 terminated unexpectedly” error occurs. You see the error …

You can run rman in debug mode to get more detailed information about Rman operations. In this way, we get more detailed information about a …

With the new feature that introduced with Oracle 18c, it is now possible to stop the running query in a session without terminating session. You …

In Oracle 12c and later versions, auditing is possible with Unified audit as well as standard auditing. This feature allows role-based auditing. It is possible …

With Oracle 12.2.0.1, SQL * Plus is capable of displaying the result of a query as CSV. Its use is as follows. [crayon-67d4ed9c0db87349010836/] Options DELIMI[TER] …

This article contains information about Oracle User Operations like creating a new Oracle user, authorizing, changing password and dropping Oracle User. Create Oracle User CREATE …