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


21 to 40 of 771 results. previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Backup and Recovery Reference, 11g Release 2 (11.2)

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

Performing Flashback and Database Point-in-Time Recovery

Performing a Flashback Table OperationIn this scenario, assume that you want to perform a flashback of the hr.temp_employees table after … a user made some incorrect updates. The perform a flashback of temp_employees: Connect SQL*Plus to … the target database and identify the current SCN. You cannot roll back a FLASHBACK TABLE statement … , but you can issue another

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

Performing Flashback and Database Point-in-Time Recovery

Performing a Flashback Drop OperationUse the FLASHBACK TABLE... TO BEFORE DROP statement to recover objects from the recycle bin. You … and drop hr.employee_demo. You decide to use FLASHBACK TABLE to retrieve the dropped object. To … can also use Flashback Query on tables in the recycle bin, but only by using the recycle bin name … bin. Retrieve the dropped table.

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

Performing Flashback and Database Point-in-Time Recovery

Performing a Flashback Database OperationThis section presents a basic technique for performing a flashback of the database, specifying the … most recent OPEN RESETLOGS, see \"Rewinding an OPEN RESETLOGS Operation with Flashback Database\". By … default, an SCN used in a FLASHBACK DATABASE command refers to an SCN in the direct ancestral path … Incarnation Branch\".

Database Backup and Recovery Reference, 11g Release 2 (11.2)

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-87 FLASHBACK DATABASE to a Specific SCN Assume that you inserted … query the earliest SCN

Database Backup and Recovery Reference, 11g Release 2 (11.2)

FLASHBACK DATABASE

Table 2-8 How FLASHBACK DATABASE Responds to Data File Status ChangesThe earliest SCN that can be used for a Flashback Database operation depends on the setting of the … DB_FLASHBACK_RETENTION_TARGET initialization parameter, and on the actual retention of flashback … NOLOGGING Operations on Flashback Database When using FLASHBACK DATABASE with a target time at which a … Flashback

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

Managing Tables

Using Flashback Drop and Managing the Recycle BinFlashback Drop, and the FLASHBACK TABLE statement is used to restore the table. Before discussing the … use of the FLASHBACK TABLE statement for this purpose, it is important to understand how the

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

Performing User-Managed Database Flashback and Recovery

Performing Flashback Database with SQL*PlusOracle Flashback Database returns your entire database to a previous state without requiring you to … restore files from backup. The SQL*Plus FLASHBACK DATABASE command performs the same function as … the RMAN FLASHBACK DATABASE command: it returns the database to a prior state. Flashback Database … requires you

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

Starting and Configuring RMAN and Flashback Database

Starting and Configuring RMAN and Flashback DatabasePart II Starting and Configuring RMAN and Flashback Database The chapters in this part explain the … Environment: Advanced Topics\" Chapter 7, \"Using Flashback Database and Restore Points\"

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

Performing Flashback and Database Point-in-Time Recovery

Rewinding a Table with Flashback TableFlashback Drop relies on a mechanism called the recycle bin, which the database uses to manage … Developer's Guide to learn how to use the logical flashback features \"Understanding Flashback … to use Flashback Database, and on the related restore points feature Rewinding a Table with … Flashback

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

Using Flashback Database and Restore Points

7 Using Flashback Database and Restore PointsThis chapter explains Flashback Database, restore points. This chapter discusses configuring … contains the following topics: Understanding Flashback Database, Restore Points and Guaranteed … Restore Points Logging for Flashback Database and Guaranteed Restore Points Prerequisites for Flashback … Database and

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

Performing Flashback and Database Point-in-Time Recovery

Rewinding a Database with Flashback DatabaseThis section explains the most common scenario for using Flashback Database to reverse unwanted changes to your database.

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

Getting Started with RMAN

Rewinding a Database with Flashback DatabaseYou can use the Oracle Flashback Database to rewind the whole database to a past time. Unlike media … RMAN FLASHBACK DATABASE command, your database must have been previously configured to generate … flashback logs. This configuration task is described in \"Flashback Database\". Flashback Database works

Database Reference, 11g Release 2 (11.2)

Descriptions of Wait Events

flashback logfile syncWaits for flashback database data to be written to disk. Wait Time: Includes RVWR writing the … flashback database data and posting this process Parameters: None

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

Performing User-Managed Database Flashback and Recovery

Overview of User-Managed Media RecoveryThis section provides an overview of recovery with SQL*Plus. This section contains the following topics: About User-Managed Restore and Recovery Automatic Recovery with the RECOVER Command Recovery When Archived Logs Are in the Default Location Recovery When Archived Logs Are in a Nondefault Location Recovery Cancellation Parallel Media Recovery

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

Performing User-Managed Database Flashback and Recovery

About User-Managed Restore and RecoveryTypically, you restore a file when a media failure or user error has damaged or deleted multiple data files. In a user-managed restore operation, you use an operating system utility to restore a backup of the file. If a media failure affects data files, then the recovery procedure depends on: The archiving mode of the database: ARCHIVELOG or NOARCHIVELOG The type of media failure The files affected

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

Performing User-Managed Database Flashback and Recovery

Performing Complete Database RecoveryTypically, media recovery is limited by data block reads and writes. Parallel recovery attempts to use all of the available I/O bandwidth of the system to improve performance. Unless there is a system I/O bottleneck or poor asynchronous I/O support, parallel recovery is likely to improve performance of recovery. To override the default behavior of performing parallel recovery, use the SQL*Plus RECOVER

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

Performing User-Managed Database Flashback and Recovery

Performing Closed Database Recoveryalso use Flashback Database, but this procedure affects all data files and returns the entire database

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

Performing User-Managed Database Flashback and Recovery

Table 29-5 Media Recovery SolutionsIf You Suspect... Then... Missing or misnamed archived redo logs Determine whether you entered the correct file name. If you did, then check whether the log is missing from the operating system. If it is missing, and if you have a backup, then restore the backup and apply the log. If you do not have a backup, then if possible perform incomplete recovery up to the point of the missing log. ORA-1113

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

Performing User-Managed Database Flashback and Recovery

Performing Trial RecoveryWhen problems such as stuck recovery occur, you have a difficult choice. If the block is relatively unimportant, and if the problem is isolated, then it is better to corrupt the block. But if the problem is not isolated, then it may be better to open the database with the RESETLOGS option. Because of this situation, Oracle Database supports trial recovery. A trial recovery applies redo in a way similar