Interactive Oracle

This procedure requires an Oracle user with DBA (Database Administrator) privileges as the system user.

To perform a backup on Windows 2019 servers, the ORACLE_HOME system variable must be defined. (See Oracle Backup).

To back up the Oracle database, follow these steps:

1. Log on to the server using an userid that has administrative privileges.
2. From the Windows Desktop, right-click on the Start  Icon and left-click on Terminal (Admin).
   
   
    
3. The User Account Control dialog is displayed.
   
   
    
4. Click on the button. Yes
5. The Administrator: CommandPrompt screen is displayed.

   Note: Do not close the Administrator: Command prompt window until explicitly instructed to do so or when instructed to perform a reboot or restart of the server.

   
    
6. In the Administrator: Command Prompt window, enter the following command to navigate to the Panorama PON EMS server folder.

   C:> cd c:TellabsPanoramaPONbbmgrserver

7. To back up the Panorama PON EMS database, type the following command, and press Enter.

   C:TellabsPanoramaPONbbmgrserver>backupems

8. Messages and a prompt similar to the following are displayed:

   Checking Platform:MSWin32 Detecting Windows Operating System. Oracle Home Is c:/oracle/product/11.2.0/dbhome_1 Ems Home Is /opt/tellabs/panoramapon/bbmgr Enter oracle user that will perform the data pump backup[SYSTEM]:

9. To use the Oracle system user, press Enter. Otherwise, type another Oracle user ID with DBA privileges, and press Enter. The following prompt is displayed:

   Enter oracle user password that will perform the data pump backup[MANAGER]: tellabs

10. To accept the default password, press Enter. Otherwise, type the correct password and press Enter. The following prompt is displayed:

    Enter oracle database SID [EMS]: _

11. To accept the default Oracle database name, press Enter. Otherwise, enter the database name being used, and press Enter. The system prompts for backup file locations:

    Where should the backup logs be stored enter full path or press enter key for default: /opt/afc/user/emsadmin/backuplogs] ?

12. Press Enter to accept the default backup file location, or type another path and press Enter. If this is the first backup on this server, a prompt similar to the following is displayed:

    The directory /opt/afc/user/emsadmin/backuplogs does not exist. Create it [y]

13. Is the directory name and path correct?
    • If YES, press Enter to create the default backup file location.
    • If NO, type N, go back to Step 12, and enter the correct path and directory. The following prompt is displayed:

      Where should the backup files be stored enter full path or press enter key for default: [C:TellabsPanoramaPONbbmgrserverbackupfiles] ?

      Note: It is recommended that individual folders be created within the backupfiles folder. Name the individual folder to reference the PON release of the backup being performed. The path would need to be entered. It could look like this: C:TellabsPanoramaPONbbmgrserverbackupfilesPON_ver_30.1

14. Press Enter to accept the default location, or type another folder name, and press Enter. If this is the first backup on this server or the directory does not exist for some reason, a prompt similar to the following is displayed:

    The directory /opt/afc/user/emsadmin/backupfiles does not exist. Create it [y]

15. Are the directory name and path correct?
    • If YES, press Enter to create the default backup file location.
    • If NO, type N, go back to Step 12, and enter the correct path and directory. The following prompt is displayed:

      Enter the name of the backup file [201007191527.dmp] _

16. Press Enter to accept the default backup filename, or type another filename, and press Enter.

    Note: The format of the default filename consists of: 4-digit year, 2-digit month, 2-digit day, 2-digit hour (24-hour clock), and 2-digit minute.

17. At this point in the backup procedure there are three possible scenarios.

• This is the first time the Panorama PON EMS database for Oracle on this server has been backed up, continue with these steps.
• This is not the first backup and the maximum number of backups have not been performed. (max_backups value has not been met), no user intervention is required. Continue with these steps.
• The maximum number of backups has been performed (max_backups value has been reached), go to Step 19.

  Note: The number of backup files that can be maintained is dependent on the amount of available storage space on the local system and the size of the backup file set. It is advisable to perform the initial backup and then analyze the amount of space required and the amount of available free space. The backup properties file, PON_BackupRestore.properties, is located at c:TellabsPanoramaPONbbmgrserver. This file can be manually edited using a standard ASCII text editor to change the max_backups= value.

18. Type the maximum number of backup files to be maintained. The default is 15. Press Enter. No further user intervention is required.  
    If this is not the first backup on this server, the following messages are displayed:

    Folder C:TellabsPanoramaPONbbmgrserverbackupfiles Is Writable. Found Backup/Restore Properties

19. If the maximum number of backup files has been met or exceeded, there are two possible choices:
    • Do not delete any backups, go to Step 20.
    • Delete the oldest backups until there are fewer than the maximum number of backup files. Go to Step 21.
      The following messages and prompts are displayed:

      Folder C:TellabsPanoramaPONbbmgrserverbackupfiles Is Writable. Found Backup/Restore Properties. You currently have 3 valid backup files[s] Including the current backup you will exceed the maximum backup count of 3 Would you like to delete the failed backup attempts? [Y]: _

20. To keep all backups, type n, and press Enter. Go to Step 23.
21. To delete one or more backups, type y, and press Enter.
    The following messages and prompts display.

    Enter the number of the backup to be deleted 1 201706301609.dmp 2 201707071613.dmp 3 201707141617.dmp 4 201707211621.dmp 5 cancel

22. Type the number corresponding to the backup file to be deleted, and press Enter.

    Note 1: The prompt repeats until the maximum number of backup files, minus one (max_backups= x -1) is reached.

    Note 2: As part of the backup process, the file 20yymmddhhmmss.info is created. It gives a summary of the status of the backup. A folder named 20yymmddhhmm.11XX is also created. It contains several sub-folders that hold files with additional information about the backup. These are in the C:TellabsPanoramaPONbbmgrserverbackupfiles directory. The 20yymmddhhmm. DMP file is the backup data. .

23. Continue with the backup.
    
    Messages similar to the following are displayed:

    Backup Log Directory is /opt/afc/user/emsadmin/backuplogs Backing up 11XX schema version 28.0.0.6 LOGIN: /opt/oracle/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus -SILENT SYSTEM/tellabs@EMS Executing: /opt/oracle/app/oracle/product/11.2.0/dbhome_1/bin/expdp SYSTEM/tellabs@EMS parfile=/ tmp/backup.par.29650 Export: Release 11.2.0.4.0 - Production on Tue Apr 7 10:52:47 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": SYSTEM/********@EMS parfile=/tmp/backup.par.29650 Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 310 MB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT . . .. exported "PON_OWNER"."VOIPNETWORKCFG" 8.687 KB 0 row .. exported "PON_OWNER"."WHITELISTASSOCIATION" 6.664 KB 0 rows .. exported "PPON_OWNER"."VOIPNETWORKCFG" 0 KB 0 rows .. exported "PON_OWNER"."WHITELISTPROFILE" 5.453 KB 1 rows Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is: C:TELLABSPANORAMAPONBINBACKUPFILES201007191527.DMP Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Apr 7 10:55:16 2015 elapsed 000:02:22 Backing up 11XX data... Backing up 11XX anchors... /opt/tellabs/panoramapon/bbmgr/httpfile/certificates... The backup has completed successfully. The log file can be found in C:/Tellabs/PanoramaPON/bbmgr/server/backuplogs/201007191527.explog