Wish you all happy friendship day….!!!!

Dear Friends,                 Wish you all happy friendship day….!!!! Just because I have best wishers like you, our blog cross more than 25000 hits  within lst 5 months and hope this will keep going….Thanks from bottom of my heart to all…..My Oracle journey will be continue till i do have friends and best wishers like you….!!!! [...]

Read Full Post »

Oracle Backup and Recovery Solutions

When implementing a backup and recovery strategy, you have the following solutions available: – Recovery Manager (RMAN) This tool integrates with sessions running on an Oracle database to perform a range of backup and recovery activities, including maintaining an RMAN repository of historical data about backups. You can access RMAN through the command line or [...]

Read Full Post »

Happy Valentine’s Day

Don’t wait until it’s too late to tell someone how much you love, how much you care. Because when they’re gone, no matter how loud you shout and cry, they won’t hear you anymore. Happy Valentine’s Day

Read Full Post »

What happens during oracle database hot backup

       This was the first question ask to me during one interview. According to oracle documentation you already heard/aware that during an Oracle tablespace hot backup, a script or program or command puts a tablespace into backup mode, then copies the datafiles to disk or tape, then takes the tablespace out of backup mode. We [...]

Read Full Post »

User Managed hot backup of oracle database

Used managed backup means you take backup without any oracle feature. Suppose if you take backup by Operating system then it is called user managed backup. And the term hot backup means taking your backup whenever your database is at open state. To take full database backup follow the following steps. 1)Before proceed remember you [...]

Read Full Post »

ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

Error Description: The scenario is I have created a materialized view through database link over a table reside on the remote database. I used the ON COMMIT option and it fails with ORA-12054 as below. SQL> create materialized view scott.mv_phones 2 TABLESPACE users 3 REFRESH FAST on commit 4 WITH rowid 5 AS select ID, [...]

Read Full Post »

Benefits of using views

•With views you can restrict database access in both column level and row level. Selective portion of tables can be hidden with view. •Creating complex view and query on them allow you to make complex query easy. They allow you to make simple queries to retrieve the results from complicated queries. •Views can be used [...]

Read Full Post »

Backup ARCHIVELOG files with RMAN

RMAN> run { Allocate channel d1 type disk format ‘/u01/backupdb/orcl_full_%T_%s_%p.bkp’; Backup database plus archivelog; } RMAN> list backup summary;

Read Full Post »