Database Backup and Recovery (MOSC)

MOSC Banner

New tablespace in pdb not reflected in rman catalog - and not backed up!

edited Mar 8, 2018 10:42AM in Database Backup and Recovery (MOSC) 9 commentsAnswered

Hello,

we have multitenant and dataguard. After creation of a new tablespace we don't see it in "rman> report schema;" even after multipe 'resync catalog', resync catalog from db_unique_name all'.

On standby it looks for ex. like this, there is no Datafile Name:

report schema;

List of Permanent Datafiles

===========================

File Size(MB) Tablespace           RB segs Datafile Name

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

1    720      SYSTEM               YES     +DATA_EXA2/CDBF/DATAFILE/system.1852.893853451

...

46  1200      PCOTA:SALES_TS       NO      +DATA_EXA2/CDBF/229F08910FEA4ED0E0530A1A010A7F1A/DATAFILE/sales_ts.610.957713389

147  230      PCLEANP:SYSTEM       NO

148  265      PCLEANP:SYSAUX       NO

149  5        PCLEANP:USERS        NO

Problem is: the tablespaces are not backed up of course, but there is no error, because the rman catalog 'thinks' it is complete, while it is not in sync with the control file.

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