Summary
RMAN is the main tool for the Oracle backups, and it can be used through the command line or OEM. The RMAN catalog helps to manage the backups and backup pieces. RMAN can back up a tablespace, archive logs, datafiles, or even just control files, as well as the complete database. Incremental backups are an option after a full baseline backup. This tool also allows for parts of the backup to be restored, such as tablespaces, datafiles, or blocks of data. The backups do not need to be broken down into these pieces in order to just recover one file, but all of the backup set pieces that are needed to apply the archive log information must be available.
Oracle’s Data Pump is another tool you can use if you need to pull a table back for comparison, ...
Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
