To perform a successful backup, you must check the control files, SPFILEs, data files, archived log files, and redo log files of Oracle databases before you back up Oracle RAC databases.

Query examples

  • To query locations of redo log files, execute the following statement:
    SELECT member FROM v$logfile WHERE type='ONLINE';
    A similar output is displayed: Each MEMBER entry starts with +. DBSBAKDAT1DG indicates the name of the ASM database that is used to manage the files in the current Oracle RAC environment.
  • To query the locations of archived log files, execute the following SQL statement:
    SELECT name FROM v$archived_log WHERE DELETED='NO';
    A similar output is displayed:Each NAME entry starts with +. DBSBAKDAT1DG indicates the name of the ASM database that is used to manage the files in the current Oracle RAC environment.
  • To query the locations of data files, execute the following statement:
    SELECT name FROM v$datafile;
    A similar output is displayed: Each VALUE entry starts with +. DBSBAKDAT1DG indicates the name of the ASM database that is used to manage the files in the current Oracle RAC environment.
  • To query the locations of SPFILEs, execute the following statement:
    SHOW parameter spfile;
    A similar output is displayed: Each VALUE entry starts with +. DBSBAKDAT1DG indicates the name of the ASM database that is used to manage the files in the current Oracle RAC environment.
  • To query the locations of control files, execute the following statement:
    SELECT member FROM v$logfile WHERE type='ONLINE';
    A similar output is displayed:Each VALUE entry starts with +. DBSBAKDAT1DG indicates the name of the ASM database that is used to manage the files in the current Oracle RAC environment.