Manually Corrupting Oracle Data Block & Recover using BLOCKRECOVER The below-given example is for the testing & learning purpose only, don’t use the production databases. I have manually corrupted the data block for my own testing ENV & verified Create the separate tablespace & the new schema/user to perform… Read more..

Restore Full with Incremental Backup of Database by using RMAN The below step by step procedure is to Restore Full Database with Incremental backup from the Production DB to Test DB Env for the verification purpose by using RMAN Transfer the Production Full DB to Test DB for restore by using WINSCP, SCP etc

Restore full Database by using RMAN The below step by step procedure is to Restore DB from the Production DB to Test DB Env for the verification purpose by using RMAN Transfer the Production Full DB Backup to Test DB for restore by using WINSCP, SCP etc [oracle@PRODDB friday_level_0]$ cd /oradata/backup/rman/friday_level_0

Connect user with “@” Password using sqlplus Verify the telnet with specific port as shown below  C:\Users>telnet 192.168.1.1 1521 Or  [oracle@localhost ~]$ telnet 192.168.1.1 1521 Trying 192.168.1.1… Connected to 192.168.1.1 Escape character is ‘^]’  Try to connect… Read more..

Configure RMAN backup using crontab [oracle@localhost ~]$ crontab -l ############################################################## #Script Used To Create Hourly Exports Of  prm database Schemas_Synaps ############################################################### 00 20 * * 0-7 /backup/Daily_Schema_dump/dumpfile.sh testdb >/dev/null ################################# #RMAN… Read more..

Installation of RAC by using VM – Step by Step Procedure Install by using the 2 virtual machine Create the 2 VM with Oracle Linux 6.7 Installation Create the HDD & Shared by 2 VM — (Network team handle this step) Oracle Installation Prerequisites on NODE 1 & Setup as fallows Verify… Read more..