With Flashback Database, you can rewind the database to a previous point in time without media recovery (that is, without restoring backup copies of the datafiles). When the database is running, Flashback Database buffers and writes before-images of data blocks to flashback logs, which are generated by default for all permanent tablespaces and which reside […]
Read More
When you create backups with RMAN, they get created in one or more backupsets; these backupsets are in proprietary format. In order to use them again for recovery, first you need to extract them from this proprietary format. This process is called restore. You use the RESTORE command of RMAN to restore the backup. For […]
Read More
The data in the databases always grows, and as the backup is a copy of the data, it grows too. As the size of the backup grows, it takes more space on the disk and it takes more time to back up. When the database becomes large, you still want to back it up faster […]
Read More
Once you get started with RMAN and become familiar with its three main concepts and the tasks it can perform, you are ready to move onto more advanced concepts. The three concepts are: Backup Making another copy of data in an organized format on disk or tape Restore Getting that copy of data back into a location […]
Read More
Learn what SQL Server experts know about database maintenance, including how and when to use plans or scripts, and the importance of a robust recovery strategy.
Read More
Learn how to recover the master database in SQL Server 2012.
Read More