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.
TYPE rcvRec_t IS RECORD(
-- *** Recovery Container Section ***
type_con NUMBER(3), -- recovery container type
key_con NUMBER(15), -- primary key
recid_con NUMBER(10), -- recid
stamp_con NUMBER(10), -- stamp
setStamp_con NUMBER(10), -- set count if backup set (null)
setCount_con NUMBER(10), -- set stamp if backup set (null)
bsRecid_con NUMBER(10), -- backup set recid (null)
bsStamp_con NUMBER(10), -- backup set stamp (null)
bsKey_con NUMBER(15), -- backup set key (null)
bsLevel_con NUMBER(1), -- backup set level (null)
bsType_con VARCHAR2(1), -- backup set type
elapseSecs_con NUMBER(10), -- backup set elapse seconds (null)
pieceCount_con NUMBER(5), -- backup set piece count (null)
fileName_con VARCHAR2(1024), -- filename is a copy (or) piece (null)
tag_con VARCHAR2(32), -- tag (null) filled in by addAction() for backup sets
copyNumber_con NUMBER(3), -- backup set copy# (null) maxlimit 256
-- filled in by addAction() only
status_con VARCHAR2(1), -- status (null)
blocks_con NUMBER(10), -- size of file in blocks (null)
blockSize_con NUMBER(5), -- block size (null)
deviceType_con VARCHAR2(255), -- device type required (null) filled in by
-- addAction() for backup sets
compTime_con DATE, -- completion time
cfCreationTime_con DATE, -- controlfile creation time if offline range (null)
pieceNumber_con NUMBER,
bpCompTime_con DATE,
bpCompressed_con VARCHAR2(3),
multi_section_con VARCHAR2(1), -- multi-section backup piece
-- *** Recovery Action Section ***
type_act NUMBER(3), -- recovery action type
fromSCN_act NUMBER(15),
toSCN_act NUMBER(15),
toTime_act DATE,
rlgSCN_act NUMBER(15),
rlgTime_act DATE,
dbincKey_act NUMBER(15),
level_act NUMBER(1),
section_size_act NUMBER,
-- *** Recovery Object Section ***
dfNumber_obj NUMBER(6),
dfCreationSCN_obj NUMBER(15),
cfSequence_obj NUMBER(15), -- controlfile autobackup sequence
cfDate_obj DATE, -- controlfile autobackup date
logSequence_obj NUMBER(10),
logThread_obj NUMBER(4),
logRlgSCN_obj NUMBER(15),
logRlgTime_obj DATE,
logLowSCN_obj NUMBER(15),
logLowTime_obj DATE,
logNextSCN_obj NUMBER(15),
logNextTime_obj DATE,
logTerminal_obj VARCHAR2(3),
cfType_obj VARCHAR2(1), -- controlfile type ('B' or 'S')
-- *** Retention Policy Section ***
keep_options NUMBER(4),
keep_until DATE,
-- *** optimization Action Section ***
afzSCN_act NUMBER(15),
rfzTime_act DATE,
rfzSCN_act NUMBER(15),
-- *** media Action Section ***
media_con VARCHAR2(80), -- media volume name for backup piece
isrdf_con VARCHAR2(3),
-- ** site specific information for recovery action ***
site_key_con NUMBER,
-- *** plugged section ***
foreignDbid_obj NUMBER, -- foreign database id
pluggedRonly_obj BINARY_INTEGER, -- 1 for read-only. Otherwise, 0
pluginSCN_obj NUMBER, -- plugin change#
pluginRlgSCN_obj NUMBER, -- plugin resetlogs change#
pluginRlgTime_obj DATE, -- plugin resetlogs time
-- ** sort order section ***
newDfCreationSCN_obj NUMBER, -- plugin scn or creation scn
newToSCN_act NUMBER, -- plugin scn or checkpoint scn
newRlgSCN_act NUMBER, -- plugin rlgscn or rlgscn
newRlgTime_act DATE, -- plugin rlgtime or rlgtime
-- ** SPFILE specific data **
sfDbUniqueName_obj VARCHAR2(30),
-- ** sparseness information for datafiles **
sparse_backup_con VARCHARr2(3), -- whether sparse or nonsparse backup
ppl_pdb_id_con NUMBER, -- preplugin pdb id
ppl_cdb_dbid_con NUMBER); -- preplugin cdb database id);
TYPE bsRec_t IS RECORD (
recid NUMBER,
stamp NUMBER,
key NUMBER,
setStamp NUMBER,
setCount NUMBER,
bsType VARCHAR2(1),
level NUMBER,
elapseSecs NUMBER,
compTime DATE,
status VARCHAR2(1),
pieceCount NUMBER,
keep_options NUMBER(4),
keep_until DATE,
multi_section VARCHAR2(1));
TYPE bpRec_t IS RECORD (
recid NUMBER,
stamp NUMBER,
key NUMBER,
bskey NUMBER,
setStamp NUMBER,
setCount NUMBER,
pieceNumber NUMBER,
copyNumber NUMBER,
status VARCHAR2(1),
compTime DATE,
handle VARCHAR2(1024),
tag VARCHAR2(32),
deviceType VARCHAR2(255),
media VARCHAR2(80),
bytes NUMBER,
compressed VARCHAR2(3),
site_key NUMBER);
-- Backupset Validation record
TYPE validBackupSetRec_t IS RECORD (
deviceType VARCHAR2(255),
tag VARCHAR2(32), -- may be null
copyNumber NUMBER, -- null if code 2 or 3
code NUMBER); -- 1 => same copy#
-- 2 => mix of copy#s, but same tag
-- 3 => mix of copy#s and tags
TYPE incarnation_t IS RECORD (
INCARNATION# NUMBER,
RESETLOGS_CHANGE# NUMBER,
RESETLOGS_TIME DATE,
PRIOR_RESETLOGS_CHANGE# NUMBER,
PRIOR_RESETLOGS_TIME DATE,
STATUS VARCHAR2(7),
RESETLOGS_ID NUMBER,
PRIOR_INCARNATION# NUMBER);
TYPE incarnation_set IS VARRAY(1) OF incarnation_t;
-- backup history
TYPE bhistoryRec_t IS RECORD (
dfNumber NUMBER,
create_scn NUMBER,
reset_scn NUMBER,
reset_time DATE,
ckp_scn NUMBER,
ckp_time DATE,
stop_scn NUMBER,
logThread NUMBER,
logSequence NUMBER,
setStamp NUMBER,
setCount NUMBER,
compTime DATE,
nbackups NUMBER,
logTerminal VARCHAR2(3),
next_scn NUMBER,
pluggedRonly BINARY_INTEGER, -- 1 for read-only. Otherwise, 0
pluginSCN NUMBER,
pluginRlgSCN NUMBER,
pluginRlgTime DATE,
newcreate_scn NUMBER, -- create_scn or pluginSCN
newreset_scn NUMBER, -- reset_scn or pluginRlgSCN
newreset_time DATE); -- reset_time or pluginRlgTime
-- aged file record
TYPE agedFileRec_t IS RECORD (
type NUMBER,
key NUMBER,
stamp NUMBER);
TYPE lbRec_t IS RECORD (
list_order1 NUMBER, -- just hint to correctly order records
list_order2 NUMBER, -- just hint to correctly order records
pkey NUMBER, -- primary key
-- row part
backup_type VARCHAR2(32), -- backup type (BACKUP SET/COPY/PROXY COPY)
-- file part
file_type VARCHAR2(32), -- file type (DATAFILE/CONTROLFILE/SPFILE/REDO LOG/PIECE)
-- Common part. This part is shared by rows returned from listBackup.
keep VARCHAR2(3),
keep_until DATE,
keep_options VARCHAR2(13),
status VARCHAR2(16), -- piece/copy status (AVAILABLE/UNAVAILABLE/EXPIRED/OTHER)
fname VARCHAR2(1024), -- piece or copy name
tag VARCHAR2(32), -- piece or copy tag
media VARCHAR2(80),
recid NUMBER,
stamp NUMBER,
device_type VARCHAR2(255),
block_size NUMBER,
completion_time DATE,
is_rdf VARCHAR2(3),
compressed VARCHAR2(3),
obsolete VARCHAR2(3),
keep_for_dbpitr VARCHAR2(3),
bytes NUMBER,
-- BACKUP SET part. Valid only when backup_type is 'BACKUP SET'
bs_key NUMBER,
bs_count NUMBER,
bs_stamp NUMBER,
bs_type VARCHAR2(32), -- backup set type (DATAFILE/ARCHIVED LOG)
bs_incr_type VARCHAR2(32),
bs_pieces NUMBER,
bs_copies NUMBER,
bs_completion_time DATE,
bs_status VARCHAR2(16), -- backup set status (AVAILABLE/UNAVAILABLE/EXPIRED/OTHER)
bs_bytes NUMBER,
bs_compressed VARCHAR2(3), -- If backup set is compressed: (Yes/No/Other)
bs_tag VARCHAR2(1024), -- List of all tags of pieces.
-- We don't repeat same tags. Tags divided by commas.
bs_device_type VARCHAR2(255), -- List of device types of pieces.
-- Device types are divided by commas.
-- BACKUP PIECE part. Valid only when file_type is 'PIECE' and backup_type is 'BACKUP SET'.
bp_piece# NUMBER,
bp_copy# NUMBER,
-- DATAFILE part Valid only when file_type is 'DATAFILE', 'CONTROLFILE', or 'SPFILE'
df_file# NUMBER,
df_tablespace VARCHAR2(30),
df_resetlogs_change# NUMBER,
df_creation_change# NUMBER,
df_checkpoint_change# NUMBER,
df_ckp_mod_time DATE,
df_incremental_change# NUMBER,
-- REDO LOG part. This part is valid only when file_type is 'REDO LOG'
rl_thread# NUMBER,
rl_sequence# NUMBER,
rl_resetlogs_change# NUMBER,
rl_first_change# NUMBER,
rl_first_time DATE,
rl_next_change# NUMBER,
rl_next_time DATE,
-- SPFILE part
sf_db_unique_name VARCHAR2(30));
TYPE lbDfRec_t IS RECORD (
dfRec dfRec_t,
-- This is the minimum checkpoint_change# of the backup that are kept
-- for retention policy and its corresponding resetlogs_change#.
-- A full backup of this datafile is kept if its checkpoint_change# is
-- greater than fullmin_scn and its resetlogs_change# is greater
-- that fullmin_scn or equal to fullmin_rlgscn.
fullmin_scn NUMBER,
fullmin_rlgscn NUMBER,
-- This is the minimum checkpoint_change# of the backup that are kept
-- for retention policy and its corresponding resetlogs_change#.
-- A incremental backup of this datafile is kept if its checkpoint_change#
-- is greater than incrmin_scn and its resetlogs_change# is greater
-- than incrmin_scn or equal to incrmin_rlgscn.
incrmin_scn NUMBER,
incrmin_rlgscn NUMBER,
-- This is the minimum checkpoint_change# of its backup that are kept
-- for archived logs attribute and its corresponding resetlogs_change#.
-- All archivelogs and its backups are kept if its first_change# is
-- greater than the logmin_scn and its resetlogs_change# is greater
-- thatn logmin_scn or equal to logmin_rlgscn.
logmin_scn NUMBER,
logmin_rlgscn NUMBER);
TYPE lbDfRecTab_t IS TABLE OF lbDfRec_t INDEX BY BINARY_INTEGER;
TYPE lbRecTab_t IS TABLE OF lbRec_t INDEX BY BINARY_INTEGER;
TYPE lbRecVar_t IS VARRAY(1) OF lbRec_t;
TYPE rcvRecTabI_t IS TABLE OF rcvRec_t INDEX BY BINARY_INTEGER;
TYPE rcvRecTabII_t IS TABLE OF rcvRecTabI_t INDEX BY BINARY_INTEGER;
TYPE dfRecTab_t IS TABLE OF dfRec_t INDEX BY BINARY_INTEGER;
TYPE numTab_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
TYPE lbCursor_t IS REF CURSOR;
TYPE lbState_t IS RECORD (
-- The collection table lbRecOutTab keeps track of the rows which should
-- returned by the function listBackup. The function listBackup will loop
-- until it does not fill lbRecOutTab with at least one element.
lbRecOutTab lbRecTab_t,
lbRecOutTab_count BINARY_INTEGER,
-- The collection table lbRecTmpTab keeps track of the backup datafiles and
-- backup archived log rows which are part of the backup set.
lbRecTmpTab lbRecTab_t,
-- The collection lbRecCmn keeps track of the backup set attributes.
lbRecCmn lbRec_t,
-- The collection table lbDfRecTab contains the list of all database files
-- which ever existed after untilSCN.
lbDfRecTabUs lbDfRecTab_t,
-- The collection table lbDfRecTab contains the list of all database files
-- which ever existed.
lbDfRecTab dfRecTab_t,
-- This variable hols the maximum number of the datafile. It is used for
-- indextin of lbDfRecTab.
lbMaxDfNumber NUMBER,
-- For keep backups we need to know the current time.
lbNowTime DATE,
-- The table piece_count stores number of pieces in each copy. The variable
-- copy_count says how many copies we have.
lbPieceCountTab numTab_t,
lbCopyCount binary_integer,
-- Must Keep List is a table of rcvRecTabI_t indexed by binary_integer
-- which itself is a table of rcvRec_t
lbMkTab rcvRecTabII_t,
-- Must Keep Incremental List is a table of rcvRecTabI_t indexed by
-- binary_integer which itself is a table of rcvRec_t
lbMkITab rcvRecTabII_t,
-- The variable lbMinGrsp stands for minimum guaranteed restore point.
-- An archived log backup set is obsolete if all rl_first_change#
-- in the backup set is less than lbMinGrsp. No resetlogs information
-- is compared. The redo log copies DOES NOT FOLLOW this rule. We
-- keep the redo log copies only if needed by guaranteed restore point.
-- The idea of keeping the backupset of redo log since the oldest GRP is
-- to flashback to GRP2 from GRP1 (where GRP2 > GRP1) because it
-- will require archivelogs outside the range listed by grsp table
-- (from_scn - to_scn column).
lbMinGrsp NUMBER,
-- The variable lbFbUntilTime stands for Flashback Until Time.
-- An archived log backup set is obsolete if all rl_first_time in the
-- backup set is less than lbFbUntilTime. No resetlogs information is
-- compared. The redo log copies (that is archived logs and proxy
-- copies) follow the same rule.
lbFbUntilTime DATE,
-- The variable lbRlKeepRlgSCN is the resetlogs_change# associated with
-- the lbRlKeepSCN. It is used in conjunction with lbRlKeepSCN to
-- decide an obsolete archived log. When NULL, the resetlogs_change#
-- is unknown.
lbRlKeepRlgSCN NUMBER,
-- The variable lbRlKeepSCN says that archived log backup set is
-- obsolete if the rl_first_change# in the backup set is less than
-- lbRlKeepSCN and its resetlogs_change# greater than lbRlKeepSCN and
-- equal to lbRlKeepRlgSCN.
-- The redo logs copies (that is archived logs and proxy copies)
-- follow the same rule.
lbRlKeepSCN NUMBER,
-- If either lbObsoleteRetention or lbObsoleteKeep is set to TRUE when the
-- current backup processed by listBackup is obsolete.
-- If lbObsoleteRetention is TRUE, then the backup is obsolete because of
-- retention policy. If lbObsoleteKeep is TRUE, then the backup is obsolete
-- because of its keep attributes.
lbObsoleteRetention BOOLEAN,
lbKeepForDBPITR BOOLEAN,
lbObsoleteKeep BOOLEAN,
lbNeedObsoleteData BOOLEAN);
-- In case that listBackup is not called from pipeline function, then there is no need
-- for the called to save and maintain the state: the function will use state from the
-- package.
lbStatePck lbState_t;
TYPE failureRec_t IS RECORD (
priority VARCHAR2(8),
failureId NUMBER,
parentId NUMBER,
childCount NUMBER,
description VARCHAR2(1024),
timeDetected DATE,
status VARCHAR2(12),
impacts VARCHAR2(1024));
TYPE repairRec_t IS RECORD (
type NUMBER,
failureidx NUMBER,
repairidx NUMBER,
description VARCHAR2(1024));
TYPE repairParmsRec_t IS RECORD (
type NUMBER,
failureidx NUMBER,
repairidx NUMBER,
name VARCHAR2(256),
value VARCHAR2(512));
TYPE repairOptionRec_t IS RECORD (
optionidx NUMBER,
description VARCHAR2(1024));
TYPE repairStepRec_t IS RECORD (
type NUMBER,
failureidx NUMBER,
repairidx NUMBER,
repairstepidx NUMBER,
workingrepair NUMBER,
description VARCHAR2(1024),
repairscript VARCHAR2(1024));
TYPE pdbNameRec_t IS RECORD(
pdbId NUMBER,
name VARCHAR2(128),
pdbGuid VARCHAR2(128),
pdbKey NUMBER, -- PDB_KEY in catalog mode and CON_ID in nocatalog
inKccpdb BINARY_INTEGER ); -- TRUE# if pdb in ctrl-file. Otherwise, FALSE#
TYPE pdbFileRec_t IS RECORD(
pdbId NUMBER,
file# NUMBER,
stopSCN NUMBER);
TYPE pdbDbinc_r IS RECORD (
dbinc_key NUMBER,
pdb_key NUMBER,
drop_scn NUMBER,
drop_time DATE,
curr_pdbinc_key NUMBER);
TYPE pdbinc_r IS RECORD (
pdbinc_key NUMBER,
pdb_key NUMBER,
born_dbinc_key NUMBER,
inc_scn NUMBER,
begin_reset_scn NUMBER,
begin_reset_time DATE,
end_reset_scn NUMBER,
parent_pdbinc_key NUMBER,
inc_time DATE,
end_reset_time DATE,
pdbinc_status VARCHAR2(8));
dbms_rcvman.computeRecoveryActions(
fno IN NUMBER, -- Datafile NUMBER
crescn IN NUMBER, -- Datafile creation SCN
df_rlgscn IN NUMBER DEFAULT NULL, -- Datafile resetlogs SCN
-- NULL if RESTORE command, else this is the value in the
-- datafile header for the datafile being recovered
df_rlgtime IN DATE DEFAULT NULL, -- Datafile resetlogs time
-- Null if df_rlgscn is null, else value from datafile header
df_ckpscn IN NUMBER DEFAULT NULL, -- Datafile checkpoint SCN
-- Null if df_rlgscn is null, else value from datafile header
offlscn IN NUMBER DEFAULT 0, -- kccfeofs
onlscn IN NUMBER DEFAULT 0, -- kccfeonc null if offlscn is null
onltime IN DATE DEFAULT NULL, -- kccfeonc_time
cleanscn IN NUMBER DEFAULT 0, -- kccfecps if either SOR or WCC set, else null
clean2scn IN NUMBER DEFAULT 0,
-- CF ckpt SCN if WCC set, infinity if SOR bit set else null
clean2time IN DATE DEFAULT NULL, -- cf ckpt time if WCC, SYSDATE if SOR
allowfuzzy IN BOOLEAN DEFAULT FALSE,
-- TRUE if can be fuzzy at until SCN/time, FALSE if not
partial_rcv IN BOOLEAN DEFAULT FALSE, -- TRUE if can do partial recovery, else FALSE
cf_scn IN NUMBER DEFAULT NULL, -- controlfile checkpoint SCN (NULL if none mounted)
cf_cretime IN DATE DEFAULT NULL, -- controlfile creation time (NULL if none mounted)
cf_offrrid IN NUMBER DEFAULT NULL, -- recid of oldest offline range in controlfile
-- (NULL if none mounted)
allCopies IN BOOLEAN DEFAULT FALSE, -- TRUE = stack all valid copies of a BU set
df_cretime IN DATE DEFAULT NULL, -- datafile creation time
rmanCmd IN BINARY_INTEGER DEFAULT unknownCmd_t,
foreignDbid IN NUMBER DEFAULT 0,
pluggedRonly IN BINARY_INTEGER DEFAULT 0,
pluginSCN IN NUMBER DEFAULT 0,
pluginRlgSCN IN NUMBER DEFAULT 0,
pluginRlgTime IN DATE DEFAULT NULL)
RETURN BINARY_INTEGER;
Finds a backup set containing the given archived log
Overload 1
dbms_rcvman.findarchivedlogbackup(
thread IN NUMBER,
sequence IN NUMBER,
lowSCN IN NUMBER,
allCopies IN BOOLEAN DEFAULT FALSE);
Deprecated as of 11g
Finds a backup set containing the given archived log
Overload 2
dbms_rcvman.findarchivedlogbackup(
thread# IN NUMBER,
sequence# IN NUMBER,
low_scn IN NUMBER,
type OUT NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER,
device_type OUT VARCHAR2)
RETURN NUMBER;
dbms_rcvman.findControlFileBackup(
allCopies IN BOOLEAN DEFAULT FALSE,
allBackups IN BOOLEAN DEFAULT FALSE,
allIncarnation IN BOOLEAN DEFAULT FALSE,
fromSCN IN NUMBER DEFAULT 0,
pdbid IN NUMBER DEFAULT 0);
dbms_rcvman.findControlFileBackup(
type OUT NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER,
fname OUT VARCHAR2,
device_type OUT VARCHAR2,
ckp_scn OUT NUMBER)
RETURN NUMBER;
Obsolete: For versions 8.0.4 to 8.1.5
Overload 3
dbms_rcvman.findControlFileBackup(
type OUT NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER,
fname OUT VARCHAR2,
device_type OUT VARCHAR2,
ckp_scn OUT NUMBER,
rlg_scn OUT NUMBER,
blksize OUT NUMBER)
RETURN NUMBER;
Finds the point where archived log continuity breaks
dbms_rcvman.findLogBreakPoint(
logBreakPointScn OUT NUMBER,
logBreakPointTime OUT DATE,
logBreakPointDbIncKey OUT NUMBER,
logBreakPointRlgScn OUT NUMBER,
logBreakPointRlgTime OUT DATE,
fromSCN IN NUMBER,
untilSCN IN NUMBER,
isOrs IN NUMBER)
RETURN BOOLEAN;
Finds all the backup sets that are required to restore the archivelog specified in the range
dbms_rcvman.findrangearchivedlogbackup(
minthread IN NUMBER,
minsequence IN NUMBER,
minlowSCN IN NUMBER,
maxthread IN NUMBER,
maxsequence IN NUMBER,
maxlowSCN IN NUMBER,
allCopies IN BOOLEAN DEFAULT FALSE);
allCopies = TRUE fetches duplex ones redundancy determine the NUMBER of redundant copies to fetch
Overload 1
dbms_rcvman.findspfilebackup(
allCopies IN BOOLEAN DEFAULT FALSE,
redundancy IN NUMBER DEFAULT NULL,
rmanCmd IN NUMBER DEFAULT unknownCmd_t);
BEGIN
dbms_rcvman.findspfilebackup;
END;
/
Overload 2
dbms_rcvman.findspfilebackup(
allCopies IN BOOLEAN DEFAULT FALSE,
redundancy IN NUMBER DEFAULT NULL,
rmanCmd IN NUMBER DEFAULT unknownCmd_t,
scn_warn OUT NUMBER);
DECLARE
outVal NUMBER;
BEGIN
outVal := dbms_rcvman.findspfilebackup;
dbms_output.put_line(TO_CHAR(outVal));
END;
/
Use the findValidBackupSetRec public variable to save a backupset record for later use as an input argument to this procedure
Overload 1
dbms_rcvman.findvalidbackupset(
backupSetRec IN rcvRec_t,
deviceType IN VARCHAR2 DEFAULT NULL,
tag IN VARCHAR2 DEFAULT NULL,
available IN NUMBER DEFAULT TRUE#, -- for compat.
unavailable IN NUMBER DEFAULT FALSE#, -- for compat.
deleted IN NUMBER DEFAULT FALSE#, -- for compat.
expired IN NUMBER DEFAULT FALSE#, -- for compat.
availableMask IN BINARY_INTEGER DEFAULT NULL); -- for compat.
TBD
Overload 2
dbms_rcvman.findvalidbackupset(
backupSetRec IN bsRec_t,
deviceType IN VARCHAR2 DEFAULT NULL,
tag IN VARCHAR2 DEFAULT NULL,
available IN NUMBER DEFAULT TRUE#, -- for compat.
unavailable IN NUMBER DEFAULT FALSE#, -- for compat.
deleted IN NUMBER DEFAULT FALSE#, -- for compat.
expired IN NUMBER DEFAULT FALSE#, -- for compat.
availableMask IN BINARY_INTEGER DEFAULT NULL); -- for compat.
Returns the key of the incarnation that a previous set until performed with allIncarnations = TRUE# ended up using when the current incarnation was not selected. This is a recovery catalog only function.
dbms_rcvman.getALBackupHistory(
backedUpDev IN VARCHAR2,
first IN BOOLEAN,
bhistoryRec OUT NOCOPY bhistoryRec_t,
doingCmd IN VARCHAR2 DEFAULT NULL,
keepTag IN VARCHAR2 DEFAULT NULL,
toDest1 IN VARCHAR2 DEFAULT NULL,
toDest2 IN VARCHAR2 DEFAULT NULL,
toDest3 IN VARCHAR2 DEFAULT NULL,
toDest4 IN VARCHAR2 DEFAULT NULL);
Retrieves the recid and stamp for each archived log, one at a time until null is returned
Overload 1
dbms_rcvman.getArchivedLog(
alRec OUT NOCOPY alRec_t,
closeCursor IN BOOLEAN DEFAULT FALSE);
TBD
Overload 2
dbms_rcvman.getArchivedLog(
recid OUT NUMBER,
stamp OUT NUMBER,
thread# OUT NUMBER,
sequence# OUT NUMBER,
low_scn OUT NUMBER,
nxt_scn OUT NUMBER,
fname OUT VARCHAR2,
reset_scn OUT NUMBER,
block_size OUT NUMBER,
blocks OUT NUMBER);
dbms_rcvman.getBackupHistory(
dfRec IN dfRec_t,
backedUpDev IN VARCHAR2,
nbackupsFlag IN NUMBER,
bscompletionFlag IN NUMBER,
nbackups OUT NUMBER,
bscompletion OUT DATE);
Deprecated as of 9.2
Retrieve Archive Log backup history
Overload 2
dbms_rcvman.getBackupHistory(
alRec IN alRec_t,
backedUpDev IN VARCHAR2,
nbackupsFlag IN NUMBER,
bscompletionFlag IN NUMBER,
nbackups OUT NUMBER,
bscompletion OUT DATE);
Deprecated as of 9.2
Overload 3
dbms_rcvman.getBackupHistory(
bpRec IN bpRec_t,
backedUpDev IN VARCHAR2,
nbackupsFlag IN NUMBER,
bscompletionFlag IN NUMBER,
nbackups OUT NUMBER,
bscompletion OUT DATE,
toDest1 IN VARCHAR2 DEFAULT NULL,
toDest2 IN VARCHAR2 DEFAULT NULL,
toDest3 IN VARCHAR2 DEFAULT NULL,
toDest4 IN VARCHAR2 DEFAULT NULL);
dbms_rcvman.getBackupPiece(
bpRec OUT NOCOPY bpRec_t,
closeCursor IN BOOLEAN DEFAULT FALSE);
TBD
Overload 2
dbms_rcvman.getBackupPiece(
recid OUT NUMBER,
stamp OUT NUMBER,
bpkey OUT NUMBER,
set_stamp OUT NUMBER,
set_count OUT NUMBER,
piece# OUT NUMBER,
copy# OUT NUMBER,
status OUT VARCHAR2,
completion OUT DATE,
handle OUT VARCHAR2);
Deprecated as of 8.1.6
Overload 3
dbms_rcvman.getBackupPiece(
recid OUT NUMBER,
stamp OUT NUMBER,
set_stamp OUT NUMBER,
set_count OUT NUMBER,
piece# OUT NUMBER,
handle OUT VARCHAR2);
dbms_rcvman.getBSBackupHistory(
backedUpDev IN VARCHAR2,
first IN BOOLEAN,
set_stamp IN NUMBER DEFAULT NULL,
set_count IN NUMBER DEFAULT NULL,
bhistoryRec OUT NOCOPY bhistoryRec_t,
doingCmd IN VARCHAR2 DEFAULT NULL,
keepTag IN VARCHAR2 DEFAULT NULL,
toDest1 IN VARCHAR2 DEFAULT NULL,
toDest2 IN VARCHAR2 DEFAULT NULL,
toDest3 IN VARCHAR2 DEFAULT NULL,
toDest4 IN VARCHAR2 DEFAULT NULL);
Copies the latest available datafilecopy for all translated datafiles
Overload 1
dbms_rcvman.getCopyofDatafile(
first IN BOOLEAN, -- TRUE if this is the first time called
itag IN VARCHAR2, -- tag that the copy should have or NULL
fno OUT NUMBER, -- datafile number
crescn OUT NUMBER, -- creation scn of the datafile
rlogscn OUT NUMBER, -- resetlogs scn of the datafile
rlgtime OUT DATE, -- resetlogs time of the datafile
recid OUT BINARY_INTEGER, -- recid of the latest datafilecopy
stamp OUT BINARY_INTEGER, -- stamp of the latest datafilecopy
name OUT VARCHAR2, -- name of the datafilecopy
otag OUT VARCHAR2, -- tag of the datafilecopy
status OUT VARCHAR2, -- status of the datafilecopy
nblocks OUT BINARY_INTEGER, -- number of blocks of datafilecopy
bsz OUT BINARY_INTEGER, -- blocksize of the datafilecopy
ctime OUT DATE, -- creation time of the datafilecopy
toscn OUT NUMBER, -- checkpoint scn of the datafilecopy
totime OUT DATE, -- checkpoint time of the datafilecopy
pluggedRonly OUT BINARY_INTEGER, -- 1 for read-only. Otherwise, 0
pluginSCN OUT NUMBER, -- plugin scn
pluginRlgSCN OUT NUMBER, -- resetlogs when datafile was plugged
pluginRlgTime OUT DATE); -- resetlog time when df was plugged
TBD
Overload 2
dbms_rcvman.getCopyofDatafile(
dfNUMBER IN NUMBER, -- datafile NUMBER
itag IN VARCHAR2, -- tag that the copy should have or NULL
crescn IN OUT NUMBER, -- creation scn of the datafile
rlogscn IN OUT NUMBER, -- resetlogs scn of the datafile
rlgtime IN OUT DATE, -- resetlogs time of the datafile
recid OUT BINARY_INTEGER, -- recid of the latest datafilecopy
stamp OUT BINARY_INTEGER, -- stamp of the latest datafilecopy
name OUT VARCHAR2, -- name of the datafilecopy
otag OUT VARCHAR2, -- tag of the datafilecopy
status OUT VARCHAR2, -- status of the datafilecopy
nblocks OUT BINARY_INTEGER, -- NUMBER of blocks of datafilecopy
bsz OUT BINARY_INTEGER, -- blocksize of the datafilecopy
ctime OUT DATE, -- creation time of the datafilecopy
toscn OUT NUMBER, -- checkpoint scn of the datafilecopy
totime OUT DATE, -- checkpoint time of the datafilecopy
pluggedRonly OUT BINARY_INTEGER, -- 1 for read-only. Otherwise, 0
pluginSCN IN NUMBER); -- plugin scn
TBD
Overload 3
dbms_rcvman.getCopyofDatafile(
dfNUMBER IN NUMBER, -- datafile NUMBER
itag IN VARCHAR2, -- tag that the copy should have or NULL
crescn IN NUMBER, -- creation scn of the datafile
rlogscn IN NUMBER, -- resetlogs scn of the datafile
rlgtime IN DATE, -- resetlogs time of the datafile
recid OUT BINARY_INTEGER, -- recid of the latest datafilecopy
stamp OUT BINARY_INTEGER, -- stamp of the latest datafilecopy
name OUT VARCHAR2, -- name of the datafilecopy
otag OUT VARCHAR2, -- tag of the datafilecopy
status OUT VARCHAR2, -- status of the datafilecopy
nblocks OUT BINARY_INTEGER, -- NUMBER of blocks of the datafilecopy
bsz OUT BINARY_INTEGER, -- blocksize of the datafilecopy
ctime OUT DATE, -- creation time of the datafilecopy
toscn OUT NUMBER, -- checkpoint scn of the datafilecopy
totime OUT DATE); -- checkpoint time of the datafilecopy
Retrieves the datafile numbers, one at a time until null is returned
Overload 1
dbms_rcvman.getdatafile(
dfRec OUT NOCOPY dfRec_t,
oldClient IN BOOLEAN DEFAULT FALSE);
TBD
Overload 2
dbms_rcvman.getDataFile(
file# OUT NUMBER,
crescn OUT NUMBER,
creation_time OUT DATE,
fname OUT VARCHAR2,
ts_name OUT VARCHAR2,
status OUT NUMBER,
blksize OUT NUMBER,
kbytes OUT NUMBER,
blocks OUT NUMBER,
unrecoverable_change# OUT NUMBER,
stop_change# OUT NUMBER,
read_only OUT NUMBER);
dbms_rcvman.getDataFileCopy(
rcvRec OUT NOCOPY rcvRec_t,
closeCursor IN BOOLEAN DEFAULT FALSE);
TBD
Overload 2
dbms_rcvman.getDataFileCopy(
recid OUT NUMBER,
stamp OUT NUMBER,
file# OUT NUMBER,
fname OUT VARCHAR2,
reset_scn OUT NUMBER,
create_scn OUT NUMBER,
ckp_scn OUT NUMBER,
block_size OUT NUMBER,
blocks OUT NUMBER);
Returns the db_key of a database if it is set. It appears that this only works in an RMAN repository.
dbms_rcvman.getDbKey RETURN NUMBER;
SELECT dbms_rcvman.getDbKey;
*
ERROR at line 1:
ORA-20999: Not supported in controlfile
ORA-06512: at "SYS.DBMS_RCVMAN", line 10154
ORA-06512: at "SYS.DBMS_RCVMAN", line 14910
dbms_rcvman.getDCBackupHistory(
backedUpDev IN VARCHAR2,
first IN BOOLEAN,
bhistoryRec OUT NOCOPY bhistoryRec_t,
doingCmd IN VARCHAR2 DEFAULT NULL,
keepTag IN VARCHAR2 DEFAULT NULL,
toDest1 IN VARCHAR2 DEFAULT NULL,
toDest2 IN VARCHAR2 DEFAULT NULL,
toDest3 IN VARCHAR2 DEFAULT NULL,
toDest4 IN
VARCHAR2 DEFAULT NULL);
dbms_rcvman.getDFBackupHistory(
backedUpDev IN VARCHAR2,
first IN BOOLEAN,
bhistoryRec OUT NOCOPY bhistoryRec_t,
recentbackup IN BOOLEAN DEFAULT FALSE, -- get no: recent backups
doingCmd IN VARCHAR2 DEFAULT NULL,
keepTag IN VARCHAR2 DEFAULT NULL,
toDest1 IN VARCHAR2 DEFAULT NULL,
toDest2 IN VARCHAR2 DEFAULT NULL,
toDest3 IN VARCHAR2 DEFAULT NULL,
toDest4 IN VARCHAR2 DEFAULT NULL);
dbms_rcvman.getDropSCN(
dfNum IN NUMBER,
creScn IN NUMBER,
creTime IN DATE,
plugScn IN NUMBER,
foreignDbId IN NUMBER,
dropScn OUT NUMBER,
dropTime OUT DATE,
dropDbIncKey OUT NUMBER,
dropRlgScn OUT NUMBER,
dropRlgTime OUT DATE)
RETURN BOOLEAN;
Return the incarnation key to which the untilscn belongs if the untilscn is in one of its parent. 0 to indicate if the untilscn is in current incarnation.
dbms_rcvman.getIncarnationKey(untilSCN IN NUMBER) RETURN NUMBER;
Returns the starting scn for an incremental backup
Overload 1
dbms_rcvman.getIncrementalScn(
file# IN NUMBER,
create_scn IN NUMBER,
reset_scn IN NUMBER,
reset_time IN DATE,
incr_level IN NUMBER,
cumulative IN NUMBER,
sourcemask IN NUMBER DEFAULT NULL,
tag IN VARCHAR2 DEFAULT NULL,
pluginSCN IN NUMBER DEFAULT 0)
RETURN NUMBER;
TBD
An improved version of Overload 1
Overload 2
dbms_rcvman.getIncrementalScn(
first IN BOOLEAN, -- open the cursor if this is TRUE
file# IN NUMBER,
create_scn IN NUMBER,
reset_scn IN NUMBER,
reset_time IN DATE,
incr_level IN NUMBER,
cumulative IN NUMBER,
rcvRec OUT NOCOPY rcvRec_t,
sourcemask IN NUMBER DEFAULT NULL,
tag IN VARCHAR2 DEFAULT NULL,
pluginSCN IN NUMBER DEFAULT 0,
keep IN BOOLEAN DEFAULT FALSE);
dbms_rcvman.getMaxRedoSCN(
maxScn OUT NUMBER,
maxTime OUT DATE,
maxDbIncKey OUT NUMBER,
maxRlgScn OUT NUMBER,
maxRlgTime OUT DATE,
isOrs IN NUMBER)
RETURN BOOLEAN;
SELECT dbms_rcvman.getMinRcvStartScn;
*
ERROR at line 1:
ORA-20999: Not supported in controlfile
ORA-06512: at "SYS.DBMS_RCVMAN", line 10656
ORA-06512: at "SYS.DBMS_RCVMAN", line 15435
Returns the parent incarnation. If resetlogs_change# is NULL on input, then the current incarnation is returned. Returns TRUE if a row was returned, otherwise returns FALSE.
dbms_rcvman.getParentIncarnation(
resetlogs_change# IN OUT NUMBER,
resetlogs_time IN OUT DATE)
RETURN NUMBER;
Returns the name, con_id of application root for specified PDB if any
dbms_rcvman.getPdbApplicationRoot(
pdbName IN VARCHAR2 DEFAULT NULL,
pdbId IN NUMBER DEFAULT 0,
appRootName OUT VARCHAR2,
appRootId OUT NUMBER,
pdbGuid IN VARCHAR2 DEFAULT NULL)
RETURN NUMBER;
dbms_rcvman.getRecoveryAction(action OUT NOCOPY rcvRec_t) RETURN BINARY_INTEGER;
TBD
Overload 2
dbms_rcvman.getRecoveryAction(
kind OUT NUMBER,
set_stamp OUT NUMBER,
set_count OUT NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER,
fname OUT VARCHAR2,
blocksize OUT NUMBER,
blocks OUT NUMBER,
devtype OUT VARCHAR2,
from_scn OUT NUMBER,
to_scn OUT NUMBER,
to_time OUT DATE,
rlgscn OUT NUMBER,
rlgtime OUT DATE,
cfcretime OUT DATE,
dbinc_key OUT NUMBER)
RETURN BINARY_INTEGER;
Retrieves the repair list whose cursor is opened by translateRepair. Until it returns a no-data-found exception, the function is called again and again to retrieve all the options.
dbms_rcvman.getRepair(repairRec OUT NOCOPY repairRec_t);
DECLARE
repairArray dbms_rcvman.repairRec_t;
BEGIN
-- translateRepair is called to open the cursor to retrieve the repair list
dbms_rcvman.translateRepair(8075);
dbms_rcvman.getRepair(repairArray);
END;
/
Retrieve the repair option list for the cursor opened by translateRepairOption
dbms_rcvman.getRepairOption(repairOptionRec OUT NOCOPY repairOptionRec_t);
DECLARE
repairArray dbms_rcvman.repairOptionRec_t;
BEGIN
-- translateRepairOption is called to open the cursor to the repair list
dbms_rcvman.translateRepairOption(8075);
dbms_rcvman.getRepairOption(repairArray);
END;
/
Retrieve the repair parameters for the cursor opened by translateRepairParms
dbms_rcvman.getRepairParms(repairParmsRec OUT NOCOPY repairParmsRec_t);
DECLARE
repairArray dbms_rcvman.repairParmsRec_t;
BEGIN
-- translateRepairParms is called to open the cursor to retrieve the repair parameters
dbms_rcvman.translateRepairParms(8075);
dbms_rcvman.getRepairParms(repairArray);
END;
/
Retrieves the repair steps whose cursor is opened by the translateRepairStep procedure. This function is called until it returns a NO_DATA_FOUND exception.
dbms_rcvman.getRepairStep(repairStepRec OUT NOCOPY repairStepRec_t);
exec dbms_rcvman.translateRepairStep(0);
DECLARE
repairRec dbms_rcvman.repairStepRec_t;
BEGIN
dbms_rcvman.getRepairStep(repairRec);
dbms_output.put_line(repairRec.repairscript);
END;
/
Calculate the lowest gap for all destinations. Calculate the highest
SCN available on all valid standby destinations.
If no gap, return the high SCN, otherwise return the gap. If streams is true consider streams also when computing remote destination required SCN.
dbms_rcvman.getRequiredSCN(
reqscn OUT NUMBER,
rlgscn OUT NUMBER,
streams IN NUMBER DEFAULT 0,
alldest IN NUMBER DEFAULT 0);
dbms_rcvman.getRestorePoint(
name IN VARCHAR2,
rlgscn OUT NUMBER,
rlgtime OUT DATE,
scn OUT NUMBER,
guaranteed OUT NUMBER,
con_id IN NUMBER,
clean OUT NUMBER,
out_con_id OUT NUMBER);
Must be called after setRedoLogDeletionPolicy call. The function is intended to compute the SCN above which all archivelogs are kept for TO APPLIED|SHIPPED policy.
dbms_rcvman.getSCNForAppliedPolicy(
minscn OUT NUMBER,
rlgscn OUT NUMBER);
Fetch the cursor opened by translateTempfiles and return a row one at a time until all rows are returned. Signal ORA-1403 (no-data-found) when there are no more rows to return.
dbms_rcvman.getTempFile(tfRec OUT NOCOPY tfRec_t);
DECLARE
retArr dbms_rcvman.tfRec_t;
BEGIN
dbms_rcvman.getTempFile(retArr);
END;
/
This is a vestigial function that was released to customers in 8.1.3 Beta. It is no longer called, and is no longer needed, but must still be here because this version of the package may be called by an 8.1.3 RMAN executable.
Called to find out whether the parent_id or failureid is part of getFailureNumList or getFailureExclude list. Return TRUE# if present in failure_list. Otherwise, return FALSE#.
dbms_rcvman.isInFailureList(
parentId IN NUMBER,
failureId IN NUMBER,
for_exclude IN BINARY_INTEGER)
RETURN NUMBER;
dbms_rcvman.listbackup(
lbRecOut OUT NOCOPY lbRec_t,
firstCall IN BOOLEAN,
only_obsolete IN BOOLEAN,
redundancy IN NUMBER,
piped_call IN BOOLEAN,
lbCursor IN OUT NOCOPY lbCursor_t,
lbState IN OUT NOCOPY lbState_t,
extRlKeepSCN IN NUMBER DEFAULT NULL)
RETURN BOOLEAN;
dbms_rcvman.listGetAppPdb(pdb_name OUT VARCHAR2) RETURN NUMBER;
DECLARE
outVal v$pdbs.name%TYPE;
retVal NUMBER;
BEGIN
retval := dbms_rcvman.listGetAppPDB(outVal);
dbms_output.put_line(retVal);
dbms_output.put_line(outVal);
END;
/
DECLARE
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_RCVMAN", line 29736
ORA-06512: at line 5
dbms_rcvman.listGetArchivedLogBackup(rcvRec OUT NOCOPY rcvRec_t);
DECLARE
retArr dbms_rcvman.rcvRec_t;
BEGIN
dbms_rcvman.listGetArchivedLogBackup(retArr);
END;
/
DECLARE
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_RCVMAN", line 22953
ORA-06512: at line 4
Overload 2
dbms_rcvman.listGetArchivedLogBackup(
bs_key OUT NUMBER,
completion_time OUT DATE)
RETURN NUMBER;
Deprecated as of 8.1
Overload 3
dbms_rcvman.listGetArchivedLogBackup(
bs_key OUT NUMBER,
thread# OUT NUMBER,
sequence# OUT NUMBER,
first_change# OUT NUMBER,
next_change# OUT NUMBER,
first_time OUT DATE,
next_time OUT DATE)
RETURN NUMBER;
Returns an aray of Archived Logfile Copies
Overload 1
dbms_rcvman.listGetArchivedLogCopy(rcvRec OUT NOCOPY rcvRec_t);
DECLARE
retArr dbms_rcvman.rcvRec_t;
BEGIN
dbms_rcvman.listGetArchivedLogCopy(retArr);
END;
/
DECLARE
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_RCVMAN", line 22544
ORA-06512: at line 4
Overload 2
dbms_rcvman.listGetArchivedLogCopy(
al_key OUT NUMBER,
status OUT VARCHAR2,
fname OUT VARCHAR2,
completion_time OUT DATE)
RETURN NUMBER;
dbms_rcvman.listGetBackupsetFiles(rcvRec OUT NOCOPY rcvRec_t);
DECLARE
retArr dbms_rcvman.rcvRec_t;
BEGIN
dbms_rcvman.listGetBackupsetFiles(retArr);
END;
/
DECLARE
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_RCVMAN", line 23087
ORA-06512: at line 4
Returns an array of Control File copies
Overload 1
dbms_rcvman.listGetControlfileCopy(rcvRec OUT NOCOPY rcvRec_t);
TBD
Overload 2
dbms_rcvman.listGetControlfileCopy(
bcfkey OUT NUMBER,
ckpscn OUT NUMBER,
ckptime OUT DATE,
status OUT VARCHAR2,
completion OUT DATE,
fname OUT VARCHAR2)
RETURN NUMBER;
dbms_rcvman.listGetDataFileBackup(rcvRec OUT NOCOPY rcvRec_t);
TBD
Overload 2
dbms_rcvman.listGetDataFileBackup(
bs_key OUT NUMBER,
backup_type OUT VARCHAR2,
incremental_level OUT NUMBER,
completion_time OUT DATE,
checkpoint_change# OUT NUMBER,
checkpoint_time OUT DATE)
RETURN NUMBER;
dbms_rcvman.listGetDataFileCopy(rcvRec OUT NOCOPY rcvRec_t);
TBD
Overload 2
dbms_rcvman.listGetDataFileCopy(
cdf_key OUT NUMBER,
status OUT VARCHAR2,
fname OUT VARCHAR2,
completion_time OUT DATE,
checkpoint_change# OUT NUMBER,
checkpoint_time OUT DATE)
RETURN NUMBER;
dbms_rcvman.listGetDBIncarnation(
db_key OUT NUMBER,
dbinc_key OUT NUMBER,
db_name OUT VARCHAR2,
db_id OUT NUMBER,
current_inc OUT VARCHAR2,
resetlogs_change# OUT NUMBER,
resetlogs_time OUT DATE,
dbinc_status OUT VARCHAR2)
RETURN NUMBER;
DECLARE
dkey NUMBER;
ikey NUMBER;
dname VARCHAR2(30);
dbid NUMBER;
cur_inc VARCHAR2(30);
rlc_num NUMBER;
rl_time DATE;
inc_status VARCHAR2(30);
retVal NUMBER;
BEGIN
retVal := dbms_rcvman.listGetDBIncarnation(dkey, ikey, dname, dbid, cur_inc, rlc_num, rl_time, inc_status);
END;
/
DECLARE
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_RCVMAN", line 23393
ORA-06512: at line 12
Overload 2
dbms_rcvman.listGetDBIncarnation(
db_key OUT NUMBER,
dbinc_key OUT NUMBER,
db_name OUT VARCHAR2,
db_id OUT NUMBER,
current_inc OUT VARCHAR2,
resetlogs_change# OUT NUMBER,
resetlogs_time OUT DATE)
RETURN NUMBER;
dbms_rcvman.listGetDBSite(
db_key OUT NUMBER,
db_id OUT NUMBER,
db_name OUT VARCHAR2,
db_role OUT VARCHAR2,
db_unique_name OUT VARCHAR2)
RETURN NUMBER;
dbms_rcvman.listGetPDBIncarnation(
pdb_key OUT NUMBER,
db_key OUT NUMBER,
pdbinc_key OUT NUMBER,
dbinc_key OUT NUMBER,
pdb_name OUT VARCHAR2,
guid OUT RAW,
current_inc OUT VARCHAR2,
resetlogs_change# OUT NUMBER,
resetlogs_time OUT DATE,
endresetlogs_change# OUT NUMBER,
endresetlogs_time OUT DATE,
incarnation_change# OUT NUMBER,
incarnation_time OUT DATE,
pdbinc_status OUT VARCHAR2)
RETURN NUMBER;
dbms_rcvman.listGetProxyDataFile(rcvRec OUT NOCOPY rcvRec_t);
TBD
Overload 2
dbms_rcvman.listGetProxyDataFile(
xdf_key OUT NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER,
status OUT VARCHAR2,
handle OUT VARCHAR2,
completion_time OUT DATE,
checkpoint_change# OUT NUMBER,
checkpoint_time OUT DATE)
RETURN NUMBER;
dbms_rcvman.listGetSpfileBackup(rcvRec OUT NOCOPY rcvRec_t);
DECLARE
spinfo dbms_rcvman.rcvRec_t;
BEGIN
dbms_rcvman.listGetSpfileBackup(spinfo);
END;
/
DECLARE
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_RCVMAN", line 22726
ORA-06512: at line 4
dbms_rcvman.listGetTablespace(
ts# OUT NUMBER,
ts_name OUT VARCHAR2)
RETURN NUMBER;
set serveroutput on
DECLARE
retv NUMBER;
tsno NUMBER;
tsnm user_tablespaces.tablespace_name%TYPE;
BEGIN
retv := dbms_rcvman.listGetTablespace(tsno, tsnm);
dbms_output.put_line(retv);
dbms_output.put_line(tsno);
dbms_output.put_line(tsnm);
END;
/
DECLARE
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_RCVMAN", line 24308
ORA-06512: at "SYS.DBMS_RCVMAN", line 24297
ORA-06512: at line 6
Overload 2
dbms_rcvman.listGetTablespace(
ts# OUT NUMBER,
ts_name OUT VARCHAR2,
pdbname OUT VARCHAR2)
RETURN NUMBER;
set serveroutput on
DECLARE
retv NUMBER;
tsno NUMBER;
tsnm user_tablespaces.tablespace_name%TYPE;
pdbnm v$pdbs.name%TYPE;
BEGIN
retv := dbms_rcvman.listGetTablespace(tsno, tsnm, pdbnm);
dbms_output.put_line(retv);
dbms_output.put_line(tsno);
dbms_output.put_line(tsnm);
dbms_output.put_line(pdbnm);
END;
/
DECLARE
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_RCVMAN", line 24308
ORA-06512: at line 7
dbms_rcvman.listTranslateArchivedLogBackup(
thread# IN NUMBER,
sequence# IN NUMBER,
first_change# IN NUMBER,
completedAfter IN DATE DEFAULT NULL,
completedBefore IN DATE DEFAULT NULL,
statusMask IN BINARY_INTEGER DEFAULT BSavailable+BSunavailable+BSexpired);
8.0 and 8.1.6, but not 8.1.5
Overload 2
dbms_rcvman.listTranslateArchivedLogBackup(
thread# IN NUMBER DEFAULT NULL,
lowseq IN NUMBER DEFAULT NULL,
highseq IN NUMBER DEFAULT NULL,
lowscn IN NUMBER DEFAULT NULL,
highscn IN NUMBER DEFAULT NULL,
from_time IN DATE DEFAULT NULL,
until_time IN DATE DEFAULT NULL,
pattern IN VARCHAR2 DEFAULT NULL);
dbms_rcvman.listTranslateArchivedLogCopy(
thread# IN NUMBER,
sequence# IN NUMBER,
first_change# IN NUMBER,
file_name_pattern IN VARCHAR2 DEFAULT NULL,
completedAfter IN DATE DEFAULT NULL,
completedBefore IN DATE DEFAULT NULL,
statusMask IN BINARY_INTEGER DEFAULT BSavailable+BSunavailable+BSexpired,
--8.0/8.1 defaults
needstby IN NUMBER DEFAULT NULL);
dbms_rcvman.listTranslateControlFileBackup(
tag IN VARCHAR2,
completedAfter IN DATE,
completedBefore IN DATE,
statusMask IN BINARY_INTEGER DEFAULT BSavailable+BSunavailable+BSexpired,
-- 8.0/8.1 defaults
autobackup IN BINARY_INTEGER DEFAULT BScfile_all,
liststby IN BINARY_INTEGER DEFAULT NULL);
dbms_rcvman.listTranslateControlFileCopy(
tag IN VARCHAR2,
completedAfter IN DATE,
completedBefore IN DATE,
statusMask IN BINARY_INTEGER DEFAULT BSavailable+BSunavailable+BSexpired,
-- default for 8.1
liststby IN BINARY_INTEGER DEFAULT NULL,
file_pattern IN VARCHAR2 DEFAULT NULL);
dbms_rcvman.listTranslateDataFileBackup(
file# IN NUMBER,
creation_change# IN NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
completedAfter IN DATE DEFAULT NULL,
completedBefore IN DATE DEFAULT NULL,
statusMask IN BINARY_INTEGER DEFAULT BSavailable+BSunavailable+BSexpired,
-- 8.0/8.1 defaults
pluginSCN IN NUMBER DEFAULT 0);
dbms_rcvman.listTranslateDataFileCopy(
file# IN NUMBER,
creation_change# IN NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
file_name_pattern IN VARCHAR2 DEFAULT NULL,
completedAfter IN DATE DEFAULT NULL,
completedBefore IN DATE DEFAULT NULL,
statusMask IN BINARY_INTEGER DEFAULT BSavailable+BSunavailable, -- default for 8.1
pluginSCN IN NUMBER DEFAULT 0);
dbms_rcvman.listTranslateProxyArchivedLog(
thread# IN NUMBER,
sequence# IN NUMBER,
first_change# IN NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
handle_pattern IN VARCHAR2 DEFAULT NULL,
completedAfter IN DATE DEFAULT NULL,
completedBefore IN DATE DEFAULT NULL,
statusMask IN BINARY_INTEGER DEFAULT BSavailable+BSunavailable+BSexpired);
dbms_rcvman.listTranslateProxyDataFile(
file# IN NUMBER,
creation_change# IN NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
handle_pattern IN VARCHAR2 DEFAULT NULL,
completedAfter IN DATE DEFAULT NULL,
completedBefore IN DATE DEFAULT NULL,
statusMask IN BINARY_INTEGER DEFAULT BSavailable+BSunavailable+BSexpired,
liststby IN BINARY_INTEGER DEFAULT NULL, -- default for 8.1
pluginSCN IN NUMBER DEFAULT 0);
dbms_rcvman.listTranslateProxyDFRecID(
recid IN NUMBER,
stamp IN NUMBER,
xdf_key OUT NUMBER,
file# OUT NUMBER,
status OUT VARCHAR2,
handle OUT VARCHAR2,
completion_time OUT DATE,
checkpoint_change# OUT NUMBER,
checkpoint_time OUT DATE);
dbms_rcvman.reportGetDFDel(
file# OUT NUMBER,
filetype OUT NUMBER,
checkpoint_change# OUT NUMBER,
checkpoint_time OUT DATE,
resetlogs_change# OUT NUMBER,
resetlogs_time OUT DATE,
incremental_change# OUT NUMBER,
fuzzy_change# OUT NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER,
fname OUT VARCHAR2,
restorable OUT NUMBER)
RETURN NUMBER;
Deprecated as of 8.1.6
Overload 2
dbms_rcvman.reportGetDFDel(
file# OUT NUMBER,
filetype OUT NUMBER,
checkpoint_change# OUT NUMBER,
checkpoint_time OUT DATE,
resetlogs_change# OUT NUMBER,
resetlogs_time OUT DATE,
incremental_change# OUT NUMBER,
fuzzy_change# OUT NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER,
fname OUT VARCHAR2,
restorable OUT NUMBER,
key OUT NUMBER,
completion_time OUT DATE)
RETURN NUMBER;
dbms_rcvman.reportGetDFDel(
file# OUT NUMBER,
filetype OUT NUMBER,
checkpoint_change# OUT NUMBER,
checkpoint_time OUT DATE,
resetlogs_change# OUT NUMBER,
resetlogs_time OUT DATE,
incremental_change# OUT NUMBER,
fuzzy_change# OUT NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER,
fname OUT VARCHAR2
restorable OUT NUMBER)
RETURN NUMBER;
Hint to indicate the archivelog that is interested. Later, isTranslatedArchivedLog can be called to verify the presence.
It doesn't take resetlogs information in order to keep it simple. Responsible for the client to validate further by comparing resetlogs information.
dbms_rcvman.setArchivedLogRecord(
thread# IN NUMBER,
sequence# IN NUMBER,
first IN BOOLEAN);
dbms_rcvman.setComputeRecoveryActionMasks(
containerMask IN NUMBER,
actionMask IN NUMBER,
allRecords IN NUMBER,
availableMask IN BINARY_INTEGER,
fullBackups IN NUMBER DEFAULT NULL);
TBD
Overload 2
dbms_rcvman.setComputeRecoveryActionMasks(
containerMask IN NUMBER,
actionMask IN NUMBER,
allRecords IN NUMBER);
Selects which target database subsequent procedures operate on
dbms_rcvman.setDatabase(
db_name IN VARCHAR2,
reset_scn IN NUMBER,
reset_time IN DATE,
db_id IN NUMBER,
db_unique_name IN VARCHAR2 DEFAULT NULL,
site_aware IN BOOLEAN DEFAULT FALSE,
dummy_instance IN BOOLEAN DEFAULT FALSE,
ors_instance IN BOOLEAN DEFAULT FALSE);
conn rman/rman@repocat
desc v$backup_files
desc rc_backup_files
-- this will generate an error
SELECT COUNT(*)
FROM rc_backup_files;
SELECT name, resetlogs_change#, resetlogs_time
FROM v$database;
SELECT db_id FROM db;
-- substitutde your own DBID from the preceding query
exec dbms_rcvman.setDatabase('ORABASE', 940976, TO_DATE('11-APR-2013 16:05:25'), 318094786);
Sets the package variables to return all logs not backed ntimes to specific device type until sbpscn (standby became primary SCN) ignore needstby flag for the subsequent archivelog translations
dbms_rcvman.setGetSinceLastBackedAL(
ntimes IN NUMBER DEFAULT 1,
devtype IN VARCHAR2 DEFAULT NULL,
sbpscn IN NUMBER);
Translate guid to pdbKey and set it in pdbKeyList. When first is TRUE clears the existing list before setting. The list is used for database translation. pdbKey is PDB_KEY in catalog mode and CON_ID in nocatalog mode.
dbms_rcvman.setPdbKey(
pdbGuid IN VARCHAR2,
first IN BOOLEAN);
Return the incarnation key to which the untilscn belongs if the untilscn is in one of its parents. 0 is returned if the untilscn is in the current incarnation.
dbms_rcvman.setSkipOfflineRangeAboveScan(maxCheckpointSCN IN NUMBER);
dbms_rcvman.setUntilScn(
scn IN NUMBER,
rlgscn IN NUMBER DEFAULT NULL,
rlgtime IN DATE DEFAULT NULL,
flbrp IN BOOLEAN DEFAULT FALSE,
rpoint IN BOOLEAN DEFAULT FALSE);
dbms_rcvman.translateAllBackupSet(
backupType IN BINARY_INTEGER,
tag IN VARCHAR2,
statusMask IN BINARY_INTEGER,
completedAfter IN DATE,
completedBefore IN DATE,
onlyrdf IN BINARY_INTEGER DEFAULT 0);
Translates the archived log key to a archived log recid and stamp in V$ARCHIVED_LOG
dbms_rcvman.translateArchivedLogKey(
al_key IN NUMBER,
available IN NUMBER DEFAULT 1, -- ignored (for compatibility)
unavailable IN NUMBER DEFAULT 1, -- ignored (for
compatibility)
deleted IN NUMBER DEFAULT 1, -- ignored (for compatibility)
online IN NUMBER DEFAULT 1, -- ignored (for compatibility)
recid OUT NUMBER,
stamp OUT NUMBER,
thread# OUT NUMBER,
sequence# OUT NUMBER,
low_scn OUT NUMBER,
reset_scn OUT NUMBER,
block_size OUT NUMBER,
fname OUT VARCHAR2,
needstby IN NUMBER DEFAULT NULL);
dbms_rcvman.translateArchivedLogName(
fname IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
deleted IN NUMBER DEFAULT NULL, -- for compatibility
online IN NUMBER, -- ignored
duplicates IN NUMBER,
statusMask IN BINARY_INTEGER DEFAULT NULL, -- for compatibility
needstby IN NUMBER DEFAULT NULL; -- for compatibility
dbms_rcvman.translateArchivedLogPattern(
pattern IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
deleted IN NUMBER DEFAULT NULL, -- for compatibility
online IN NUMBER, -- ignored
duplicates IN NUMBER,
statusMask IN BINARY_INTEGER DEFAULT NULL, -- for compatibility
needstby IN NUMBER DEFAULT NULL, -- for compatibility
foreignal IN BINARY_INTEGER DEFAULT 0); -- for compatibility
dbms_rcvman.translateArchivedLogSCNRange(
thread# IN NUMBER,
fromSCN IN NUMBER,
toSCN IN NUMBER,
pattern IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
eleted IN NUMBER DEFAULT NULL, -- for compatibility
online IN NUMBER,
duplicates IN NUMBER,
statusMask IN BINARY_INTEGER DEFAULT NULL, -- for compatibility
needstby IN NUMBER DEFAULT NULL,
doingRecovery IN NUMBER DEFAULT FALSE#,
onlyrdf IN BINARY_INTEGER DEFAULT 0, -- for compatibility
reset_scn IN NUMBER DEFAULT NULL, -- for compatibility
reset_time IN DATE DEFAULT NULL, -- for compatibility
sequence# IN NUMBER DEFAULT NULL, -- for compatibility
foreignal IN BINARY_INTEGER DEFAULT 0, -- for compatibility
incarn IN NUMBER DEFAULT NULL); -- for compatibility
dbms_rcvman.translateArchivedLogSeqRange(
thread# IN NUMBER,
fromseq# IN NUMBER,
toseq# IN NUMBER,
pattern IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
deleted IN NUMBER DEFAULT NULL, -- for compatibility
online IN NUMBER, -- ignored
duplicates IN NUMBER,
statusMask IN BINARY_INTEGER DEFAULT NULL, -- for compatibility
needstby IN NUMBER DEFAULT NULL, -- for compatibility
foreignal IN BINARY_INTEGER DEFAULT 0, -- for compatibility
incarn IN NUMBER DEFAULT NULL); -- for compatibility
dbms_rcvman.translateArchivedLogTimeRange(
thread# IN NUMBER,
fromTime IN DATE,
toTime IN DATE,
pattern IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
deleted IN NUMBER DEFAULT NULL, -- for compatibility
online IN NUMBER, -- ignored
duplicates IN NUMBER,
statusMask IN BINARY_INTEGER DEFAULT NULL, -- for compatibility
needstby IN NUMBER DEFAULT NULL, -- for compatibility
foreignal IN BINARY_INTEGER DEFAULT 0, -- for compatibility
incarn IN NUMBER DEFAULT NULL); -- for compatibility
dbms_rcvman.translateBackupFile(
bs_recid IN NUMBER,
bs_stamp IN NUMBER,
fno IN NUMBER,
bskey OUT NUMBER,
inclevel OUT NUMBER,
backup_type OUT VARCHAR2,
completed OUT DATE);
Translates the specified backup set into a list of backup pieces
Overload 1
dbms_rcvman.translateBackupPieceBSKey(
key IN NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
deviceType IN VARCHAR2 DEFAULT NULL,
pieceCount IN NUMBER,
duplicates IN NUMBER DEFAULT TRUE#,
copyNumber IN NUMBER DEFAULT NULL,
available IN NUMBER DEFAULT TRUE#,
unavailable IN NUMBER DEFAULT FALSE#,
deleted IN NUMBER DEFAULT FALSE#,
expired IN NUMBER DEFAULT FALSE#,
statusMask IN BINARY_INTEGER DEFAULT NULL); -- for compatibility
TBD
Overload 2
dbms_rcvman.translateBackupPieceBSKey(
startBsKey IN NUMBER,
tag IN VARCHAR2 DEFAULT NULL,
statusMask IN BINARY_INTEGER DEFAULT NULL);
dbms_rcvman.translateBackupPieceHandle(
handle IN VARCHAR2,
deviceType IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
expired IN NUMBER DEFAULT NULL, -- for compatibility
statusMask IN BINARY_INTEGER DEFAULT NULL); -- for compatibility
TBD
Overload 2
dbms_rcvman.translateBackupPieceHandle(
handle IN VARCHAR2,
device_type IN VARCHAR2,
available IN NUMBER,
unavailable IN NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER,
set_stamp OUT NUMBER,
set_count OUT NUMBER,
piece# OUT NUMBER);
dbms_rcvman.translateBackupPieceKey(
key IN NUMBER,
available IN NUMBER DEFAULT TRUE#,
unavailable IN NUMBER DEFAULT TRUE#,
expired IN NUMBER DEFAULT TRUE#,
statusMask IN BINARY_INTEGER DEFAULT NULL); -- for compatibility
TBD
Overload 2
dbms_rcvman.translateBackupPieceKey(
bp_key IN NUMBER,
available IN NUMBER,
unavailable IN NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER,
handle OUT VARCHAR2,
set_stamp OUT NUMBER,
set_count OUT NUMBER,
piece# OUT NUMBER);
dbms_rcvman.translateBackupPieceTag(
tag IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
statusMask IN BINARY_INTEGER DEFAULT NULL); -- for compatibility
dbms_rcvman.translateBackupSetKey(
bs_key IN NUMBER,
device_type IN VARCHAR2,
available IN NUMBER,
unavailable IN NUMBER,
deleted IN NUMBER,
duplicates IN NUMBER,
backup_type OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER,
set_stamp OUT NUMBER,
set_count OUT NUMBER,
bslevel OUT NUMBER,
completion_time OUT DATE);
Deprecated as of 8.1.6
Overload 2
dbms_rcvman.translateBackupSetKey(
bs_key IN NUMBER,
device_type IN VARCHAR2,
available IN NUMBER,
unavailable IN NUMBER,
deleted IN NUMBER,
duplicates IN NUMBER,
backup_type OUT VARCHAR2,
recid OUT NUMBER,
stamp OUT NUMBER);
Deprecated as of 8.1
Overload 3
dbms_rcvman.translateBackupSetKey(
key IN NUMBER,
bsRec OUT NOCOPY bsRec_t);
dbms_rcvman.translateBackupSetRecID(
recid IN NUMBER,
stamp IN NUMBER,
device_type IN VARCHAR2,
bs_key OUT NUMBER,
bslevel OUT NUMBER,
completed OUT DATE);
TBD
Overload 2
dbms_rcvman.translateBackupSetRecID(
recid IN NUMBER,
stamp IN NUMBER,
device_type IN VARCHAR2);
dbms_rcvman.translateControlFileCopyKey(
key IN NUMBER,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
statusMask IN BINARY_INTEGER DEFAULT NULL); -- for compatibility
Translates a control file name into a list of control file copies
dbms_rcvman.translateControlFileCopyName(
fname IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
duplicates IN NUMBER,
statusMask IN BINARY_INTEGER DEFAULT NULL, -- for compatibility
onlyone IN NUMBER DEFAULT 1);
dbms_rcvman.translateControlFileCopyTag(
cftag IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
duplicates IN NUMBER,
statusMask IN BINARY_INTEGER DEFAULT NULL, -- for compatibility
onlyone IN NUMBER DEFAULT 1);
Translates the datafile copy key into a datafile copy recid and stamp in V$DATAFILE_COPY. This overload is obsolete as of 8.1.6
Overload 1
dbms_rcvman.translateDataFileCopy(
cdf_key IN NUMBER,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
statusMask IN BINARY_INTEGER DEFAULT NULL); -- for compatibility
TBD
Overload 2
dbms_rcvman.translateDataFileCopyKey(
cdf_key IN NUMBER,
available IN NUMBER,
unavailable IN NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER,
file# OUT NUMBER,
fname OUT VARCHAR2,
reset_scn OUT NUMBER,
create_scn OUT NUMBER,
ckp_scn OUT NUMBER,
block_size OUT NUMBER,
blocks OUT NUMBER);
Translates a file number into a list of datafile copies
dbms_rcvman.translateDataFileCopyFNO(
fno IN NUMBER,
available IN NUMBER DEFAULT NULL,
unavailable IN NUMBER DEFAULT NULL,
duplicates IN NUMBER,
statusMask IN BINARY_INTEGER DEFAULT NULL,
pluginSCN IN NUMBER DEFAULT 0);
Translates the datafile copy key into a datafile copy recid and stamp in V$DATAFILE_COPY
Overload 1
dbms_rcvman.translateDataFileCopyKey(
cdf_key IN NUMBER,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
statusMask IN BINARY_INTEGER DEFAULT NULL); -- for compatibility
TBD
Overload 2
dbms_rcvman.translateDataFileCopyKey(
cdf_key IN NUMBER,
available IN NUMBER,
unavailable IN NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER,
file# OUT NUMBER,
fname OUT VARCHAR2,
reset_scn OUT NUMBER,
create_scn OUT NUMBER,
ckp_scn OUT NUMBER,
block_size OUT NUMBER,
blocks OUT NUMBER);
dbms_rcvman.translateDataFileCopyName(
fname IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
duplicates IN NUMBER,
statusMask IN BINARY_INTEGER DEFAULT NULL, -- for compatibility
onlyone IN NUMBER DEFAULT 1,
pluginSCN IN NUMBER DEFAULT 0);
Translates the tag into a list of datafile copies and getDataFileCopy returns the recid and stamp of each datafile copy one at a time until null is returned
dbms_rcvman.translateDataFileCopyTag(
tag IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
duplicates IN NUMBER,
statusMask IN BINARY_INTEGER DEFAULT NULL, -- for compatibility
pluginSCN IN NUMBER DEFAULT 0,
onlytc IN BINARY_INTEGER DEFAULT FALSE#); -- for compatibility
Converts a non-cdb name into a guid, con_id and pdbKey
What is interesting is that it doesn't have an input non-cdb name and in the example, at right, returns nothing so it possibly acts on a back or restore in progress only.
dbms_rcvman.translateDbName(
pdbGuid OUT VARCHAR2,
pdbKey OUT NUMBER)
RETURN NUMBER;
Called to open the cursor in order to retrieve the list of failures (using getFailure) from ADR
dbms_rcvman.translateFailure(
critical IN BINARY_INTEGER,
high IN BINARY_INTEGER,
low IN BINARY_INTEGER,
closed IN BINARY_INTEGER,
adviseId IN NUMBER);
Translates handle and device type to a proxy copy recid and stamp
Overload 1
dbms_rcvman.translateProxyCopyHandle(
handle IN VARCHAR2,
deviceType IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
deleted IN NUMBER DEFAULT NULL, -- for compatibility
expired IN NUMBER DEFAULT NULL, -- for compatibility
statusMask IN BINARY_INTEGER DEFAULT NULL); -- for compatibility
TBD
Overload 2
dbms_rcvman.translateProxyCopyHandle(
handle IN VARCHAR2,
device_type IN VARCHAR2,
available IN NUMBER,
unavailable IN NUMBER,
deleted IN NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER);
Translates a proxy copy key to a recid and stamp in V$PROXY_DATAFILE / V$PROXY_ARCHIVEDLOG. Translates handle and device type to a proxy copy recid and stamp
Overload 1
dbms_rcvman.translateProxyCopyKey(
pc_key IN NUMBER,
deviceType IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
deleted IN NUMBER DEFAULT NULL, -- for compatibility
expired IN NUMBER DEFAULT NULL, -- for compatibility
statusMask IN BINARY_INTEGER DEFAULT NULL); -- for compatibility
TBD
Overload 2
dbms_rcvman.translateProxyCopyKey(
pc_key IN NUMBER,
device_type IN VARCHAR2,
available IN NUMBER,
unavailable IN NUMBER,
deleted IN NUMBER,
recid OUT NUMBER,
stamp OUT NUMBER,
handle OUT VARCHAR2);
dbms_rcvman.translateProxyCopyTag(
tag IN VARCHAR2,
device_type IN VARCHAR2,
available IN NUMBER DEFAULT NULL, -- for compatibility
unavailable IN NUMBER DEFAULT NULL, -- for compatibility
deleted IN NUMBER DEFAULT NULL, -- for compatibility
statusMask IN BINARY_INTEGER DEFAULT NULL); -- for compatibility
Used seek to a specified backupset key, device, copyNumber. May return no_data_found if the backupset key is not found or the cursor have passed over the backupset key, device, copyNumber.
dbms_rcvman.translateSeekBpBsKey(
bsKey IN NUMBER,
deviceType IN VARCHAR2,
pieceCount IN NUMBER,
duplicates IN NUMBER DEFAULT TRUE#,
copyNumber IN NUMBER DEFAULT NULL);
