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
This package contains the interface to the kernel for creating and restoring backups of datafiles and archived logs. Backups can exist on sequential media such as tape.
The kernel will read and write backups, but it is the responsibility of the caller to catalog the names of the backups.
-- This record captures block statistics for a file validation.
TYPE blockStat_t IS RECORD (
filetype BINARY_INTEGER, -- KSFD file type
dfNUMBER NUMBER, -- datafile NUMBER
thread BINARY_INTEGER, -- archived log thread
sequence NUMBER, -- archived log sequence
highscn NUMBER, -- highest scn found in the datafile
examined NUMBER, -- total blocks examined
corrupt NUMBER, -- total blocks that are marked corrupt
empty NUMBER, -- total empty blocks
data_proc NUMBER, -- total data blocks that are processed
data_fail NUMBER, -- total data blocks that failed
index_proc NUMBER, -- total index blocks that are processed
index_fail NUMBER, -- total index blocks that failed
other_proc NUMBER, -- total other blocks that are processed
other_fail NUMBER, -- total other blocks that failed
spare1 NUMBER,
spare2 NUMBER,
spare3 NUMBER,
spare4 NUMBER,
spare5 NUMBER,
spare6 NUMBER,
spare7 DATE,
spare8 DATE);
-- Table of block statistics
TYPE blockStatTable_t IS TABLE OF blockStat_t
INDEX BY BINARY_INTEGER;
-- Record to describe a block range
TYPE blockRange_t IS RECORD (
blkNUMBER NUMBER,
dfNUMBER NUMBER,
range NUMBER,
spare1 NUMBER,
spare2 NUMBER,
spare3 NUMBER);
-- Table of block ranges
TYPE blockRangeTable_t IS TABLE OF blockRange_t
INDEX BY BINARY_INTEGER;
TYPE register_auxdfc IS RECORD (
fname VARCHAR2(1024),
dfnumber NUMBER,
tsnum NUMBER,
blksize NUMBER,
spare1 NUMBER DEFAULT NULL,
spare2 NUMBER DEFAULT NULL,
spare3 NUMBER DEFAULT NULL,
spare4 NUMBER DEFAULT NULL,
spare5 NUMBER DEFAULT NULL);
TYPE register_auxdfc_list IS TABLE OF register_auxdfc
INDEX BY BINARY_INTEGER;
TYPE nrecs_array IS TABLE OF BINARY_INTEGER
INDEX BY BINARY_INTEGER;
Dependencies
DBMS_APPLICATION_INFO
DBMS_FEATURE_RMAN_MEDIUM
DBMS_TTS
DBMS_FEATURE_BACKUP_ENCRYPTION
DBMS_FEATURE_RMAN_TAPE_BACKUP
DUAL
DBMS_FEATURE_RMAN_BACKUP
DBMS_FEATURE_RMAN_ZLIB
PLITBLM
DBMS_FEATURE_RMAN_BASIC
DBMS_IR
V$ARCHIVED_LOG
DBMS_FEATURE_RMAN_BZIP2
DBMS_SERVER_ALERT
V$DATABASE_INCARNATION
DBMS_FEATURE_RMAN_DISK_BACKUP
DBMS_STREAMS_TBS_INT
V$INSTANCE
DBMS_FEATURE_RMAN_HIGH
DBMS_SYS_ERROR
X$KCCFN
DBMS_FEATURE_RMAN_LOW
Documented
No
Exceptions
Error Code
Reason
ORA-00230
snapshot_enqueue_busy
ORA-00231
snapshot_name_not_set
ORA-00232
snapshot_not_made
ORA-00235
inconsistant_read
ORA-19551
The requested device is allocated to another session, or all devices of the requested type are busy
ORA-19557
The OSD returned an error
ORA-19560
An invalid limit number was specified
ORA-19563
File validation failure
ORA-19569
This session does not have a device allocated
ORA-19571
record_not_found
ORA-19579
archivelog_not_found
ORA-19580
backup conversation not active
ORA-19582
archivelog_validate_error
ORA-19610
corrupt_directory
ORA-19620
File_type_mismatch
ORA-19625
File not found
ORA-19648
inc_scn_matches_df_scn
ORA-19658
different_resetlogs
backuppiece failover exceptions
ORA-19505
cant_identify_file
ORA-19599
corrupt_block
ORA-19608
not_a_backup_piece
ORA-19610
corrupt_directory
ORA-19624
retryable_error_exp
Used in SPFILE and controlfile restore from autobackup
ORA-19635
identical_input_output_file
ORA-19687
spfile_not_in_bs
ORA-19695
scf_not_in_bs
Used in copy code
ORA-19635
identical_input_output_file: used in copy code
Signaled if recovery area is not set
ORA-19801
ra_not_set: signaled if recovery area is not set
ORA-19887
all_dfile_dropped
ORA-19989
xtts_name_files: not really an exception but a way to interrupt the xtts restore once we have the names of the files that will be restored so that the rman client can print them.
Applies an incremental backup from the backup set to an existing copy of the datafile. The incremental backup and the datafile must have the same resetlogs stamp but this can not be detected until the restore is begun.
Overload 1
dbms_backup_restore.applydatafileto(
dfNUMBER IN BINARY_INTEGER,
toname IN VARCHAR2 DEFAULT NULL,
fuzziness_hint IN NUMBER DEFAULT 0);
TBD
Overload 2
dbms_backup_restore.applydatafileto(
dfNUMBER IN BINARY_INTEGER,
toname IN VARCHAR2 DEFAULT NULL,
fuzziness_hint IN NUMBER DEFAULT 0,
max_corrupt IN BINARY_INTEGER);
TBD
Overload 3
dbms_backup_restore.applydatafileto(
dfNUMBER IN BINARY_INTEGER,
toname IN VARCHAR2 DEFAULT NULL,
fuzziness_hint IN NUMBER DEFAULT 0,
max_corrupt IN BINARY_INTEGER,
islevel0 IN BINARY_INTEGER,
recid IN NUMBER,
stamp IN NUMBER);
Applies an offline range record from the named controlfile to the named datafile
Overload 1
dbms_backup_restore.applyofflinerange(
cfname IN VARCHAR2 DEFAULT NULL,
dfname IN VARCHAR2 DEFAULT NULL,
blksize IN NUMBER DEFAULT NULL,
recid IN NUMBER DEFAULT NULL,
stamp IN NUMBER DEFAULT NULL,
fno IN BINARY_INTEGER);
TBD
Overload 2
dbms_backup_restore.applyofflinerange(
cfname IN VARCHAR2 DEFAULT NULL,
dfname IN VARCHAR2 DEFAULT NULL,
blksize IN NUMBER DEFAULT NULL,
recid IN NUMBER DEFAULT NULL,
stamp IN NUMBER DEFAULT NULL,
fno IN BINARY_INTEGER,
dfrecid IN NUMBER,
dfstamp IN NUMBER);
dbms_backup_restore.applysetdatafile(
check_logical IN BOOLEAN,
cleanup IN BOOLEAN,
service IN VARCHAR2,
chunksize IN BINARY_INTEGER,
rs_flags IN BINARY_INTEGER);
Copies a backup piece originally written to an operating system file, onto sequential media. This requires allocating a sequential device first. Can copy to another operating system file if the NULL device is allocated.
Overload 1
dbms_backup_restore.backupbackuppiece(
bpname IN VARCHAR2,
fname IN VARCHAR2,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
recid OUT NUMBER,
stamp OUT NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE);
TBD
Overload 2
dbms_backup_restore.backupbackuppiece(
bpname IN VARCHAR2,
fname IN VARCHAR2,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
recid OUT NUMBER,
stamp OUT NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE,
check_logical IN BOOLEAN);
TBD
Overload 3
dbms_backup_restore.backupbackuppiece(
bpname IN VARCHAR2,
fname IN VARCHAR2,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
recid OUT NUMBER,
stamp OUT NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE,
check_logical IN BOOLEAN,
copyno IN BINARY_INTEGER);
TBD
Overload 4
dbms_backup_restore.backupbackuppiece(
bpname IN VARCHAR2,
fname IN VARCHAR2,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
recid OUT NUMBER,
stamp OUT NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE,
check_logical IN BOOLEAN,
copyno IN BINARY_INTEGER,
deffmt IN BINARY_INTEGER,
copy_recid IN NUMBER,
copy_stamp IN NUMBER,
npieces IN BINARY_INTEGER);
TBD
Overload 5
dbms_backup_restore.backupbackuppiece(
bpname IN VARCHAR2,
fname IN VARCHAR2,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
recid OUT NUMBER,
stamp OUT NUMBEr,
tag IN VARCHAR2 DEFAULT NULL,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE,
check_logical IN BOOLEAN,
copyno IN BINARY_INTEGER,
deffmt IN BINARY_INTEGER,
copy_recid IN NUMBER,
copy_stamp IN NUMBER,
npieces IN BINARY_INTEGER,
dest IN BINARY_INTEGER);
TBD
Overload 6
dbms_backup_restore.backupbackuppiece(
bpname IN VARCHAR2,
fname IN VARCHAR2,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
recid OUT NUMBER,
stamp OUT NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE,
check_logical IN BOOLEAN,
copyno IN BINARY_INTEGER,
deffmt IN BINARY_INTEGER,
copy_recid IN NUMBER,
copy_stamp IN NUMBER,
npieces IN BINARY_INTEGER,
dest IN BINARY_INTEGER,
pltfrmfr IN BINARY_INTEGER);
TBD
Overload 7
dbms_backup_restore.backupbackuppiece(
bpname IN VARCHAR2,
fname IN VARCHAR2,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
recid OUT NUMBER,
stamp OUT NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE,
check_logical IN BOOLEAN,
copyno IN BINARY_INTEGER,
deffmt IN BINARY_INTEGER,
copy_recid IN NUMBER,
copy_stamp IN NUMBER,
npieces IN BINARY_INTEGER,
dest IN BINARY_INTEGER,
pltfrmfr IN BINARY_INTEGER,
ors IN BOOLEAN,
bpsize OUT NUMBER);
Backups a copy of a datafile that was made via copyDataFile or some operating system utility
dbms_backup_restore.backupDataFileCopy(
copy_recid IN NUMBER,
copy_stamp IN NUMBER,
since_change IN NUMBER DEFAULT 0,
max_corrupt IN BINARY_INTEGER DEFAULT 0);
Adds a datapump export dumpfile log to the backup set
dbms_backup_restore.backupdmpfile(
dmpfile IN VARCHAR2,
blksize IN NUMBER,
dpckpscn IN NUMBER,
dpckptime IN NUMBER,
dprlgscn IN NUMBER,
dprlgtime IN NUMBER,
dpfno IN NUMBER,
dbid IN NUMBER);
Copies a backup piece to disk/tape using the existing backup conversation. A backup conversation must be started prior to this call.
dbms_backup_restore.backupPieceBackup(
BPNAME IN VARCHAR2,
COPYNO IN NUMBER,
COPY_RECID IN NUMBER,
COPY_STAMP IN NUMBER,
NPIECES IN NUMBER,
TEMPLATE_KEY IN NUMBER DEFAULT NULL);
This procedure should be called to create the first (and any subsequent) backup piece after all calls to specify the file list have been issued. Multiple backupPieceCreate calls may be necessary.
Overload 1
dbms_backup_restore.backupPieceCreate(
fname IN VARCHAR2,
pieceno OUT BINARY_INTEGER,
done OUT BOOLEAN,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL);
dbms_backup_restore.backupPieceCreate(
fname IN VARCHAR2,
pieceno OUT BINARY_INTEGER,
done OUT BOOLEAN,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER);
TBD
Overload 3
dbms_backup_restore.backupPieceCreate(
fname IN VARCHAR2,
pieceno OUT BINARY_INTEGER,
done OUT BOOLEAN,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN);
TBD
Overload 4
dbms_backup_restore.backupPieceCreate(
fname IN VARCHAR2,
pieceno OUT BINARY_INTEGER,
done OUT BOOLEAN,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
sequence IN BINARY_INTEGER,
year IN BINARY_INTEGER,
month_day IN BINARY_INTEGER);
TBD
Overload 5
dbms_backup_restore.backupPieceCreate(
fname IN VARCHAR2,
pieceno OUT BINARY_INTEGER,
done OUT BOOLEAN,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER,
sequence IN BINARY_INTEGER,
year IN BINARY_INTEGER,
month_day IN BINARY_INTEGER);
TBD
Overload 6
dbms_backup_restore.backupPieceCreate(
fname IN VARCHAR2,
pieceno OUT BINARY_INTEGER,
done OUT BOOLEAN,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN,
sequence IN BINARY_INTEGER,
year IN BINARY_INTEGER,
month_day IN BINARY_INTEGER);
TBD
Overload 7
dbms_backup_restore.backupPieceCreate(
fname IN VARCHAR2,
pieceno OUT BINARY_INTEGER,
done OUT BOOLEAN,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE,
sequence IN BINARY_INTEGER,
year IN BINARY_INTEGER,
month_day IN BINARY_INTEGER,
archlog_failover OUT BOOLEAN);
TBD
Overload 8
dbms_backup_restore.backupPieceCreate(
fname IN VARCHAR2,
pieceno OUT BINARY_INTEGER,
done OUT BOOLEAN,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE,
sequence IN BINARY_INTEGER,
year IN BINARY_INTEGER,
month IN BINARY_INTEGER,
day IN BINARY_INTEGER,
archlog_failover OUT BOOLEAN,
deffmt IN BINARY_INTEGER,
recid OUT NUMBER,
stamp OUT NUMBER,
tag OUT VARCHAR2);
TBD
Overload 9
dbms_backup_restore.backupPieceCreate(
fname IN VARCHAR2,
pieceno OUT BINARY_INTEGER,
done OUT BOOLEAN,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE,
archlog_failover OUT BOOLEAN,
deffmt IN BINARY_INTEGER,
recid OUT NUMBER,
stamp OUT NUMBER,
tag OUT VARCHAR2,
docompress IN BOOLEAN);
TBD
Overload 10
dbms_backup_restore.backupPieceCreate(
fname IN VARCHAR2,
pieceno OUT BINARY_INTEGER,
done OUT BOOLEAN,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE,
archlog_failover OUT BOOLEAN,
deffmt IN BINARY_INTEGER,
recid OUT NUMBER,
stamp OUT NUMBER,
tag OUT VARCHAR2,
docompress IN BOOLEAN,
dest IN BINARY_INTEGER);
TBD
Overload 11
dbms_backup_restore.backupPieceCreate(
fname IN VARCHAR2,
pieceno OUT BINARY_INTEGER,
done OUT BOOLEAN,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE,
archlog_failover OUT BOOLEAN,
deffmt IN BINARY_INTEGER,
recid OUT NUMBER,
stamp OUT NUMBER,
tag OUT VARCHAR2,
docompress IN BOOLEAN,
dest IN BINARY_INTEGER,
post10_2 IN BOOLEAN);
TBD
Overload 12
dbms_backup_restore.backupPieceCreate(
fname IN VARCHAR2,
pieceno OUT BINARY_INTEGER,
done OUT BOOLEAN,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE,
archlog_failover OUT BOOLEAN,
deffmt IN BINARY_INTEGER,
recid OUT NUMBER,
stamp OUT NUMBER,
tag OUT VARCHAR2,
docompress IN BOOLEAN,
dest IN BINARY_INTEGER,
post10_2 IN BOOLEAN,
netalias IN VARCHAR2,
compressalg IN VARCHAR2);
TBD
Overload 13
dbms_backup_restore.backupPieceCreate(
fname IN VARCHAR2,
pieceno OUT BINARY_INTEGER,
done OUT BOOLEAN,
handle OUT VARCHAR2,
comment OUT VARCHAR2,
media OUT VARCHAR2,
concur OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
media_pool IN BINARY_INTEGER DEFAULT 0,
reuse IN BOOLEAN DEFAULT FALSE,
archlog_failover OUT BOOLEAN,
deffmt IN BINARY_INTEGER,
recid OUT NUMBER,
stamp OUT NUMBER,
tag OUT VARCHAR2,
docompress IN BOOLEAN,
dest IN BINARY_INTEGER,
post10_2 IN BOOLEAN,
netalias IN VARCHAR2,
compressalg IN VARCHAR2,
compressasof IN NUMBER DEFAULT 1,
compresslopt IN BINARY_INTEGER DEFAULT LOPT_TRUE);
dbms_backup_restore.backuppiecerestore(
bpname IN VARCHAR2,
fname IN VARCHAR2,
handle OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
reuse IN BOOLEAN DEFAULT FALSE,
check_logical IN BOOLEAN);
dbms_backup_restore.backupSetArchivedlog(
set_stamp OUT NUMBER,
set_count OUT NUMBER,
nochecksum IN BOOLEAN DEFAULT FALSE,
tag IN VARCHAR2);
TBD
Overload 3
dbms_backup_restore.backupSetArchivedlog(
set_stamp OUT NUMBER,
set_count OUT NUMBER,
nochecksum IN BOOLEAN DEFAULT FALSE,
tag IN VARCHAR2,
imagcp IN BOOLEAN);
TBD
Overload 4
dbms_backup_restore.backupSetArchivedlog(
set_stamp OUT NUMBER,
set_count OUT NUMBER,
nochecksum IN BOOLEAN DEFAULT FALSE,
tag IN VARCHAR2,
imagcp IN BOOLEAN,
validate IN BOOLEAN);
TBD
Overload 5
dbms_backup_restore.backupSetArchivedlog(
set_stamp OUT NUMBER,
set_count OUT NUMBER,
nochecksum IN BOOLEAN DEFAULT FALSE,
tag IN VARCHAR2,
imagcp IN BOOLEAN,
validate IN BOOLEAN,
keep_options IN BINARY_INTEGER,
keep_until IN NUMBER);
Starts a backup conversation to backup datafiles and possibly a controlfile
Overload 1
dbms_backup_restore.backupsetdatafile(
set_stamp OUT NUMBER,
set_count OUT NUMBER,
nochecksum IN BOOLEAN DEFAULT FALSE,
tag IN VARCHAR2 DEFAULT NULL,
incremental IN BOOLEAN DEFAULT FALSE,
backup_level IN BINARY_INTEGER DEFAULT 0);
dbms_backup_restore.backupsetdatafile(
set_stamp OUT NUMBER,
set_count OUT NUMBER,
nochecksum IN BOOLEAN DEFAULT FALSE,
tag IN VARCHAR2 DEFAULT NULL,
incremental IN BOOLEAN DEFAULT FALSE,
backup_level IN BINARY_INTEGER DEFAULT 0,
check_logical IN BOOLEAN);
TBD
Overload 3
dbms_backup_restore.backupsetdatafile(
set_stamp OUT NUMBER,
set_count OUT NUMBER,
nochecksum IN BOOLEAN DEFAULT FALSE,
tag IN VARCHAR2 DEFAULT NULL,
incremental IN BOOLEAN DEFAULT FALSE,
backup_level IN BINARY_INTEGER DEFAULT 0,
check_logical IN BOOLEAN DEFAULT FALSE,
keep_options IN BINARY_INTEGER,
keep_until IN NUMBER);
TBD
Overload 4
dbms_backup_restore.backupsetdatafile(
set_stamp OUT NUMBER,
set_count OUT NUMBER,
nochecksum IN BOOLEAN DEFAULT FALSE,
tag IN VARCHAR2 DEFAULT NULL,
incremental IN BOOLEAN DEFAULT FALSE,
backup_level IN BINARY_INTEGER DEFAULT 0,
check_logical IN BOOLEAN DEFAULT FALSE,
keep_options IN BINARY_INTEGER DEFAULT 0,
keep_until IN NUMBER DEFAULT 0,
imagcp IN BOOLEAN,
convertto IN BOOLEAN,
convertfr IN BOOLEAN,
pltfrmto IN BINARY_INTEGER,
pltfrmfr IN BINARY_INTEGER,
sameen IN BOOLEAN);
TBD
Overload 5
dbms_backup_restore.backupsetdatafile(
set_stamp OUT NUMBER,
set_count OUT NUMBER,
nochecksum IN BOOLEAN DEFAULT FALSE,
tag IN VARCHAR2 DEFAULT NULL,
incremental IN BOOLEAN DEFAULT FALSE,
backup_level IN BINARY_INTEGER DEFAULT 0,
check_logical IN BOOLEAN DEFAULT FALSE,
keep_options IN BINARY_INTEGER DEFAULT 0,
keep_until IN NUMBER DEFAULT 0,
imagcp IN BOOLEAN,
convertto IN BOOLEAN,
convertfr IN BOOLEAN,
pltfrmto IN BINARY_INTEGER,
pltfrmfr IN BINARY_INTEGER,
sameen IN BOOLEAN,
convertdb IN BOOLEAN);
TBD
Overload 6
dbms_backup_restore.backupsetdatafile(
set_stamp OUT NUMBER,
set_count OUT NUMBER,
nochecksum IN BOOLEAN DEFAULT FALSE,
tag IN VARCHAR2 DEFAULT NULL,
incremental IN BOOLEAN DEFAULT FALSE,
backup_level IN BINARY_INTEGER DEFAULT 0,
check_logical IN BOOLEAN DEFAULT FALSE,
keep_options IN BINARY_INTEGER DEFAULT 0,
keep_until IN NUMBER DEFAULT 0,
imagcp IN BOOLEAN,
convertto IN BOOLEAN,
convertfr IN BOOLEAN,
pltfrmto IN BINARY_INTEGER,
pltfrmfr IN BINARY_INTEGER,
sameen IN BOOLEAN,
convertdb IN BOOLEAN,
nocatalog IN BOOLEAN);
TBD
Overload 7
dbms_backup_restore.backupsetdatafile(
set_stamp OUT NUMBER,
set_count OUT NUMBER,
nochecksum IN BOOLEAN DEFAULT FALSE,
tag IN VARCHAR2 DEFAULT NULL,
incremental IN BOOLEAN DEFAULT FALSE,
backup_level IN BINARY_INTEGER DEFAULT 0,
check_logical IN BOOLEAN DEFAULT FALSE,
keep_options IN BINARY_INTEGER DEFAULT 0,
keep_until IN NUMBER DEFAULT 0,
imagcp IN BOOLEAN,
convertto IN BOOLEAN,
convertfr IN BOOLEAN,
pltfrmto IN BINARY_INTEGER,
pltfrmfr IN BINARY_INTEGER,
sameen IN BOOLEAN,
convertdb IN BOOLEAN,
nocatalog IN BOOLEAN,
validate IN BOOLEAN,
validateblk IN BOOLEAN,
hdrupd IN OUT BOOLEAN);
Starts a backup set conversation to copy a backup piece to destination device.
dbms_backup_restore.backupSetPiece(
TAG IN VARCHAR2 DEFAULT NULL,
CHECK_LOGICAL IN BOOLEAN DEFAULT FALSE,
CONVERTFR IN BOOLEAN DEFAULT FALSE,
PLTFRMFR IN NUMBER DEFAULT NULL,
CONVERTTO IN BOOLEAN DEFAULT FALSE,
PLTFRMTO IN NUMBER DEFAULT NULL,
ORSBCK IN BOOLEAN DEFAULT FALSE);
Returns information about the current backup conversation. Useful for resyncing with a conversation after an error has interrupted normal execution. Can also be called if there is no conversation.
dbms_backup_restore.backupstatus(
state OUT BINARY_INTEGER,
setid OUT NUMBER,
stamp OUT NUMBER,
pieceno OUT BINARY_INTEGER,
files OUT BINARY_INTEGER,
datafiles OUT BOOLEAN,
incremental OUT BOOLEAN,
nochecksum OUT BOOLEAN,
device OUT BOOLEAN);
Allows for runtime adjustment of various constants that affect the operation of the CTWR process. This routine should be used only by Oracle support personnel.
dbms_backup_restore.bctSet(
parmno IN BINARY_INTEGER,
numval IN NUMBER DEFAULT NULL,
charval IN VARCHAR2 DEFAULT NULL);
This function establishes a connection to a standby that is open during block media recovery and retrieves the blocks returning the number of blocks restored blocks
dbms_backup_restore.bmrRestoreFromStandby(validate IN BOOLEAN) RETURN NUMBER;
DECLARE
x BOOLEAN := TRUE;
BEGIN
dbms_backup_restore.bmrSestoreFromStandby(TRUE);
END;
/
dbms_backup_restore.bmrStart(
save_all_blocks IN BOOLEAN,
save_final_blocks IN BOOLEAN,
nofileupdate IN BOOLEAN,
doclear IN BOOLEAN,
flags_clear IN BINARY_INTEGER DEFAULT 0);
Takes a list of parameters, for each record type, the NUMBER of record slots postulated for the section containing records of that type.
Obsolete from 10gR2 onward
Overload 1
dbms_backup_restore.cfileCalcSizeList(
num_ckptprog_recs IN BINARY_INTEGER DEFAULT 0,
num_thread_recs IN BINARY_INTEGER DEFAULT 0,
num_logfile_recs IN BINARY_INTEGER DEFAULT 0,
num_datafile_recs IN BINARY_INTEGER DEFAULT 0,
num_filename_recs IN BINARY_INTEGER DEFAULT 0,
num_tablespace_recs IN BINARY_INTEGER DEFAULT 0,
num_tempfile_recs IN BINARY_INTEGER DEFAULT 0,
num_rmanconfiguration_recs IN BINARY_INTEGER DEFAULT 0,
num_loghistory_recs IN BINARY_INTEGER DEFAULT 0,
num_offlinerange_recs IN BINARY_INTEGER DEFAULT 0,
num_archivedlog_recs IN BINARY_INTEGER DEFAULT 0,
num_backupset_recs IN BINARY_INTEGER DEFAULT 0,
num_backuppiece_recs IN BINARY_INTEGER DEFAULT 0,
num_backedupdfile_recs IN BINARY_INTEGER DEFAULT 0,
num_backeduplog_recs IN BINARY_INTEGER DEFAULT 0,
num_dfilecopy_recs IN BINARY_INTEGER DEFAULT 0,
num_bkdfcorruption_recs IN BINARY_INTEGER DEFAULT 0,
num_dfcopycorruption_recs IN BINARY_INTEGER DEFAULT 0,
num_deletedobject_recs IN BINARY_INTEGER DEFAULT 0,
num_proxy_recs IN BINARY_INTEGER DEFAULT 0,
num_reserved4_recs IN BINARY_INTEGER DEFAULT 0)
RETURN BINARY_INTEGER;
Obsolete and deprecated
Overload 2
dbms_backup_restore.cfileCalcSizeList(
num_ckptprog_recs IN BINARY_INTEGER DEFAULT 0,
num_thread_recs IN BINARY_INTEGER DEFAULT 0,
num_logfile_recs IN BINARY_INTEGER DEFAULT 0,
num_datafile_recs IN BINARY_INTEGER DEFAULT 0,
num_filename_recs IN BINARY_INTEGER DEFAULT 0,
num_tablespace_recs IN BINARY_INTEGER DEFAULT 0,
num_tempfile_recs IN BINARY_INTEGER DEFAULT 0,
num_rmanconfiguration_recs IN BINARY_INTEGER DEFAULT 0,
num_loghistory_recs IN BINARY_INTEGER DEFAULT 0,
num_offlinerange_recs IN BINARY_INTEGER DEFAULT 0,
num_archivedlog_recs IN BINARY_INTEGER DEFAULT 0,
num_backupset_recs IN BINARY_INTEGER DEFAULT 0,
num_backuppiece_recs IN BINARY_INTEGER DEFAULT 0,
num_backedupdfile_recs IN BINARY_INTEGER DEFAULT 0,
num_backeduplog_recs IN BINARY_INTEGER DEFAULT 0,
num_dfilecopy_recs IN BINARY_INTEGER DEFAULT 0,
num_bkdfcorruption_recs IN BINARY_INTEGER DEFAULT 0,
num_dfcopycorruption_recs IN BINARY_INTEGER DEFAULT 0,
num_deletedobject_recs IN BINARY_INTEGER DEFAULT 0,
num_proxy_recs IN BINARY_INTEGER DEFAULT 0,
num_reserved4_recs IN BINARY_INTEGER DEFAULT 0,
num_db2_recs IN BINARY_INTEGER,
num_incarnation_recs IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
Overload 3
dbms_backup_restore.cfileCalcSizeList(
num_ckptprog_recs IN BINARY_INTEGER DEFAULT 0,
num_thread_recs IN BINARY_INTEGER DEFAULT 0,
num_logfile_recs IN BINARY_INTEGER DEFAULT 0,
num_datafile_recs IN BINARY_INTEGER DEFAULT 0,
num_filename_recs IN BINARY_INTEGER DEFAULT 0,
num_tablespace_recs IN BINARY_INTEGER DEFAULT 0,
num_tempfile_recs IN BINARY_INTEGER DEFAULT 0,
num_rmanconfiguration_recs IN BINARY_INTEGER DEFAULT 0,
num_loghistory_recs IN BINARY_INTEGER DEFAULT 0,
num_offlinerange_recs IN BINARY_INTEGER DEFAULT 0,
num_archivedlog_recs IN BINARY_INTEGER DEFAULT 0,
num_backupset_recs IN BINARY_INTEGER DEFAULT 0,
num_backuppiece_recs IN BINARY_INTEGER DEFAULT 0,
num_backedupdfile_recs IN BINARY_INTEGER DEFAULT 0,
num_backeduplog_recs IN BINARY_INTEGER DEFAULT 0,
num_dfilecopy_recs IN BINARY_INTEGER DEFAULT 0,
num_bkdfcorruption_recs IN BINARY_INTEGER DEFAULT 0,
num_dfcopycorruption_recs IN BINARY_INTEGER DEFAULT 0,
num_deletedobject_recs IN BINARY_INTEGER DEFAULT 0,
num_proxy_recs IN BINARY_INTEGER DEFAULT 0,
num_reserved4_recs IN BINARY_INTEGER DEFAULT 0,
num_db2_recs IN BINARY_INTEGER,
num_incarnation_recs IN BINARY_INTEGER,
num_flashback_recs IN BINARY_INTEGER,
num_rainfo_recs IN BINARY_INTEGER,
num_instrsvt_recs IN BINARY_INTEGER,
num_agedfiles_recs IN BINARY_INTEGER,
num_rmanstatus_recs IN BINARY_INTEGER,
num_threadinst_recs IN BINARY_INTEGER,
num_mtr_recs IN BINARY_INTEGER,
num_dfh_recs IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
Overload 4
dbms_backup_restore.cfileCalcSizeList(
num_ckptprog_recs IN BINARY_INTEGER DEFAULT 0,
num_thread_recs IN BINARY_INTEGER DEFAULT 0,
num_logfile_recs IN BINARY_INTEGER DEFAULT 0,
num_datafile_recs IN BINARY_INTEGER DEFAULT 0,
num_filename_recs IN BINARY_INTEGER DEFAULT 0,
num_tablespace_recs IN BINARY_INTEGER DEFAULT 0,
num_tempfile_recs IN BINARY_INTEGER DEFAULT 0,
num_rmanconfiguration_recs IN BINARY_INTEGER DEFAULT 0,
num_loghistory_recs IN BINARY_INTEGER DEFAULT 0,
num_offlinerange_recs IN BINARY_INTEGER DEFAULT 0,
num_archivedlog_recs IN BINARY_INTEGER DEFAULT 0,
num_backupset_recs IN BINARY_INTEGER DEFAULT 0,
num_backuppiece_recs IN BINARY_INTEGER DEFAULT 0,
num_backedupdfile_recs IN BINARY_INTEGER DEFAULT 0,
num_backeduplog_recs IN BINARY_INTEGER DEFAULT 0,
num_dfilecopy_recs IN BINARY_INTEGER DEFAULT 0,
num_bkdfcorruption_recs IN BINARY_INTEGER DEFAULT 0,
num_dfcopycorruption_recs IN BINARY_INTEGER DEFAULT 0,
num_deletedobject_recs IN BINARY_INTEGER DEFAULT 0,
num_proxy_recs IN BINARY_INTEGER DEFAULT 0,
num_reserved4_recs IN BINARY_INTEGER DEFAULT 0,
num_db2_recs IN BINARY_INTEGER,
num_incarnation_recs IN BINARY_INTEGER,
num_flashback_recs IN BINARY_INTEGER,
num_rainfo_recs IN BINARY_INTEGER,
num_instrsvt_recs IN BINARY_INTEGER,
num_agedfiles_recs IN BINARY_INTEGER,
num_rmanstatus_recs IN BINARY_INTEGER,
num_threadinst_recs IN BINARY_INTEGER,
num_mtr_recs IN BINARY_INTEGER,
num_dfh_recs IN BINARY_INTEGER,
num_sdm_recs IN BINARY_INTEGER,
num_grp_recs IN BINARY_INTEGER,
num_rp_recs IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
Overload 5
dbms_backup_restore.cfileCalcSizeList(
num_ckptprog_recs IN BINARY_INTEGER DEFAULT 0,
num_thread_recs IN BINARY_INTEGER DEFAULT 0,
num_logfile_recs IN BINARY_INTEGER DEFAULT 0,
num_datafile_recs IN BINARY_INTEGER DEFAULT 0,
num_filename_recs IN BINARY_INTEGER DEFAULT 0,
num_tablespace_recs IN BINARY_INTEGER DEFAULT 0,
num_tempfile_recs IN BINARY_INTEGER DEFAULT 0,
num_rmanconfiguration_recs IN BINARY_INTEGER DEFAULT 0,
num_loghistory_recs IN BINARY_INTEGER DEFAULT 0,
num_offlinerange_recs IN BINARY_INTEGER DEFAULT 0,
num_archivedlog_recs IN BINARY_INTEGER DEFAULT 0,
num_backupset_recs IN BINARY_INTEGER DEFAULT 0,
num_backuppiece_recs IN BINARY_INTEGER DEFAULT 0,
num_backedupdfile_recs IN BINARY_INTEGER DEFAULT 0,
num_backeduplog_recs IN BINARY_INTEGER DEFAULT 0,
num_dfilecopy_recs IN BINARY_INTEGER DEFAULT 0,
num_bkdfcorruption_recs IN BINARY_INTEGER DEFAULT 0,
num_dfcopycorruption_recs IN BINARY_INTEGER DEFAULT 0,
num_deletedobject_recs IN BINARY_INTEGER DEFAULT 0,
num_proxy_recs IN BINARY_INTEGER DEFAULT 0,
num_reserved4_recs IN BINARY_INTEGER DEFAULT 0,
num_db2_recs IN BINARY_INTEGER,
num_incarnation_recs IN BINARY_INTEGER,
num_flashback_recs IN BINARY_INTEGER,
num_rainfo_recs IN BINARY_INTEGER,
num_instrsvt_recs IN BINARY_INTEGER,
num_agedfiles_recs IN BINARY_INTEGER,
num_rmanstatus_recs IN BINARY_INTEGER,
num_threadinst_recs IN BINARY_INTEGER,
num_mtr_recs IN BINARY_INTEGER,
num_dfh_recs IN BINARY_INTEGER,
num_sdm_recs IN BINARY_INTEGER,
num_grp_recs IN BINARY_INTEGER,
num_rp_recs IN BINARY_INTEGER,
num_bcr_recs IN BINARY_INTEGER,
num_acm_recs IN BINARY_INTEGER,
num_rlr_recs IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
Creates a snapshot of the current controlfile and stores it in a file it creates using the DEFAULT filename or previously specified via cfileSetSnapshotName
Overload 1
dbms_backup_restore.cfilemakeandusesnapshot;
BEGIN
dbms_backup_restore.cfilesetsnapshotname('c:\temp\backup.ctl');
dbms_backup_restore.cfilemakeandusesnapshot;
END;
/
If TRUE, indicates that the controlfile to make is a standby controlfile, else normal
Overload 2
dbms_backup_restore.cfilemakeandusesnapshot(isstby IN BOOLEAN);
dbms_backup_restore.cfilemakeandusesnapshot(
isstby IN BOOLEAN,
source_dbuname IN VARCHAR2,
dest_cs IN VARCHAR2,
source_cs IN VARCHAR2,
for_resync IN BOOLEAN);
Attempts to resize the controlfile, expanding or shrinking the section holding records of the specified "record_type" such that it will hold "desired_numrecs" (rounded up to the nearest block boundary)
dbms_backup_restore.cfileresizesection(
record_type IN BINARY_INTEGER,
before_numrecs OUT BINARY_INTEGER,
after_numrecs OUT BINARY_INTEGER,
delta_numrecs IN BINARY_INTEGER DEFAULT 0);
Sets up this process' PGA such that the X$KCC fixed tables will be redirected to read the snapshot controlfile previously created via cfileMakeAndUseSnapshot
dbms_backup_restore.changearchivedlog(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
thread IN NUMBER,
sequence IN NUMBER,
resetlogs_change IN NUMBER,
first_change IN NUMBER,
blksize IN NUMBER,
new_status IN VARCHAR2);
TBD
Overload 2
dbms_backup_restore.changearchivedlog(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
thread IN NUMBER,
sequence IN NUMBER,
resetlogs_change IN NUMBER,
first_change IN NUMBER,
blksize IN NUMBER,
new_status IN VARCHAR2,
force IN BINARY_INTEGER);
TBD
Overload 3
dbms_backup_restore.changearchivedlog(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
thread IN NUMBER,
sequence IN NUMBER,
resetlogs_change IN NUMBER,
first_change IN NUMBER,
blksize IN NUMBER,
new_status IN VARCHAR2,
force IN BINARY_INTEGER,
foreignal IN BINARY_INTEGER);
dbms_backup_restore.changebackuppiece(
recid IN NUMBER,
stamp IN NUMBER,
handle IN VARCHAR2,
set_stamp IN NUMBER,
set_count IN NUMBER,
pieceno IN BINARY_INTEGER,
status IN VARCHAR2, -- 'D','S','A','U','X'
params IN VARCHAR2 DEFAULT NULL);
TBD
Overload 2
dbms_backup_restore.changebackuppiece(
recid IN NUMBER,
stamp IN NUMBER,
handle IN VARCHAR2,
set_stamp IN NUMBER,
set_count IN NUMBER,
pieceno IN BINARY_INTEGER,
status IN VARCHAR2, -- 'D','S','A','U','X'
params IN VARCHAR2 DEFAULT NULL,
force IN BINARY_INTEGER);
dbms_backup_restore.changedatafilecopy(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
dfNUMBER IN BINARY_INTEGER,
resetlogs_change IN NUMBER,
creation_change IN NUMBER,
checkpoint_change IN NUMBER,
blksize IN NUMBER,
new_status IN VARCHAR2);
TBD
Overload 2
dbms_backup_restore.changedatafilecopy(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
dfNUMBER IN BINARY_INTEGER,
resetlogs_change IN NUMBER,
creation_change IN NUMBER,
checkpoint_change IN NUMBER,
blksize IN NUMBER,
new_status IN VARCHAR2,
keep_options IN BINARY_INTEGER,
keep_until IN NUMBER);
TBD
Overload 3
dbms_backup_restore.changedatafilecopy(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
dfNUMBER IN BINARY_INTEGER,
resetlogs_change IN NUMBER,
creation_change IN NUMBER,
checkpoint_change IN NUMBER,
blksize IN NUMBER,
new_status IN VARCHAR2,
keep_options IN BINARY_INTEGER,
keep_until IN NUMBER,
force IN BINARY_INTEGER);
Validates the provided compression algorithm exists for the provided release. 1 = TRUE, 0 = FALSE
dbms_backup_restore.checkcompressionalg(
algname IN VARCHAR2, -- name of the algorithm to validate
asofrel IN NUMBER, -- release to which algname refers
isvalid OUT BINARY_INTEGER, -- 1 if valid
req_aco OUT BINARY_INTEGER, -- 1 if requires Adv. Comp. option license
have_aco OUT BINARY_INTEGER, -- 1 if Adv. Comp. is enabled
mincompat OUT VARCHAR2) -- minimum release compatible with algorithm
RETURN BINARY_INTEGER;
desc v$rman_compression_algorithm
SELECT algorithm_name
FROM v$rman_compression_algorithm;
set serveroutput on
DECLARE
ret BINARY_INTEGER;
isv BINARY_INTEGER;
req BINARY_INTEGER;
hav BINARY_INTEGER;
mct VARCHAR2(500);
BEGIN
ret := dbms_backup_restore.checkCompressionAlg('MEDIUM', 99, isv, req, hav, mct);
dbms_output.put_line(ret);
dbms_output.put_line(isv);
dbms_output.put_line(req);
dbms_output.put_line(hav);
dbms_output.put_line(mct);
END;
/
Returns 0 if the filename is not in use by the database as a controlfile, datafile, or online logfile. Returns 1 if the filename is in use. The filename must be normalized by the caller.
dbms_backup_restore.checkFileName(name IN VARCHAR2) RETURN NUMBER;
SELECT file_name, dbms_backup_restore.checkfilename(file_name)
FROM dba_data_files;
SELECT dbms_backup_restore.checkfilename('ZZYZX.DBF') FROM dual;
Clears the circular sections of the controlfile to remove all the backups and image copy records and supporting controlfile records
Danger: This is done in preparation for a no target, no recovery catalog duplicate, be sure you understand the implications.
dbms_backup_restore.clearControlfile;
Commits the row into controlfile. The SGA version of the row is saved in the controlfile and the contolfile record is marked as finished.
Overload 1
dbms_backup_restore.commitrmanstatusrow(
row_id IN NUMBER,
row_stamp IN NUMBER,
mbytes IN NUMBER,
status IN BINARY_INTEGER);
TBD
Overload 2
dbms_backup_restore.commitrmanstatusrow(
row_id IN NUMBER,
row_stamp IN NUMBER,
mbytes IN NUMBER,
status IN BINARY_INTEGER,
ibytes IN NUMBER,
obytes IN NUMBER,
odevtype IN VARCHAR2);
Makes a copy of a log that was already archived. This may be useful for moving redo to a different location, or for extra redundancy. A record is created in the controlfile as if this log was just archived.
dbms_backup_restore.copyarchivedlog(
arch_recid IN NUMBER,
arch_stamp IN NUMBER,
fname IN VARCHAR2,
full_name OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
nochecksum IN BOOLEAN DEFAULT FALSE);
Makes copies of a controlfile that is already on disk in an operating system file. It is intended to be used to make copies of controlfiles for specifying multiple controlfiles in the initialization parameter.
Overload 1
dbms_backup_restore.copycontrolfile(
src_name IN VARCHAR2,
dest_name IN VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
full_name OUT VARCHAR2);
TBD
Overload 2
dbms_backup_restore.copycontrolfile(
src_name IN VARCHAR2,
dest_name IN VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
full_name OUT VARCHAR2,
keep_options IN BINARY_INTEGER,
keep_until IN NUMBER);
dbms_backup_restore.copydatafile(
dfNumber IN BINARY_INTEGER,
fname IN VARCHAR2,
full_name OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
max_corrupt IN BINARY_INTEGER DEFAULT 0,
tag IN VARCHAR2 DEFAULT NULL,
nochecksum IN BOOLEAN DEFAULT FALSE,
isbackup IN BOOLEAN DEFAULT FALSE);
TBD
Overload 2
dbms_backup_restore.copydatafile(
dfNumber IN BINARY_INTEGER,
fname IN VARCHAR2,
full_name OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
max_corrupt IN BINARY_INTEGER DEFAULT 0,
tag IN VARCHAR2 DEFAULT NULL,
nochecksum IN BOOLEAN DEFAULT FALSE,
isbackup IN BOOLEAN DEFAULT FALSE,
check_logical IN BOOLEAN);
TBD
Overload 3
dbms_backup_restore.copydatafile(
dfNumber IN BINARY_INTEGER,
fname IN VARCHAR2,
full_name OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
max_corrupt IN BINARY_INTEGER DEFAULT 0,
tag IN VARCHAR2 DEFAULT NULL,
nochecksum IN BOOLEAN DEFAULT FALSE,
isbackup IN BOOLEAN DEFAULT FALSE,
check_logical IN BOOLEAN DEFAULT FALSE,
keep_options IN BINARY_INTEGER,
keep_until IN NUMBER);
dbms_backup_restore.copydatafilecopy(
copy_recid IN NUMBER,
copy_stamp IN NUMBER,
full_name OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
fname IN
VARCHAR2 DEFAULT NULL,
max_corrupt IN BINARY_INTEGER DEFAULT 0,
tag IN
VARCHAR2 DEFAULT NULL,
nochecksum IN BOOLEAN DEFAULT FALSE,
isbackup IN BOOLEAN DEFAULT FALSE);
TBD
Overload 2
dbms_backup_restore.copydatafilecopy(
copy_recid IN NUMBER,
copy_stamp IN NUMBER,
full_name OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
fname IN VARCHAR2 DEFAULT NULL,
max_corrupt IN BINARY_INTEGER DEFAULT 0,
tag IN VARCHAR2 DEFAULT NULL,
nochecksum IN BOOLEAN DEFAULT FALSE,
isbackup IN BOOLEAN DEFAULT FALSE,
check_logical IN BOOLEAN);
TBD
Overload 3
dbms_backup_restore.copydatafilecopy(
copy_recid IN NUMBER,
copy_stamp IN NUMBER,
full_name OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
fname IN VARCHAR2 DEFAULT NULL,
max_corrupt IN BINARY_INTEGER DEFAULT 0,
tag IN VARCHAR2 DEFAULT NULL,
nochecksum IN BOOLEAN DEFAULT FALSE,
isbackup IN BOOLEAN DEFAULT FALSE,
check_logical IN BOOLEAN DEFAULT FALSE,
keep_options IN BINARY_INTEGER,
keep_until IN NUMBER);
TBD
Overload 4
dbms_backup_restore.copydatafilecopy(
copy_recid IN NUMBER,
copy_stamp IN NUMBER,
full_name OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
fname IN VARCHAR2 DEFAULT NULL,
max_corrupt IN BINARY_INTEGER DEFAULT 0,
tag IN VARCHAR2 DEFAULT NULL,
nochecksum IN BOOLEAN DEFAULT FALSE,
isbackup IN BOOLEAN DEFAULT FALSE,
check_logical IN BOOLEAN DEFAULT FALSE,
inst_restore IN BINARY_INTEGER);
Re-createDatafile for RMAN. Functionally this is same as ALTER DATABASE CREATE DATAFILE from RMAN client point of view, when RMAN is doing recovery (i.e., recovery is TRUE)
dbms_backup_restore.createdatafile(
fno IN NUMBER,
newomf IN BOOLEAN,
recovery IN BOOLEAN,
fname IN VARCHAR2 DEFAULT NULL);
Creates a restore point with the specified SCN.
This is diffferent from CREATE RESTORE POINT AS OF SCN command in the way the server trusts the SCN specified and doesn't check whether the database has advanced to that scn on the standby
dbms_backup_restore.createRestorePoint(
name IN VARCHAR2,
scn IN NUMBER);
Creates an row in a V$RMAN_OUTPUT view. The function will create one row in SGA (krbmrort [Rman Output Row Table]).
Overload 1
dbms_backup_restore.creatermanoutputrow(
l0row_id IN NUMBER,
l0row_stamp IN NUMBER,
row_id IN NUMBER,
row_stamp IN NUMBER,
txt IN VARCHAR2);
TBD
Overload 2
dbms_backup_restore.creatermanoutputrow(
l0row_id IN NUMBER,
l0row_stamp IN NUMBER,
row_id IN NUMBER,
row_stamp IN NUMBER,
txt IN VARCHAR2,
sameline IN BINARY_INTEGER);
Creates an row for V$RMAN_STATUS view. The function will create one row in SGA (krbmrsrt [Rman Status Row Table] and create one controlfile record (kccrsr).
Overload 1
dbms_backup_restore.creatermanstatusrow(
level IN BINARY_INTEGER,
parent_id IN NUMBER,
parent_stamp IN NUMBER,
status IN BINARY_INTEGER,
command_id IN VARCHAR2,
operation IN VARCHAR2,
row_id OUT NUMBER,
row_stamp OUT NUMBER);
TBD
Overload 2
dbms_backup_restore.creatermanstatusrow(
level IN BINARY_INTEGER,
parent_id IN NUMBER,
parent_stamp IN NUMBER,
status IN BINARY_INTEGER,
command_id IN VARCHAR2,
operation IN VARCHAR2,
row_id OUT NUMBER,
row_stamp OUT NUMBER,
flags IN BINARY_INTEGER);
CrosscheckBackupPiece is obsolete: Use validateBackupPiece instead
dbms_backup_restore.crosscheckbackuppiece(
recid IN NUMBER,
stamp IN NUMBER,
handle IN VARCHAR2,
set_stamp IN NUMBER,
set_count IN NUMBER,
pieceno IN BINARY_INTEGER,
params IN VARCHAR2 DEFAULT NULL)
RETURN BINARY_INTEGER;
Deletes an operating system file and mark its record in the controlfile as obsolete so that its row will not appear in the fixed view.
If the stamp in the record does not match the stamp argument, the controlfile record will not be marked as obsolete.
Overload 1
dbms_backup_restore.deletearchivedlog(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
thread IN NUMBER,
sequence IN NUMBER,
resetlogs_change IN NUMBER,
first_change IN NUMBER,
blksize IN NUMBER);
TBD
Overload 2
dbms_backup_restore.deletearchivedlog(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
thread IN NUMBER,
sequence IN NUMBER,
resetlogs_change IN NUMBER,
first_change IN NUMBER,
blksize IN NUMBER,
force IN BINARY_INTEGER);
Delete a backup piece from the storage subsystem. If a controlfile record ID is given, it is marked as obsolete so that it will no longer appear in V$BACKUP_PIECE.
If the stamp in the record does not match the stamp argument, the controlfile record will not be marked as obsolete.
Overload 1
dbms_backup_restore.deletebackuppiece(
recid IN NUMBER,
stamp IN NUMBER,
handle IN VARCHAR2,
set_stamp IN NUMBER,
set_count IN NUMBER,
pieceno IN BINARY_INTEGER,
params IN VARCHAR2 DEFAULT NULL);
TBD
Overload 2
dbms_backup_restore.deletebackuppiece(
recid IN NUMBER,
stamp IN NUMBER,
handle IN VARCHAR2,
set_stamp IN NUMBER,
set_count IN NUMBER,
pieceno IN BINARY_INTEGER,
params IN VARCHAR2 DEFAULT NULL,
force IN BINARY_INTEGER);
Deletes an operating system file and mark its record in the controlfile as obsolete so that its row will not appear in the fixed view.
If the stamp in the record does not match the stamp argument, the controlfile record will not be marked as obsolete.
Overload 1
dbms_backup_restore.deletedatafilecopy(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
dfNUMBER IN BINARY_INTEGER,
resetlogs_change IN NUMBER,
creation_change IN NUMBER,
checkpoint_change IN NUMBER,
blksize IN NUMBER,
no_delete IN BINARY_INTEGER);
TBD
Overload 2
dbms_backup_restore.deletedatafilecopy(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
dfNUMBER IN BINARY_INTEGER,
resetlogs_change IN NUMBER,
creation_change IN NUMBER,
checkpoint_change IN NUMBER,
blksize IN NUMBER,
no_delete IN BINARY_INTEGER,
force IN BINARY_INTEGER);
dbms_backup_restore.deviceAllocate(
type IN VARCHAR2 DEFAULT NULL,
name IN VARCHAR2 DEFAULT NULL,
ident IN VARCHAR2 DEFAULT NULL,
noio IN BOOLEAN DEFAULT FALSE,
params IN VARCHAR2 DEFAULT NULL)
RETURN VARCHAR2;
See RESTOREDATAFILETO Demo
Overload 2
dbms_backup_restore.deviceAllocate(
type IN VARCHAR2 DEFAULT NULL,
name IN VARCHAR2 DEFAULT NULL,
ident IN VARCHAR2 DEFAULT NULL,
noio IN BOOLEAN DEFAULT FALSE,
params IN VARCHAR2 DEFAULT NULL,
node OUT VARCHAR2,
dupcnt IN BINARY_INTEGER,
trace IN BINARY_INTEGER DEFAULT 0)
RETURN VARCHAR2;
TBD
Overload 3
dbms_backup_restore.deviceAllocate(
type IN VARCHAR2 DEFAULT NULL,
name IN VARCHAR2 DEFAULT NULL,
ident IN VARCHAR2 DEFAULT NULL,
noio IN BOOLEAN DEFAULT FALSE,
params IN VARCHAR2 DEFAULT NULL,
node OUT VARCHAR2,
dupcnt IN BINARY_INTEGER,
trace IN BINARY_INTEGER DEFAULT 0,
allowmts IN BOOLEAN,
ors_lib_key IN NUMBER)
RETURN VARCHAR2;
TBD
Overload 4
dbms_backup_restore.deviceAllocate(
type IN VARCHAR2 DEFAULT NULL,
name IN VARCHAR2 DEFAULT NULL,
ident IN VARCHAR2 DEFAULT NULL,
noio IN BOOLEAN DEFAULT FALSE,
params IN VARCHAR2 DEFAULT NULL,
node OUT VARCHAR2,
dupcnt IN BINARY_INTEGER,
trace IN BINARY_INTEGER DEFAULT 0,
allowmts IN BOOLEAN,
ors_lib_key IN NUMBER,
db_name IN VARCHAR2)
RETURN VARCHAR2;
Returns information about the currently allocated device
dbms_backup_restore.devicestatus(
state OUT BINARY_INTEGER,
type OUT VARCHAR2,
name OUT VARCHAR2,
bufsz OUT BINARY_INTEGER,
bufcnt OUT BINARY_INTEGER,
kbytes OUT NUMBER,
readrate OUT BINARY_INTEGER,
parallel OUT BINARY_INTEGER);
Generates an Auto backup if autobackup is enabled. If no channel is allocated, a copy of autobackup will be written in controlfile autoformat to disk.
Autobackup will contain the spfile if instance is started using the server parameter file.
Overload 1
dbms_backup_restore.doautobackup(
ncopies OUT BINARY_INTEGER,
cfaudate IN DATE DEFAULT NULL,
seq IN BINARY_INTEGER DEFAULT NULL,
format IN VARCHAR2 DEFAULT NULL);
TBD
Overload 2
dbms_backup_restore.doautobackup(
ncopies OUT BINARY_INTEGER,
cfaudate IN DATE DEFAULT NULL,
seq IN BINARY_INTEGER DEFAULT NULL,
format IN VARCHAR2 DEFAULT NULL,
p1 IN BINARY_INTEGER,
p2 IN BINARY_INTEGER,
p3 IN BINARY_INTEGER,
p4 IN VARCHAR2);
Check if a ?/dbs/_rm_dup_@.dat file exists from a previous failed duplication. If it exists, it is read into the PGA memory of the channel and the function returns a non zero value.
If the file does not exist, the function returns a zero value and the file is created in anticipation of a duplicate run.
Used to get the files which were restored successfully by the restore conversation.
Overload 1
dbms_backup_restore.fetchfilerestored(
firstcall IN BOOLEAN,
proxy IN BOOLEAN,
ftype OUT BINARY_INTEGER,
fno OUT BINARY_INTEGER,
thread OUT BINARY_INTEGER,
sequence OUT NUMBER,
resetSCN OUT NUMBER,
resetStamp OUT NUMBER)
RETURN BINARY_INTEGER;
TBD
Overload 2
dbms_backup_restore.fetchfilerestored(
firstcall IN BOOLEAN,
proxy IN BOOLEAN,
ftype OUT BINARY_INTEGER,
fno OUT BINARY_INTEGER,
thread OUT BINARY_INTEGER,
sequence OUT NUMBER,
resetSCN OUT NUMBER,
resetStamp OUT NUMBER,
fname OUT VARCHAR2)
RETURN BINARY_INTEGER;
Returns auto backup piece from X$KRBMSFT which match the input criteria (must spfile and until)
dbms_backup_restore.findautsearchfiletable(
mustspfile IN BOOLEAN,
until IN NUMBER,
fname OUT VARCHAR2,
year OUT BINARY_INTEGER,
month OUT BINARY_INTEGER,
day OUT BINARY_INTEGER,
sequence OUT BINARY_INTEGER,
ats OUT NUMBER)
RETURN BOOLEAN;
Starts a flashback conversation to flashback the database to given flashbackSCN/flashbackTime.
Overload 1
dbms_backup_restore.flashbackstart(
flashbackSCN IN NUMBER,
flashbackTime IN DATE,
scnBased IN BINARY_INTEGER,
toBefore IN BINARY_INTEGER);
TBD
Overload 2
dbms_backup_restore.flashbackstart(
flashbackSCN IN NUMBER,
flashbackTime IN DATE,
scnBased IN BINARY_INTEGER,
toBefore IN BINARY_INTEGER,
resetSCN IN NUMBER,
resetTime IN DATE);
TBD
Pluggable Database Overload
Overload 3
dbms_backup_restore.flashbackstart(
flashbackSCN IN NUMBER,
flashbackTime IN DATE,
scnBased IN BINARY_INTEGER,
toBefore IN BINARY_INTEGER,
resetSCN IN NUMBER,
resetTime IN DATE,
pdbId IN NUMBER);
dbms_backup_restore.genpiecename(
pno IN NUMBER,
set_count IN NUMBER,
set_stamp IN NUMBER,
format IN VARCHAR2,
copyno IN NUMBER,
devtype IN VARCHAR2,
year IN VARCHAR2,
month IN VARCHAR2,
day IN VARCHAR2,
dbid IN VARCHAR2,
ndbname IN VARCHAR2,
pdbname IN VARCHAR2,
cfseq IN NUMBER)
RETURN VARCHAR2;
TBD
Overload 2
dbms_backup_restore.genpiecename(
pno IN NUMBER,
set_count IN NUMBER,
set_stamp IN NUMBER,
format IN VARCHAR2,
copyno IN NUMBER,
devtype IN VARCHAR2,
year IN BINARY_INTEGER,
month IN BINARY_INTEGER,
day IN BINARY_INTEGER,
dbid IN NUMBER,
ndbname IN VARCHAR2,
cfseq IN NUMBER,
fileno IN NUMBER,
tsname IN VARCHAR2,
logseq IN VARCHAR2,
logthr IN NUMBER,
imagcp IN BOOLEAN)
RETURN VARCHAR2;
TBD
Overload 3
dbms_backup_restore.genpiecename(
pno IN NUMBER,
set_count IN NUMBER,
set_stamp IN NUMBER,
format IN VARCHAR2,
copyno IN NUMBER,
devtype IN VARCHAR2,
year IN BINARY_INTEGER,
month IN BINARY_INTEGER,
day IN BINARY_INTEGER,
dbid IN NUMBER,
ndbname IN VARCHAR2,
cfseq IN NUMBER,
fileno IN NUMBER,
tsname IN VARCHAR2,
logseq IN VARCHAR2,
logthr IN NUMBER,
imagcp IN BOOLEAN,
savepname IN BOOLEAN)
RETURN VARCHAR2;
TBD
Overload 4
dbms_backup_restore.genpiecename(
pno IN NUMBER,
set_count IN NUMBER,
set_stamp IN NUMBER,
format IN VARCHAR2,
copyno IN NUMBER,
devtype IN VARCHAR2,
year IN BINARY_INTEGER,
month IN BINARY_INTEGER,
day IN BINARY_INTEGER,
dbid IN NUMBER,
ndbname IN VARCHAR2,
cfseq IN NUMBER,
fileno IN NUMBER,
tsname IN VARCHAR2,
logseq IN VARCHAR2,
logthr IN NUMBER,
imagcp IN BOOLEAN,
savepname IN BOOLEAN,
fname IN VARCHAR2,
forcnvrt IN BOOLEAN)
RETURN VARCHAR2;
Generates the transport script, pfile and convert script for transportable db
Overload 1
dbms_backup_restore.gentransportscript(
tscname IN VARCHAR2 DEFAULT NULL,
pfformat IN VARCHAR2 DEFAULT NULL,
rmtscname IN VARCHAR2 DEFAULT NULL,
pfname OUT VARCHAR2,
newtscname OUT VARCHAR2,
newrmtscname OUT VARCHAR2);
TBD
Overload 2
dbms_backup_restore.gentransportscript(
tscname IN VARCHAR2 DEFAULT NULL,
pfformat IN VARCHAR2 DEFAULT NULL,
rmtscname IN VARCHAR2 DEFAULT NULL,
pfname OUT VARCHAR2,
newtscname OUT VARCHAR2,
newrmtscname OUT VARCHAR2,
parallelism IN NUMBER);
Generates an archived log file name valid for a log file with the given thread, sequence, resetlog id. Other values such as db id, activation number, log archive format and destination are taken from the mounted or open instance.
dbms_backup_restore.getarcfilename(
thread IN NUMBER,
sequence IN NUMBER,
rls_id IN NUMBER,
arcName OUT VARCHAR2);
conn / as sysdba
SELECT thread#, sequence#
FROM v$log;
set serveroutput on
DECLARE
x VARCHAR2(128);
BEGIN
dbms_backup_restore.getarcfilename(1, 11, 1, x);
dbms_output.put_line(x);
END;
/
Obtains an SCN and returns the high-recids from the controfile record section for each type of controlfile record.
The recids and the SCN are allocated from inside a controlfile transaction. If the database is not open, then the SCN is calculated in the same way as for a backup controlfile.
dbms_backup_restore.getckpt(
ckp_scn OUT NUMBER,
high_cp_recid OUT NUMBER,
high_rt_recid OUT NUMBER,
high_le_recid OUT NUMBER,
high_fe_recid OUT NUMBER,
high_fn_recid OUT NUMBER,
high_ts_recid OUT NUMBER,
high_r1_recid OUT NUMBER,
high_rm_recid OUT NUMBER,
high_lh_recid OUT NUMBER,
high_or_recid OUT NUMBER,
high_al_recid OUT NUMBER,
high_bs_recid OUT NUMBER,
high_bp_recid OUT NUMBER,
high_bf_recid OUT NUMBER,
high_bl_recid OUT NUMBER,
high_dc_recid OUT NUMBER,
high_fc_recid OUT NUMBER,
high_cc_recid OUT NUMBER,
high_dl_recid OUT NUMBER,
high_r3_recid OUT NUMBER,
high_r4_recid OUT NUMBER);
Obtains from the server the connect string to use as defined in sparams.h; if escaped is TRUE then it performs sosd specific conversion to allow connect string to be passed to RMAN host command
dbms_backup_restore.getcnctstr(
cnctstr OUT VARCHAR2,
orasid IN VARCHAR2,
escaped IN BOOLEAN);
Returns a non zero value if the filenumber is found in the ?/dbs/_rm_dup_@.dat file, the name in the datafilecopy matches the newname (for non-OMF newnames),
the datafilecopy refers to an existing datafilecopy, the creation scn of the datafilecopy matches the creation scn of the datafilecopy, the checkpoint of the datafilecopy is before the until scn,
the dbid and the dbname of the datafilecopy also match. If all checks pass the datafilecopy name and checkpoint scn are returned to the caller together with the non-zero return value
dbms_backup_restore.getduplicateddatafilecopy(
fno IN NUMBER,
newname IN VARCHAR2,
crescn IN NUMBER,
untscn IN NUMBER,
dbid IN NUMBER,
dbname IN VARCHAR2,
fname OUT VARCHAR2,
ckpscn OUT NUMBER)
RETURN BINARY-INTEGER;
Returns the guid string given the pdbid. The v$pdbs and x$kccpdb cannot be used for this because they can't retrieve guid of a non-cdb.
This routine is useful to generate a OMF filename of a non-cdb when copied to cdb. ie migrating a non-cdb to cdb.
dbms_backup_restore.getguid(pdbid IN NUMBER)
RETURN VARCHAR2;
This procedure is used to obtain the max values for the parameters used in the create controlfile command. These values cannot be obtained from tables, as are only kept in the SGA.
dbms_backup_restore.getmaxinfo(
mlogf OUT BINARY_INTEGER,
mlogm OUT BINARY_INTEGER,
mdatf OUT BINARY_INTEGER,
minst OUT BINARY_INTEGER,
mlogh OUT BINARY_INTEGER,
chset OUT VARCHAR2);
Returns the connect string of best standby by comparing the applied scn. If executed on standby, it will return the best cascading standby (if any): Otherwise NULL.
Returns a non zero value if the filenumber is found in the '?/dbs/_rm_stby_@.dat' file. If the filenumber is not found then a zero value is returned and the fname parameter is invalid.
dbms_backup_restore.getStandbyFileName(
fno IN NUMBER,
ftype IN NUMBER,
grpnum IN NUMBER DEFAULT NULL,
memnum IN NUMBER DEFAULT NULL,
crescn IN NUMBER DEFAULT NULL,
fname OUT VARCHAR2)
RETURN BINARY_INTEGER;
Return the file number and the name of the foreign datafile that will be restored as stored in the restore context. When no more files are available returns 0.
dbms_backup_restore.getXttsName(xfname OUT VARCHAR2)
RETURN NUMBER;
Returns the number of the file name as described in the plugin.xml and the file number. The description in the /rdbms/admin/dbmsbkrs is not correct.
dbms_backup_restore.getXTTS(xfname OUT VARCHAR2)
RETURN NUMBER;
DECLARE
plugin_file_name VARCHAR2(30);
plugin_file_numb NUMBER;
BEGIN
plugin_file_numb := dbms_backup_restore.getXTTSPlugName(plugin_file_name);
dbms_output.put_line(plugin_file_numb);
dbms_output.put_line(plugin_file_name);
END;
/
DECLARE
*
ERROR at line 1:
ORA-19580: restore conversation not active
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 10181
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 10174
ORA-06512: at line 5
Called to increment BACKUP_COUNT column V$ARCHIVED_LOG
dbms_backup_restore.incrarchivedlogbackupcount(
fname IN VARCHAR2,
thread OUT NUMBER,
sequence OUT NUMBER,
first_change OUT NUMBER,
all_logs IN BOOLEAN DEFAULT TRUE);
Clears FRA meta-data and re-initializes it by inspecting each FRA file w.r.t current FRA setting. This was invented to re-init FRA meta-data on clone instance.
Note that database isn't mounted as CLONE when RMAN does duplicate. So, this has be to re-initialized using an explicit call.
Used for testing to create locations because oratst doesn't support creating locations with uppercase. It initializes controlfile, logfile and datafile locations for db_create_file_dest.
Reads the header from an archived redo log and constructs a record in the controlfile as if the file had just been archived or created via copyArchivedLog.
Overload 1
dbms_backup_restore.inspectarchivedlog(
fname IN VARCHAR2,
full_name OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER);
TBD
Overload 2
dbms_backup_restore.inspectarchivedlog(
fname IN VARCHAR2,
full_name OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
change_rdi IN BOOLEAN);
dbms_backup_restore.inspetarchivedlogseq(
log_dest IN VARCHAR2,
format IN VARCHAR2 DEFAULT NULL,
thread IN BINARY_INTEGER,
sequence IN NUMBER,
full_name OUT VARCHAR2);
TBD
Overload 2
dbms_backup_restore.inspectarchivedlogseq(
log_dest IN VARCHAR2,
format IN VARCHAR2 DEFAULT NULL,
thread IN BINARY_INTEGER,
sequence IN NUMBER,
full_name OUT VARCHAR2,
resetlogs_id IN NUMBER);
Reads the header from a backuppiece and creates the corresponding backupset, backuppiece, backup datafile or backup redo log records as if the file had just been created with RMAN backup command
dbms_backup_restore.inspectbackuppiece(
handle IN VARCHAR2,
full_handle OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER);
Reads the header from a backup controlfile and creates a record in the current controlfile as if the file had just been created with 'alter database backup controlfile' or copyControlFile or restoreControlFileTo
dbms_backup_restore.inspectcontrolfile(
fname IN VARCHAR2,
full_name OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER);
Reads the header from an operating system datafile copy, and makes a record in the controlfile as if the copy had just been made via copyDataFile.
Overload 1
dbms_backup_restore.inspectdatafilecopy(
fname IN VARCHAR2,
full_name OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
isbackup IN BOOLEAN DEFAULT FALSE,
change_rdi IN BOOLEAN);
TBD
Overload 2
dbms_backup_restore.inspectdatafilecopy(
fname IN VARCHAR2,
full_name OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
isbackup IN BOOLEAN DEFAULT FALSE);
Called at begining of DBMS_IR interface it is same as icdStart in prvtbkrs.pls that increments the RPC count and sets the v$session.action field to STARTED
dbms_backup_restore.isFileNameOMF(
fname IN VARCHAR2,
isOMF OUT BOOLEAN,
isASM OUT BOOLEAN);
SELECT file_name
FROM dba_data_files;
DECLARE
isO BOOLEAN;
isA BOOLEAN;
BEGIN
dbms_backup_restore.isFileNameOMF('C:\ORACLE\ORADATA\ORABASE2\SYSTEM01.DBF', isO, isA);
IF isO THEN
dbms_output.put_line('File is OMF');
ELSIF isA THEN
dbms_output.put_line('File is ASM');
ELSE
dbms_output.put_line('Not OMF or ASM');
END IF;
END;
/
Does the filename belong to an Oracle Template
Overload 2
dbms_backup_restore.isfilenameomf(
fname IN VARCHAR2,
isOMF OUT BOOLEAN,
isASM OUT BOOLEAN,
isTMPLT OUT BOOLEAN);
DECLARE
isO BOOLEAN;
isA BOOLEAN;
isT BOOLEAN;
BEGIN
dbms_backup_restore.isFileNameOMF('C:\ORACLE\ORADATA\ORABASE2\SYSTEM01.DBF', isO, isA);
IF isO THEN
dbms_output.put_line('File is OMF');
ELSIF isA THEN
dbms_output.put_line('File is ASM');
ELSIF isT THEN
dbms_output.put_line('File is Oracle Template');
ELSE
dbms_output.put_line('Not OMF, ASM, or Template');
END IF;
END;
/
Returns the count of files that need to be processed
dbms_backup_restore.nbrFileStatus(files OUT BINARY_INTEGER);
DECLARE
retVal PLS_INTEGER;
BEGIN
dbms_backup_restore.nbrAddFile(retVal);
dbms_output.put_line(retVal);
END;
/
DECLARE
*
ERROR at line 1:
ORA-19580: nbr conversation not active
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 9990
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 9984
ORA-06512: at line 4
dbms_backup_restore.networkfiletransfer(
dbname IN VARCHAR2,
username IN VARCHAR2 DEFAULT NULL,
passwd IN VARCHAR2 DEFAULT NULL,
srcfile IN VARCHAR2,
destfile IN VARCHAR2,
operation IN VARCHAR2)
RETURN BOOLEAN;
TBD
Overload 2
dbms_backup_restore.networkfiletransfer(
dbname IN VARCHAR2,
username IN VARCHAR2 DEFAULT NULL,
passwd IN VARCHAR2 DEFAULT NULL,
role IN VARCHAR2,
srcfile IN VARCHAR2,
destfile IN VARCHAR2,
operation IN VARCHAR2,
retcode OUT NUMBER)
RETURN BOOLEAN;
TBD
Overload 3
dbms_backup_restore.networkfiletransfer(
dbname IN VARCHAR2,
username IN VARCHAR2 DEFAULT NULL,
passwd IN VARCHAR2 DEFAULT NULL,
role IN VARCHAR2,
srcfile IN VARCHAR2,
destfile IN VARCHAR2,
operation IN VARCHAR2,
ftype_check IN BOOLEAN,
retcode OUT NUMBER)
RETURN BOOLEAN;
dbms_backup_restore.networkReadFileHeader(
service IN VARCHAR2,
dfNUMBER IN BINARY_INTEGER,
blksize IN NUMBER,
blocks OUT NUMBER,
crescn OUT NUMBER,
rlgscn OUT NUMBER,
ckpscn OUT NUMBER,
afzscn OUT NUMBER,
rfzscn OUT NUMBER,
fhdbi OUT NUMBER,
fhfdbi OUT NUMBER,
fhplus OUT NUMBER);
Sets section size for multi-section backup in remote server
dbms_backup_restore.networkSetMSB(
dfnumber IN NUMBER,
section_size IN NUMBER,
first_section IN NUMBER,
section_count IN NUMBER,
pieceno IN NUMBER,
piececnt IN NUMBER);
dbms_backup_restore.nidbegin(
newdbname IN VARCHAR2,
olddbname IN VARCHAR2,
newdbid IN NUMBER,
olddbid IN NUMBER,
dorevert IN BINARY_INTEGER,
dorestart IN BINARY_INTEGER,
events IN NUMBER);
dbms_backup_restore.nidprocessdf(
fno IN NUMBER,
istemp IN BINARY_INTEGER,
skipped OUT BINARY_INTEGER,
chgdbid OUT BINARY_INTEGER,
chgdbname OUT BINARY_INTEGER);
Checks if our SBT tape channel is using Oracle Backup. If so, sets isOracle to TRUE and returns the version number as a text string in the form of "AAA.BBB.CCC.DDD".
dbms_backup_restore.oraclesbtversion(
isOracle OUT BOOLEAN,
version OUT VARCHAR2);
Parses the plugin XML file in the context of a restore foreign pluggable database to infer the afn (absolute fil#) and datafile path and used by restore while calling 'CREATE PLUGGABLE' in SOURCE_FILE_NAME_CONVERT
dbms_backup_restore.parsePlugXMLFile(plugXmlPath IN VARCHAR2);
A more precise time check for PDB orphan branch in PDB PITR and flashback
Clearly there is an untrapped internal error when this is executed in a manner never intended to be used (my database has no PDB 6)
dbms_backup_restore.pdbTimeCheck(
pdbid IN NUMBER,
untilTime IN DATE,
isFlashback IN BINARY_INTEGER);
exec dbms_backup_restore.pdbTimeCheck(6, SYSDATE-1, 0);
BEGIN dbms_backup_restore.pdbTimeCheck(6, SYSDATE-1, 0); END;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [2130], [0], [10], [38], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 10668
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 10665
ORA-06512: at line 1
This procedure sets the pre-plugin media recovery context
dbms_backup_restore.prePluginRecoveryStart(
pdbid IN NUMBER, -- pdb con_id
pplpdbid IN NUMBER, -- pre-plugin PDB con_id
pplcdbdbid IN NUMBER, -- pre-plugin root dbid (orig CDB)
unplugScn IN NUMBER); -- SCN at which PDB was unplugged
Begin a proxy backup session. The database must be mounted for proxy backups, so that the backups can be recorded in the controlfile.
Overload 1
dbms_backup_restore.proxyBeginBackup(
tag IN VARCHAR2 DEFAULT NULL,
incremental IN BOOLEAN DEFAULT FALSE,
media_pool IN BINARY_INTEGER DEFAULT 0,
set_stamp OUT NUMBER,
set_count OUT NUMBER);
TBD
Overload 2
dbms_backup_restore.proxyBeginBackup(
tag IN VARCHAR2 DEFAULT NULL,
incremental IN BOOLEAN DEFAULT FALSE,
media_pool IN BINARY_INTEGER DEFAULT 0,
set_stamp OUT NUMBER,
set_count OUT NUMBER,
keep_options IN BINARY_INTEGER,
keep_until IN NUMBER);
Change proxy backup status, delete from the storage subsystem, or validate that a proxy backup exists in the storage subsystem
Overload 1
dbms_backup_restore.proxychange(
recid IN NUMBER,
stamp IN NUMBER,
handle IN VARCHAR2,
status IN VARCHAR2, -- 'D','A','U','X'
params IN VARCHAR2 DEFAULT NULL);
TBD
Overload 2
dbms_backup_restore.proxyChange(
recid IN NUMBER,
stamp IN NUMBER,
handle IN VARCHAR2,
status IN VARCHAR2, -- 'D','A','U','X','K'
params IN VARCHAR2 DEFAULT NULL,
keep_options IN BINARY_INTEGER,
keep_until IN NUMBER);
TBD
Overload 3
dbms_backup_restore.proxyChange(
recid IN NUMBER,
stamp IN NUMBER,
handle IN VARCHAR2,
status IN VARCHAR2, -- 'D','A','U','X','K'
params IN VARCHAR2 DEFAULT NULL,
keep_options IN BINARY_INTEGER,
keep_until IN NUMBER,
force IN BINARY_INTEGER);
Specifies one archived log to be restored during a proxy session
Overload 1
dbms_backup_restore.proxyRestoreArchivedlog(
handle IN VARCHAR2,
thread IN BINARY_INTEGER,
sequence IN NUMBER);
TBD
Overload 2
dbms_backup_restore.proxyRestoreArchivedlog(
handle IN VARCHAR2,
thread IN BINARY_INTEGER,
sequence IN NUMBER,
resetlogs_id IN NUMBER,
blksize IN BINARY_INTEGER,
blocks IN NUMBER);
Specifies one datafile to be restored during a proxy session
Overload 1
dbms_backup_restore.proxyRestoreDataFile(
handle IN VARCHAR2,
file# IN BINARY_INTEGER,
toname IN VARCHAR2 DEFAULT NULL);
TBD
Overload 2
dbms_backup_restore.proxyRestoreDataFile(
handle IN VARCHAR2,
file# IN BINARY_INTEGER,
toname IN VARCHAR2 DEFAULT NULL,
tsname IN VARCHAR2,
blksize IN BINARY_INTEGER,
blocks IN NUMBER);
Reads the header of a archived redo log and returns thread, sequence, first_change# and next_change#. No controlfile record is added.
dbms_backup_restore.readArchivedLogHeader(
fname IN VARCHAR2,
full_name OUT VARCHAR2,
thread OUT NUMBER,
sequence OUT NUMBER,
first_change OUT NUMBER,
next_change OUT NUMBER,
resetlogs_change OUT NUMBER,
resetlogs_time OUT DATE);
Used to obtain information from the file header of a datafile that is being cross-platform converted at the target.
In this case the file does not belong to the database (yet) and its block format is not the same of the database that is doing the conversion.
dbms_backup_restore.readFileHeader(
fname IN VARCHAR2,
dbname OUT VARCHAR2,
dbid OUT NUMBER,
tsname OUT VARCHAR2,
fno OUT BINARY_INTEGER,
nblocks OUT NUMBER,
blksize OUT BINARY_INTEGER,
plid OUT BINARY_INTEGER,
sameen IN BINARY_INTEGER);
dbms_backup_restore.recoverStart(
opcode IN BINARY_INTEGER,
pitrSCN IN NUMBER,
pitrTime IN DATE,
scnBased IN BINARY_INTEGER,
toBefore IN BINARY_INTEGER,
resetSCN IN NUMBER,
resetTime IN DATE,
cleanResPt IN BINARY_INTEGER,
localUndo IN BINARY_INTEGER,
rspName IN VARCHAR2);
Reads the header from an operating system datafile copy, and makes a record in the controlfile section V$AUXILIARY_DATAFILE_COPY.
This is used later to extract the undo for a PDB during open resetlogs operation of a PDB.
dbms_backup_restore.registerAuxDFCopy(
pdbname IN VARCHAR2,
clnscnwrp IN NUMBER,
clnscnbas IN NUMBER,
auxdfcList IN register_auxdfc_list);
Allows execution of a SQL statement at a remote database identified by the source_cs connect and source_dbuname db_unique_name parameters to execute a simple SQL statement or a SELECT statement that returns only one row,
the value is returned by the function.
dbms_backup_restore.remotesqlexecute(
source_dbuname IN VARCHAR2,
source_cs IN VARCHAR2,
stmt IN VARCHAR2)
RETURN VARCHAR2;
A special version of copyDataFileCopy, but is used when performing a duplicate, in this case, there is no controlfile at the duplicate
Overload 1
dbms_backup_restore.resdataFileCopy(
cname IN VARCHAR2,
fname IN VARCHAR2,
full_name OUT VARCHAR2,
max_corrupt IN BINARY_INTEGER DEFAULT 0,
check_logical IN BOOLEAN,
blksize IN BINARY_INTEGER,
blocks IN BINARY_INTEGER,
fno IN BINARY_INTEGER,
scnstr IN VARCHAR2,
rfno IN BINARY_INTEGER);
TBD
Overload 2
dbms_backup_restore.resdataFileCopy(
cname IN VARCHAR2,
fname IN VARCHAR2,
full_name OUT VARCHAR2,
max_corrupt IN BINARY_INTEGER DEFAULT 0,
check_logical IN BOOLEAN,
blksize IN BINARY_INTEGER,
blocks IN BINARY_INTEGER,
fno IN BINARY_INTEGER,
scnstr IN VARCHAR2,
rfno IN BINARY_INTEGER,
tsname IN VARCHAR2);
Restore logs, specified by thrad and sequence, from a redo log backup set (NUMBER(restoreArchivedLog).
Multiple calls can be made to specify thread and sequence NUMBERs. Only one SCN range and destination can be given per restore.
dbms_backup_restore.restoreArchivedlog(
thread IN BINARY_INTEGER,
sequence IN NUMBER);
Restore logs from a redo log backup set, and where to restore them.
The logs are specified by giving an SCN range(restoreArchivedLogRange). Multiple calls can be made to specify thread and sequence NUMBERs. Only one SCN range and destination can be given per restore.
dbms_backup_restore.restoreArchivedlogRange(
low_change IN NUMBER DEFAULT 0,
high_change IN NUMBER DEFAULT 281474976710655);
Reads one backup piece and writes its contents to the files in the restore list. Creates files from complete backups.
Overload 1
dbms_backup_restore.restoreBackupPiece(
handle IN VARCHAR2,
done OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
fromdisk IN BOOLEAN DEFAULT FALSE);
TBD
Overload 2
dbms_backup_restore.restoreBackupPiece(
done OUT BOOLEAN,
params IN VARCHAR2 DEFAULT NULL,
outhandle OUT VARCHAR2,
outtag OUT VARCHAR2,
failover OUT BOOLEAN);
Copies the controlfile from the backup set to an operating system file. If the database is mounted, the name must NOT match any of the current controlfiles.
Overload 1
dbms_backup_restore.restoreControlFileTo(cfname IN VARCHAR2);
TBD
Overload 2
dbms_backup_restore.restoreControlFileTo(
cfname IN VARCHAR2,
isstby IN BOOLEAN);
TBD
Overload 3
dbms_backup_restore.restoreControlFileTo(
cfname IN VARCHAR2
isstby IN BOOLEAN
nocfconv IN BOOLEAN);
Creates the output file from a complete backup in the backup set
Overload 1
dbms_backup_restore.restoredatafileto(
dfNUMBER IN BINARY_INTEGER,
toname IN VARCHAR2 DEFAULT NULL);
TBD
Overload 2
dbms_backup_restore.restoredatafileto(
dfNUMBER IN BINARY_INTEGER,
toname IN VARCHAR2 DEFAULT NULL,
max_corrupt IN BINARY_INTEGER);
TBD
Overload 3
dbms_backup_restore.restoredatafileto(
dfNUMBER IN BINARY_INTEGER,
toname IN VARCHAR2 DEFAULT NULL,
max_corrupt IN BINARY_INTEGER,
tsname IN VARCHAR2);
Begins a conversation that will completely recreate datafiles and possibly a controlfile from the backup
Overload 1
dbms_backup_restore.restoreSetDataFile;
exec dbms_backup_restore.restoreSetDataFile;
Overload 2
dbms_backup_restore.restoreSetDataFile(check_logical IN BOOLEAN);
TBD
Overload 3
dbms_backup_restore.restoreSetDataFile(
check_logical IN BOOLEAN,
cleanup IN BOOLEAN);
TBD
Overload 4
dbms_backup_restore.restoreSetDataFile(
check_logical IN BOOLEAN,
cleanup IN BOOLEAN,
service IN VARCHAR2);
TBD
Overload 5
dbms_backup_restore.restoreSetDataFile(
check_logical IN BOOLEAN,
cleanup IN BOOLEAN,
service IN VARCHAR2,
chunksize IN BINARY_INTEGER,
rs_flags IN BINARY_INTEGER);
dbms_backup_restore.restoreSetForeignDF(
check_logical IN BOOLEAN,
cleanup IN BOOLEAN,
service IN VARCHAR2,
dfincr IN BOOLEAN
sameend IN BOOLEAN DEFAULT TRUE);
Sets up the handle for restoreBackupPiece to use. When multiple copies of piece exists, call restoreSetPiece to for each copy before calling restoreBackupPiece. This will enable RESTORE FAILOVER feature inside kernel.
dbms_backup_restore.restoresetpiece(
handle IN VARCHAR2,
tag IN VARCHAR2,
fromdisk IN BOOLEAN,
recid IN NUMBER,
stamp IN NUMBER);
Initiates a restore conversation for files that do not belong to this database from backup pieces that are not part of the database to transport a tablespace
dbms_backup_restore.restoreSetXTTFile(
pltfrmfr IN BINARY_INTEGER,
xttincr IN BOOLEAN);
Returns information about the current restore conversation.
It is useful for resyncing with a conversation after some error has interrupted normal execution, and it is now time to resume the conversation. It can also be called when there is no conversation.
dbms_backup_restore.restorestatus(
state OUT BINARY_INTEGER,
pieceno OUT BINARY_INTEGER,
files OUT BINARY_INTEGER,
datafiles OUT BOOLEAN,
incremental OUT BOOLEAN,
device OUT BOOLEAN);
Forces the reading of the entire backup set as if all files in the backup were being restored but no data is written to any files. Incremental backup application does not require a valid file to applying the changes.
dbms_backup_restore.restorevalidate;
-- After the conversation is complete, a report is written to an
-- trace file, giving the status of all the files in the backup set.
--
-- Restore Conversation File Status Report
-- File Start Finish OK Name
-- ----- ----- ------ -- --------------------
-- 2 Y Y Y
-- 4 Y Y Y
-- 6 Y Y Y
-- 3 Y Y Y
-- 5 Y Y Y
Add a file to the restore conversation for files that do not belong to this database that will be restored
dbms_backup_restore.restoreXTTFileTo(
xtype IN BINARY_INTEGER,
xfno IN BINARY_INTEGER,
xtsname IN VARCHAR2,
xfname IN VARCHAR2);
-- All files for this backup piece list
XTT_ALL CONSTANT BINARY_INTEGER := 0;
-- Tablespace name is valid in xtsname
XTT_TABLESPACE CONSTANT BINARY_INTEGER := 1;
-- Absolute filenumber is valid in xfno
XTT_FILENO CONSTANT BINARY_INTEGER := 2;
Appears to return the number of recorded RMAN usages that meet the input criteria
dbms_backup_restore.rman_usage(
diskonly IN BOOLEAN,
nondiskonly IN BOOLEAN,
encrypted IN BOOLEAN,
compalg IN VARCHAR2) -- compression algorithm
RETURN BINARY_INTEGER;
Scans a file and verifies the checksum (if present) in each block
Overload 1
dbms_backup_restore.scanDataFile(
dfNUMBER IN BINARY_INTEGER,
max_corrupt IN BINARY_INTEGER DEFAULT 0,
update_fuzziness IN BOOLEAN DEFAULT TRUE)
RETURN NUMBER;
TBD
Overload 2
dbms_backup_restore.scandatafile(
dfNUMBER IN BINARY_INTEGER,
max_corrupt IN BINARY_INTEGER DEFAULT 0,
update_fuzziness IN BOOLEAN DEFAULT TRUE,
check_logical IN BOOLEAN)
RETURN NUMBER;
Scans a file and verifies the checksum (if present) in each block
Overload 1
dbms_backup_restore.scanDataFileCopy(
recid IN NUMBER,
stamp IN NUMBER,
max_corrupt IN BINARY_INTEGER DEFAULT 0,
isbackup IN BOOLEAN DEFAULT FALSE,
update_fuzziness IN BOOLEAN DEFAULT TRUE)
RETURN NUMBER;
TBD
Overload 2
dbms_backup_restore.scanDataFileCopy(
recid IN NUMBER,
stamp IN NUMBER,
max_corrupt IN BINARY_INTEGER DEFAULT 0,
isbackup IN BOOLEAN DEFAULT FALSE,
update_fuzziness IN BOOLEAN DEFAULT TRUE,
check_logical IN BOOLEAN)
RETURN NUMBER;
Populates X$KRBMSFT with files that match the specified pattern
Overload 1
dbms_backup_restore.searchFiles(
pattern IN OUT VARCHAR2,
ns IN OUT VARCHAR2,
ccf IN BOOLEAN DEFAULT FALSE,
omf IN BOOLEAN DEFAULT FALSE,
ftype IN VARCHAR2 DEFAULT NULL);
set serveroutput on
DECLARE
TYPE file_rec IS RECORD (FileName dbms_sql.varchar2_table);
frec file_rec;
CURSOR fcur IS
SELECT fname_krbmsft AS FileName
FROM x$krbmsft
WHERE fname_krbmsft LIKE '%.%';
dirname VARCHAR2(1024) := 'c:\temp';
ns VARCHAR2(1024);
BEGIN
dbms_backup_restore.searchFiles(dirname, ns);
OPEN fcur;
FETCH fcur BULK COLLECT INTO frec;
CLOSE fcur;
FOR i IN 1 .. frec.FileName.COUNT LOOP
dbms_output.put_line(frec.FileName(i));
END LOOP;
END;
/
DECLARE
fn VARCHAR2(100);
yr PLS_INTEGER;
mo PLS_INTEGER;
dy PLS_INTEGER;
seq PLS_INTEGER;
ts NUMBER;
b BOOLEAN;
BEGIN
b := dbms_backup_restore.findAutSearchFileTable(FALSE, 1, fn, yr, mo, dy, seq, ts);
dbms_output.put_line(fn);
dbms_output.put_line(yr);
dbms_output.put_line(mo);
dbms_output.put_line(dy);
dbms_output.put_line(seq);
dbms_output.put_line(ts);
END;
/
dbms_backup_restore.searchfiles(
pattern IN OUT VARCHAR2,
ns IN OUT VARCHAR2,
ccf IN BOOLEAN DEFAULT FALSE,
omf IN BOOLEAN DEFAULT FALSE,
ftype IN VARCHAR2 DEFAULT NULL,
onlyfnm IN BOOLEAN,
normfnm IN BOOLEAN);
Called after export for transporting encrypted tablespace
dbms_backup_restore.setExportJobName(
jobname IN VARCHAR2, -- name of the export job
passphrase IN VARCHAR2); -- TDE password
exec dbms_backup_restore.setExportJobName('UWExpJob', 'ZZYZX');
BEGIN dbms_backup_restore.setExportJobName('UWExpJob', 'ZZYZX'); END;
*
ERROR at line 1:
ORA-19580: backup conversation not active
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 10329
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 10323
ORA-06512: at line 1
dbms_backup_restore.setmsb(
dfnumber IN NUMBER,
section_size IN NUMBER,
first_section IN NUMBER,
section_count IN NUMBER,
set_stamp IN NUMBER,
set_count IN NUMBER,
pieceno IN NUMBER,
piececnt IN NUMBER);
dbms_backup_restore.setMSB_AL(
thread IN NUMBER,
sequence IN NUMBER,
section_size IN NUMBER,
first_section IN NUMBER,
section_count IN NUMBER,
set_stamp IN NUMBER,
set_count IN NUMBER,
pieceno IN NUMBER,
piececnt IN NUMBER);
dbms_backup_restore.setParms(
p0 IN NUMBER DEFAULT NULL,
p1 IN NUMBER DEFAULT NULL,
p2 IN NUMBER DEFAULT NULL,
p3 IN NUMBER DEFAULT NULL,
p4 IN NUMBER DEFAULT NULL,
p5 IN VARCHAR2 DEFAULT NULL,
p6 IN VARCHAR2 DEFAULT NULL,
p7 IN VARCHAR2 DEFAULT NULL,
p8 IN VARCHAR2 DEFAULT NULL,
p9 IN VARCHAR2 DEFAULT NULL);
Set the values in x$kcpdbinc key for orphan pdb incarnation restore
required to make the correct backup selection based on restore point and time stamp.
dbms_backup_restore.setPDBinc(
pdbid IN NUMBER,
rspname IN VARCHAR2,
untilTime IN DATE,
do_resync OUT NUMBER);
Equivalent to dbms_application_info.set_client_info. Was added so RMAN could call it from recover.bsq without needing to make the x$kqp326 package spec public.
dbms_backup_restore.set_client_info(client_info IN VARCHAR2);
Cecks if a '?/dbs/_rm_stby_@.dat' file exists from a previous failed standby sync. If it exists, it is read into the PGA memory of the channel and the function returns a non zero value.
Renames a controlfile tempfile record. Will add missing tempfile and tablespace records if they are missing.
Overload 1
dbms_backup_restore.switchtempfile(
tsnum IN NUMBER,
tsname IN VARCHAR2,
tfnum IN NUMBER,
tfname IN VARCHAR2,
create_time IN DATE,
create_scn IN NUMBER,
blocks IN NUMBER,
blocksize IN BINARY_INTEGER,
rfnum IN NUMBER,
exton IN BOOLEAN,
isSFT IN BOOLEAN,
maxsize IN NUMBER,
nextsize IN NUMBER);
TBD
Pluggable Database Overload
Overload 2
dbms_backup_restore.switchtempfile(
tsnum IN NUMBER,
tsname IN VARCHAR2,
tfnum IN NUMBER,
tfname IN VARCHAR2,
create_time IN DATE,
create_scn IN NUMBER,
blocks IN NUMBER,
blocksize IN BINARY_INTEGER,
rfnum IN NUMBER,
exton IN BOOLEAN,
isSFT IN BOOLEAN,
maxsize IN NUMBER,
nextsize IN NUMBER
pdbId IN NUMBER);
Sets a lock on transportable db context. The name of the new database to be created on the target platform can be passed to transportable db context, too.
dbms_backup_restore.transportdblock(newdbname IN VARCHAR2 DEFAULT NULL);
Called by RMAN when headers of locally managed datafiles need to be updated after the database compatibility has been upgraded to 10.2 or above
dbms_backup_restore.updateHeaders RETURN BOOLEAN;
set serveroutput on
BEGIN
IF dbms_backup_restore.updateheaders THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;
/
-- 12cR1 error
ERROR at line 1:
ORA-00600: internal error code, arguments: [krbbUpdLocManHeaders_noctx], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 7923
ORA-06512: at line 2
-- 18cR3 error
ERROR at line 1:
ORA-00600: internal error code, arguments: [krbbUpdLocManHeaders_noctx], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 9058
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 9054
ORA-06512: at line 2
-- 19cR3 error
ERROR at line 1:
ORA-00600: internal error code, arguments: [krbbUpdLocManHeaders_noctx], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 9106
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 9102
ORA-06512: at line 2
-- 21cR1 error
BEGIN
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [krbbUpdLocManHeaders_noctx],
[], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 9301
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 9297
ORA-06512: at line 2
Validates the correctness of archived log information in the recovery catalog and controlfile
Overload 1
dbms_backup_restore.validatearchivedlog(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
thread IN NUMBER,
sequence IN NUMBER,
resetlogs_change IN NUMBER,
first_change IN NUMBER,
blksize IN NUMBER)
RETURN BINARY_INTEGER;
TBD
Overload 2
dbms_backup_restore.validatearchivedlog(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
thread IN NUMBER,
sequence IN NUMBER,
resetlogs_change IN NUMBER,
first_change IN NUMBER,
blksize IN NUMBER,
signal IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
Overload 3
dbms_backup_restore.validatearchivedlog(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
thread IN NUMBER,
sequence IN NUMBER,
resetlogs_change IN NUMBER,
first_change IN NUMBER,
blksize IN NUMBER,
signal IN BINARY_INTEGER,
terminal IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
Overload 4
dbms_backup_restore.validatearchivedlog(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
thread IN NUMBER,
sequence IN NUMBER,
resetlogs_change IN NUMBER,
first_change IN NUMBER,
blksize IN NUMBER,
signal IN BINARY_INTEGER,
terminal IN BINARY_INTEGER,
foreignal IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
Validates the correctness of backup piece information in the recovery catalog and controlfile
Overload 1
dbms_backup_restore.validatebackuppiece(
recid IN NUMBER,
stamp IN NUMBER,
handle IN VARCHAR2,
set_stamp IN NUMBER,
set_count IN NUMBER,
pieceno IN BINARY_INTEGER,
params IN VARCHAR2 DEFAULT NULL)
RETURN BINARY_INTEGER;
TBD
Overload 2
dbms_backup_restore.validatebackuppiece(
recid IN NUMBER,
stamp IN NUMBER,
handle IN VARCHAR2,
set_stamp IN NUMBER,
set_count IN NUMBER,
pieceno IN BINARY_INTEGER,
params IN VARCHAR2 DEFAULT NULL,
hdl_isdisk IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
Overload 3
dbms_backup_restore.validatebackuppiece(
recid IN NUMBER,
stamp IN NUMBER,
handle IN VARCHAR2,
set_stamp IN NUMBER,
set_count IN NUMBER,
pieceno IN BINARY_INTEGER,
params IN VARCHAR2 DEFAULT NULL,
hdl_isdisk IN BINARY_INTEGER,
media OUT VARCHAR2)
RETURN BINARY_INTEGER;
Validates the correctness of datafile copy information in the recovery catalog and controlfile
Overload 1
dbms_backup_restore.validatedatafilecopy(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
dfnumber IN BINARY_INTEGER,
resetlogs_change IN NUMBER,
creation_change IN NUMBER,
checkpoint_change IN NUMBER,
blksize IN NUMBER)
RETURN BINARY_INTEGER;
TBD
Overload 2
dbms_backup_restore.validatedatafilecopy(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
dfnumber IN BINARY_INTEGER,
resetlogs_change IN NUMBER,
creation_change IN NUMBER,
checkpoint_change IN OUT NUMBER,
checkpoint_time IN OUT BINARY_INTEGER,
blksize IN NUMBER,
signal IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
Overload 3
dbms_backup_restore.validatedatafilecopy(
recid IN NUMBER,
stamp IN NUMBER,
fname IN VARCHAR2,
dfnumber IN BINARY_INTEGER,
resetlogs_change IN NUMBER,
creation_change IN NUMBER,
checkpoint_change IN NUMBER,
blksize IN NUMBER,
signal IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
Validate that the tablespace has not been recreated when performing TSPITR
Overload 1
dbms_backup_restore.validatetablespace(
tsid IN BINARY_INTEGER,
cSCN IN NUMBER) -- Minimum SCN of all TBSP datafiles at the PIT of the TSPITR
RETURN BINARY_INTEGER; -- 0 if recreated, 1 if not
TBD
Pluggable Database Overload
Overload 2
dbms_backup_restore.validatetablespace(
tsid IN BINARY_INTEGER,
cSCN IN NUMBER, -- Minimum SCN of all TBSP datafiles at the PIT of the TSPITR
pdbId IN NUMBER)
RETURN BINARY_INTEGER; -- 0 if recreated, 1 if not
Adds a backup piece to the list of pieces to validate
dbms_backup_restore.validationaddpiece(
recid IN NUMBER,
stamp IN NUMBER,
handle IN VARCHAR2,
set_stamp IN NUMBER,
set_count IN NUMBER,
pieceno IN NUMBER,
params IN VARCHAR2 DEFAULT NULL,
hdl_isdisk IN BINARY_INTEGER);
Gets the next result.- If no more results are found, then HANDLE is null
Overload 1
dbms_backup_restore.validationnextresult(
handle OUT VARCHAR2,
recid OUT NUMBER,
set_stamp OUT NUMBER,
set_count OUT NUMBER,
pieceno OUT NUMBER,
msca OUT BINARY_INTEGER,
m1 OUT VARCHAR2,
m2 OUT VARCHAR2,
m3 OUT VARCHAR2,
m4 OUT VARCHAR2,
m5 OUT VARCHAR2,
m6 OUT VARCHAR2,
m7 OUT VARCHAR2,
m8 OUT VARCHAR2,
m9 OUT VARCHAR2,
m10 OUT VARCHAR2,
m11 OUT VARCHAR2,
m12 OUT VARCHAR2,
m13 OUT VARCHAR2,
m14 OUT VARCHAR2,
m15 OUT VARCHAR2,
m16 OUT VARCHAR2,
m17 OUT VARCHAR2,
m18 OUT VARCHAR2,
m19 OUT VARCHAR2,
m20 OUT VARCHAR2);
TBD
Overload 2
dbms_backup_restore.validationnextresult(
handle OUT VARCHAR2,
recid OUT NUMBER,
set_stamp OUT NUMBER,
set_count OUT NUMBER,
pieceno OUT NUMBER,
msca OUT BINARY_INTEGER,
m1 OUT VARCHAR2,
m2 OUT VARCHAR2,
m3 OUT VARCHAR2,
m4 OUT VARCHAR2,
m5 OUT VARCHAR2,
m6 OUT VARCHAR2,
m7 OUT VARCHAR2,
m8 OUT VARCHAR2,
m9 OUT VARCHAR2,
m10 OUT VARCHAR2,
m11 OUT VARCHAR2,
m12 OUT VARCHAR2,
m13 OUT VARCHAR2,
m14 OUT VARCHAR2,
m15 OUT VARCHAR2,
m16 OUT VARCHAR2,
m17 OUT VARCHAR2,
m18 OUT VARCHAR2,
m19 OUT VARCHAR2,
m20 OUT VARCHAR2,
attributes OUT BINARY_INTEGER);
Performs "the" validation ... whatever that means
Overload 1
dbms_backup_restore.validationValidate;
exec dbms_backup_restore.validationvalidate;
Overload 2
dbms_backup_restore.validationValidate(flags IN BINARY_INTEGER);
-- VVFLAGS_RECALL bit flag indicate that server should request SBT
-- to recall remote backups for current set of backup files.
VVFLAGS_RECALL constant binary_integer := 1;
Writes one record to the ?/dbs/_rm_dup_@.dat file and flushes the record to disk. If the write fails the failure is logged in the trace file but no error is signaled
dbms_backup_restore.writeDuplicatedDataFileCopy(
fno IN NUMBER,
fname IN VARCHAR2);
writes one record to the '?/dbs/_stby_dup_@.dat' file and flushes the record to disk.If the write fails the failure is logged in the trace file but no error is signaled.
dbms_backup_restore.writeStandbyFileName(
fno IN NUMBER,
fname IN VARCHAR2,
ftype IN NUMBER,
grpnum IN NUMBER DEFAULT NULL);
