Oracle | DBMS

Oracle DBMS_DNFS Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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

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');