Mir Sayeed Hassan – Oracle Blog

Block Change Tracking for Incremental Backups in Oracle database 11gR2

The Block change tracking is mainly used in Incremental backup of the database as it has to scan each block of the datafile to find weather it has any changes or not & it also consume more time, to reduce this we can enable the block change tracking in database level

When...

Truncate all the tables data from the Oracle schema in Oracle database 11gR2

sys@TESTDB>;create user mir identified by mirhassan123;
User created.

sys@TESTDB>;grant connect,resource to mir;
Grant succeeded.

sys@TESTDB>;conn mir
Enter password:
Connected.

mir@TESTDB>;sho user
USER... 
Read more..			

Crontab job for RMAN Backup as Level 0 and level 1

Create all the directories and give the permission in /backup folder

[oracle@Testdb ~]$ cd /backup/rman/

Example:

$mkdir friday_level_0

And others

[oracle@Testdb rman]$ ls
friday_level_0  monday_level_1 ... 
Read more..			

Configuring the Default Type for Backups in Oracle database 11gR2

RMAN will take a backup as backupset or image copy by configuring the device type:

To backup as BACKUPSET whenever you perform the backup of database, issue the below command:

RMAN>; configure device type disk backup type to backupset;
old... 
Read more..			

Configuring AUTOBACKUP of CONTROLFILE and SPFILE in Oracle database 11gR2

 Whenever you perform any RMAN backup, Configure the Control file & SPFILE

 To setup the control file & spfile auto backup

RMAN>; configure controlfile autobackup... 
Read more..			

Script to automatically startup and shutdown the Oracle database 11gR2

Fallow the below step by step procedure as shown below:

Create the directory as shown below:

[oracle@ogg-test1 ~]$ pwd
/home/oracle
[root@oracleTestServer ~]# mkdir -p /home/oracle/scripts
[root@oracleTestServer... 
Read more..