• Arun Kumar

Validate RMAN Backups

Validate Database Files


Connect to RMAN
RMAN> validate database;
RMAN> validate backupset 22;
RMAN> validate datafile 5 block 2;

Speed up Validation Process

run
{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
validate database;
}

Check Physical / Logical DB Corruptions

RMAN> backup validate database archivelog all;
RMAN> backup validate check logical database archivelog all;

Validate Backups Before Restore

RMAN> restore database validate;
RMAN> restore archivelog all validate;


Recent Posts

See All

MySQL Installation on Linux

This article demonstrates MySQL installation on Oracle Enterprise Linux 6.5 version. Installation of MySQL Make sure you are able to connect internet via virtual machine. Try to ping google.com and pr

Add ISO image storage repository on XenServer

If you have used VMware ESXI, its very easy to upload ISO files to the data store and create VMs. With XenServer, you must create your own ISO repository to upload ISO files. Create ISO directory Acce

Perform Manual Switchover on Physical Standby

Connect to proddb database via client: Take a new putty session and connect to proddb database via client machine. Keep querying below sqlplus sys/sys@proddb as sysdba SQL> select name, open_mode, db

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback