Oracle 19c and 18c Enterprise

For more information on backing up and restoring Oracle enterprise databases, see the information found in the document Oracle Database 2-Day DBA and the section titled Performing Backup and Recovery. See also:

Assumption

The procedures in this section were developed based upon the assumption that the default Flash Recovery Area settings were chosen in the Database Configuration Assistant when the VoiceConsole database was created.

How to Create a Backup of the VoiceConsole Database for VoiceConsole On Prem Deployment

Log into the Database

  1. Open the Oracle Enterprise Manager Database Control for the VoiceConsole database.
  2. Log in with the SYS username and password.
  3. Select Connect As SYSDBA from the dropdown list.
  4. Click the Login button.

Configure ARCHIVELOG Mode for the VoiceConsole Database

  1. From the Database Instance home page, select Maintenance > Recovery Settings.
  2. In the Media Recovery section, check the box for ARCHIVELOG Mode if it is not already checked.
  3. Click Apply to save your changes. You are now taken to the Confirmation screen. It informs you that you need to restart the database for the change to take effect.
    Restarting the database makes the VoiceConsole On Prem deployment unusable for a short period of time. Perform this step only when no one is using VoiceConsole.
  4. Click Yes on the Confirmation screen. A page asking you to input Host and Target Database Credentials appears.
  5. Enter the OS username and password you used to install Oracle for the Host Credentials.
  6. Leave the Database Credentials user name and password blank.

    7. If you receive an error like RemoteOperationException: ERROR: wrong password for user, try entering both the Host Credentials and Database Credentials. If this doesn't work, set up the OS user to be able to log on as a batch job in the server's Local Security Policy. To do this, follow these steps:

    1. Select Start > Settings > Control Panel > Administrative Tools > Local Security Policy.
    2. In Local Policies, select User Rights Assignment.
    3. Add the OS user to Log on as a Batch Job. Now you should be able to get past the Host and Target Database Credentials page.
    4. In Restart Database: Confirmation page, click the Yes button. You are taken to the Restart Database: Activity Information page, informing you that the database restart may take some time.
    5. Wait about five minutes, and then click the Refresh button. This should take you back to the Database Login page.
  7. Log back in using the SYS username and password, and then choose Connect As SYSDBA from the drop-down list. After you restart the database, the VoiceConsole system can be used again.

Configure the Backup Policy

  1. From the Database Instance home page, go to Maintenance > Backup Settings > Policy.
  2. Under Backup Policy, check the box beside Automatically backup the control file and server parameter file (SPFILE) with every backup and database structural change.
  3. Scroll to the bottom of the page, and under the Host Credentials section, enter the OS username and password.
  4. Click OK.

Schedule a Database Backup

  1. From the Database Instance home page, go to Maintenance > Schedule Backup.
  2. At the bottom of the Schedule Backup page, enter your OS Host Credentials.
  3. Under the section Oracle-Suggested Backup, click Schedule Oracle-Suggested Backup.
  4. Select Disk as the destination media for the backup.
  5. Click Next. You are now be taken to the Setup page, which explains how the Oracle-suggested backup works.
  6. There are no settings on this page; so click Next.
  7. You are now be taken to the Schedule page where you need to specify the start date, time zone, and daily backup time.
  8. We recommend that you schedule the daily backup for a time when database activity is low.
  9. Click Next. You are taken to the Review page. Here you can see some details of the backup schedule.
  10. Click Submit Job to complete the process.
  11. In the Status page, you can click View Job or click OK to return to the database home page.

Restore a Database Backup

  1. From the Database Instance home page, select Maintenance > Perform Recovery.
  2. Recover to the current time or a previous point-in-time.
  3. Scroll to the bottom of the page. In the Host Credentials section, enter the OS username and password.
  4. Click Perform Whole Database Recovery. A Confirmation page now appears, informing you that this operation temporarily shuts down the database.
    1. Stop the VoiceConsole service.
    2. On the Confirmation page, click Yes. You are taken to a Recovery Wizard page, informing you that it takes a few minutes to shut down and restart the database.
    3. Wait a few minutes, then click the Refresh button on this page.
  5. On the Database Instance page, click Perform Recovery.
  6. Enter your OS Host Credentials.
  7. Click Continue. Another Database Login window appears.
  8. Enter the SYS username and password.
  9. Select SYSDBA from the Connect As login. You are taken back to the Perform Recovery page with an information message at the top saying that the current status is MOUNTED.
  10. Click the Recover to the current time or a previous point-in-time radio button.
  11. Scroll to the bottom of the page, and under the Host Credentials section, enter the OS username and password.
  12. Click Perform Whole Database Recovery.
  13. On the Perform Whole Database Recovery: Point-in-time page, specify whether to recover all transactions to your database up to the present time (complete recovery), or only transactions up through some point in time (point-in-time recovery).
  14. Select Recover to the current time.
  15. Click the Next button.
  16. The next page asks if you want to restore the files to a different location. Select No.
  17. Click the Next button. The Review page displays the options that you chose.
  18. Click the Submit button. A window indicating progress appears.
  19. When the process is complete, the Perform Recovery: Result page appears with a message that the operation succeeded.
  20. Scroll to the bottom of the page, and click the Open Database button.
  21. Click OK on the Result page.
  22. Start the VoiceConsole On Prem deployment service.