TRAINER COBIT | CISA | CISM | CRISC | CCISO | CISSP | CDMP | CBAP | PMP | PRIMAVERA

Thursday, December 3, 2015

Training GIS di tanjung kalimantan selatan

December 03, 2015 arcgis trainer, bandung trainer, gis quantum, gis trainer freelance jakarta, map server, open layer, qgis trainer, training gis kalimantan No comments

Terima kasih kepada peserta dari Pamapersada nusantara dan edutrain jakarta atas undangan mengajar GIS - Geographic Information System di tanjung kalimantan selatan, semoga bermanfaat

Hery Purnama
GIS Freelance Trainer
081223344506

Ajax Jquery freelance trainer jakarta bandung surabaya

December 02, 2015 ajax jquery training, freelance trainer jquery, inhouse jquery, php jquery trainer No comments

Hery Purnama 081223344506 , freelance IT trainer jakarta bandung indonesia for training ajax jquery, for inquiry please contact :

Hery Purnama
Tel/ Whatsapp 081-223344-506
PinBB 7DC633AA

Ajax jquery, sencha extjs, laravel, codeigniter, excel macro, powerview dashboard, itil, pmbok, itpm, togaf, cobit, oracle, mysql dba

QGIS trainer freelance Jakarta , Bandung

November 30, 2015 freelance trainer, gis jakarta trainer, gis trainer No comments

HERY PURNAMA 081-223344-506 , freelance GIS trainer , QGIS trainer , ARCGIS trainer and GIS Programming with python

What is QGIS
QGIS is an official project of the Open Source Geospatial Foundation (OSGeo). It runs on Linux, Unix, Mac OSX, Windows and Android and supports numerous vector, raster, and database formats and functionalities.

For inquiry or further information please contact

HERY PURNAMA
MCDBA, PMP, ITILF, CISA
Inhouse IT Trainer

http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

PMBOK Freelance Certified Trainer

November 27, 2015 Freelance, pmbok trainer bandung No comments

HERY PURNAMA, 081223344506,Trainer for Project Management with PMBOK 5th Edition, PMP Exam Preparation Training

Please contact :

IT Risk Management Trainer Jakarta

November 27, 2015 it risk trainer, risk management trainer No comments

HERY PURNAMA, 081223344506 , Freelance Trainer for training Topic IT Risk Management (IT Risk Framework ISACA)

Training Location on Jakarta, Bandung, Yogya, Surabaya, Bali, Makasar, Balikpapan, Lampung, Medan, Indonesia, SIngapore, malaysia

for Inquiry please contact

Agile Project Management Trainer

November 27, 2015 agile project trainer, training No comments

HERY PURNAMA , 081223344506 , freelance trainer for training Project Management with AGILE Methodologies , this Agile Methodes is adopted from PMI

Agile Project Management Trainer Jakarta, Bandung, Bali, Makasar, Palembang, Balikpapan, Medan, Indonesia, Singapore, Malaysia

For Inquiry please contact :

Regards,

HERY PURNAMA
MCDBA, PMP, ITILF, CISA
Inhouse IT Trainer

http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Excel PowerView Trainer Jakarta, Bandung, Bogor, Makasar, Medan, Balikpapan, Banjarmasin, Indonesia

November 27, 2015 bandung trainer, cobit, excel macro trainer, excel trainer, ITIL, Jakarta, powerpivot training, powerview excel tutorial, powerview trainer jakarta, training No comments

Hery Purnama, 081223344506, Trainer for training Excel 2013 powerPivot and PowerView.

Membangun dashboard analisis dengan tampilan yang menarik serta sistem permodelan data dari beberapa sumber dapat terselesaikan dengan memanfaatkan fitur Excel PowerPivot dan PowerView.

Untuk undangan mengajar topik tersebut hubungi

HERY PURNAMA
MCDBA, CPMP, PMP, ITILF, CISA

Tel/WA : 081-223344-506
PinBB : 7DC633AA
www.inhousetrainer.net
http://freelance-it-trainer.blogspot.com
inhousetrainer@yahoo.com

