Some minions are behind NAT and I'd like to get their public IP address as seen from master (for firewall purposes).
There is external_ip grain but AFAIK it depends on third party service and doesn't even work reliably for me.
we had power failure that left corruption in data files. It was recovered from RMAN backup including logs and all is OK, the DB is working.. except that I noticed this:
RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE FILESPERSET=10;
...snip..
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2 FAILED 0 24312 139056 71820306
File Name: /u02/oradata/ORCL/datafile/o1_mf_sysaux_4kjcn4qg_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 35222
Index 101 39306
Other 0 40216
Other datafiles are all OK. Now the question is, what to do with these indexes? I will try (outside working hours) to do 'alter index... rebuild' for all indexes in SYSAUX but AFAIK that won't help, dropping and recreating the indexes is necessary...but is there SQL source to recreate them? It is Oracle 11.1.0.6 on Linux.