Oracle Scripts
open-menu closeme
Home
All Oracle Scripts
Scripts & Commands
Links icon
Oracle Database Documentation Oracle Enterprise Manager
About
Contact Us
Privacy Satement
🌐
English Português
rss

  • Oracle RMAN Resync Catalog Command Guide

    calendar Feb 1, 2026 / Mar 6, 2026 · 5 min read · Oracle RMAN Database Backup Recovery Catalog DBA Tasks Database Administration Backup and Recovery Oracle Database  ·
    Share on: twitter facebook linkedin copy

    Oracle RMAN Resync Catalog Command Guide Purpose The RESYNC CATALOG command synchronizes the metadata stored in your Oracle RMAN recovery catalog with the current information in the target database control file. This ensures that all backup, restore, and recovery operations use the most accurate and up-to-date database …


    Read More

  • Oracle RMAN Crosscheck Backup Command - Verify Backup Availability

    calendar Jan 31, 2026 / Mar 6, 2026 · 5 min read · Oracle RMAN Backup Database Administration Recovery Manager Backup Validation Database Maintenance Oracle DBA  ·
    Share on: twitter facebook linkedin copy

    Oracle RMAN Crosscheck Backup Command - Verify Backup Availability Purpose The CROSSCHECK BACKUP command is an essential Oracle RMAN (Recovery Manager) tool that verifies whether backup files recorded in the RMAN repository still physically exist on storage media. This command synchronizes the logical records in your …


    Read More

  • Oracle RMAN Reset Database After RESETLOGS Recovery

    calendar Jan 9, 2026 / Mar 6, 2026 · 6 min read · Oracle Database RMAN Database Recovery Backup and Restore Recovery Catalog Database Administration Incomplete Recovery RESETLOGS  ·
    Share on: twitter facebook linkedin copy

    Oracle RMAN Reset Database After RESETLOGS Recovery Purpose The RESET DATABASE command in Oracle Recovery Manager (RMAN) notifies the recovery catalog that a new database incarnation has been created after opening the database with the RESETLOGS option. This command is essential for maintaining synchronization between …


    Read More

  • Oracle RMAN Unregister Database from Recovery Catalog or rc_database

    calendar Jan 8, 2026 / Mar 6, 2026 · 4 min read · Oracle RMAN Recovery Catalog Database Administration Backup Management DBMS_RCVCAT SQL*Plus Database Maintenance rc_database  ·
    Share on: twitter facebook linkedin copy

    Oracle RMAN Unregister Database from Recovery Catalog Purpose Unregistering a database from an Oracle RMAN (Recovery Manager) recovery catalog removes all backup metadata and database information from the catalog repository. This process is essential when a database is decommissioned, no longer needs catalog-based …


    Read More

  • How to Register an Oracle Database with RMAN Catalog

    calendar Jan 7, 2026 / Mar 6, 2026 · 3 min read · Oracle Database RMAN Database Backup Recovery Catalog Database Administration Password File Oracle Scripts Database Registration  ·
    Share on: twitter facebook linkedin copy

    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 More

  • How to Create Oracle RMAN Recovery Catalog Step by Step

    calendar Jan 6, 2026 / Mar 6, 2026 · 5 min read · Oracle RMAN Database Backup Recovery Catalog DBA Database Administration Oracle Scripts Backup Strategy  ·
    Share on: twitter facebook linkedin copy

    How to Create Oracle RMAN Recovery Catalog Step by Step Purpose The Oracle Recovery Manager (RMAN) recovery catalog is a dedicated database schema that stores metadata about backup and recovery operations for one or more target databases. This script demonstrates how to create a recovery catalog by establishing a …


    Read More

  • Display Log Destinations Options for Oracle Data Guard Primary Database

    calendar Jan 5, 2026 / Mar 6, 2026 · 4 min read · Oracle Database Data Guard Database Administration Archive Logs Primary Database Monitoring Scripts SQL Queries High Availability v$archive_dest  ·
    Share on: twitter facebook linkedin copy

    Display Log Destinations Options for Oracle Data Guard Primary Database Purpose This SQL script displays detailed information about all configured archive log destinations on an Oracle Data Guard primary database. The query retrieves critical configuration parameters from the V$ARCHIVE_DEST view, allowing database …


    Read More

  • Oracle Database Log Destinations Monitoring Script for Data Guard

    calendar Jan 4, 2026 / Mar 6, 2026 · 5 min read · Oracle Data Guard Database Monitoring SQL Scripts High Availability Backup Recovery DBA Scripts Oracle Views v$archive_dest_status v$archive_dest  ·
    Share on: twitter facebook linkedin copy

    Oracle Database Log Destinations Monitoring Script for Data Guard Purpose This Oracle SQL script monitors all log destinations in a Data Guard configuration from the primary database. The query provides real-time information about archive log destinations, their status, operational modes, and standby redo log activity. …


    Read More

  • Check Oracle Data Guard Standby Synchronization Status

    calendar Jan 3, 2026 / Mar 6, 2026 · 5 min read · v$log v$archive_dest_status Oracle Data Guard Standby Database Database Monitoring Oracle Views DBA Scripts Sequence Numbers Replication  ·
    Share on: twitter facebook linkedin copy

    How to Check Physical Standby Database Synchronization Physical standby databases in Oracle Data Guard need regular monitoring to ensure they stay synchronized with the primary database. The most effective way to check synchronization status is by comparing the current sequence number on the primary database with the …


    Read More

  • Oracle Logical Standby Apply Stop and Start Commands

    calendar Jan 2, 2026 / Mar 6, 2026 · 3 min read · Oracle Database Data Guard Logical Standby SQL Apply Database Administration Backup Recovery High Availability DBA Commands  ·
    Share on: twitter facebook linkedin copy

    Oracle Logical Standby Apply Stop and Start Commands Purpose The logical standby apply commands control the SQL Apply process in Oracle Data Guard logical standby databases. These commands allow database administrators to stop and start the application of redo log data from the primary database to the logical standby …


    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • 4
    • 5
    • »
    • »»

