Results for flashback


1 to 20 of 771 results. Prev  Next
Results per page:   20  | 40 | 60


Database SQL Language Reference, 11g Release 2 (11.2)

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 2 (11.2)

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 2 (11.2)

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. The data is stored in internal history tables. Flashback data … . Historical

Database SQL Language Reference, 11g Release 2 (11.2)

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 2 (11.2)

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 Backup and Recovery User's Guide, 11g Release 2 (11.2)

Using Flashback Database and Restore Points

Flashback Databaseis accessible through the RMAN command and SQL statement FLASHBACK DATABASE. You can use either … command to quickly recover the database from logical data corruptions or user errors. Flashback … database to its state at a time in the recent past. Flashback Database is much faster than point-in-time … changes from the archived

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

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 … this feature.

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

Performing Flashback and Database Point-in-Time Recovery

Prerequisites of Flashback DatabaseTo use the FLASHBACK DATABASE command to return your database contents to points in time within the … flashback window, your database must be configured for flashback logging as described in … \"Understanding Flashback Database, Restore Points and Guaranteed Restore Points\". To return the database to … Normal

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

Using Flashback Database and Restore Points

Limitations of Flashback DatabaseBecause Flashback Database works by undoing changes to the data files that exist at the moment when … you run the command, it has the following limitations: Flashback Database can only undo changes to … accidental deletion of data files. You cannot use Flashback Database to undo a shrink data file … then later restore and recover

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

Using Flashback Database and Restore Points

Using Flashback DatabaseThis section describes the basic commands for Flashback Database. It also lists guidelines to ensure optimal performance of Flashback Database.

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

Using Flashback Database and Restore Points

Enabling Flashback DatabaseFollow these are the steps to enable Flashback Database. To enable flashback logging: Ensure the … . Optionally, set the DB_FLASHBACK_RETENTION_TARGET to the length of the desired flashback window in … DB_FLASHBACK_RETENTION_TARGET is set to 1 day (1440 minutes). Enable the Flashback Database feature for the whole database

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

Performing Flashback and Database Point-in-Time Recovery

Prerequisites of Flashback TableTo 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 User's Guide, 11g Release 2 (11.2)

Performing Flashback and Database Point-in-Time Recovery

Prerequisites of Flashback DropThe 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 2 (11.2)

Using Flashback Database and Restore Points

Flashback Database WindowThe range of SCNs for which there is currently enough flashback log data to support the FLASHBACK … DATABASE command is called the flashback database window. The flashback database window cannot extend … further back than the earliest SCN in the available flashback logs. Note: Some database operations

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

Introduction to Backup and Recovery

Oracle Flashback TechnologyAs explained in Oracle Database Concepts, Oracle Flashback Technology complements your physical … . Specifically, you can use the various features of Oracle Flashback to view past states of data and … , flashback features are more efficient and less disruptive than media recovery in most situations in which they apply.

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

Performing Flashback and Database Point-in-Time Recovery

About 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

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

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. Except for Oracle Flashback Drop … , the logical flashback

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

Performing Flashback and Database Point-in-Time Recovery

Monitoring Flashback DatabaseWhen you use Flashback Database to rewind a database to a past target time, Flashback Database … determines which blocks changed after the target time and restores them from the flashback logs. This is … called the restore phase. After this phase completes, Flashback Database then uses redo logs to … reapply changes

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

Using Flashback Database and Restore Points

Disabling Flashback Database LoggingOn a database instances that is either in mount or open state, issue the following command: ALTER DATABASE FLASHBACK OFF;

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

Managing Tables

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





Was this page helpful?

Integrated Cloud Applications & Platform Services