Oracle database backup is an important role for oracle DBA. Physical Backups Oracle database physical backup includes of backing up the physical files as Datafiles Archived redo logs Control files Network files (tnsnames.ora,listener.ora,sqlnet.ora) Parameter file Physical backups are made on the disk or on the tape devices. Logical Backups Oracle database logical backup made using [...]
Published by Paresh Sarma //
How Recovery Manager (RMAN) perform backup of target database ? Following is an example for taking backup of target database with RMAN.For easy understanding,assume target database orcltarget01 and catalog database as orclrman. Simple steps to backup the database with Recovery Manager Steps -I : Execute the following command windows C:\> set ORACLE_SID=orcltarget01 Steps -II : [...]
Published by Paresh Sarma //
Recovery Manager configuration is very simple and straightforward process.Two ways we can configure RMAN backup. Command line version Web-based GUI through EM database control There are many parameters of RMAN can control for better utilization and performance of backup and recovery process.The parameters can be configured through Oracle Enterprise Manager or RMAN command line option. [...]
Published by Paresh Sarma //
Oracle Recovery manager commonly known as RMAN is a very important Oracle’s utility to manage oracle backup and recovery , is used to manage database backup and recovery operations. Using RMAN we can perform the following types of backups Whole backup Partial Backup Full or incremental backup Consistent or inconsistent backup RMAN backup format There [...]
Published by Paresh Sarma //
Database backup is a primary goal of an Oracle DBA , to keep the database open and available for users by 365*24*7 . Database backup is a copy of the database files and as being a DBA, you should maintain it regularly to recover database quickly and without data loss. As per the backup strategies [...]
Published by Paresh Sarma //
