Search This Blog

Thursday, July 27, 2017

Slide:- Session on VeeamONMY Forum - Top 15 Easy Performance Optimization


During VeeamON Malaysia Forum on 25 July 2017, I've presented about "Top 15 Easy Performance Optimization". Area covered on
-Backup Method Consideration
-Transport Mode Consideration
-Repository Consideration
-Proxy Affinity
-ReFS
-Hyper-V Consideration - Windows Server 2016 Hyper-V
-Vmware Consideration
-Offsite backup copy





Slide:- Session on VeeamONMY Forum - Veeam Availability Console


During VeeamON Malaysia Forum on 25 July 2017, i 've presented about "Veeam Availability Console" on five key area.




Thursday, July 20, 2017

Backup and Recover Oracle Database Using Veeam

In this post, we are going to show on how to backup oracle database & recover database using Veeam Explorer for Oracle.

[Pre-requisite]
Configure achieve log mode on oracle database before configure backup. Please refer to http://www.ms4u.info/2017/07/configure-oracle-archivelog-mode.html

[ Backup Configuration ]

On Guest Processing page,
1. tick "Enable Application aware processing"
2. On Guest OS Credential, enter local admin authentication

Click on Application button


On Oracle tab,
3. Enter Oracle account with SYSDBA credential (full right)
You can configure an additional setting on archived logs.
We set to backup log every 15 minutes for testing purpose.

Run backup and at the end, result will consists of:-
1. Virtual image backup
2. Transaction log backup


[ Recovery Configuration ]

Open Veeam Explorer for Oracle

 Before we start recovery, change setting to point to target server/staging server. Go to Top Left | Click Options

Enter target server
A - Target IP or Server Name
B - Enter local admin credential
C - Click browse to select Oracle Home.


If credential is correct, system will display result else you will get an error message " The Username or password is incorrect"




Here is the recovery process video:-


Enjoy!

Configure Oracle ArchiveLog Mode

In this post, we are going to configure archive log mode before backup Oracle database using Veeam Backup & Replication

Open SQL Command Line

Execute below command to configure archivelog mode


or use command prompt to access sqlplus
Type:
sqlplus / as sysdba
SQL > connect / as sysdba 

1. Connect to Oracle
connect / as sysdba

or type sqlplus / as sysdba

2. View database log mode
Select log_mode from v$database;

3. Shutdown the database before configure archivelog mode
Shutdown immediate

4. Startup the database in mount mode
startup mount

5. Set ArchiveLog mode
alter database archivelog;
alter database open;

6. View status. Should in Archivelog mode
Select log_mode from v$database;

End result:-

Saturday, July 1, 2017

Renewed : Microsoft Most Valuable Professional (2017-2018): Cloud & Data Center Management

Just got an email from Microsoft. Renewed for 8th year as MVP: Cloud & DataCenter Management.