Freelance IT Trainer :
EXCEL VBA MACRO, ITIL, COBIT, PRINCE2, TOGAF, PMBOK, PMO, ITPM, AUTOCAD, CATIA 3D, GOOGLE SKETCHUP, ORACLE, SQL SERVER, MYSQL DBA, MS.ACCESS, PHP, JQUERY, SENCHA EXTJS, ANDROID STUDIO, PHONEGAP/CORDOVA, ANGULARJS, SMS GATEWAY, GOOGLE MAP API, ASP/VB.NET, CODEIGNITER, YII, ZEND, LARAVEL, MAGENTO, SEO, JAVA, MS. PROJECT, PRIMAVERA P6, EXCEL POWERPIVOT/ POWERVIEW, etc.

Hometown : Bandung Jawa Barat

GIS Freelance Trainer Jakarta, Bandung

November 20, 2015 arcgis, freelance gis, google map gis, quantum, trainer bandung, trainer gis jakarta, trainer gis programming, trainer Qgis bandung, tutor qgis No comments

HERY PURNAMA , 081-223344-506 (GIS Trainer for training GIS using Quantum GIS - QGIS) , inquiry please contact :

http://inhousetrainer.net
http://freelance-it-trainer.blogspot.com

Hery Purnama 081.223344.506 , IT trainer , Excel / access VBA Macro, MS Project, Primavera, COBIT, ITIL, CISA, ITPM, PRINCE2, PMO, CATIA3D, PMBOK, PMP, AUTOCAD, GIS

PHP Ajax Jquery, Google Map API, Google Sketchup3D, Ubuntu, Sencha ExtJS, YII, Code Igniter,

Oracle, SQL Server,

Bandung, Jakarta, Bali, Medan, Surabaya, Yogya, Indonesia

Project Management , PMBOK trainer Jakarta

November 20, 2015 catia trainer autocad bandung, ms project, pmbok trainer, Project Management, training PMP No comments

HERY PURNAMA , 081223344506 freelance trainer for training PROJECT MANAGEMENT , IT PROJECT MANAGEMENT (ITPM), PROJECT MANAGEMENT OFFICE (PMO), PMBOK (PROJECT MANAGEMENT BODY OF KNOWLEDGE). PMP, MS.PROJECT, PRIMAVERA

FOR INQUIRY PLEASE CONTACT

HERY PURNAMA
MCDBA, CPMP, PMP, ITILF, CISA

Tel/WA : 081-223344-506
PinBB : 7DC633AA
www.inhousetrainer.net
http://freelance-it-trainer.blogspot.com
inhousetrainer@yahoo.com

Freelance IT Trainer :
EXCEL VBA MACRO, ITIL, COBIT, PRINCE2, TOGAF, PMBOK, PMO, ITPM, CISA, AUTOCAD, CATIA 3D, GOOGLE SKETCHUP, ORACLE, SQL SERVER, MYSQL DBA, MS.ACCESS, PHP, JQUERY, SENCHA EXTJS, ANDROID STUDIO, PHONEGAP/CORDOVA, ANGULARJS, SMS GATEWAY, GOOGLE MAP API, ASP/VB.NET, CODEIGNITER, YII, ZEND, LARAVEL, MAGENTO, SEO, JAVA, MS. PROJECT, PRIMAVERA P6, EXCEL POWERPIVOT/ POWERVIEW, etc.

Hometown : Bandung Jawa Barat

Trainer CISA di Jakarta, bandung, bali

November 18, 2015 cisa audit system trainer, freelance cisa trainer, professional auditor, trainer cisa di, training audit, training cisa No comments

HERY PURNAMA 081.223344.506 , freelance TRAINER for Certified Information System Audit CISA , for inqury please contact :

HERY PURNAMA
MCDBA, CPMP, ITILF, CISA

Tel/WA : 081-223344-506
PinBB : 7DC633AA
www.inhousetrainer.net
http://freelance-it-trainer.blogspot.com
inhousetrainer@yahoo.com

