find /share/Multimedia/ –name *.m4a | while read foo; do rm “$foo” ;done
https://www.ripcaster.co.uk/node/772
Build an Oracle DBA on a firm foundation of sound practices and technical knowledge!
find /share/Multimedia/ –name *.m4a | while read foo; do rm “$foo” ;done
https://www.ripcaster.co.uk/node/772

RMAN - Identify Datafile Block Corruptions
The next command checks the complete database for both corruptions in a backup:$ rman target /
RMAN> backup check logical validate database;
$ rman target /
RMAN> backup check logical database
1) validate all database files and archived redo log files for physical and logical corruption: BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;
1) validate all database files and archived redo log files for physical and logical corruption: BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL; 2) to check individual data blocks, as shown in the following example: VALIDATE DATAFILE 4 BLOCK 10 TO 13; 3) validate backup sets: VALIDATE BACKUPSET 3;
The following RMAN command recovers the corrupted blocks:
1) recover all corrupted blocks reported in v$database_block_corruption
RMAN> RECOVER CORRUPTION LIST;
2) recover individual blocks, see eg:
RMAN> RECOVER DATAFILE 1 BLOCK 233, 235 DATAFILE 2 BLOCK 100 TO 200;
ORA-1578 / ORA-26040 Corrupt blocks by NOLOGGING - Error explanation and solution (Doc ID 794505.1)
The "VALIDATE" RMAN command is used to identify NOLOGGING blocks and populates the view v$database_block_corruption (versions lower than 12c) and v$nonlogged_block (12c and greater).
In version 12.2 the new command "validate .. nonlogged block" is available to validate NOLOGGING Blocks. In the next example datafiles 5 and 6 have nologged blocks:
https://www.zabbix.com/documentation/3.4/manual/installation/install_from_packages/rhel_centos
follow above, but replace 'mysql' with 'pgsql'
yum install zabbix-server-pgsql
yum install zabbix-proxy-pgsql
yum install zabbix-web-pgsql
below is my final packages started with zabbix
[oracle@hmc-P55A-UD3 zabbix]$ rpm -qa |grep zabbix zabbix-get-3.4.4-2.el7.x86_64 zabbix-web-3.4.4-2.el7.noarch zabbix-release-3.4-2.el7.noarch zabbix-proxy-pgsql-3.4.4-2.el7.x86_64 zabbix-web-pgsql-3.4.4-2.el7.noarch zabbix-server-pgsql-3.4.4-2.el7.x86_64 zabbix-agent-3.4.4-2.el7.x86_64
postgres createuser --pwprompt zabbix
postgres createdb -O zabbix zabbix
logon as postgres
zcat /usr/share/doc/zabbix-proxy-pgsql*/schema.sql.gz | psql -U zabbix -d zabbix
-- /etc/httpd/conf.d/zabbix.conf.
set php_value date.timezone accordingly