Oracle DBA | Introduction To Backup & Recovery | Bangla | DBA2-01
To See More DBA part-01 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUO3yQq7-LLdfQb5HpsQKNg
To See More DBA part-02 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUviefN3-ZzKDVgbIH0RoaS
To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY
To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU
Dear viewer, In this tutorial you will know about Backup Restore & Recovery.
A backup is a copy of data. This copy can include important parts of the database, such as the control file and data files.It is simply a copy. If you loose original data, you can recover it by using backup.A backup is a safeguard against unexpected data loss and application errors. If you lose the original data, then you can reconstruct it by using a backup.
About Recovery:To restore a physical backup of a datafile or control file is to reconstruct it and make it available to the Oracle database server.To recover a restored datafile is to update it by applying archived redo logs and online redo logs, that is, records of changes made to the database after the backup was taken. If you use RMAN, then you can also recover datafiles with incremental backups, which are backups of a datafile that contain only blocks that changed after a previous incremental backup.
Types Of Backup:
There are two types of Oracle backup
- Physical Backup
- Logical Backup
Ways Of Backup And Recovery:
There are two ways to perform Oracle backup and Recovery:
- Recovery Manager (RMAN)
About Recovery Manager(RMAN):
Recovery Manager is an oracle utility (with graphic and command-line interface) that can backup, restore, and recover database files. It is a feature of the Oracle database server and does not require separate installation. RMAN is the component of the Oracle database that is used to perform backup and recovery operations. It can make consistent and inconsistent backups, perform incremental and full backups, and back up either the whole database or a portion of it. RMAN uses its own powerful job control and scripting language, as well as a published API that interfaces RMAN with many popular backup software solutions.
About user-managed backup: You can also use operating system commands for backups and SQL*Plus for recovery. This method, also called user-managed backup and recovery, is fully supported by Oracle, Although use of RMAN is highly recommended because it is more robust and greatly simplifies administration.
Backup Strategy May Include:
- Entire database (whole)
- Portion of the database (partial)
Whole database backup:
Includes all data files and at least one control file (Remember that all control files in a database are identical.)
Partial database backup:
May include zero or more tablespaces and zero or more data files; may or may not include a control file.
Backup Mode May Be:
- Offline (consistent, cold)
- Online (inconsistent, hot)
Offline backups (also known as “cold” or consistent backup):
Are taken while the database is not open. They are consistent because, at the time of the backup, the system change number (SCN) in data file headers matches the SCN in the control files.
Online backups (also known as “hot” or inconsistent backup):
Are taken while the database is open. They are inconsistent because, with the database open, there is no guarantee that the data files are synchronized with the control files.
To Get more Tutorial Subscribe The Channel
click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1
To Get All Post Like The Facebook Page
Click here https://www.facebook.com/oracledbsolutions
Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber
Facebook Group: https://www.facebook.com/groups/465557066961548
email: [email protected]
Mob: 01734557080, 01627422780