This chapter contains the following topics:
Section 10.1, "Understanding Backup Requirements for Servers"
Section 10.2, "Backing Up JD Edwards EnterpriseOne Tables on Servers"
A well-planned backup strategy is essential to protect the enterprise information assets. Rigorously following the backup strategy will provide insurance against data lost by acts of nature, hardware or software failure, or human error. The backup strategy must balance the level of protection you need against the physical constraints of the system, such as information storage capacity.
We recommend that the backup strategy include these:
Perform a full system backup whenever data is at risk, such as when you are installing or upgrading software. In this circumstance, at least back up the database completely.
Each night, back up changed objects, such as tables and JD Edwards EnterpriseOne objects.
Each week, back up the deployment server, enterprise servers, and the full database.
When you perform a backup on a server, you can back up either the entire server or only the changed objects and data. You do not need to perform a complete backup of the server nightly. Only directories that change daily require daily backups.
Note:
You should outline and implement the backup strategy before you begin the Prototype phase of implementation.JD Edwards EnterpriseOne on the deployment server includes these items:
JD Edwards EnterpriseOne directory (all subdirectories and contents).
jde.ini file on c:\winnt.
Services file on c:\winnt\system32\drivers\etc.
Registry export file.
JD Edwards EnterpriseOne files in the root directory (c:\):
jdeapp.ddp
jdeapp.xdp
jdeauth.dda
jdeauth.xda
jdemod.ddm
jdemod.xdm
jdesec.dds
jdesec.xds
jdecode.ddm
jdecode.xdm
If you modify objects, build new packages, or update the Access database delivered during a workstation installation, create backups of the PD900, DV900, and PY900 directories. If you modify help files, create a backup of the HELPS directory. If the media objects reside on the deployment server, create a backup of the MEDIA OBJ directory.
If important data, such as system data, resides on the deployment server, create nightly backups of the JD Edwards EnterpriseOne data sources (Oracle or SQL Server). For example, if the central objects or Object Management Workbench resides on the deployment server, create a nightly backup.
JD Edwards EnterpriseOne on the enterprise server runs on the IBM i, UNIX, or Windows operating systems. You back up key libraries on the IBM i and key files on the UNIX and Windows operating systems.
IBM i
These JD Edwards EnterpriseOne IBM i libraries should be backed up:
Note:
Shut down the database before you create any backups.All JD Edwards EnterpriseOne system libraries.
JDEOW
SYS900
E900SYS
SVM900
JD Edwards EnterpriseOne data dictionary library: DD900.
JD Edwards EnterpriseOne Object Management Workbench library: OL900.
All JD Edwards EnterpriseOne production libraries (This example is for pristine and production):
PD900
PY900
PRODDTA
PRSTDTA
All JD Edwards EnterpriseOne business data libraries:
PRODDTA
CRPDTA
PRSTDTA
TESTDTA
All JD Edwards EnterpriseOne control libraries:
PRODCTL
CRPCTL
TESTCTL
PRSTCTL
All JD Edwards EnterpriseOne versions libraries:
PD900DNT
PY900DNT
PS900DNT
DV900DNT
IFS (Integrated File System) libraries:
PD900
PY900
PS900
TS900
DV900
IBM libraries that require backups:
OCPA
OGPL
Central objects on the deployment server in Oracle or Microsoft SQL Server database.
UNIX
On a JD Edwards EnterpriseOne UNIX system, backup these database files:
Note:
Shut down the database before you create any backups using Backup Manager. If you export or import using Data Manager, you do not need to shut down the database.System files
Create backups of all host files under the JDEdwards/E900 directory. For example, /u03/JDEdwards/E900/*.
Database files
Create backups of all data files that reside in the JD Edwards EnterpriseOne tablespaces.
Use the Oracle Data Manager Tool on the deployment server to make a .dmp file of the desired database, and then back up the .dmp file on tape or hard disk.
Windows
On a JD Edwards EnterpriseOne Windows system, back up these database files:
Note:
Shut down the database before you create any backups.System files.
JDEdwards\ddp\E900 directory.
Oracle database files.
Create backup files for all data files that reside in the JD Edwards EnterpriseOne tablespaces
Use the Oracle Data Manager Tool on the deployment server to make a .dmp file of the desired database, and then back up the .dmp file on tape or hard disk.
Microsoft SQL Server database files.
Create backup files for all tables that reside in the JD Edwards EnterpriseOne databases.
Use the SQL Server Database/Object Transfer tool on the enterprise server to copy the desired tables or database (for example, PSFT900) to a backup database.
Note:
We recommend that you use the backup tool provided by the RDBMS vendor.These tables list JD Edwards EnterpriseOne tables by type and with the associated object owner IDs.
Note:
If any of the control table merges fail or if the specification merge fails, you might need to restore the tables to a pre-merge condition and run the merge again. Follow the restore instructions for the database.System Tables
The Object Owner for System tables is sys900.
F00053
F000531
F000532
F0092
F00921
F00924
F0093
F0094
F00941
F00942
F00945
F00946
F00948
F00950
F00960
F99001
F986101
F98611
F986115
F986116
F98613
F986150
F986151
F986152
F98616
F986161
F986162
F986163
F986164
F986165
F98701
F98800D
F98900D
F9882
F98825
F9883
F9885
F9886
F9887
F9888
F98881
F98882
F98885
F98887
F9889
F98891
F98892
F98980
F98CONST
F98DRENV
F98DRLOG
F98DRPCN
F98DRPUB
F98DRSUB
F98EVDTL
F98EVHDR
F98MOQUE
F98OWSEC
F98TMPL
F98VAR
Object Management Workbench (OMW) Tables
The Object Owner for OMW tables is obj900.
F00165
F9860
F9861
F9862
F9863
F9865
Data Dictionary Tables
The Object Owner for the Data Dictionary tables is dd900.
F00165
F9200
F9202
F9203
F9207
F9210
F9211
Server Map Tables
The Object Owner for Server Map tables is svm900.
F986101
F98611
F986110
F986111
F986113
F98DRPCN
F98DRLOG
Control Tables
The Object Owners for the Control Tables are:
Control Tables - PROD: prodctl
Control Tables - CRP: crpctl
Control Tables - TEST: testctl
Control Tables - PS900: prstctl
The Control Tables are listed:
F0002
F00021
F0004
F0004D
F0005
F0005D
F0082
F00821
F00825
F00826
F0083
F0084
Versions Tables
The Object Owners of the Versions tables are:
Versions - PD900: PD900
Versions - PY900: PY900
Versions - DV900: DV900
Versions - PS900: PS900
The Versions tables are listed:
F983051
F98306
Central Objects
The Object Owners of the Central Objects tables are:
Central Objects - PD900: pd900
Central Objects - PY900: py900
Central Objects - DV900: dv900
Central Objects - PS900: PS900
The Central Objects tables are listed:
F980011
F980021
F983051
F98306
F98710
F98711
F98712
F98713
F98720
F98740
F98741
F98743
F98745
F98750
F98751
F98752
F98753
F98760
F98761
F98762
F98950
Business Data
The Object Owners of the Business Data tables are:
Business Data - PROD: proddta
Business Data - CRP: crpdta
Business Data - TEST: testdta
Business Data - PS900: prstdta
This section discusses how to:
Create a backup for IBM i.
Creating a backup for Oracle on UNIX or Windows.
Creating a backup for SQL Server.
Restoring a backup file for Oracle on UNIX or Windows.
Restoring a backup file for IBM i.
Restoring a backup file for SQL Server.
Before you complete the tasks in this section:
If you are using SQL Server or Oracle, verify that you have enough disk space for the backup copy before you begin the backup.
If you are using SQL Server, verify that the Select Into/Bulk Copy option on the Options form is turned on for the database into which you will transfer objects. Double-click the database in the tree structure to access the Options form.
To create a backup for IBM i:
On a tape drive, back up these libraries, depending on which path codes you have installed:
Library name | Description |
---|---|
SYS900 | System library |
SVM900 | Server Map |
OL900 | Object Librarian |
DD900 | Data Dictionary |
COPY900 | Central Objects - Prototype |
COPS900 | Central Objects - PS900 |
COPD900 | Central Objects - PROD |
CODV900 | Central Objects - DEV |
PRODDTA | Production Business Data |
PRODCTL | Production Control Tables |
CRPDTA | Prototype Business Data |
CRPCTL | Prototype Control Tables |
TESTDTA | Test Business Data |
TESTCTL | Test Control Tables |
PRSTDTA | Pristine Business Data |
PRSTCTL | Pristine Control Tables |
PY900DNT | Versions for CRP |
PD900DNT | Versions for PROD |
PS900DNT | Versions for PRST |
DV900DNT | Versions for DEV |
E900SYS | Server system library |
JDEOW | JD Edwards Installation |
PY900 | Server modules - Prototype |
PY900FA | Package Library - Prototype |
PS900 | Server modules - PS900 |
PS900FA | Package Library - PS900 |
PD900 | Server modules - PROD |
PD900FA | Package Library - PROD |
DV900 | Server modules - DEV |
DV900FA | Package Library - DEV |
Back up these IFS structure with the subdirectories:
Library name | Description |
---|---|
PSFT900 | Logging directory |
E900SYS | Kernel spec and XML |
PY900 | Spec files for Prototype |
PS900 | Spec files for PSFT |
PD900 | Spec files for PROD |
DV900 | Spec files for DEV |
JD Edwards | Contains the spec files for each path code.
\JDEdwards\PACKAGES\PY900FA\SPEC\*.* \JDEdwards\PACKAGES\PS900FA\SPEC\*.* \JDEdwards\PACKAGES\PD900FA\SPEC\*.* \JDEdwards\PACKAGES\DV900FA\SPEC\*.* |
To create a backup for Oracle on UNIX or Windows:
From the Oracle Enterprise Manager Tool, open Data Manager and from the Data menu, select Export.
Type the name for the export utility .dmp file.
Click the Browse button to select the directory where the .dmp file will reside.
Click Next.
On the Object Selection form, select the objects you want to back up, and then click Next.
Note:
Objects selected in the tree on the Data Manager form appear in the Selected Objects form. You can move objects between forms using the arrow buttons or by dragging and dropping.To export objects, expand the Available Objects tree and select the item to export. Use the arrows to move objects to and from the Selected Objects form.
On the Tuning form, select generate a log file, if needed.
Click Next.
Note:
Select the Generate Log File option and enter a log file name or use Browse to select a log file.On the Advanced Options form, take the default values or select the desired options, and click Next.
On the Summary form, verify that all of the chosen objects and options are correct.
Click Finish to begin exporting objects.
A message window opens that displays information about the progress of the export process.
When the export process is completed, you will receive these message: "Export terminated successfully without warnings."
If errors or warnings exist, check the log file to review the export process.
To create a backup for SQL Server:
From SQL Enterprise Manager, select Database/Object Transfer from the Tools menu.
On the Database/Object Transfer form, select a destination server and database on which to create backup copies of the tables.
Note:
The source server and the destination server can be the same, but the database must be different.Keep all default settings and then click the Start Transfer button.
The Database/Object Transfer tool moves the objects.
Perform either of these tasks to verify whether the backup was successful:
When the process completes the transfer, click the View Logs button to review the transfer process.
Run a SELECT statement to verify that the backup tables transferred to the new database with data.
To restore a backup file for Oracle on UNIX or Windows:
From the Oracle Enterprise Manager Tool, open Data Manager and from the Data menu, select Import.
Type the name of the import utility .dmp file.
Click Next.
On the Object Selection form, select the objects you want to restore and click Next.
The Importable Objects tree contains the objects that are importable in the file you specified. To move the object to the Selected Objects tree, select an object in the tree and click the down arrow.
Note:
When the .dmp file is on a remote machine, Data Manager uses the Console job and event system to retrieve the file before displaying the data through the Import Wizard. The Remote Import page of the Import Wizard has a status line at the top of the page that displays the progress of data retrieval. The Oracle Enterprise Manager Console must be running.Three conditions can be displayed: Job Submitted, Job Started, and Job Completed.
Note:
Data retrieval must complete successfully before beginning the import operation.The Selected Objects/Available Objects tree contains the objects to be imported. To remove an object from the list, select the object and use the up arrow or drag and drop.
Click Next.
On the Associated Objects form, accept the defaults and click Next.
On the Tuning form, you can generate a log file, if needed.
Click Next.
Note:
Select the Generate Log File options and enter a log file name or use Browse to select a log file.On the Advanced Options form, select the Increment Type. If you followed the instructions to create a backup, select None for Increment Type and click Next.
On the Summary form, verify that all selected objects and options are correct.
Note:
You must drop the existing objects in the database that you want to restore or the import process will fail.Click Finish to begin importing objects.
When the import process is completed, you will receive these message: "Process terminated successfully with no warnings."
If errors or warnings exist, check the log file to review the export process.
Perform a SELECT statement to verify that the backup tables are populated with data.
To restore a backup file for IBM i:
Restore the libraries and IFS directories that you backed up from tape.
To restore a backup file for SQL Server:
Verify that the Choose Into/Bulk Copy option on the Options form is turned on for the database into which you will transfer objects.
Double-click the database in the tree structure to access the Options form.
From SQL Enterprise Manager, select Database/Object Transfer from the Tools menu.
On the Database/Object Transfer form, select a destination server and database from which to transfer backup copies of the tables.
Note:
The source server and the destination server can be the same, but the database must be different.Deselect the Transfer All Objects option, but keep all of the other default settings.
Click the Choose Objects button, select the objects that you want to transfer, and then click OK to return to the Database/Object Transfer form.
Click the Start Transfer button.
The Database/Object Transfer tool moves the objects.
Perform either of these to verify whether the backup was successful:
When the process completes the transfer, click the View Logs button to review the transfer process.
Run a SELECT statement to verify that the backup tables transferred to the new database with data.
To restore a backup file for SQL Server on Windows:
Verify that the Select Into/Bulk Copy option on the Options form is turned on for the database into which you will transfer objects.
Double-click the database in the SQL Enterprise Manager tree structure to access the Options form.
Generate scripts for the tables you want to restore and then drop the tables.
Use SQL to recreate the scripts for the tables.
From the command line, type this command:
bcp [[database_name.]owner.] table_name(in|out) datafile /n /u /p /s
Perform a SELECT statement to verify that data populates the backup tables.