Purpose¶
The Lode Data Database Utilities was created to assist users who are not familiar with Oracle Database and/or who do not have Oracle Database Administrators on site. The utilities offer a simple way for our users to create backups, export, and import their database.
Tip
The Database Utilities are command line compatible which allows you to write scripts to be used for backup automation.
See step 1 of Create BAT File in the backup section for an example.
Installation¶
Installing the Lode Data Database Utilities is a straight forward process. The installer will install two programs in the C:\Program Files\Lode Data Corporation\Database Utilities
folder.
-
FiberExport.exe
A graphical interface to create an Oracle Database datapump DMP file.
-
FiberImport.exe
A graphical interface to import an Oracle Database DMP file.
Steps¶
- Unzip the installation files to a folder on the server desktop
- Right-Click the setup.exe file and run as Administrator
- Next
- Accept license agreement
- Install
- Finish
DB Utilities Installation GIF
Usage¶
When using the DB Utilities you'll need to know the proper users and passwords for the database. These are the passwords you configured in Step 15 - Specify Schema Passwords of the Oracle DB Install.
The exception is that you'll also need the schema user and password. The schema user is normally setup as user = Data
.
Tip
Setup and directory where you will save your backup files. In the example we use C:\DMP
as our default location. Since virtual machines usually have limited drive storage it would be wise to zip archive the files and move them regularly.
Fiber Module Export¶
Running the Fiber Module Export program will create an exact copy of your Fiber Module database. This is useful for backups, migration, and providing Lode Data with a copy of your database. The file created is a *.DMP
file.
Tip
A typical use case is to create a new database to import the DMP file into. When using a database that already has data in it, you'll need to delete the schema. Typically the schema isdata
In the example below we used the same passwords (lode
) for all of the database users Sys and System that we created in Step 15 - Specify Schema Passwords. If you assigned different passwords for each user in Step 15 then you would use those instead.
-
Enter database name:
Oracle system identifier (SID) created in Step 10 - Specify Database Identifiers
-
Enter password for Sys:
Password created in Step 15 - Specify Schema Passwords
-
Enter password for System:
Password created in Step 15 - Specify Schema Passwords
-
Enter schema name:
Schema created on database setup
-
Enter path (
C:\DMP
):Recommended file path. If you are using this as the default path you can hit enter to use
C:\DMP
-
Enter filename (ex:
expdat.dmp
):Default file name. If you want to use the
expdat.dmp
for the file name hit enter to continue
Fiber Module Import¶
Running the Fiber Module Import program will import an Oracle Database DMP file. This can be useful restore corrupt databases from backup or database duplication.
The fields for the Fiber Module Import program are the same as the Fiber Module Export program except you will need the schema password.
-
Enter database name:
Oracle system identifier (SID) created in Step 10 - Specify Database Identifiers
-
Enter password for Sys:
Password created in Step 15 - Specify Schema Passwords
-
Enter password for System:
Password created in Step 15 - Specify Schema Passwords
-
Enter schema name:
Schema created on database setup
-
Enter password for schema:
Password created on database setup
-
Enter default password:
This assigns the default password for all users (other than Sys, System, and Schema).
-
Enter path (C:\DMP):
Recommended file path. If you are using this as the default path you can hit enter to use
C:\DMP
-
Enter filename (ex: expdat.dmp):
Default file name. If you want to use the
expdat.dmp
for the file name hit enter to continue