Recovery Manager (RMAN) script is generated by backup scheduler - Oracle DBA

Q.  You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate?
- Published on 12 Aug 15

a. SQL script
b. PL/SQL script
c. Operating System (OS) script
d. Enterprise Manager (EM) script
e. Recovery Manager (RMAN) script

ANSWER: Recovery Manager (RMAN) script
 

    Discussion

  • Nirja Shah   -Posted on 24 Aug 15
    -The RMAN scripts reliably backup,restore and recover Oracle Database instances.
    1. Most Oracle RMAN activities are batch-oriented and can be automated. For instance, backing up a database is a repetitive activity and not something you would want to execute interactively.

    2. Scripts provide consistency. For tasks of an ad hoc nature, such as recovering a database from a backup, automation is not strictly required. When a script is used to execute the activity, however, the action will be the same, regardless of the experience and expertise of the DBA performing the recovery.

    - SQL Scripts - It is a set of SQL commands saved in a file format in SQL Scripts.

    - Enterprise Manager (EM) Script - It allows you to set up and schedule OS scripts, SQL scripts and other type of scripts.Each script can run against multiple targets and display the results.

    -Operating System Script - It means a list of operating system commands that are prestored in a file and performed sequentially by the interpreter.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)