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 DB_RECOVERY_FILE_DEST


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


Database Reference, 12c Release 1 (12.1)

DB_RECOVERY_FILE_DEST

1.69 DB_RECOVERY_FILE_DESTProperty Description Parameter type String Syntax DB_RECOVERY_FILE_DEST = directory | disk group … the same value. DB_RECOVERY_FILE_DEST specifies the default location for the fast recovery area. The

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

Using Oracle Managed Files

17.2.3 Setting the DB_RECOVERY_FILE_DEST ParameterInclude the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters in your initialization … : DB_RECOVERY_FILE_DEST = '/u01/app/oracle/fast_recovery_area' DB_RECOVERY_FILE_DEST_SIZE = 20G

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

Configuring the RMAN Environment

This table describes the DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST parameters.occurs. Oracle recommends that DB_RECOVERY_FILE_DEST be set to a different value from … warning to the alert log if DB_RECOVERY_FILE_DEST equals these parameters. Multiple databases can … have the same value for DB_RECOVERY_FILE_DEST, but one of the following must be true: No two databases … DB_RECOVERY_FILE_DEST

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

Using Oracle Managed Files

17.3.8 Creating Archived Logs Using Oracle Managed Filesin the DB_RECOVERY_FILE_DEST location when: The ARC or LGWR background process archives an online … : DB_RECOVERY_FILE_DEST_SIZE = 20G DB_RECOVERY_FILE_DEST = '/u01/oradata' LOG_ARCHIVE_DEST_1 = 'LOCATION=USE_DB_RECOVERY_FILE_DEST'

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

Using Oracle Managed Files

17.5.2 Scenario 2: Create and Manage a Database with Database and Fast Recovery Areas' DB_RECOVERY_FILE_DEST_SIZE = 10G DB_RECOVERY_FILE_DEST = '/u02/oradata' LOG_ARCHIVE_DEST_1 = 'LOCATION … data files, temp files, control files, and redo logs. The DB_RECOVERY_FILE_DEST parameter sets the … DB_RECOVERY_FILE_DEST location. The DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST parameters set the default directory

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Creating Archive Log Files in Oracle ASM

Creating Archive Log Files in Oracle ASMalso set the DB_RECOVERY_FILE_DEST initialization parameter to a disk group destination. In Example … 17-3, archive log files are generated with ARCHIVELOG mode enabled, DB_RECOVERY_FILE_DEST set to the … log files in an Oracle ASM disk group SQL> SHOW PARAMETER DB_RECOVERY_FILE_DEST NAME TYPE VALUE … ------------------------------------

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

Maintaining RMAN Backups and Repository Records

Disabling the Fast Recovery Arearecovery area by setting the DB_RECOVERY_FILE_DEST initialization parameter to a string. For … DB_RECOVERY_FILE_DEST='' SCOPE=BOTH SID='*'; The database no longer provides the space management … features of the fast recovery area for the files stored in the old DB_RECOVERY_FILE_DEST location. The

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

Using Oracle Managed Files

17.3.1 When Oracle Database Creates Oracle Managed FilesDB_CREATE_FILE_DEST, DB_RECOVERY_FILE_DEST, or DB_CREATE_ONLINE_LOG_DEST_ n initialization parameters in … of DB_RECOVERY_FILE_DEST, DB_CREATE_FILE_DEST, or DB_CREATE_ONLINE_LOG_DEST_ n initialization … , DB_RECOVERY_FILE_DEST, or DB_CREATE_ONLINE_LOG_DEST_ n initialization parameters. If a statement

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

Using Oracle Managed Files

You can create, back up, and drop control files.database does not create a control file in DB_CREATE_FILE_DEST or in DB_RECOVERY_FILE_DEST (the Fast … both the DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST, then the database creates one control file in … location. If a value is specified only for DB_RECOVERY_FILE_DEST, then the database creates one control

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

Creating and Configuring an Oracle Database

2.6.3 Specifying a Fast Recovery Areathe following initialization parameters: DB_RECOVERY_FILE_DEST: Location of the Fast Recovery Area … parameter must be specified before DB_RECOVERY_FILE_DEST is enabled. In an Oracle RAC environment, the

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Creating a Database that Uses Oracle ASM

Creating a Database that Uses Oracle ASM: DB_CREATE_FILE_DEST = +data DB_RECOVERY_FILE_DEST = +fra DB_RECOVERY_FILE_DEST_SIZE = 10G The

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

Managing Control Files

10.2.1 Provide File Names for the Control Filesthe DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST initialization parameters. Oracle ASM then

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

Using Oracle Managed Files

You manage the redo log by completing tasks such as creating redo log groups and members, relocating…DB_CREATE_ONLINE_LOG_DEST_ n parameter is not set, but both the DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST … member in that location. If only the DB_RECOVERY_FILE_DEST initialization parameter is specified, then

Grid Infrastructure Installation Guide for Linux, 12c Release 1 (12.1)

Oracle Grid Infrastructure Postinstallation Procedures

9.2.2 Create a Fast Recovery Area Disk Group… Database administrators can define the DB_RECOVERY_FILE_DEST parameter to the path for the Fast … setting DB_RECOVERY_FILE_DEST. The size of the Fast Recovery Area is set with

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Creating Oracle ASM Files Using a Default File Location for Disk Group Specification

Creating Oracle ASM Files Using a Default File Location for Disk Group Specificationcreate redo log and control files. DB_RECOVERY_FILE_DEST Specifies a default disk group for a fast

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

Using Oracle Managed Files

17.2.4 Setting the DB_CREATE_ONLINE_LOG_DEST_n Initialization ParametersDB_RECOVERY_FILE_DEST initialization parameters. If you do not specify a DB_CREATE_FILE_DEST parameter, but you do

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

Using Oracle Managed Files

If you previously created a control file specifying RESETLOGS and either did not specify file names…statement with the RESETLOGS option. Some combination of DB_CREATE_FILE_DEST, DB_RECOVERY_FILE_DEST, and

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

Maintaining RMAN Backups and Repository Records

Changing the Fast Recovery Area to a New Locationprocedure: Start SQL*Plus on the target database and change the DB_RECOVERY_FILE_DEST initialization … : ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+disk1' SCOPE=BOTH SID='*'; After you change this parameter

Database Error Messages, 12c Release 1 (12.1)

ORA-19500 to ORA-19997

ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZECause: There are two possible cause for this error: 1) The DB_RECOVERY_FILE_DEST parameter was in … parameter. 2) An attempt was made to set DB_RECOVERY_FILE_DEST with the ALTER SYSTEM command when no

Database Error Messages, 12c Release 1 (12.1)

ORA-19500 to ORA-19997

ORA-19812: cannot use string without DB_RECOVERY_FILE_DESTDB_RECOVERY_FILE_DEST parameter was encountered while fetching the initialization parameter. 2) An … DB_RECOVERY_FILE_DEST was in use. 3) An attempt was made to clear DB_RECOVERY_FILE_DEST with the ALTER SYSTEM