SQL developer 3.2

The SQL Developer DBA Navigator GUI interface for RMAN and Data Pump is a very flexible option available for performing backup and recovery operations, and incredibly many DBAs do not have idea that it exists. In this section, we will take a closer look at some of the options available with this tool.

RMAN operations

The DBA Navigator allows us to have the following RMAN options available:

  • Backup Jobs: We can view backup jobs that have been previously executed. It also permits us to create and run a new backup job from here; for example, using the right-click you can execute the following actions: Backup operations such as tablespaces backup, datafiles backup, archivelog backup, and recovery files backup, Restore/Recovery operations ...

Get Oracle Database 12c Backup and Recovery Survival Guide 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.