We recently identified a table on a primary HADR database that had been
loaded with the parm "nonrecoverable " thus the table was unavailable to
the HADR standby copy. The table was identified by the diag log message
ADM5571. After we resolved the problem (resync'ing the HADR standby) we
have been investigating the best way to report on any tables that may
become "unavailabl e"...

Hello All,

create table a (i int);
create table b(i int);
insert into a values(1);
insert into b values(2);
select * from a union all select * from b;
...