OracleScripts.com

Your Source for Oracle SQL Scripts
Read More

Recent Posts

  • Oracle Resumable Import Parameters: Monitor and Manage DBA_RESUMABLE
  • Oracle Full Database Export Using a Named Pipe and Gzip Compression in KSH
  • Oracle exp/imp Parameter File: Direct Path User-to-User Data Migration
  • Oracle Database Export and Import to Gzip Through a Named Pipe
  • Oracle RMAN Delete Obsolete Backups with Maintenance Channel
  • LIST BACKUPSET OF DATABASE: Oracle RMAN Command Guide
  • Oracle RMAN Delete Expired Backup: Complete Guide to Repository Maintenance
  • Oracle RMAN REPORT SCHEMA Command: Display Database Files

Categories

SCRIPTS 189 ORACLE RMAN 22 ORACLE BACKUP DATA GUARD 15 ORACLE ADMINISTRATION RAC 12 ORACLE PERFORMANCE AWR 12 ORACLE STRUCTURE TABLESPACE 11 ORACLE STRUCTURE FILES 10 ORACLE STRUCTURE OBJECTS 10 ORACLE ADMINISTRATION SESSION 9 ORACLE ADMINISTRATION ASM 8 ORACLE PERFORMANCE GENERAL 8 ORACLE PERFORMANCE STATISTICS 8 ORACLE PERFORMANCE WAITS 8 ORACLE ADMINISTRATION STATUS 7
All Categories
ORACLE ADMINISTRATION ASM8 ORACLE ADMINISTRATION INIT PARAMETERS3 ORACLE ADMINISTRATION RAC12 ORACLE ADMINISTRATION SESSION9 ORACLE ADMINISTRATION STATUS7 ORACLE ADMINISTRATION USER5 ORACLE BACKUP DATA GUARD15 ORACLE BACKUP IMPORT EXPORT4 ORACLE PERFORMANCE AWR12 ORACLE PERFORMANCE GENERAL8 ORACLE PERFORMANCE LOCKS DML4 ORACLE PERFORMANCE MEMORY3 ORACLE PERFORMANCE QUERY TUNING6 ORACLE PERFORMANCE STATISTICS8 ORACLE PERFORMANCE STATSPACK7 ORACLE PERFORMANCE WAITS8 ORACLE RMAN22 ORACLE STRUCTURE CONSTRAINTS7 ORACLE STRUCTURE FILES10 ORACLE STRUCTURE INDEXES2 ORACLE STRUCTURE OBJECTS10 ORACLE STRUCTURE REDO LOGS3 ORACLE STRUCTURE TABLESPACE11 ORACLE STRUCTURE UNDO4 SCRIPTS189
[A~Z][0~9]

Series

ADMIN GUIDE 189

Tags

