Disabling online backup of the Oracle database instance

Run the following script to turn off archive logging mode, which disables Oracle online database backup for the specified database instance.

This simply stops the service that runs online database backup; it does not remove any files or data already stored in the backup area.

sqlplus /nolog @sql-wrapper disable-archivelog-mode <log_file_name> <tns_name_alias> SYS <sysdba_password>

Where:

  • <log_file_name> is the directory location, including the log file name that you specify, where any errors or messages relating to this script are logged. If you specify only the log file name, it is stored in the current working directory.
  • <tns_name_alias> is the TNS alias of the IBM OpenPages® with Watson™ database instance as it is known on the network. If necessary, you can retrieve this alias from the tnsnames.ora file.
  • <sysdba_password> is the Oracle SYS account password.
    If the password contains special characters, surround the password in quotation marks:
    • Windows: "password"
    • Linux®: 'password'
Example: Disables online backup for the database instance op.
  • Windows:
    sqlplus /nolog @sql-wrapper disable-archivelog-mode c:\tmp\log op SYS "password"
  • Linux:
    sqlplus /nolog @sql-wrapper disable-archivelog-mode /tmp/log op SYS 'password'
Important:
  • The script restarts the database. Users are unable access the database while the script is running.
  • After disabling online database backup mode, if you want to re-enable online database backup mode for the database instance, do not use the rman-init or rman-daily scripts. Doing so may cause unpredictable database behavior or other problems. To re-enable online database backup mode, contact IBM® OpenPages Support for assistance.