Adjusting space by running the Oracle UPDATE-FRA-SIZE script

You can adjust the size of the backup area by using a script.

If you want to adjust the maximum size of the backup area to a specific value, run the following scripts. The enable-archivelog-mode.sql script enables archive log mode, which enables Oracle online database backup for the specified database instance. The update-fra-size.sql script adjusts the size of the online backup area.

sqlplus /nolog @sql-wrapper enable-archivelog-mode.sql <log_file_name> <tns_name_alias> sys <sysdba_password> <archive_dir> <file_size>
sqlplus /nolog @sql-wrapper update-fra-size.sql <log_file_name> <tns_name_alias> SYS <sysdba_password> <new_size>

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® 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'
  • <archive_dir> is the directory where the archive file is stored.
  • <file_size> is the maximum size of the archive file.
  • <new_size> is the updated size of the backup area (use M for megabytes or G for gigabytes). For example, you would specify 20 gigabytes as 20G.
Example: Enables archive log mode and then sets the backup area for the database instance op to 1 gigabyte.
  • Windows:
    sqlplus /nolog @sql-wrapper enable-archivelog-mode.sql c:\tmp\log OP sys "password" c:\tmp 50M
sqlplus /nolog @sql-wrapper update-fra-size.sql C:\temp\log op SYS "password" 1G
  • Linux:
    sqlplus /nolog @sql-wrapper enable-archivelog-mode.sql /tmp/log OP sys 'password' /tmp/ 50M
sqlplus /nolog @sql-wrapper update-fra-size.sql /tmp/log OP sys 'password' 1G
Important: The script restarts the database. Users are unable to access the database while the script is running.