Freelance IT Trainer :
EXCEL VBA MACRO, ITIL, COBIT, PRINCE2, TOGAF, CISA, PMBOK, PMO, ITPM, CISA, AUTOCAD, CATIA 3D, GOOGLE SKETCHUP, ORACLE, SQL SERVER, MYSQL DBA, MS.ACCESS, PHP, JQUERY, SENCHA EXTJS, ANDROID STUDIO, PHONEGAP/CORDOVA, ANGULARJS, SMS GATEWAY, GOOGLE MAP API, ASP/VB.NET, CODEIGNITER, YII, ZEND, LARAVEL, MAGENTO, SEO, JAVA, MS. PROJECT, PRIMAVERA P6, EXCEL POWERPIVOT/ POWERVIEW, etc.

Hometown : Bandung Jawa Barat

Prosedur Mengundang Freelance IT Trainer

November 11, 2015 bali, bandunh, corporate trainer, freelance trainer, inhousetrainer, Jakarta, prosedur mengundang hery, prosedur trainer, trainer it inquiry, undang trainer, undangan mengajar, undangan trainer No comments

Prosedur mengundang certified trainer Hery Purnama untuk kegiatan inhouse training di perusahaan atau training center di seluruh wilayah indonesia, malaysia, singapore dengan topik : Excel Vba Macro, Excel powerpivot, powerview, cobit, itil, pmbok, pmo, itpm, togaf, prince2, ms. Project, Primavera, mysql dba, oracle dba, sql server dba, sencha extjs, sencha touch, google sketchup, autocad 2d/3d, catia 3d, angularjs, jquery, phonegap, cordova, android studio, java, asp.net, vb.net, magento, wordpress, SEO internet marketing, java web, ethical hacker, ubuntu server, ms. Access, sms gateway, google map api. Dan topik IT lainnya

1) Pengiriman penawaran dan silabus materi
2) Kesepakatan mengenai waktu, biaya, fasilitas dan akomodasi
3) Tanda tangan Kontrak kerja atau SPK yang diterbitkan pengundang dengan mencantumkan hal hal yang disepakati di point 2
4) Invoice sesuai termin yang disepakati pada point 2
5)Pelaksanaan training

Demikian dan terima kasih

HERY PURNAMA
MCDBA, CPMP, ITILF

Tel/WA : 081-223344-506
PinBB : 7DC633AA
www.inhousetrainer.net
inhousetrainer@yahoo.com

Google Map API freelance trainer Jakarta

November 11, 2015 android google map trainer, freelance google toolkit trainer, google map trainer jakarta, nearby geofence map No comments

Hery Purnama, 081.223344.506, Google Map API freelance trainer , corporate trainer for training google map api for web application or mobile application development - android

Combined with PHP ajax, cordova, jquery mobile

For inquiry please contact :

HERY PURNAMA
MCDBA, CPMP, ITILF

Tel/WA : 081-223344-506
PinBB : 7DC633AA
www.inhousetrainer.net
inhousetrainer@yahoo.com

Sencha touch freelance trainer jakarta

November 10, 2015 ahlinya, extjs mvc trainer, freelance sencha touch, Sencha ExtJS, sencha trainer jakarta, the best trainer No comments

Hery Purnama - 081223344506 is sancha touch and sencha extjs freelance trainer

For inquiry please contact :

HERY PURNAMA
MCDBA, CPMP, ITILF

Tel/WA : 081-223344-506
PinBB : 7DC633AA
www.inhousetrainer.net
inhousetrainer@yahoo.com

Android apps development with AngularJS and phonegap/ cordova

November 10, 2015 ahlinya, angularjs trainer jakarta, cordova trainer bandung, freelance trainer android, the best trainer No comments

Hery Purnama, 081223344506, Trainer AngularJs, android trainer, Trainer for training android apps development with cordova

Jakarta, bandung, medan, surabaya, balikpapan, bali inhouse training

HERY PURNAMA
MCDBA, CPMP, ITILF

Tel/WA : 081-223344-506
PinBB : 7DC633AA
www.inhousetrainer.net
inhousetrainer@yahoo.com

