• Configuring the RMAN Backup Location

    When you run a BACKUP command for disk-based backups, RMAN creates backup pieces in one of the following locations:

    • Default location
    • FRA
    • Location specified via the BACKUP...FORMAT command
    • Location specified via the CONFIGURE CHANNEL...FORMAT command

    Of these choices, I lean toward the last of them; I prefer specifying a target location via a backup channel.

  • Oracle Database 12C Backup: understanding RMAN

    RMAN is Oracle’s flagship B&R tool. RMAN is provided by default when you install the Oracle software (for both the Oracle Database 12C  Standard Edition and Enterprise Edition). RMAN offers a robust and flexible set of B&R features. The following list highlights some of the most salient qualities:

  • Restore Oracle Database 12c from an RMAN Backup

    How to recovery Oracle 12 from Rman backupWhen you think about architecting your backup strategy, as part of the process you must also consider how you’re going to restore and recover Oracle Database 12c. Your backups are only as good as the last time you tested a restore and recovery. A backup can be rendered worthless without a good restore and recovery strategy. The last thing you want to happen is to experience a media failure, go to restore your database, and then find out you’re missing a file, you don’t have enough space to restore, something is corrupt, and so on.

  • RMAN Recipes for Oracle Database 12c

    Book RMAN Recipes for Oracle Database 12cAuthor: Darl Kuhn, Sam Alapati, Arup Nanda
    Publisher: Apress

    Year:July 16, 2013
    Pages: 796
    Language: english
    Format: PDF
    ISBN: 143024836X

  • RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach

    Книга RMAN Recipes for Oracle Database 12cАвтор: Darl Kuhn, Sam Alapati, Arup Nanda
    Издательство: Apress

    Год:July 16, 2013
    Страниц: 796
    Язык: английский
    ISBN: 143024836X

  • RMAN: Setting the Autobackup of the Control File

    You should always configure RMAN to back up the control file automatically after running any RMAN BACKUP or COPY command or after you make physical changes to the database that result in updates to the control file (such as adding/removing a data file). Use the SHOW command to display the current setting of the control file autobackup:

  • RMAN: Specifying the Backup User

    As discussed previously, RMAN requires that you use a database user with SYSDBA privileges. Whether I’m running RMAN from the command line or invoking RMAN in a script, in most scenarios, I connect directly as SYS to the target database. For example, here is how I connect to RMAN from the command line:

  • RMAN: Using Online or Offline Backups?

    Most production Oracle databases have 24-7 availability requirements. Therefore, your only option is online RMAN backups. Your database must be in archivelog mode for online backups. You need to consider carefully to place archive redo logs, how to format them, how often to back them up, and how long to retain them before deletion. These topics are discussed in subsequent sections.

  • Running the RMAN Client Remotely or Locally with example

    It’s possible to run the rman utility from a remote server and connect to a target Oracle database via Oracle Net:

  • Starting RMAN for Oracle Database 12C

    Before you start RMAN and connect to your Oracle database 12C, you need to ensure that you have the proper OS variables set and that you have access to an account with sys* privileges. Once those are in place, you can start RMAN and connect to your target database via the rman command-line utility. These are the same conditions that need to be in place before connecting to your database as a privileged user are described earlier in this blog