My first stage of preparation needs to be planned. I will be concentrating on parts of the Database, RMAN, EM and Network Configuration exam topic during the build of the
Database, RMAN, EM and Network Configuration
Configure server-side network
Since the database on the
gridctrl server is a stand-alone instance, the server-side network is very basic. The real challenge comes when I move to a two (2) node RAC with Data Guard.
Configure client-side network
Again, the real challenge of a client-side network comes when I move to a two (2) node RAC with Data Guard.
Create and Manage encrypted tablespaces
Encrypted tablespaces are not part of this phase of planning.
Create and Manage a tablespace that uses NFS mounted file system file
Tablespaces on NFS are not part of this phase of planning.
Set up ADR file based repository
ADR file based repository will be set up as part of all database installations.
Perform cold database backup
After the database is set up, I will do a cold backup using RMAN (and a restoration using RMAN).
Manage user accounts and use case sensitive passwords
Case sensitive passwords will be set up as part of all database installations.
Use OPatch to install a patch
To install the Oracle RDBMS 188.8.131.52 software, I will have to use OPatch on Oracle RDBMS 184.108.40.206.
Install and configure EM Agent
Installing and configuring the EM Agent will be done as part of all database installations.
Create Base Recovery Catalog
The Base Recovery Catalog will be on the
RMAN configuration will be done as part of all database installations.
Perform multisection backup of a datafile
I will leave multisection backup of a datafile until I build the main RAC database.
Create an Archival Backup
I will create an archival backup of all databases (and doing a complete recovery using the archival backup).
General Plan for GRIDCTRL
- Install Oracle RDBMS 220.127.116.11 software
- Use OPatch to upgrade to Oracle RDBM 18.104.22.168 software
- Create a database called
REPOSfor the Infrastructure Repository Databases that will contain the OEM Grid Control repository and Base Recovery Catalog as per the recommendation from the Oracle® Database Licensing Information 11g Release 1 (11.1).
REPOSdatabase will use case-sensitive passwords.
- Install the OEM Grid Control Server 10.2.0.5 on
gridctrl. This should automatically install the agent as well. The repository will be in
- Create a RMAN base recovery catalog in the
- Perform a cold backup of the
- Restore the
REPOSdatabase from the cold backup.
- Perform an archival backup of the
- Recover the
REPOSdatabase from the archival backup.