V$DATABASE
Run a Consistent Export with expdp FLASHBACK_TIME
Jul 10, 2026 / · 10 min read · Oracle DBA Data Pump expdp FLASHBACK_TIME Consistent Export Oracle Administration Undo Retention Oracle Backup dba_free_space v$database v$parameter v$undostat ·Run a Consistent Export with expdp FLASHBACK_TIME Purpose A schema export reads many tables over a span of time, and for schemas where rows in one table reference rows in another, you usually want every table in the dump to reflect the same moment. Community Data Pump documentation puts it directly: expdp exports are …
Read MoreOracle: Get Current SCN with DBMS_FLASHBACK
Mar 8, 2026 / · 5 min read · oracle scn flashback dba sql database recovery read consistency admin scripts dba_tab_privs v$database dbms_flashback ·How to Find the Current SCN in Oracle Database Using DBMS_FLASHBACK What number marks "now" inside an Oracle database? The System Change Number (SCN) does. One call to DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER returns it from any session that has EXECUTE on the package. What Is an SCN? The System Change Number (SCN) is a …
Read MoreDB_FLASHBACK_RETENTION_TARGET: Set Oracle Flashback Window
Mar 6, 2026 / · 5 min read · Oracle Flashback DBA Recovery Database Administration ALTER SYSTEM Fast Recovery Area Point In Time Recovery v$database ·Set Oracle Flashback Database Retention Target with ALTER SYSTEM Oracle Flashback Database lets you rewind your entire database to a past point in time without a full restore. The command ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET controls how far back in time that rewind can go. What This Command Does The …
Read MoreOracle Flashback: Enable with Shutdown, Mount, ALTER
Mar 5, 2026 / · 6 min read · Oracle Flashback DBA Database-Recovery Oracle-Backup SQL Data-Protection Admin-Guide v$database v$flashback_database_log ·How to Enable Oracle Database Flashback: Shutdown, Mount, and ALTER Commands Oracle Flashback Database is one of the most powerful data protection tools available to a DBA. This guide walks you through the four commands needed to turn on Oracle Flashback — from a clean shutdown to opening the database in flashback …
Read MoreHow to Register an Oracle Database with RMAN Catalog
Jan 7, 2026 / · 10 min read · Oracle Database RMAN Database Backup Recovery Catalog Database Administration Password File Oracle Scripts Database Registration v$database ·How to Register an Oracle Database with RMAN Catalog Purpose The RMAN register database command adds a target database to the recovery catalog so that Recovery Manager can track and maintain backup metadata. This allows RMAN to store backup information, recovery points, and database structure details in a central …
Read MoreHow to Check Oracle Database Role Using V$DATABASE View
Jan 1, 2026 / · 3 min read · Oracle Data Guard DBA SQL Query Database Administration V$DATABASE Standby Database Primary Database ·How to Check Oracle Database Role Using V$DATABASE View Purpose The SQL query SELECT database_role FROM v$database is a fundamental Oracle Database command used to determine the current operational role of a database instance. This query is essential for Database Administrators (DBAs) working with Oracle Data Guard …
Read MoreOracle Data Guard Standby Database Startup Commands
Oct 23, 2025 / · 6 min read · Oracle Data Guard Standby Database Database Recovery High Availability Backup DBA SQL Commands v$archive_dest_status v$database ·Oracle Data Guard Standby Database Startup Commands Oracle Data Guard standby database startup commands enable database administrators to initialize and maintain physical standby databases that provide disaster recovery and high availability for production systems. These three essential commands work together to bring …
Read MoreOracle Statspack: List Snapshots with stats$snapshot
Sep 4, 2025 / · 3 min read · oracle statspack performance monitoring dba sql snapshots administration v$database ·How to List Oracle Statspack Snapshots with SQL Query This Oracle Database query provides a simple way to view all Statspack snapshots stored in your database. Statspack is Oracle's built-in performance monitoring tool that captures database statistics at regular intervals, helping database administrators analyze …
Read MoreOracle DBA SQL Scripts and Database Commands
Oracle SQL Scripts and Database Commands 23c 21c 19c 18c 12c 11g 10g 9i 8i We are in the process of building a list of simple scripts used every day by DBA and others. If you have your own scripts you reuse in a text file on you workstation please send it to us. To look at other scripts see the Oracle Scripts Tag …
Read More