Category Archives: Oracle Backup Recovery Questions

Why more redos are generated when the oracle database is in begin backup mode? | Oracle Backup Recovery Questions

During begin backup mode datafile headers get freezed and as a result row information cannot be retrieved as a result the entire block is copied to redo logs as a result more redo generated and more log switch and in … Continue reading

Posted in Oracle Backup Recovery Questions | Leave a comment

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle? | Oracle Backup Recovery Questions

Database in archive log mode chance to take hot backup and no data loss in recovery. you can use RMAN for backup and recovery .disadvantage is poor performance, and more chance to crash disc.

Posted in Oracle Backup Recovery Questions | Leave a comment

What is the disk migration? what is the steps involved in oracle disk migration? | Oracle Backup Recovery Questions

Disk migration is noting but, migration of data from one OS dependent database to another Dependent database. The steps involved in this are ? first go to your target database and export all your data into flat files ? next … Continue reading

Posted in Oracle Backup Recovery Questions | Leave a comment

What do you mean by Oracle MEDIA RECOVERY? | Oracle Backup Recovery Questions

When physical disk fail, physical database file corrupt then media recovery required

Posted in Oracle Backup Recovery Questions | Leave a comment

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database? | Oracle Backup Recovery Questions

A hot backup can be done by either RMAN,User Managed Backups by puting tablespace in backup mode my OEM which does the same as the user managed backup.But the Backup depends upon the size of the database you are using … Continue reading

Posted in Oracle Backup Recovery Questions | Leave a comment

What is the difference between recovery and restoring of the oracle database? | Oracle Backup Recovery Questions

Here is a scenario to understand Restore & Recovery: Sunday 10pm: Database is backed up. and is running fine. Monday 11am: Went down / crashed due to some reason. To bring up the database, we have 2 options: 1. Simple … Continue reading

Posted in Oracle Backup Recovery Questions | Leave a comment

What is Restricted Mode of Instance Startup in Oracle? | Oracle Backup Recovery Questions

To Enable Restricted Session: Alter system enable restricted session; To Disable Restricted Session Alter system disable restricted session; To Start the Database in Restricted Mode STARTUP RESTRICT By starting Instance in restricted mode it will not allow all users to … Continue reading

Posted in Oracle Backup Recovery Questions | Leave a comment

What is db_recovery_file_dest in oracle? When do you need to set this value? | Oracle Backup Recovery Questions

Give me the steps to perform the point in time recovery with a backup which is taken before the reset logs of the db? Tell me about the steps required to enable the RMAN backup for a target database? In … Continue reading

Posted in Oracle Backup Recovery Questions | Leave a comment

What is the difference between oracle media recovery and crash recovery? | Oracle Backup Recovery Questions

Media recovery is a process to recover database from backup when physical disk failure occure. cash recovery is a automated process take care by oracle when instance failure occure.

Posted in Oracle Backup Recovery Questions | Leave a comment

What is an Oracle database Full Backup? | Oracle Backup Recovery Questions

A full backup is an operating system backup of all data files, on-line redo log files and control file that constitute ORACLE database and the parameter.

Posted in Oracle Backup Recovery Questions | Leave a comment