Mir Sayeed Hassan – Oracle Blog

How to export table level by using expdp

 Consider the below example tested in our test env & verified

Create the directory at OS Level to place the backup of the dumpfile

[oracle@testdb backup]$ mkdir db_dump_bkp

[root@testdb backup]# chmod... 
Read more..			

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..