Backup and recovery: Recovery and backup is one of the most essential aspects of any job. If you miss your company's important data, you could very well miss your job. Software and hardware can always be changed, but your important data may be irreplaceable!
Backup An oracle database backup recovery is a replica of the data stored in an oracle database. There are two types of oracle backup’s logical backups and physical backups.
Inconsistent and consistent backups A consistent backup is one in which the data files being reversed up hold all modifies up to the similar system change number (SCN). This means that the data files in the backup hold all the data caught from a similar point in time. Dissimilar a conflicting backup, a reliable total file database support does not require revival subsequent to it is reinstated.
A contradictory oracle backup recovery is a kind of support of one or additional files database that you create although the database is after or open the file database has basically shut down unusually.
Recovery Since most possibly, the data files that were reversed up (not the reverse itself) have altered between a restore and backup, the reinstated files should be recovered. During a recovery, all modifies made to the reinstated data file since the era of the oracle backup are redo. That's what the archived redo logs and log are for. It is as well probable to (at least partly) recover if the control files or current redo log is lost are lost. There are four types of recovery crash recovery, instant recovery; disaster recovery and data file media recovery.
Summary of Data File Media Recovery
The type of recovery that gets applies redo and backup is called data file media recovery. Data File Media recovery modernizes a backup to either to the present or to a particular previous time. Usually, the term "data file media recovery" refers to revival of data files.
For maintaining, good database services and remote dba work, understanding strong concept of Oracle basics is always needed. You can get some good tips and techniques from Oracle DBA forums and Oracle DBA blog about Oracle basics.
Backup An oracle database backup recovery is a replica of the data stored in an oracle database. There are two types of oracle backup’s logical backups and physical backups.
Inconsistent and consistent backups A consistent backup is one in which the data files being reversed up hold all modifies up to the similar system change number (SCN). This means that the data files in the backup hold all the data caught from a similar point in time. Dissimilar a conflicting backup, a reliable total file database support does not require revival subsequent to it is reinstated.
A contradictory oracle backup recovery is a kind of support of one or additional files database that you create although the database is after or open the file database has basically shut down unusually.
Recovery Since most possibly, the data files that were reversed up (not the reverse itself) have altered between a restore and backup, the reinstated files should be recovered. During a recovery, all modifies made to the reinstated data file since the era of the oracle backup are redo. That's what the archived redo logs and log are for. It is as well probable to (at least partly) recover if the control files or current redo log is lost are lost. There are four types of recovery crash recovery, instant recovery; disaster recovery and data file media recovery.
Summary of Data File Media Recovery
The type of recovery that gets applies redo and backup is called data file media recovery. Data File Media recovery modernizes a backup to either to the present or to a particular previous time. Usually, the term "data file media recovery" refers to revival of data files.
For maintaining, good database services and remote dba work, understanding strong concept of Oracle basics is always needed. You can get some good tips and techniques from Oracle DBA forums and Oracle DBA blog about Oracle basics.