You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for V$BACKUP_PIECE


1 to 20 of 2549 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Reference, 12c Release 1 (12.1)

V$BACKUP_PIECE

7.87 V$BACKUP_PIECEV$BACKUP_PIECE displays information about backup pieces from the control file. Each backup set … of the device on which the backup piece resides. Set to DISK for backup sets on disk. See Also: V … ) RMAN_STATUS_RECID NUMBER Owning V$RMAN_STATUS record ID RMAN_STATUS_STAMP NUMBER Owning V

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Reporting on RMAN Operations

Determining the Encryption Status of Backup PiecesThe ENCRYPTED column of the V$BACKUP_PIECE and V$RMAN_BACKUP_PIECE views indicates whether a backup … \", P.RECID AS \"BP_REC\", P.ENCRYPTED, P.TAG, P.HANDLE AS \"MEDIA_HANDLE\" FROM V$BACKUP_PIECE P, V … -39525561-20070711-01 3 3 YES TAG20070711T140130 /disk1/c-39525561-20070711-02

Database Reference, 12c Release 1 (12.1)

V$BACKUP_SET

7.90 V$BACKUP_SETthe foreign key for the following tables: V$BACKUP_PIECE, V$BACKUP_DATAFILE, V$BACKUP_REDOLOG, V … key for the following tables: V$BACKUP_PIECE, V$BACKUP_DATAFILE, V$BACKUP_REDOLOG, V$BACKUP_CORRUPTION … V$BACKUP_SET

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Reporting on RMAN Operations

About Recovery Catalog Viewsthe database. For example, RC_BACKUP_PIECE corresponds to V$BACKUP_PIECE. The primary difference … information about a database incarnation. Most of the catalog views have a corresponding V$ view in … between the recovery catalog view and corresponding V$ view is that each recovery catalog view contains … metadata

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Maintaining RMAN Backups and Repository Records

Removing Records from the RMAN Repositoryquery V$ views to verify your changes. Views include V$BACKUP_PIECE, V$BACKUP_SET, V$BACKUP_DATAFILE … HANDLE FROM V$BACKUP_PIECE; See Also: Oracle Database Backup and Recovery Reference for CATALOG … . After the files are cataloged, you can run the LIST command or query

Database Backup and Recovery Reference, 12c Release 1 (12.1)

Summary of RMAN Recovery Catalog Views

Summary of RMAN Recovery Catalog ViewsV$BACKUP_FILES RMAN backups and copies known to the repository. RC_BACKUP_PIECE V$BACKUP_PIECE … VARCHAR2(32767). Table 5-1 Recovery Catalog Views Recovery Catalog View Corresponding V$ View Catalog … View Description RC_ARCHIVED_LOG V$ARCHIVED_LOG Archived and unarchived redo log files … RC_BACKUP_ARCHIVELOG_DETAILS

Database Backup and Recovery Reference, 12c Release 1 (12.1)

RC_BACKUP_PIECE

RC_BACKUP_PIECEThis view lists information about backup pieces. This view corresponds to the V$BACKUP_PIECE view … . RECID NUMBER The backup piece RECID from V$BACKUP_PIECE. RECID and STAMP form a concatenated primary … piece stamp propagated from V$BACKUP_PIECE. RECID and STAMP form a concatenated

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

Contents$BACKUP_PIECE 7.88 V$BACKUP_PIECE_DETAILS 7.89 V$BACKUP_REDOLOG 7.90 V$BACKUP_SET 7.91 V … USER_ZONEMAP_MEASURES 6.624 USER_ZONEMAPS Part III Dynamic Performance Views 7 Dynamic Performance (V … $) Views: V$ACCESS to V$HVMASTER_INFO 7.1 About Dynamic

Database Backup and Recovery Reference, 12c Release 1 (12.1)

RC_BACKUP_PIECE_DETAILS

RC_BACKUP_PIECE_DETAILSfile. STAMP NUMBER The backup piece stamp propagated from V$BACKUP_PIECE. RECID and STAMP form a … from V$BACKUP_SET. SET_STAMP and SET_COUNT form a concatenated key that uniquely identifies the backup … value from V$BACKUP_SET. SET_STAMP and SET_COUNT form a concatenated key that uniquely identifies

