Information stored in the database systems become more and more valuable day after day. Therefore, the role of the Database Administrator (DBA) become more and more critical. That is one of the main reasons the DBA, this means you, have to configure Oracle Database effectively and practice the backup and recovery process in order to be 100% sure to master it.
In this series, I will go with the DBA from the novice to expert. We will begin by configuring the Oracle Database 11g correctly, and then we will go through various scenarios of the backup and recovery of your Oracle Database. Finally, we will go through the necessary steps to configure an Oracle Data Guard environment, which will protect you if you completely lost your primary site and give you more ROI as well.
Now, letâ€™s go and configure our Oracle Database 11g; You are going to use Oracle Enterprise Manager as well as SQLPLUS to configure Oracle. You should not rely only on the GUI tools, you will need the command line one day, trust me on this.
I will assume you have installed Oracle Database 11g using the default options, and you have configured the Fast Recovery Area (Formerly, the Flash Recovery Area). The FRA will contain all your backups, and it is highly recommended to be used.
Configuring User Rights
To start using Oracle Enterprise Manager (OEM) to backup and recover your database, you need to configure a special OS user for the OEM that will be used as the Preferred Credentials, to have it done in Windows, follow the following steps:
- Go to Control Panel -> Administrative Tools.
- Run the Local Security Policy.
- Expand the Local Policies from the left and click the User Rights Assignment.
- At the right panel, search for the Logon as batch job and double click to open it.
- Add a user to this category; this user must be a local administrator to the machine where the Oracle Database 11g has been installed.
Go to your Database Console (OEM) via the link https://<machinename>:1158/em
- Figure 2: OEM Login Screen
Once you are logged on, you will get the following:
From the right upper corner, click the Preferences link. From the Preferences click the Preferred Credentials and then click the Set Credentials icon for the Database Instance. You need to fill the users as follows:
- UserName: For normal Database functions that do not require SYSDBA privilege. Use the SYSTEM user.
- Password: SYSTEMâ€™s password
- SYSDBA UserName: SYS user
- SYSDBA Password: SYSâ€™s password
- Host Username: The local administrator who has been added to the category â€œLogon as batch jobâ€ earlier
- Host Password: The password for the Host username above
Once you finish filling all the fields, click the Test button to have OEM test the entered values. If they are all correct, then click the Apply button to save your work.
Cool, OEM is now ready to backup and recover your Oracle Database. In the next lesson, we will discuss the different methods and options to back your Oracle Database, so be tuned till the next lesson.