Posted by Mir Sayeed Hassan on October 8th, 2017
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..
Posted in DBA Administration | Comments Off on Manually Corrupting Oracle Data Block & Recover using BLOCKRECOVER
Posted by Mir Sayeed Hassan on October 7th, 2017
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
Read more..
Posted in RMAN | Comments Off on Restore Full with Incremental Backup of Database using RMAN
Posted by Mir Sayeed Hassan on October 7th, 2017
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
Read more..
Posted in RMAN | Comments Off on Restore full Database by using RMAN
Posted by Mir Sayeed Hassan on October 4th, 2017
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 '^]'
Posted in DBA Administration | Comments Off on Connect user with “@” Password using sqlplus
Posted by Mir Sayeed Hassan on October 4th, 2017
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..
Posted in RMAN | Comments Off on Configure RMAN backup using crontab
Posted by Mir Sayeed Hassan on October 4th, 2017
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
Posted in RAC | Comments Off on Installation of RAC by using VM – Step by Step Procedure
