Thursday, July 29, 2010

RMAN Tablespace Point-in-Time Recovery

Recovery Manager (RMAN) automatic tablespace point-in-time recovery (commonly abbreviated TSPITR) enables you to quickly recover one or more tablespaces in an Oracle database to an earlier time, without affecting the state of the rest of the tablespaces and other objects in the database.

Check online Oracle documentation for TSPITR limitations and how tos.

Known bugs :

TS_PITR_CHECK SHOWS MISLEADING MESSAGES WHEN STATISTICS ARE LOCK (BUG 5192382)

Workaround

1) Apply patch 5192382
2) Unlock affected table statistics.
exec DBMS_STATS.UNLOCK_TABLE_STATS ('table_owner','table_name');

TS_PITR_CHECK REPORTS "MASTER TABLE USED FOR SNAPSHOTS/REPLICATION NOT "

No workaorund

Apply patch 5192382

1 comment: