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 flashback


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


Database SQL Language Reference, 11g Release 1 (11.1)

FLASHBACK DATABASE

FLASHBACK DATABASEPurpose Use the FLASHBACK DATABASE statement to return the database to a past time or system change … . Following a FLASHBACK DATABASE operation, in order to have write access to the flashed back … Backup and Recovery User's Guide for more information on FLASHBACK DATABASE Prerequisites You must … database must have been put in

Database SQL Language Reference, 11g Release 1 (11.1)

FLASHBACK TABLE

FLASHBACK TABLEPurpose Use the FLASHBACK TABLE statement to restore an earlier state of a table in the event of … parameters. You cannot roll back a FLASHBACK TABLE statement. However, you can issue another FLASHBACK TABLE … the current SCN before issuing a FLASHBACK TABLE clause. See Also: FLASHBACK DATABASE for information

Database SQL Language Reference, 11g Release 1 (11.1)

ALTER FLASHBACK ARCHIVE

ALTER FLASHBACK ARCHIVEPurpose Use the ALTER FLASHBACK ARCHIVE statement for these operations: Designate a flashback data … archive as the default flashback data archive for the system Add a tablespace for use by the … flashback data archive Change the quota of a tablespace used by the flashback data archive Remove a

Database SQL Language Reference, 11g Release 1 (11.1)

DROP FLASHBACK ARCHIVE

DROP FLASHBACK ARCHIVEPurpose Use the DROP FLASHBACK ARCHIVE clause to remove a flashback data archive from the system … . This statement removes the flashback data archive and all the historical data in it, but does not … drop the tablespaces that were used by the flashback data archive. Prerequisites You must have the … FLASHBACK

Database SQL Language Reference, 11g Release 1 (11.1)

CREATE FLASHBACK ARCHIVE

CREATE FLASHBACK ARCHIVEPurpose Use the CREATE FLASHBACK ARCHIVE statement to create a flashback data archive, which … objects. A flashback data archive consists of multiple tablespaces and stores historic data from all … transactions against tracked tables. Flashback data archives retain historical data for the time … duration specified

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Introduction to Backup and Recovery

Flashback DatabaseOracle Database includes the following logical flashback features: Oracle Flashback Query You can … Database Advanced Application Developer's Guide explains how to use this feature. Oracle Flashback … Database Advanced Application Developer's Guide explains how to use this feature. Oracle Flashback … feature.

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Introduction to Backup and Recovery

Oracle Flashback TechnologyAs explained in Oracle Database Concepts, Oracle Flashback Technology complements your physical … . Specifically, you can use flashback features to view past states of data and rewind your database … without restoring backups or performing point-in-time recovery. In general, flashback features are more

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Configuring the RMAN Environment

Enabling Flashback DatabaseTo enable logging for Flashback Database, set the DB_FLASHBACK_RETENTION_TARGET initialization … parameter and issue the ALTER DATABASE FLASHBACK ON statement. To enable flashback logging: Start SQL … MOUNT; Optionally, set the DB_FLASHBACK_RETENTION_TARGET to the length of the desired flashback … DB_FLASHBACK_RETENTION_TARGET

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Introduction to Backup and Recovery

Logical Flashback FeaturesMost of the flashback features of Oracle operate at the logical level, enabling you to view and … manipulate database objects. The logical-level flashback features of Oracle do not depend on RMAN and … are available whether or not RMAN is part of your backup strategy. With the exception of Flashback … Drop, the logical flashback

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing Flashback and Database Point-in-Time Recovery

About Flashback DropThis section explains how to retrieve objects from the recycle bin by means of the FLASHBACK TABLE... TO BEFORE DROP statement. About Flashback Drop

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing Flashback and Database Point-in-Time Recovery

Prerequisites of Flashback DropFlashback Drop reverses the effects of a DROP TABLE operation. Flashback Drop is faster than other … . You can query objects in the recycle bin, just as you can query other objects. A flashback … perform Flashback Drop, the objects are generally all retrieved together. When you restore a table from … dependent

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing Flashback and Database Point-in-Time Recovery

Prerequisites for Flashback TableFlashback Table uses information in the undo tablespace rather than restored backups to retrieve … the table. When a Flashback Table operation occurs, new rows are deleted and old rows are reinserted … . The rest of your database remains available while the flashback of the table is being performed. See … Also: Oracle Database

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing Flashback and Database Point-in-Time Recovery

Prerequisites of Flashback DatabaseThis section explains the most common scenario for using Flashback Database to reverse unwanted … changes to your database. Prerequisites of Flashback Database

Database Administrator's Guide, 11g Release 1 (11.1)

Recovering Tables Using Oracle Flashback Table

Recovering Tables Using Oracle Flashback TableRecovering Tables Using Oracle Flash back Table Oracle Flashback Table enables you to restore a … , Oracle Flashback Table eliminates the need for you to perform more complicated point-in-time recovery … operations. Oracle Flashback Table: Restores all data in a specified table to a previous point in time … specified between a

Database Backup and Recovery Reference, 11g Release 1 (11.1)

FLASHBACK DATABASE

FLASHBACK DATABASEPurpose Use the FLASHBACK DATABASE command to rewind the database to a target time, SCN, or log … exist when you run the command. Flashback can fix logical failures, but not physical failures. Thus … . FLASHBACK DATABASE is usually much faster than a RESTORE operation followed by point-in-time recovery … , because the time needed

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing Flashback and Database Point-in-Time Recovery

Performing a Flashback Database OperationTo use the FLASHBACK DATABASE command to return your database contents to points in time within the … flashback window, your database must have been previously configured for flashback logging as … described in \"Configuring Oracle Flashback Database and Restore Points\". To return the database to a … \"Creating

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Maintaining RMAN Backups and Repository Records

Monitoring Flashback Database Performance Impactare several data analysis methods for monitoring the Flashback Database workload on your system … . For example, you can compare AWR reports from before and after the Flashback Database was turned on … . You can also review AWR snapshots to pinpoint system usage caused by flashback logging. For example … , if flashback

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing Flashback and Database Point-in-Time Recovery

Performing a Flashback Drop OperationThe following list summarizes the user privileges required for the operations related to Flashback … , placing it in the recycle bin. FLASHBACK TABLE... TO BEFORE DROP Privileges for this statement are … tied to the privileges for DROP. That is, any user who can drop an object can perform Flashback Drop to … FLASHBACK

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing Flashback and Database Point-in-Time Recovery

Performing a Flashback Table OperationTo use the Flashback Table feature on one or more tables, use the FLASHBACK TABLE SQL statement … with a target time or SCN. You must have the following privileges to use the Flashback Table feature … : You must have been granted the FLASHBACK ANY TABLE system privilege or you must have the FLASHBACK

Database Backup and Recovery Reference, 11g Release 1 (11.1)

FLASHBACK DATABASE

TO BEFORE SEQUENCE integer THREAD  integer Specifies a redo log sequence number and thread as an upper…most recent OPEN RESETLOGS. Note: FLASHBACK DATABASE can only return the database to a point before … to convert the time to the current format, for example, FLASHBACK DATABASE TO TIME 'SYSDATE-7'. Query … can flash back. Examples Example 2-79 FLASHBACK DATABASE to a Specific SCN Assume that you inserted … query the earliest SCN