Database Backup and Recovery (MOSC)

MOSC Banner

Why "Advanced Queuing does not support Tablespace Point-in-Time Recovery (Doc ID 137237.1)"

edited May 21, 2015 10:04AM in Database Backup and Recovery (MOSC) 6 commentsAnswered

Hello!

Can someone shed light on why TSPITR is not supported with AQ objects?

What property does an AQ queue table or other supporting object have that interferes with TSPITR?

And also: why is it not a problem with database point-in-time recovery?

In my example I have one single and one multi consumer queue table.

SYS@buda>r

  1   SELECT OBJ1_OWNER, OBJ1_NAME,OBJ1_TYPE,REASON

  2   FROM SYS.TS_PITR_CHECK

  3   WHERE (

  4   TS1_NAME IN ('AQTS')

  5   AND TS2_NAME NOT IN ('AQTS')

  6   )

  7   OR (

  8   TS1_NAME NOT IN ('AQTS')

  9   AND TS2_NAME IN ('AQTS')

10* )

own1   name1                     obj1type reason

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center