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 datafile


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


Database Reference, 11g Release 2 (11.2)

V$DATAFILE

V$DATAFILEdisplays datafile information from the control file. See Also: \"V$DATAFILE_HEADER\", which … displays information from datafile headers Column Datatype Description FILE# NUMBER File identification … number CREATION_CHANGE# NUMBER Change number at which the datafile was created CREATION_TIME DATE … Timestamp of the datafile

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Transporting Data Across Platforms

Using CONVERT DATAFILE to Convert Data File FormatsThis section explains how to use the CONVERT DATAFILE command. The section assumes that you intend … following command: % rman RMAN> CONNECT TARGET SYS@prod_dest Execute the CONVERT DATAFILE command to … PLATFORM clause. RMAN> CONVERT DATAFILE 2> '/tmp/transport_solaris/fin/fin01.dbf', 3> '/tmp

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Creating Database Files in Oracle ASM Using SQL*Plus

Creating Control Files in Oracle ASM: Example 2LOGFILE DATAFILE '+DATA/orcl/datafile/system.256.685366089', '+DATA/orcl/datafile/sysaux.257.685366089 … ', '+DATA/orcl/datafile/undotbs1.258.685366091', '+DATA/orcl/datafile/users.259.685366091' CHARACTER SET WE8MSWIN1252;

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

ASMCMD File Management Commands

Option Descriptionfollowing example creates the sysaux.f alias for the fully qualified filename +data/orcl/DATAFILE … . Example 12-25 Using the ASMCMD mkalias command ASMCMD [+data/orcl/datafile] > mkalias SYSAUX … .257.721811945 sysaux.f ASMCMD [+data/orcl/datafile] > ls --absolutepath none => EXAMPLE.265.721812093 +DATA … /ORCL/DATAFILE/sysaux.f

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Performing Oracle ASM Data Migration with RMAN

Moving Data Files Between Oracle ASM Disk Groups Using RMAN, assume that you are using disk groups DATA and USERDATA. You want to move data file +DATA/orcl/datafile … ) Tablespace RB segs Datafile Name ---- -------- -------------- ------- ------------------------ 1 740 … SYSTEM *** +DATA/orcl/datafile/system.258.689589737 2 570 SYSAUX *** +DATA/orcl/datafile/sysaux

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Managing Physical and Snapshot Standby Databases

9.3.4 Renaming a Datafile in the Primary Database9.3.4 R enaming a Datafile in the Primary Database When you rename one or more datafiles in the … a datafile in the primary database and manually propagate the changes to the standby database. To … rename the datafile in the primary database, take the tablespace offline: SQL> ALTER TABLESPACE tbs_4 … mv command, to rename the

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Managing Physical and Snapshot Standby Databases

9.3.1 Adding a Datafile or Creating a Tablespacedatafile to the primary database is automatically propagated to a physical standby databases. If the … datafile must be manually copied from the primary database to the physical standby databases after … it is added to the primary database. Note that if an existing datafile from another database is … TABLESPACE MTS2 DATAFILE

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Data Guard Scenarios

Step 3   Copy the datafile to the standby database.Copy the datafile that contains the missing redo data from the primary site to a location on the

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

ASMCMD File Management Commands

pwd-27 Using the ASMCMD pwd command ASMCMD [+data/orcl/datafile] > pwd +data/orcl/datafile

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Creating Database Files in Oracle ASM Using SQL*Plus

Creating Control Files in Oracle ASM: Example 1/group_3.259.685366215' ) SIZE 50M BLOCKSIZE 512 -- STANDBY LOGFILE DATAFILE '+DATA/orcl/datafile/system.256.685366089 … ', '+DATA/orcl/datafile/sysaux.257.685366089', '+DATA/orcl/datafile/undotbs1.258.685366091', '+DATA … /orcl/datafile/users.259.685366091' CHARACTER SET WE8MSWIN1252;

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

ASMCMD File Management Commands

Option DescriptionPath orcl orcl +data/orcl/controlfile/current.260.691577263 orcl orcl +data/orcl/datafile/example … .265.691577295 orcl orcl +data/orcl/datafile/sysaux.257.691577149 orcl orcl +data/orcl/datafile/system … .256.691577149 orcl orcl +data/orcl/datafile/undotbs1.258.691577151 orcl orcl +data/orcl/datafile

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

ASMCMD File Management Commands

Option Description12-19 Using the ASMCMD cd command ASMCMD [+data/hr] > cd +data/orcl ASMCMD [+data/orcl] > cd DATAFILE ASMCMD [+data/orcl/DATAFILE] >cd..

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

ASMCMD File Management Commands

Option Description/datafile EXAMPLE.265.691577295 SYSAUX.257.691577149 SYSTEM.256.691577149 UNDOTBS1.258.691577151 … USERS.259.691577151 ASMCMD [+] > ls -lt +data/orcl/datafile Type Redund Striped Time Sys Name DATAFILE … MIRROR COARSE JUL 13 08:00:00 Y EXAMPLE.265.691577295 DATAFILE MIRROR COARSE JUL 13 05:00:00 Y … SYSAUX.257.691577149

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

About ASMCMD

Absolute Path and Relative Path/datafile/users.259.555341963 The following cd command uses an absolute path to the directory. ASMCMD … /DATAFILE/undotbs1.272.557429239. ASMCMD [+] > cd +data ASMCMD [+data] > cd orcl/DATAFILE ASMCMD … [+data/orcl/DATAFILE] > ls EXAMPLE.269.555342243 SYSAUX.257.555341961 SYSTEM.256.555341961 … UNDOTBS1.258.555341963

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Altering a Bigfile TablespaceRESIZE 80G; AUTOEXTEND (used outside of the ADD DATAFILE clause): With a bigfile tablespace, you can … use the AUTOEXTEND clause outside of the ADD DATAFILE clause. For example: ALTER TABLESPACE bigtbs … AUTOEXTEND ON NEXT 20G; An error is raised if you specify an ADD DATAFILE clause for a bigfile tablespace.

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Data Files and Temp Files

Bringing Data Files Online or Taking Offline in ARCHIVELOG ModeDATAFILE clause. The following statement brings the specified data file online: ALTER DATABASE DATAFILE … : ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/stuff01.dbf' OFFLINE; Note: To use this form of the ALTER

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Data Guard Scenarios

Step 2   On the primary site, back up the datafile you need to copy to the standby site.needed datafile to a local directory. SQL> ALTER TABLESPACE system END BACKUP;

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Files, Directories, and Templates

Adding an Alias Name for an Oracle ASM FilenameOracle ASM filename ALTER DISKGROUP data ADD ALIAS '+data/orcl/second.dbf' FOR '+data/orcl/datafile/mytable.342.123456789';

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

ASMCMD File Management Commands

Option Description12-20 Using the ASMCMD cp command ASMCMD [+] > cp +data/orcl/datafile/EXAMPLE.265.691577295 … /mybackups/example.bak copying +data/orcl/datafile/EXAMPLE.265.691577295 -> /mybackups/example.bak ASMCMD … [+] > cp /mybackups/examples.bak +data/orcl/datafile/myexamples.bak copying /mybackups/examples.bak … -> +data/orcl/datafile/myexamples.bak

Database Administrator's Guide, 11g Release 2 (11.2)

Creating and Configuring an Oracle Database

Step 10: Create Additional TablespacesDATAFILE '/u01/app/oracle/oradata/mynewdb/apps01.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 1280K … tablespace (optional) CREATE TABLESPACE indx_tbs LOGGING DATAFILE '/u01/app/oracle/oradata/mynewdb/indx01