Results for “dbms_backup_restore”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

SYS.DBMS_BACKUP_RESTORE is an Oracle-supplied, SYS-owned PL/SQL package body that exposes the low-level primitives used by Recovery Manager (RMAN) and related backup utilities to perform physical backup, restore, and recovery operations against an Oracle database. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package underpins the backup and cloning infrastructure on which the applications tier depends. Although the package is not an EBS application object, EBS DBAs and cloning utilities invoke its functionality indirectly whenever a hot backup, cold backup, or Rapid Clone operation is executed against the EBS database.

The ETRM metadata records the object as VALID in schema SYS and classifies the API family as OTHER, reflecting its status as a database kernel utility rather than an EBS application programming interface. Its role is strictly infrastructural: it provides device allocation, backup set creation, file copy, and control file orchestration so that higher-level tools can coordinate consistent backups of the datafiles, archived redo logs, and control files that constitute an EBS database.

Key Procedures and Functions

The documented interface comprises 355 procedures and functions. Representative members illustrate the package's responsibilities:

  • DEVICEALLOCATE, DEVICEDEALLOCATE, DEVICECOMMAND, DEVICESTATUS — manage the allocation and control of backup devices (tape or disk channels) used during RMAN operations.
  • BACKUPDATAFILE, BACKUPDATAFILECOPY, BACKUPSETDATAFILE — initiate and populate backups of database datafiles into backup sets or image copies.
  • BACKUPARCHIVEDLOG, BACKUPSETARCHIVEDLOG, COPYARCHIVEDLOG — back up or image-copy archived redo logs, essential for point-in-time recovery of EBS.
  • BACKUPCONTROLFILE, COPYCONTROLFILE — capture control file backups and copies that record the physical structure of the EBS database.
  • BACKUPPIECECREATE, BACKUPBACKUPPIECE, BACKUPSTATUS, BACKUPCANCEL — orchestrate backup piece creation, track progress, and support cancellation.
  • COPYDATAFILE, COPYDATAFILECOPY — perform image copies of datafiles.
  • REINIT, SETLIMIT — reset package state and establish operational limits for a session.

Parameter lists are intentionally undocumented here; the package is not a supported application interface and should not be called directly with user-constructed arguments.

Tables Accessed

The ETRM metadata does not enumerate base tables or APPS synonyms referenced by the package body; no application tables are documented. The package operates primarily against the control file and internal kernel structures, and it references SYS-owned objects including DBMS_APPLICATION_INFO, DBMS_SYS_ERROR, DUAL, PLITBLM, and STANDARD. It is not referenced by any application database object, confirming its isolation from the EBS data model.

Usage Notes

DBMS_BACKUP_RESTORE is invoked internally by RMAN and by Oracle utilities such as the Enterprise Manager backup agents and the Rapid Clone process used across EBS 12.1.1 and 12.2.2. EBS administrators do not call this package from Forms, concurrent programs, or custom PL/SQL; instead they rely on RMAN or on the standard EBS backup and cloning scripts that in turn drive the package. Given that the package body is SYS-owned, proprietary, and unsupported for direct invocation, customization should be avoided. Any use should be confined to documented RMAN workflows, and the package's state should be reinitialized between independent backup sessions through the REINIT procedure to prevent cross-session contamination.