Oracle | DBMS

Oracle DBMS_DNFS Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Provides an interface to assists in creating a database using files in the backup set by renaming files in the DNFS test database. The new file points to the original file for reads.

AUTHID CURRENT_USER

Data Types TYPE varchar2_table IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;

Dependencies

STANDARD (only)

Documented Yes: Packages and Types Reference

First Available 11.2

Security Model Owned by SYS with EXECUTE granted to the DBA role

Source {ORACLE_HOME}/rdbms/admin/dbmsdnfs.sql

Subprograms

CLONEDB_RENAMEFILE

RESTORE_DATAFILE_PERMISSIONS

UNMOUNTVOLUME

CLONEDB_RENAMEFILE

Renames files in a DNFS database to the new name. The new file points to the original file for reads. dbms_dnfs.clondb_renamefile( srcfile IN VARCHAR2, destfile IN VARCHAR2);

exec dbms_dnfs.renameFile('/imp/oradata/PRD/uwdata_prd6.dbf', '/app/oracle/oradata/DEV/oradata_dev1.dbf');

RESTORE_DATAFILE_PERMISSIONS

Restore datafile read/write permission. If a PDB is not named the default is the current PDB. dbms_dnfs.restore_datafile_permissions(pdb_name IN VARCHAR2 DEFAULT NULL);

exec dbms_dnfs.restore_datafile_permissions('PDBDEV');

UNMOUNTVOLUME

Unmounts a DNFS volume dbms_dnfs.unmountvolume( server IN VARCHAR2, volume IN VARCHAR2);

exec dbms_dnfs.unMountVolume('PERRITO5', '/mnt/UWDATA/NFSDATA');