Trainer Excel vba macro indonesia

November 10, 2015 ahlinya, macro trainer jakarta, the best trainer, trainer excel vba macro, trainer terbaik No comments

Hery Purnama 081223344506 , Freelance Excel vba macro trainer jakarta , bandung, bali, makasar, balikpapan, medan

Trainer for training Hacking Web Application - Ethical Hacker, Jakarta, bandung

November 07, 2015 ethical hacker bandung, freelance trainer, training hacker jakarta, web hacking tutorial No comments

Hery Purnama 081223344506 , trainer for Hacking Exposed Web Application - Ethical Hacker, for inquiry please contact

HERY PURNAMA
MCDBA, CPMP, ITILF
Inhouse IT Trainer
http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA : 081.223344.506 , 022.91299407 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Office :
Graha Rifai , Jl. Pelajar Pejuang 45 No.23 Lt.2
Bandung - Jawa Barat

IIS HTTP Error 404.3-Not Found

November 07, 2015 iis 4043 error, iis error No comments

HTTP Error 404.3-Not Found

The page you are requesting cannot be served because of the extension configuration. If the page is script, add a handler. If the file should be downloaded, add a MIME map.

solution :

You should install IIS sub components from

Control Panel -> Programs and Features -> Turn Windows features on or off

Internet Information Services has subsection World Wide Web Services / Application Development Features

There you must check ASP.NET (.NET Extensibility, ISAPI Extensions, ISAPI Filters will be selected automatically). Double check that specific versions are checked. Under Windows Server 2012 R2, these options are split into 4 & 4.5.

Run from cmd:

%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -ir

Finally check in IIS manager, that your application uses application pool with .NET framework version v4.0.

By

HERY PURNAMA
MCDBA, CPMP, ITILF
Inhouse IT Trainer
http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA : 081.223344.506 , 022.91299407 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Bandung - Jawa Barat

Inhouse Training Topics Inquiry

November 04, 2015 catia trainer autocad bandung, cobit trainer, excel trainer jakarta, it trainer jakarta, it training, itil trainer jakarta No comments

IT Concept :

ITIL Foundation V.3/2011

COBIT 5 Foundation

Project Management Body of Knowledge (PMBOK) V.5

Project Management Office (PMO)

TOGAF 9.1

RDBMS Concept

Project Tools :

Project Management and Methodology with MS. Project

Project Management and Methodology with Primavera P6

Database :

Microsoft Access Database Application Development

Microsoft Access VBA Macro Programming

MySQL Database Administration

Oracle Database Administration

SQL Server Database Administration

Application Development :

Android Application Development with PHP and Phonegap/ Cordova

Android Application Development with Android

Web Application Development with ASP.NET

Desktop Application Development with VB.Net

Web Application Development with PHP and Sencha ExtJS

Web Application Development with PHP and Ajax Jquery

Web Application Development with Yii PHP Framework

Web Application Development with Codeigniter PHP Framework

Web Application Development with Laravel PHP Framework

Microsoft Excel :

Microsoft Excel Advanced for Business Accounnting & Management

Microsoft Excel VBA Macro Programming

Microsoft Excel Dashboard Data Analysis with PowerPivot and PowerView

CAD Tools :

Autocad 2D/3D/ MEP

Catia 3D V5/6

Google Sketchup 3D

API Tool :

Integrated Map Website with PHP and Google Map API V.3

Event Scheduler system with PHP and SMS Gateway

Twitter and Facebook Developer Toolbox

For detail / Inquiry please contact

HERY PURNAMA

MCDBA, CPMP, ITILF

Freelance IT Trainer

Tel/ WA : 081.223344.506

pinBB : 7DC633AA

www.inhousetrainer.net

inhousetrainer@yahoo.com

http://freelance-it-trainer.blogspot.com

Training Excel Basic to Advanced by Hery Purnama

November 02, 2015 excel advanced trainer No comments

Microsoft Excel adalah software spreedsheet yang sangat populer di dunia, hampir semua bidang pekerjaan menyadari betapa pentingnya penggunaan Excel untuk pengolahan data dan mempercepat proses bisnis serta efektifitas pekerjaan.

