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!
[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
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:-
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
Subscribe to:
Posts (Atom)