Test for compression ratio for using compression ALL in datapump exports at 11G, this is a very simple test of a small test schema with 2 tables. Set-up Env TEST ENV testdb1 SQL> col DIRECTORY_PATH format a20 TEST ENV testdb1 SQL> col DIRECTORY_PATH format a50 TEST ENV testdb1 SQL> select directory_name, directory_path from dba_directories; DIRECTORY_NAME DIRECTORY_PATH —————————— […]
The RMAN restore validate command can be very useful to test the integrity of your backups on tape or disk; it is sometimes not feasible to test a restore so we can at least run the restore validate as a test. We can check for database, controlfile, spfile or archivelogs. Restore database test RMAN> restore database […]
Running an RMAN backup or backup validate will check for logical and physical corruption on the data blocks, with 11g we get more output back from the run listing if there are any blocks marked corrupt. Output from checking a test database for corruptions, in the test run we have no issues RMAN> backup check […]
Welcome to my blog, this is going to be a site dedicated to tools and tips for Oracle DBA’s! it will be mainly a place for me to store all my sql scripts I have created over the years but i’m sure they will be helpful to many a DBA.
For the Love of Data 