Namun sejauh manakah Anda bisa memaksimalkan kinerja Excel ? , Saya akan membongkar rahasia memanfaatkan microsoft Excel hingga nantinya anda akan sadari bahwa selama ini semua kebutuhan Anda bisa terjawab dengan Microsoft. Apa saja yang akan saya bahas ? basic penggunaan Excel, teknik formula tingkat lanjut dengan function Nested (IF, Vlookup), ARRAY, OFFSET, DSUM, RANK, MATCH, INDEX, PV, FV, dan lainnya, lalu anda juga akan belajar fitur TABLE, CONDITIONAL Formating, DATA VALIDATION, GOAL SEEK, SUBTOTALS,PIVOT Table, Pivot Chart, EXCEL PROTECTION. Tingkat lanjutnya anda akan mengenal cara membuat DASHBOARD di Excel 2013 dan Data Analysis Business Intelegence dengan fitur POWER PIVOT dan POWER VIEW. Lalu terakhir anda akan mengenal penggunaan VBA macro programming

Luar biasa, dalam 4 hari x 7 jam Anda akan mengetahui betapa hebatnya Microsoft Excel

Untuk undangan mengajar topik diatas, hubungi saya :

HERY PURNAMA
MCDBA, CPMP, ITILF
Inhouse IT Trainer
http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA : 081.223344.506 , 022.91299407 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Hometown - Bandung

MS. Project / Primavera trainer in bandung

October 31, 2015 ms project class, trainer pmp jakarta, trainer training ms project, trainer training primavera No comments

Hery Purnama 081223344506, is trainer of Project Management with MS. Project or Primavera P6, methodology and project management

Contact :

Hery Purnama
MCDBA, CPMP, ITILF
Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com

Hometown : Bandung

Noor Hotel Bandung Boutique Hotel

October 31, 2015 alamat noor hotel, booking noor hotel, boutique hotel bagus di bandung, harga noor hotel bandung, hotel di jl riau bandung, layanan noor hotel bandung, meeting hotel noor bandung, noor hotel bandung No comments

Noor Hotel Bandung , prestisius boutique hotel in bandung, Jl. Madura no.06 Bandung.

www.noorhotels.com

The Classy Islamic Boutique Hotel with Green Concept, beautifully designed rooms, friendly service and attentive to every detail are some of the benefits of The Noor Bandung.

Located at the intersection of business and commercial district, in the heart of Bandung, The Noor Bandung is near to popular shopping centres especially famous factory outlets in Riau Road area, the heaven for shopaholics, restaurants and other entertainment places, Taking five minutes on foot from the hotel, there is a famous Mosque, Istiqomah and it only takes 15 minutes driving from the Hussein Sastranegara International Airport to the hotel.

Review by

Hery Purnama
MCDBA, CPMP, ITILF
Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com

Hometown : Bandung

Android Studio Freelance trainer Jakarta

October 30, 2015 android studio freelance trainer, android trainer, application development android studio, training android studio No comments

Hery Purnama is trainer for training " Android Application Development with Android Studio ", for inquiry please contact

HERY PURNAMA
MCDBA, CPMP, ITILF
Inhouse IT Trainer
http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA : 081.223344.506 , 022.91299407 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Hometown : Bandung

Freelance Python Trainer di Jakarta, Bandung, Bali

October 30, 2015 freelance python trainer bandung No comments

Hery Purnama, 081223344506 is freelance trainer for training "Programming with Python ", inquiry please contact

HERY PURNAMA
MCDBA, CPMP, ITILF
Inhouse PythonTrainer
http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA : 081.223344.506 , 022.91299407 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Freelance Java Trainer

October 30, 2015 freelance jakarta, java trainer No comments

Hery Purnama, 081223344506, Freelance Java Web/ Java Mobile Trainer in Jakarta, Bandung, Indonesia,
For inquiry for inhouse training, please contact :