ORACLE 133 DATABASE 60 DATABASE ADMINISTRATION 56 SQL 44 ORACLE DATABASE 39 ADMINISTRATION 34 DBA 32 PERFORMANCE 30 PERFORMANCE TUNING 24 RMAN 18 OPTIMIZATION 17 DATA GUARD 14 TROUBLESHOOTING 14 DATABASE BACKUP 13
All Tags
$DATAFILE1 ACCOUNT1 ADMIN1 ADMINISTRATION34 ALL_OBJECTS1 ALTER SESSION1 ANALYZE1 ARCHIVE LOG1 ARCHIVE LOGS6 ARCHIVELOG1 ARCHIVELOG MANAGEMENT1 ASH REPORTS1 ASM2 ASM DISK UTILIZATION1 AUTOMATION1 AUTOTRACE1 AWR10 AWR ANALYSIS1 BACKUP6 BACKUP AND RECOVERY4 BACKUP AND RESTORE1 BACKUP MAINTENANCE1 BACKUP MANAGEMENT6 BACKUP RECOVERY4 BACKUP REPOSITORY1 BACKUP RETENTION1 BACKUP STRATEGY2 BACKUP VALIDATION2 BACKUP VERIFICATION3 BACKUP-COMMANDS1 BASELINE MANAGEMENT3 CHARACTER-SET1 CLUSTER5 CLUSTER MANAGEMENT1 CLUSTERWARE1 COLD-BACKUP1 COMPRESSION2 CONNECTED-USERS3 CONSTRAINTS3 CONTROLFILE1 CORRUPTION DETECTION1 DATA GUARD14 DATA INTEGRITY3 DATA-MANAGEMENT8 DATA-PUMP1 DATABASE60 DATABASE ADMINISTRATION56 DATABASE BACKUP13 DATABASE CLEANUP1 DATABASE FILES1 DATABASE MAINTENANCE4 DATABASE MANAGEMENT3 DATABASE MONITORING10 DATABASE OPTIMIZATION3 DATABASE PERFORMANCE1 DATABASE RECOVERY9 DATABASE REGISTRATION1 DATABASE SIZE1 DATABASE START-UP1 DATABASE TUNING2 DATAFILES5 DBA32 DBA COMMANDS4 DBA SCRIPTS9 DBA TASKS2 DBA TOOLS4 DBA_CONS_COLUMNS1 DBA_CONSTRAINTS6 DBA_DATA_FILES5 DBA_ERRORS1 DBA_EXTENTS1 DBA_FEATURE_USAGE_STATISTICS1 DBA_FREE_SPACE2 DBA_HIST_BASELINE1 DBA_HIST_SNAPSHOT1 DBA_HIST_WR_CONTROL2 DBA_INDEXES1 DBA_LOCK1 DBA_OBJECTS7 DBA_ROLES1 DBA_ROLLBACK_SEGS1 DBA_SEGMENTS9 DBA_SOURCE1 DBA_TAB_COLUMNS1 DBA_TABLES2 DBA_TABLESPACES1 DBA_TEMP_FILES2 DBA_TS_QUOTAS1 DBA_UNDO_EXTENTS1 DBA_USERS1 DBA-RESUMABLE1 DBMS SCHEDULER1 DBMS WORKLOAD REPOSITORY1 DBMS_METADATA1 DBMS_RCVCAT1 DBMS_SCHEDULER1 DBMS_STATS5 DBMS_STATS.GATHER_DATABASE_STATS1 DBMS_STATS.GATHER_SCHEMA_STATS1 DBMS_WORKLOAD_REPOSITORY4 DDL1 DEVELOPMENT1 DIAGNOSTICS1 DISASTER RECOVERY1 DISK GROUP CREATION1 DISK INFORMATION5 DISK SPACE ANALYSIS1 DISKGROUP4 ERROR RESOLUTION1 EXECUTION PLAN1 EXPLAIN-PLAN2 EXPORT2 EXPORT-IMPORT1 EXTERNAL REDUNDANCY1 FAL1 FEATURES1 FREE SPACE1 GAP RESOLUTION1 GATHER_SYSTEM_STATS1 HASH1 HIGH AVAILABILITY5 HOT-BACKUP2 I/O1 IMPDP1 IMPORT2 IMPORT-EXPORT1 INCOMPLETE RECOVERY1 INDEX1 INSTALLED3 JAVA1 JOB SCHEDULING1 KSH1 LAST-ACTIVITY1 LATCH1 LATCH CONTENTION1 LINUX1 LOG MANAGEMENT1 LOGICAL STANDBY1 MAINTENANCE1 MAINTENANCE TASKS1 MANAGEMENT8 MANAGING10 MEMORY1 MEMORY MANAGEMENT1 MEMORY TUNING1 MIGRATION1 MODIFY1 MONITORING12 MONITORING SCRIPTS1 MRP1 NLS_DATABASE_PARAMETERS1 OBJ$1 OBJECTS6 OIFCFG1 OPTIMIZATION17 OPTIMIZER STATISTICS1 ORACHECK1 ORACLE133 ORACLE - DATABASE ADMINISTRATION - SQL - DBA_CONSTRAINTS1 ORACLE ADMINISTRATION4 ORACLE ASM6 ORACLE BACKUP1 ORACLE BROKER1 ORACLE CLUSTERWARE11 ORACLE COMMANDS1 ORACLE CRS9 ORACLE DATABASE39 ORACLE DBA11 ORACLE DIAGNOSTICS1 ORACLE PERFORMANCE2 ORACLE RMAN3 ORACLE RMAN REPORTING1 ORACLE SCRIPTS3 ORACLE TUNING1 ORACLE VIEWS3 ORACLE-ADMIN1 ORACLE-EXPORT1 OSUSER1 PARAMETERS2 PASSWORD FILE1 PEFORMANCE1 PERFORMANCE30 PERFORMANCE ANALYSIS4 PERFORMANCE OPTIMIZATION3 PERFORMANCE TUNING24 PERFORMANCE-MONITORING8 PGA1 PHYSICAL STANDBY1 PL SQL1 PL/SQL5 PLSQL1 POINT-IN-TIME RECOVERY1 PRIMARY DATABASE2 PRIVILEGES1 PROCEDURE2 QUERY1 QUERY ANALYSIS1 QUERY OPTIMIZATION3 QUERY-TUNING2 QUOTAS1 RAC7 RC_DATABASE1 RDBMS1 RECOVERY5 RECOVERY CATALOG5 RECOVERY MANAGER10 REDO LOGS1 REDO TRANSPORT1 REPLICATION2 RESETLOGS1 RESOURCE OPTIMIZATION3 RETENTION POLICY3 RMAN18 RMAN COMMANDS1 ROLE PRIVILEGES1 ROLE_SYS_PRIVS1 ROLE_TAB_PRIVS1 SCHEMA SPACE USED1 SCRIPTING1 SCRIPTS6 SECURITY1 SEGMENTS3 SEQUENCE NUMBERS1 SESSION ANALYSIS2 SESSION-PID1 SESSIONS1 SESSIONS-SORTED1 SHARED POOL1 SHELL-SCRIPTING2 SHOW2 SHOW ROLES1 SHOW_TABLE_ROLE_PRIVILEGES1 SHOW-USER-SQL5 SNAPSHOT MANAGEMENT4 SNAPSHOTS1 SPACE USAGE1 SPACE USED1 SPACE-MANAGEMENT1 SPFILE1 SQL44 SQL APPLY1 SQL COMMANDS5 SQL OPTIMIZATION1 SQL PERFORMANCE2 SQL PLUS1 SQL QUERIES3 SQL QUERY3 SQL SCRIPTS9 SQL STATISTICS1 SQL TUTORIAL1 SQL*PLUS1 SRVCTL3 STANDBY DATABASE7 STANDBY LOGS1 START4 START-UP TIME1 STATISTICS3 STATISTICS GATHERING1 STATISTICS MANAGEMENT2 STATSPACK7 STOP4 STORAGE2 STORAGE CAPACITY MONITORING1 STORAGE MANAGEMENT8 STORAGE OPTIMIZATION1 SYSTEM PERFORMANCE1 TABLE1 TABLESPACE10 TEMP2 TIME MODEL STATISTICS1 TRACING2 TRANSACTIONS1 TROUBLESHOOTING14 TUNING8 UNDO_RETENTION1 UNIX1 USAGE2 USED SPACE1 USER4 USER SPACE1 USER$1 USERS2 UTLXPLS1 V$ACTIVE_SESSION_HISTORY1 V$ARCHIVE_DEST2 V$ARCHIVE_DEST_STATUS2 V$ARCHIVED_LOG1 V$ASM_OPERATION1 V$BACKUP1 V$CONTROLFILE3 V$DATABASE2 V$DATAFILE7 V$DB_CACHE_ADVICE1 V$FILESTAT1 V$INSTANCE1 V$LOCK2 V$LOCKED_OBJECT1 V$LOG4 V$LOGFILE5 V$MANAGED_STANDBY1 V$PARAMETER2 V$PROCESS2 V$SEGMENT_STATISTICS1 V$SESS_TIME_MODEL1 V$SESSION12 V$SESSION_LONGOPS1 V$SESSION_WAIT1 V$SESSTAT1 V$SGASTAT2 V$SQLAREA8 V$STANDBY_LOG1 V$STATNAME2 V$SYS_TIME_MODEL1 V$SYSSTAT2 V$SYSTEM_EVENT2 V$TEMPFILE3 V$TRANSACTION1 V$WAITSTAT1 VDATAFILE2 WORKLOAD REPOSITORY3 X$BH1 X$KCBFWAITV1
[A~Z][0~9]
OracleScripts.com

Copyright  ORACLESCRIPTS.COM. All Rights Reserved

to-top