Hery Purnama 081223344506, is trainer of Project Management with MS. Project or Primavera P6, methodology and project management Contact : |
Hery Purnama 081.223344.506 - Certified Trainer , DMBOK, PMBOK, ITIL, COBIT, QGIS, Postgresql, MS Project, Bigdata Hadoop, Oracle DBA, SQL Server, Excel VBA Macro, MySQL, CISSP, CISA, CISM, CDPSE, VBA, Primavera P6, Microsoft R , BABOK, Yii, CodeIgniter. POWER BI, CRISC, ISTQB , IBM COGNOS, UML TOGAF, Certified Trainer For Inquiry : Call/SMS/WA : 081.223344.506
INHOUSE TRAINING VBA MACRO PROGRAMMING
INHOUSE TRAINING I.S GOVERNANCE
PUBLIC TRAINING MAGENTO ADVANCED
PUBLIC TRAINING PMP PMBOK EXAM PREPARATION
INHOUSE TRAINING CYBERSECURITY AWARENESS PROGRAM
Hery Purnama 081223344506, is trainer of Project Management with MS. Project or Primavera P6, methodology and project management Contact : |
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, 081223344506, MySql DBA trainer , topics, mysql server configuration, mysql backup recovery, mysql performance tuning, mysql clustering for detail syllabuss and inquiry please contact
Freelance IT Trainer
|
Terima kasih kepada peserta dari PT. PJB service surabaya yang telah mengikuti pelatihan Oracle 11g Administration workshop I di sisindotek bandung, semoga bermanfaat Regards, MCDBA, CPMP, ITILF Oracle DBA freelance trainer Tel/WA : 081.223344.506 |
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
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.
|
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.
|
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
1. | Click Server tab. Click Initialization Parameters di Database Configuration region.
|
2. | The Current property page muncul. Ketik db_unique_name dibagian Name field dan click Go.
|
3. | 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:
1. | Click Control Files di Storage region pada halaman Server.
|
2. | Pada halaman control file yang muncul . Pilih Advanced property link.
|
3. | 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
|
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 http://freelance-it-trainer.blogspot.co Call/WA/SMS : 081.223344.506
|
C:\>set ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_sisindotek
C:\>set PATH=%ORACLE_HOME%\bin;%PATH%
C:\>set ORACLE_SID=MYORA
Tahap 2 BUAT DIREKTORI YANG DIBUTUHKAN
C:\>mkdir
C:\app\Administrator\
db\myora\admin\adump
C:\>mkdir
C:\app\Administrator\
db\myora\
admin\dpdump
C:\>mkdir
C:\app\Administrator\
db\myora\
admin\pfile
C:\>mkdir
C:\app\Administrator\
db\myora\
diag
C:\>mkdir
C:\app\Administrator\
db\myora\
flash_recovery_area
C:\app\Administrator\
db\myora\
oradata
Tahap 3 BUAT PARAMETER FILE
berikan nama initmyora.ora dan simpan di folder {ORACLE_HOME}\database\
db_name='MYORA'
db_block_size=8192
memory_target=500m
processes=100
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
compatible ='11.1.0'
audit_trail ='db'
db_recovery_file_dest_size=5g
db_recovery_file_dest='C:\app\Administrator\db\myora\flash_recovery_area'
audit_file_dest='C:\app\Administrator\db\myora\admin\adump'
diagnostic_dest='C:\app\Administrator\db\myora\diag'
control_files = ('C:\app\Administrator\db\myora\oradata\control1.ctl', 'C:\app\Administrator\db\myora
\oradata\control2.ctl', 'C:\app\Administrator\db\myora\oradata\control3.ct
Tahap 4 BUAT WINDOW SERVICE
C:\>oradim -NEW -SID myora -STARTMODE manual
Instance created.
C:\>sc query oracleservicemyora
SERVICE_NAME: oracleservicemyora
TYPE : 10 WIN32_OWN_PROCESS
STATE : 4 RUNNING
(STOPPABLE,PAUSABLE,ACCEPTS_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0
C:\>sqlplus
SQL*Plus: Release 11.1.0.1.0 Production
on
Wed May 23 07:39:54 2012
Copyright (c) 1982, 2010, Oracle.
All
rights reserved.
Enter
user
-
name
: /
as
sysdba
Connected
to
an idle instance.
SQL>
create
spfile
from
pfile;
File created.
SQL> startup nomount
ORACLE instance started.
Total System
Global
Area 523108352 bytes
Fixed
Size
1375704 bytes
Variable
Size
314573352 bytes
Database
Buffers 201326592 bytes
Redo Buffers 5832704 bytes
Tahap 7 - BUAT DATABASE
gunakan script berikut
CREATE
DATABASE
MYORA
USER
sys IDENTIFIED
BY
sys
USER
system IDENTIFIED
BY
system
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 200
MAXINSTANCES 1
MAXLOGHISTORY 500
LOGFILE
GROUP
1 (
'
C:\app\Administrator\
db\myora\
oradata\redo01a.rdo'
,
'
C:\app\Administrator\
db\myora\
oradata\
redo01b.rdo'
)
SIZE
50M,
GROUP
2 (
'
C:\app\Administrator\
db\myora\
oradata\
redo02a.rdo'
,
'
C:\app\Administrator\
db\myora\
oradata\
redo02b.rdo'
)
SIZE
50M,
GROUP
3 (
'
C:\app\Administrator\
db\myora\
oradata\
redo03a.rdo'
,
'
C:\app\Administrator\
db\myora\
oradata\
redo03b.rdo'
)
SIZE
50M
DATAFILE
'
C:\app\Administrator\
db\myora\
oradata\
system01.dbf'
SIZE 100M AUTOEXTEND ON
NEXT 50K
MAXSIZE 100M
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE
'
C:\app\Administrator\
db\myora\
oradata\
sysaux01.dbf'
SIZE
200M
UNDO TABLESPACE UNDOTBS1 DATAFILE
'
C:\app\Administrator\
db\myora\
oradata\
undotbs01.dbf'
SIZE
300M AUTOEXTEND
OFF
DEFAULT
TEMPORARY
TABLESPACE
TEMP
TEMPFILE
'
C:\app\Administrator\
db\myora\
oradata\
temp01.dbf'
SIZE
200M REUSE AUTOEXTEND
OFF
CHARACTER
SET
WE8ISO8859P1
NATIONAL
CHARACTER
SET
UTF8;
Tahap 8 Buat data dictionary object
SQL> @%ORACLE_HOME%\rdbms\admin\catalog.sql
SQL> @%ORACLE_HOME%\rdbms\admin\catproc.sql
SQL>
connect
system/system
SQL> @%ORACLE_HOME%\sqlplus\admin\pupbld.sql
SQL>
connect
/
as
sysdba
SQL> shut immediate
Database
closed.
Database
dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System
Global
Area 523108352 bytes
Fixed
Size
1375704 bytes
Variable
Size
314573352 bytes
Database
Buffers 201326592 bytes
Redo Buffers 5832704 bytes
Database
mounted.
SQL>
alter
database
archivelog;
Database
altered.
SQL>
alter
database
open
;
Database
altered.
SQL> archive log list
Database
log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log
sequence
12
Next
log
sequence
to
archive 13
Current
log
sequence
13
Freelance trainer for soft skill FRAMEWORK topics : PRINCE, ITIL, COBIT, TOGAF, PMBOK, PMP, ITPM, PMO, SQA JAKARTA, BANDUNG, MAKASAR, BALI, MEDAN, INDONESIA, MALAYSIA, SINGAPORE for inquiry please contact :
|
Hery Purnama, 081223344506, freelance trainer MS.Access Database Fundamental or Programming MS.Access VBA Macro, Bandung - Jawa Barat
Details : www.inhousetrainer.net
Hery Purnama 081223344506 , freelance trainer for Oracle DBA topics , fundamental PL/SQL, workshop I, workshop II , Performance tuning.
other details please access http://inhousetrainer.net
Hery Purnama , 081.223344.505 , freelance Trainer for training web java , ajax, xml or json
Inhouse trainer for location Jakarta, bandung, surabaya, balikpapan, makasar, menado and other city in Indonesia, singapore, malaysia
For inquiry please contact
+62.81223344506
PinBB 7dc633aa
Hery Purnama, 081.223344.506 , freelance certified trainer for PMBOK, ITIL V.3/2011, ITPM, TOGAF, CPMP, PMP
Location Jakarta , Bandung, Medan, Semarang, Makasar, Surabaya, Ambon, Indonesia
for inqury please contact
HERY PURNAMA
Freelance IT Trainer
Call/WA : 081.223344.506
pinBB : 7DC633AA
inhousetrainer@yahoo.com
www.inhousetrainer.net
http://freelance-it-trainer.blogspot.com
"..Dedicated to share..."
Terima kasih kepada staff dan manajemen LITBANG ESDM jakarta dan Sciencom training center Jakarta atas undangan mengajar CATIA 3D V5 yang berlangsung selama 4 hari
Semoga bermanfaat
Hery Purnama, MCDBA, CPMP, ITILF
CATIA Freelance Trainer
081.223344.506
http://inhousetrainer.net
Hometown : Bandung - Jawa Barat
Hery Purnama , 081223344506, catia 3d trainer, mechanical design, drafting, modelling, structure analysis freelance trainer for catia v5 Regards, |
Project Management Body of Knowledge , PMBOK trainer, for inquiry please contact HERY PURNAMA 081.223344.506 , Other topics are PMO , ITPM, ITIL, COBIT, TOGAF, PRINCE Regards, |
zu y aaTutorial excel vba maco is available in google play. download at https://play.google.com/store/apps/details?id=net.inhousetrainer.excelmacro Regards, |
tutorial excel vba macro in google play, will comming soon
Author : Hery Purnama
freelance it trainer
Training ITIL V.3 2011 foundation dan COBIT 5 di surabaya bersama peserta dari BNI surabaya dan Hotel Ayana bali. Terima kasih kepada pesert...