Exporting the Tablespaces Not Being Recovered

Use

You export tablespaces that do not need to be recovered when using BRRECOVER to perform Tablespace Point-In-Time Recovery. During the database status check, BRRECOVER identified which tablespaces it needs to export because they are not involved in the recovery.

Prerequisites

·        BRRECOVER uses the Oracle EXP tool to export the tablespaces that are not involved in the recovery.

In fact, BRRECOVER calls EXP to export only the metadata of these tablespaces. The tablespace data remains in the data files but is invisible to the database during the recovery. This means that the recovery does not affect these tablespaces.

·        Before exporting these tablespaces, BRRECOVER sets them to status READ ONLY.

·        BRRECOVER writes the results to the BRRECOVER detail log file. See “Example” below for the contents of the log file.

Procedure

...

       1.      Check the display and continue with the database recovery.

       2.      Check the results in the BRRECOVER detail log, v<encoded timestamp>.tpt.

For more information on how to view the logs, see Showing Logs with BR*Tools.

Example

This example shows the contents of the BRRECOVER detail log file for this procedure.

BR0655I Control menu 106 - please decide how to proceed

-------------------------------------------------------------------

Tablespace point-in-time recovery main menu

 

 1 + Set point-in-time and tablespaces for recovery

 2 + Select database backup

 3 + Check the status of tablespaces

 4 = Export tablespaces not being recovered

 5 * Restore required data files

 6 # Restore and apply incremental backup

 7 * Restore and apply archivelog files

 8 * Open database and plug in exported tablespaces

 9 - Exit program

10 - Reset program status

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

------------------------------------------------------------------

BR0662I Enter your choice:

BR0280I Time stamp 2003-01-31 18.37.06

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0342I Database instance GC2 is open in RESTRICT mode

 

BR0767I Following tablespaces will be set READ ONLY:

PSAPSTABD,PSAPSTABI,PSAPTESTD,PSAPTTTTD

 

BR0280I Time stamp 2003-01-31 18.37.07

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I Time stamp 2003-01-31 18.37.10

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0768I Tablespace PSAPSTABD set READ ONLY

BR0768I Tablespace PSAPSTABI set READ ONLY

BR0768I Tablespace PSAPTESTD set READ ONLY

BR0768I Tablespace PSAPTTTTD set READ ONLY

 

BR0742I Metadata of the following tablespaces will be exported:

PSAPSTABD,PSAPSTABI,PSAPTESTD,PSAPTTTTD

 

BR0280I Time stamp 2003-01-31 18.37.10

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I Time stamp 2003-01-31 18.37.14

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

 

BR0370I Directory /oracle/GC2/sapbackup/vdjwrdum created

 

BR0278I Command output of '/oracle/GC2/bin/exp':

 

Export: Release 9.2.0.1.0 - Production on Fri Jan 31 18:37:14 2003

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

 

Username:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

With the Partitioning option

JServer Release 9.2.0.1.0 - Production

Export done in WE8DEC character set and UTF8 NCHAR character set

Note: table data (rows) will not be exported

About to export transportable tablespace metadata...

For tablespace PSAPSTABD ...

. exporting cluster definitions

. exporting table definitions

. . exporting table                          DBABL

. . exporting table                          DBABD

. . exporting table                          DBAML

.....

. . exporting table                          SDBAH

For tablespace PSAPSTABI ...

. exporting cluster definitions

. exporting table definitions

For tablespace PSAPTESTD ...

. exporting cluster definitions

. exporting table definitions

. . exporting table                        SDBAH_1

For tablespace PSAPTTTTD ...

. exporting cluster definitions

. exporting table definitions

. . exporting table                        SDBAH_2

. exporting referential integrity constraints

. exporting triggers

. end transportable tablespace metadata export

Export terminated successfully without warnings.

 

BR0744I EXP called successfully for database instance GC2