11 — Troubleshooting the 5620 SAM database
11-4 Alcatel-Lucent 5620 Service Aware Manager, Release
Troubleshooting Guide 3HE 05723 TQZZA Edition 01
Procedure 11-4 Problem: I need to restore a database
A database restore may be required for a reason such as one of the following:
• the failure of the PC or workstation that houses the database
• the requirement for a rollback due to incorrect configurations in the database
This procedure is intended only to restore a database. It is not intended to upgrade a
database, or create redundancy between databases on Solaris workstations. To
perform upgrades or create redundancy, see the procedures in the
5620 SAM | 5650 CPAM Installation and Upgrade Guide.
Before you start, ensure that:
• a regular database backup exists
• you have the release version of the database installer used to initially install
and create the 5620 SAM database, and the installer version matches the
version of the database being restored
• you have the database name, database instance name, and all user names and
passwords used to create the database
• the database restore is done using the same Oracle instance name as the
database backup
• the directory structure for the restore matches the directory structure of the
database backup used for the restore
1 Determine whether you are restoring the database:
a On the same PC or workstation where the original database was installed. Go
to step 2.
b On a different PC or workstation from the one on which the original database
was installed. Go to step 3.
2 Remove the existing database:
i Launch the database uninstaller to remove the existing database instance
and follow the prompts, as described in the 5620 SAM | 5650 CPAM
Installation and Upgrade Guide.
ii Restart the PC or workstation as prompted by the uninstaller.
iii Remove the remaining tablespace files in the
/opt/5620sam/samdb/tablespaces or C:\5620sam\samdb\tablespace
directory.
iv Remove the remaining archivelog files in the
/opt/5620sam/samdb/archivelog directory or C:\5620sam\samdb\archivelog
folder.
v Ensure that the orapwdatabase_instance_name file is removed. Go to step 4.
3 Ensure that the database backup used for the restore has the same directory
structure as the previous restore, and that the path to the backup directory on the
PC or workstation where the database restore is occurring matches the backup
directory on the PC or workstation where the backup was made.