thanks pak irwan atas bantuannya...!! saya coba dulu, klo ada masalah lagi boleh tanya lagi g ...? hehe coz masih newbie :)
Regards Handoko -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Irawan Budi Utomo Sent: Tuesday, August 16, 2005 1:44 PM To: [email protected] Subject: Re: [indo-oracle] Backup database incremental / per user? Dear Handoko, untuk backup database menggunakan RMAN dapat dilakukan dengan cara : 1. Enterprise Manager 2. Command Line Interface (CLI) Contoh - target database saya namakan "targdb" juga mempunyai TNS alias yang sama - user "targdba" dengan password "irawan" diasumsikan mempunyai privilage SYSDBA ========================================================= % rman nocatalog --> connect ke RMA tanpa recovery catalog RMAN> connect target targdba/[EMAIL PROTECTED] ## Contoh Incremental Backup Level 0 ## RMAN> run { 2> allocate channel dev1 type disk; 3> backup 4> incremental level 0 5> filesperset 4 6> format '/oracle/backups/senin_level0_%t' 7>(database) 8>release channel dev1; 9> } ## Contoh backup User Tablasespace ## RMAN> run { 2> allocate channel dev1 type disk; 3> backup 4> tag tbs_users_read_only 5> format '/oracle/backups/tbs_users_t%t_s%s' 6> (tablespace "Nama Tablespace User"); 7> release channel dev1; 8> } ============================================================= ini cara membackup database dengan export ## Contoh export incremental ## > exp system/manager full=y files=exp01.dmp inctype=incremental ##Contoh Export per user tablespace ## > exp irawan/irawan file=expirawan.dmp owner=irawan grants=Y rows=Y compress=Y kondisi diatas disesuaikan user dan passwordnya smoga membantu .... salam, Irawan ----- Original Message ----- From: "Handoko" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, August 15, 2005 10:38 AM Subject: [indo-oracle] Backup database incremental / per user? > > Dear pakar Oracle...!! > > Bagaimana Backup database incremental ato per user..? > > Saya sudah baca cara backup pada oracle dengan menggunakan Rman dan metode > export /import, > Tetapi saya belum faham step-stepnya pembuatannya, saya juga mencoba script > yang saya dapatkan dari internet tetapi juga masih error..! > > ada yang bisa membantu..? > > Thanks u/ rekam milis semua.. > handoko > > > > > > > > > [Non-text portions of this message have been removed] > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > > > > The contents of this e-mail may be confidential and the unauthorized use, copying, or dissemination of it and any attachments to it, is prohibited. Internet communications are not secure and Dexa Group companies do not, therefore, accept legal responsibility for the contents of this message nor for any damage caused by viruses. The views expressed here do not necessarily represent those of Dexa Group companies. -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hfkq6fj/M=362329.6886308.7839368.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1124184190/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
