Database 12c: Flashback technology


Today I’vh have been asked what flashback technologies are possbile in 12c PDB:

Here the overview:

  • Flashback query/versions query
    • is UNDO based and work in PDB’s
  • Flashback transaction query/flashback transaction
    • is UNDO and REDO based and work in PDB’s
  • Flashback data archive
    • UNDO gernerated archives
  • Flashback table
    • before drop –> Rename segment name of recylebin, which is based on UNDO, work in PDB’s
    • flashback table to –> is UNDO based, work in PDB’s
  • Flashback database
    • doesn’t work in PDB’s:
RMAN> flashback pluggable database pdb1 to time "to_date('23:15 12-07-2013','hh24:mi dd-mm-yyyy')";

Starting flashback at 12-JUL-13
using channel ORA_DISK_1
using channel ORA_DISK_2

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of flashback command at 07/12/2013 23:20:45
RMAN-05108: Command is not supported for pluggable database

RMAN>

The RMAN command already exists, so there will be a plan to support flashback pluggable databases also. To do a point in time recovery, the “traditional” way via restore/recovery should be used. See here

One thought on “Database 12c: Flashback technology

  1. The system view v$restore_point has a new column named con_id (NUMBER). The ID of the container to which the data pertains. Possible values include: 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. 1: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data (http://docs.oracle.com/cd/E16655_01/server.121/e17615/refrn30390.htm#REFRN30390).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s