HERY PURNAMA
MCDBA, CPMP, ITILF
Inhouse Java Trainer
http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA : 081.223344.506 , 022.91299407 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Freelance Trainer C++ di Jakarta, Bandung

October 30, 2015 bandung trainer, c++ freelance trainer, jakarta c++ training No comments

Hery Purnama 081223344506, is freelance IT Trainer for programming with C++ , Inquiry please

contact

HERY PURNAMA
MCDBA, CPMP, ITILF
C++ Trainer
http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA : 081.223344.506 , 022.91299407 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Mysql DBA freelance Trainer Bandung

October 29, 2015 backup recovery mysql, database mysql, dba trainer jakarta, mysql dba trainer, mysql tuning tutorial No comments

Hery Purnama, 081223344506, MySql DBA trainer , topics, mysql server configuration, mysql backup recovery, mysql performance tuning, mysql clustering

for detail syllabuss and inquiry please contact

Hery Purnama
MCDBA, CPMP, ITILF

Freelance IT Trainer

Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com

Hometown : Bandung

Training Oracle DBA di Bandung

October 29, 2015 freelance oracle trainer, ocp trainer, trainer dba, training oracle dba No comments

Terima kasih kepada peserta dari PT. PJB service surabaya yang telah mengikuti pelatihan Oracle 11g Administration workshop I di sisindotek bandung, semoga bermanfaat

Regards,

Hery Purnama

MCDBA, CPMP, ITILF

Oracle DBA freelance trainer

Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com

Hometown : Bandung

Project Management based on Prince2 , jakarta bandung trainer

October 29, 2015 trainer freelance, trainer prince2 jakarta, training project prince No comments

PRINCE2 trainer, Project Management training Jakarta , bandung, bogor, bekasi, karawang, makasar, yogya, surabaya, balikpapan

Contact

HERY PURNAMA
Inhouse IT Trainer
Call/sms/WA :
081.223344.506 , 022.91299407
PinBB : 7DC633AA
Email/YM : info@inhousetrainer.net / inhousetrainer@yahoo.com
http://www.inhousetrainer.net
facebook.com/inhousetrainer
twitter.com/inhousetrainer

Office : Bandung

Tutorial Backup Recovery Oracle 11g , Enterprise Manager

October 28, 2015 backup and restore, cara backup oracle, oracle 11 tutorial backup, oracle backup recovery, oracle dba tutorial, petunjuk backup di oracle, tips oracle, trainer oracle jakarta, tutorial oracle No comments

Berikut yang perlu anda lakukan untuk melakukan backup restore, recovery di Oracle 11g menggunakan Enterprise Manager dimana meliputi konfigurasi (Flash Recovery Area + Mode Archive, Recovery Setting, Backup Setting), silahkan Anda praktekkan

Flash Recovery Area dan mode ARCHIVELOG

Flash Recovery area dibutuhkan saat anda melakukan proses backup recovery untuk mode archivelog. Flash recovery area juga dikenal dengan istilah fast recovery area

Lokasi Flash Recovery Area seharusnya tidak berada satu tempat dengan database working area

Berikut konfigurasi flash/fast recovery area dan Archivelog Mode

1. Melalui Command prompt perbesar size dari backup and recovery area, dengan perintah

sqlplus system/<password>

alter system set db_recovery_file_dest_size=8G scope=both;

exit

2. Buat folder flash_recovery_area melalui command prompt, contoh:

C:\> set ORACLE_BASE=d:\app\administrator\

cd $ORACLE_BASE

mkdir flash_recovery_area

3. Log in ke Enterprise Manager Database Console melalui browser , gunakan username SYS SYSDBA. Click Login.

4. Click Availability setelah login web

5. Pilih Recovery Settings di Backup/Recovery Settings section.

6. Recovery Setting Page muncul dan perhatikan settingan yang tertera

Flash Recovery Area Location: d:\app\administrator\flash_recovery_area
Flash Recovery Area Size: 8 GB

7. Scroll ke atas . Check ARCHIVELOG Mode untuk mengubah ke mode Archivelog. Click Apply.

8. Untuk verifikasi isikan user dan password windows (OS) login Anda. Click Continue.