Database Backup and Recovery Reference, 12c Release 1 (12.1)

LIST

LISTconnected in NOCATALOG mode, then BP Key displays the RECID from V$BACKUP_PIECE. Note: The values for KEY in … connected in NOCATALOG mode, then BP Key displays the RECID from V$BACKUP_PIECE. Note: The values for KEY … Key displays the RECID from V$BACKUP_PIECE. Note: The values for

Database Backup and Recovery Reference, 12c Release 1 (12.1)

CATALOG

CATALOG… Cataloging a backup piece creates a new row in V$BACKUP_PIECE. A backup set is only usable when all backup

Database Administrator's Guide, 12c Release 1 (12.1)

Distributed Database Management

Part V Distributed Database ManagementYou can manage a distributed database environment.

Database Concepts, 12c Release 1 (12.1)

Oracle Instance Architecture

Part V Oracle Instance ArchitectureThis part describes the basic structural architecture of the Oracle database instance. This part contains the following chapters: Oracle Database Instance Memory Architecture Process Architecture Application and Networking Architecture

Database SQL Tuning Guide, 12c Release 1 (12.1)

Optimizer Statistics

Part V Optimizer StatisticsThe optimizer relies on statistics to create execution plans. This part contains the following chapters: Optimizer Statistics Concepts Histograms Managing Optimizer Statistics: Basic Topics Managing Optimizer Statistics: Advanced Topics

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Subprograms

PL/SQL Functions that SQL Statements Can InvokePackages and Types Reference. Dynamic performance views: [G]V$RESULT_CACHE_STATISTICS [G]V … $RESULT_CACHE_MEMORY [G]V$RESULT_CACHE_OBJECTS [G]V$RESULT_CACHE_DEPENDENCY See Oracle Database Reference for more … information about [G]V$RESULT_CACHE_STATISTICS, [G]V$RESULT_CACHE_MEMORY,

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Collections and Records

Declaring Associative Array Constants'; Ret(9):= 'nine'; RETURN Ret; END Init_My_AA; END My_Types; / DECLARE v CONSTANT My_Types.My_AA … DBMS_OUTPUT.PUT_LINE(TO_CHAR(Idx, '999')||LPAD(v(Idx), 7)); Idx:= v.NEXT(Idx); END LOOP; END; END

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Language Fundamentals

Conditional Compilation ExamplesDatabase release number. Each BOOLEAN constant of the form VER_LE_ v has the value TRUE if the database … version is less than or equal to v. otherwise, it has the value FALSE. Each BOOLEAN constant of the … form VER_LE_ v_r has the value TRUE if the database version is less than or equal to v and release

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Reserved Words and Keywords

D PL/SQL Reserved Words and Keywordscan display them with the dynamic performance view V$RESERVED_WORDS. For information about this view … , SQL, START, SUBTYPE T TABAUTH, TABLE, THEN, TO, TYPE U UNION, UNIQUE, UPDATE V VALUES, VIEW, VIEWS W … , UNSIGNED, UNTRUSTED, USE, USING V VALIST, VALUE, VARIABLE, VARIANCE, VARRAY, VARYING, VOID W WHILE, WORK, WRAPPED, WRITE Y YEAR

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Subprograms

Formal and Actual Subprogram ParametersSUBTYPE n1 IS NUMBER(1); SUBTYPE v1 IS VARCHAR2(1); PROCEDURE p (n n1, v v1) IS... But you cannot … ), v VARCHAR2(1)) IS... Tip: To avoid confusion, use different names for formal and actual parameters

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Tuning RMAN Performance

Identifying Bottlenecks with V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IOYou can use the V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO views to determine the source of backup or … restore bottlenecks and to see detailed progress of backup jobs. V$BACKUP_SYNC_IO contains rows when … the I/O is synchronous to the process (or thread on some platforms) performing the backup. V … SQL*Plus and