Saturday, March 04, 2017

RMAN Validate Script

rman target /

RMAN> spool log to validate_rman.txt
RMAN> BACKUP VALIDATE CHECK LOGICAL  DATABASE ARCHIVELOG ALL;

SQL> select name from v$database;

NAME
---------
SPROD

SQL> select * from v$database_block_corruption;

no rows selected
Post a Comment

Autoconfig post 12C upgrade from 11g failed with "ORA-01804: failure to initialize timezone information"

Autoconfig post 12C upgrade from 11g failed with "ORA-01804: failure to initialize timezone information" Error DB Autoconfig ...