9. Sebuah pesan akan muncul, untuk menyelesaikan perubahan mode maka anda perlu shutdown database, Click Yes untuk shut down instance dan melakukan restart.

10. Untuk restart database anda akan diminta isikan user dan password windows dan database anda . Click OK.

11. Restart Database:Confirmation page akan muncul. Click Yes untuk shut down instance dan melakukan kembali restart.

12. Halaman restart database kembali muncul. Click Refresh untuk login ke Enterprise Manager Database Control dan login kembali ke Enterprise Manager begitu database telah selesai restart.

Backup Settings and Policy

Anda dapat mensetting backup dan beberapa policy terkait lokasi backup, bagaimana proses backup, waktu melakukan backup dan lainnya.

1.	Click Availability di home page.
2.	Pilih Backup Settings dibagian Backup/Recovery Setup section.
3.	Scroll ke the Host Credentials di halaman Backup Settings. Isikan operating system username dan password. Scroll ke atas ke bagian Disk Settings.
4.	Biarkan nilai tetap 1 di Parallelism field. Disk Backup Location field biarkan tetap null agar menggunakan settingan flash recovery area untuk backup. Pilih Backup Set untuk Disk Backup Type. Click Test Disk Backup.
5.	Sebuah pesan sukses akan muncul apabila proses test disk backup berhasil. Selanjutnya anda akan configure backup policy settings. Click Policy to access the Policy page.
6.	Pilih Automatically backup the control file and server parameter file (SPFILE) with every backup and database structural change. Pilih Optimize the whole database backup by skipping unchanged files such as read-only and offline datafiles that have been backed up. Pilih Enable block change tracking for faster incremental backups. Isikan nama file Block Change Tracking file. Lalu scroll kebawah kebagian Retention Policy section.
7.	Pilih Retain backups that are necessary for a recovery to any time within the specified number of days (point-in-time recovery) biarkan saja nilai hari tetap 31 days. Di bagian Archivelog Deletion Policy, Pilih Delete archivelogs after it has specified number of backups dan biarkan nilai tetap terisi "1 backup". Click OK. Anda akan diarahkan kembali ke halaman availability.

DBID dan DB_UNIQUE_NAME

Jika anda kehilangan control file atau SPFILE, Enterprise Manager dapat mengembalikannya dari backup sepanjang anda masih mengetahui DB_UNIQUE_NAME dan DBID database anda, silahkan ingat atau catat informasi DB_UNIQUE_NAME dan DBID anda terlebih dahulu

Untuk mengetahuinya lakukan tahapan berikut

Click Server tab. Click Initialization Parameters di Database Configuration region.

The Current property page muncul. Ketik db_unique_name dibagian Name field dan click Go.

Baris record akan muncul db_unique_name di kolom Name, dan nilai db_unique_name akan terlihat silahkan catat/ ingat

Click Database Instance link untuk kembali ke Server page.

Untuk mengecek nilai DBID:

Click Control Files di Storage region pada halaman Server.

Pada halaman control file yang muncul . Pilih Advanced property link.

Database ID field berisi nilai DBID akan muncul. (Note: Nilai berbeda untuk setiap mesin, silahkan catat juga).

Click the Database Instance link untuk kembali ke halaman server

Whole Database Backup

Keseluruhan content database mencakup datafile, redolog file, control file, parameter file dapat anda backup dengan menggunakan "Whole Database Backup"

