June 2019

In this blog I will show you how to use an RMAN backup to create a database clone. In my last blog “Recovery with RMAN is easy!” I explained how RMAN can assist to recover from a data file corruption. Fortunately failures like corrupted data files or loss of the entire database are very rarely. More often you might have the challenge to create a copy of the database on a different server for testing or Q&A purposes. RMAN can assist directly with the duplicate command. But it might be a good idea to validate the backup while creating a

In this blog I will show you how easy it is to restore a corrupted tablespace or datafile using RMAN. In my last blog “Backup and Recovery with RMAN is easy!” I wrote how easy it is to backup a database using RMAN if “Oracle” can take care of the file structure. The third blog will than give some details about database cloning / database restore. Let’s start with a curruped database first. Linux is very handy so to destroy or corrupt a data file you can simply use the following command: dd if=/dev/zero of=/u02/oradata/PAUL/88ECC48AE4632772E0530D63A8C04AEF/datafile/o1_mf_users_gfqznp2m_.dbf’ bs=8192 count=1000 Please don’t test