OEM 13c - Schedule RMAN Backup using OEM13c Console

 

Scenario Preview : We are scheduling rman automated backup on regular basis using OEM13c . Remmebr expdp backup is not scheduled using OEM console 

Database name : OEMDB

Rman  Backup location : /u01/rmanbkp

Operating System : OEL 7.7 

1. Go to database console then select schecduled backup database in our case it is OEMDB. In coming blog we going to schedule backup using recovery catalog option so in all target database repository detailed stored on it. In our production console we have done the same as using recovery catalog.  

Availability  > Backup & Recovery > Schedule Backup >  

2.  Select Schedule Customized Backup  select  options in our case we select Whole Database 

3. Select Backup type | Backup mode | Advanced option    

                                    

4. Select Disk or Tape option 

5.  Set Jobs scheduling options describes on screenshots

6. We can customized  rman backup script  as well. on RMAN script window TEXT Box.

7. After Submitting  job we can check on Job Activity 

8.  After execution of job we can check Job is  successful or failed status we can check on job activity

 

9. We can check job report as well as job backup logs.

Availability  > Backup & Recovery >  Backup Report >  

OEM12-13c-examples

OEM 13c : Oracle Enterprise manager Installation 13c on linux 64 bit OS.

OEM13c - Add agents on remote target host server 

EM13c - OMR Database minimum recommended parameters

OEM : Add OEM 12c express edition console on database

OEM 13c - Schedule RMAN Backup using OEM13c Console

OEM 13c - Oracle Management Server and agent commands

OEM12c - Physical Standby sync status

OEM13c - Add agents on remote target host server

Here we add monitoring on OMR database and after that add host on target database server and add monitoring on it using EM 13c Console .

OMR database and OEM 13c are in same server so agent already installed at the time of installation so we add monitoring on server.

1. Add Discovery target on OMR database
2. Add OEM agent on target host and add discovery target 

OMR Database : OEMDB

Hostname : oem13c.example.com

New Target host name : srv3.example.com

Target Database : SMRCDB

OEM Console URL : 

 Enterprise Manager Cloud Control URL: https://oem13c.example.com:7803/em also ( https://192.168.56.71:7803/em)

 Admin Server URL: https://oem13c.example.com:7102/console

BI Publisher URL: https://oem13c.example.com:9803/xmlpserver/servlet/home

STEP 1 : Login OEM console and go to setting and add target manually 

STEP 2 : choose 2nd option (Add Non-Host Targets Using Guided Process )

STEP 3 : As default oracle database and listener automatically set on discovery target types.

STEP 4: Target already installed so we select OMR database server oem13c.example.com

STEP 5: OEM will discover host at there end .

 

STEP 6 : Select on checkbox OEMDB database and add password of dbsnmp schema. By default it is locked.

SQL> alter user dbsnmp account unlock identified by dbsnmp;

User altered.

SQL> select USERNAME,DEFAULT_TABLESPACE,ACCOUNT_STATUS from dba_users where username='DBSNMP';

USERNAME                                 DEFAULT_TABLESPACE             ACCOUNT_STATUS

---------------------------------------- ------------------------------ --------------------------------

DBSNMP                                   SYSAUX                         OPEN

 

STEP 7 :  Discovery Target Review

STEP 8 : Target confirmation 

 

STEP 9 :  OEMDB  database and listener Successfully on console. 

Adding OEM Agent on target server  and discover target for monitoring

OS NAME : srv3.example.com

STEP 1: Select add host targets

STEP 2 : Add host targets.

 

STEP 3 : Add named credential of oracle user and then  root (optional) user .

STEP 4 : Add  agent base directory /u01/app/oracle/agents . Instance directory will be automatically created.

Default port is 3872.

STEP 5 : Review Agent target hosts

STEP 6: Deploy agent Summary process 

STEP 7: Agent successfully added on target server.

Add Discovery target on srv3.example.com agent

STEP 1: Choose 2nd option ( Add using guided process  and then further select default oracle database and listener option)

STEP 2 : Add host target details.

STEP 3: Add password dbsnmp user on database discovery results in this server we have CDB database so details will automatically fetch by discovery.

STEP 4: Database discovery review

STEP 5: Configuration of  database and listener target saved successfully.

STEP 6 : Successfully done 

STEP 7: OEM 13c Console Summary dashboard