1.	Click Availability tab. Pilih Schedule Backup dibagian Manage.
2.	Halaman Schedule Backup page akan muncul. Di bagian Customized Backup, Pilih Whole Database. Isikan username dan password di bagian host credential. Click Schedule Customized Backup.
3.	Halaman Schedule Customized Backup: Options akan muncul . Pilih Full Backup di bagian Backup Type. Pilih Online Backup di bagian Backup Mode. Pilih Also back up all archived logs on disk dibagian Advanced. Click Next.
4.	Halaman Schedule Backup: Settings akan muncul . Pilih Disk or Tape sesuai yang telah anda tentukan sebelumnya. Click Next.
5.	Halaman Schedule Backup: Schedule page akan muncul . biarkan saja nilai default Job Name. Pilih One Time (Immediately) untuk menjalankan backup job immediately atau isikan waktu eksekusi yang anda rencanakan , Click Next.
6.	Halaman Schedule Backup: Review akan muncul. Click Submit Job.
7.	Backup Submit Successful message akan muncul . Click View Job untuk lihat status dari backup.
8.	Scroll ke bagian bawah halaman. Didalam table anda akan melihat status dari setiap proses backup can view the status of the backup akan success apabila setiap fase selesai. Perlu diketahui bahwa proses ini akan memakan waktu . Lakukan Refresh halaman browser untuk melihat progress Job . Sebelum melanjutkan tahap berikutnya pastikan (Prebackup, Backup, and Post Backup) telaj selesai (successful). Click Database tab untuk kembali ke Database Home page.

Restore dan Recovery dengan "Whole Database"

Pada bagian ini anda akan belajar by using melakukan recovery dengan enterprise Manager.

1.	Pilih Perform Recovery di bagian Manage dari halaman Availability.
2.	Halaman Perform Recovery akan appears. Di bagian bawah Recovery Scope, pilih Whole Database. Pilih Recover to the current time or a previous point-in-time. Isikan user dan password OS anda di bagian Host Credentials. Click Recover.
3.	Pada halaman Confirmation yang muncul berisi indikasi bahwa instance akan di shut down dan di restart. Click Yes untuk lanjutkan.
4.	Halaman Recovery Wizard yang muncul yang mengindikasikan instance akan di shut down dan restart (Note: Anda harus menunggu beberapa menit untuk proses ini sampai complete). Click Refresh untuk lanjutkan tahap Recovery Wizard.
5.	Selanjutnya halaman Database Instance akan menampilkan database dalam kondisi Mounted state. Click Perform Recovery.
6.	Enter user dan password OS host credentials and click Continue.
7.	Database Login window yang muncul .isi informasi Login database dengan user sys as sysdba
8.	Halaman Perform Recovery akan muncul.Pada bagian pilihan Recovery Scope pilih Whole Database dan click Recover kembali untuk mengulang tahapan Recovery wizard.
9.	Halaman Perform Whole Database Recovery: Point-in-time akan terlihat. Pilih Recover to the current time. Click Next.
10.	Halaman Perform Whole Database Recovery: Rename akan terlihat. Pilih No. Restore the files to the default location atau Yes. Jika anda ingin file restore ditempatkan di lokasi lain. Click Next.
11.	Halaman Perform Whole Database Recovery: Review akan terlihat. Review informasi akan munculu dan click Submit.
12.	Halaman Processing: Perform Whole Database Recovery akan muncul.
13.	Lalu anda akan menerima konfirmasi bahwa aktifitas recovery sudah sukses. Click Open Database.
14.	Click OK.
15.	Isikan informasi login seperti yang sering anda lakukan . Click Login. Selanjutnya anda akan masuk kembali ke halaman Availability. Proses recovery selesai Selamat mencoba, semoga bermanfaat Penulis, Hery Purnama Freelance Oracle DBA Trainer www.inhousetrainer.net http://freelance-it-trainer.blogspot.co Call/WA/SMS : 081.223344.506 PinBB : 7DC633AA Email/YM : inhousetrainer@yahoo.com

Thursday, December 3, 2015

Wednesday, December 2, 2015

Monday, November 30, 2015

Friday, November 27, 2015

Friday, November 20, 2015

Wednesday, November 18, 2015

Wednesday, November 11, 2015

Tuesday, November 10, 2015

Saturday, November 7, 2015

Wednesday, November 4, 2015

Monday, November 2, 2015

Saturday, October 31, 2015

Friday, October 30, 2015

Thursday, October 29, 2015

Wednesday, October 28, 2015

Social Profiles

Specific Search

Total Pageviews

Blog Archive

Tags

Blog Archive

Tags

Popular Posts

Pages

Featured Post

Links