Friday 29 July 2011

.::: Jadwal Puasa Dan Imsakiyah Ramadhan Tahun 2011 Masehi / 1432 Hijriah Di Seluruh Kota Di Indonesia :::.

Jadwal Imsakiyah Ramadhan – Tak terasa, sebentar lagi kita akan berjumpa dengan Bulan Suci Ramadhan, ini berarti kita masih diberikan berkah yang sangat besar karena masih diberikan nikmat melalui bulan seribu bulan. Bulan yang penuh dengan rahmat, barokah dan ampunan, yang ditunggu-tunggu umat muslim seluruh Dunia. ( Download Jadwal Puasa dan Imsakiyah Tahun 2011 /1432 Di Jakarta dan Sekitarnya )


“Wahai orang-orang yang beriman diwajibkan atas kamu sekalian puasa, sebagaimana diwajibkan atas orang-orang sebelum kamu agar kamu sekalian bertaqwa “( QS Al-Baqarah : 183 )

Bagi umat muslim, ibadah puasa adalah sebuah kewajiban di Bulan Ramadhan. Untuk itu, berikut saya berikan Jadwal Imsakiyah untuk hampir seluruh kota besar di Indonesia. Semoga ini dapat membantu teman-teman yang akan melaksanakan Ibadah Puasa di Bulan Suci Ramadhan..
Dalam waktu dekat ini para umat muslim diseluruh dunia akan melaksanakan ibadah wajib yaitu puasa di bulan Ramadhan yang akan datang.

berikut ini adalah jadwal puasa untuk 2011 atau 1432 hijriah








Al Quran digital free download



Bulan puasa akan segera tiba mari kita tingkatkan amal jariah dan ibadah kita. Dari pada tidur atau bengong melamun yang nggak-nggak lebih baik kita gapai semua berkah dibulan ramadhan dengan membaca Al-Quran..walau dikos an gak da al quran..sekarang tak perlu bingung lagi karna ada Al quran digital yang setia menemani suasana ramadan.hahaha.................yuk download.



AlQur’an dalam format digital. Bahasa Indonesia (terjemahannya) dan huruf ayat dalam Bahasa Arab. Disertai pula sedikit tafsir. Berikut ini detail lengkap kemampuan dari AlQuran Digital ini.

  • Menampilkan ayat-ayat Al Quran dalam tulisan Arab dan terjemahan Indonesia

  • Menampilkan catatan kaki dari Al Quran terjemahan Depag RI

  • Menampilkan asbabun nuzul (sebab-sebab turunnya ayat) juz 30

  • Disediakan indeks menurut subyek

  • Melakukan pencarian kata dalam terjemahan

  • Membuat bookmark dari ayat yang dianggap penting

  • Ayat dalam tulisan Arab dan terjemahan dapat dicopy dan dipaste ke program lain seperti Microsoft Word

  • Tidak memerlukan instalasi font atau program tambahan.

Silakan download. Jangan khawatir barang bajakan coz lisensi file adalah freeware (sebagaimana tertulis oleh para pembuatnya bahwa hak cipta hanya milik Allah SWT). Ukuran file cuma 9,5MB-an (tidak seberapa besar dibanding manfaatnya).

Download

Clock X Free download



Anda yang sangat memperhatikan waktu pasti akan sangat terbantu dengan adanya aplikasi seperti clockx ini. Clockx adalah jam analog yang bisa anda taruh pada desktop dimanapun anda inginkan.

Banyak juga fitur-fitur lain yang bisa anda peroleh dari Clockx ini di antarnya:

  • Adanya Alarm

  • Tema atau skinnya bisa di gonta ganti sesuai dengan selera kita

  • Ontop placement

  • Dan masih banyak lagi fitur Lainnya….

Setelah anda menginstalnya maka tampilan clock x nya akan terlihat seperti gambar ditas (diatas samping kiri)

Download



Visit Clockx Homepage

Ini juga ada sedikit features dari situs aslinya:

ClocX features:

* antialiasing (3 levels: off / method 1 / method 2)

* 256 levels of transparency with special mouse-over transparency function

* changable and configurable styles (24 PNGs and 7 BMPs in standard installation, additional 98 PNGs and 69 BMPs available in full instalation or in PNG/BMP packs)

* per-pixel alphablending for PNG backgrounds

* advanced window options (unmovable, always on top, pin to desktop, click through, …)

* priority settings

* configurable alarms with ability to show alarm window, play sound, execute application and shutdown computer

* simple calendar

* automatic start with Windows (for all users) or with user login (only for your user)

* language support (Arabic, Bulgarian, Chinese, Czech, Dutch, English, Finnish, French, German, Hebrew, Italian, Japanese, Polish, Portuguese, Russian, Serbian, Slovak, Spanish, Swedish, Turkish and more)

* absolutely free software – it contains no ads, no spyware, no adware and no toolbars

RocketDock v.1.3.5 free download

Sempat bosen dengan tampilan dekstop Notebook yang gitu-gitu saja, berkelana deh cari-cari aplikasi buat dekstop n singkat kata ketemulah ama yang namanya RocketDock. Bagi kamu yang merasa bosan juga dengan tampilan pada dekstop kompimu, kamu bisa menggunakan aplikasi StarDock untuk mengubah tampilan dekstop kompimu, salah satu keunggulan dari RocketDock ini yaitu selain dapat mempercantik tampilan dekstop juga mempermudah kita untuk masuk ke sub menu tertentu seperti my computer, my document, control panel, dsb. Gambar datas merupakan tampilan dekstop notebook saya setelah diinstal RocketDock v.1.3.5.

Download

.::: How To Backup And Restore Database Oracle Using RMAN ( Oracle Backup Tool ) And Fix ORA-19602 :::.

How To Backup And Restore Database Oracle Using RMAN Tool And Fix

ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

Cause:       You tried to copy or backup a file that was not closed cleanly, and the database was in NOARCHIVELOG mode. This is not allowed because when restored, the file will require redo application before it is usable, and redo is not currently being saved beyond the contents of the online redo logs.

Action:  Take the tablespace offline clean or close the database and retry the copy or backup. ( so Please Run Pre Backup Oracle Using SQL Command Before Backup)

A. Step by Step Backup And Restore Oracle Using RMAN Tool

  - Run Pre Backup Oracle Using SQL Command
        SQL> shutdown immediate;
        SQL> startup mount;
        SQL> alter database archivelog;
        SQL> alter database open;
        SQL> archivelog list;
        SQL> ARCHIVE LOG LIST
        SQL> alter system archive log start;

   - Backup Database
        RMAN> backup database ;
        or you can use
        RMAN> backup database plus archivelog;

   - Check Database Backup
        RMAN> list backup;
     RMAN> list backup summary;
    RMAN> list backup by file;
   - Restore Database
    SQL> startup;
    SQL> shutdown abort;
    RMAN> startup nomount;
    RMAN> restore controlfile from <name_file_backup>
   - Check Database Restore

B. Backup Database Oracle Sample from Lab

1. Backup Database Oracle Without PreBackup
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd c:\

C:\>
C:\>cd C:\oracle\product\10.2.0\db_1

C:\oracle\product\10.2.0\db_1>
C:\>cd C:\oracle\product\10.2.0\db_1

C:\oracle\product\10.2.0\db_1>dir
 Volume in drive C has no label.
 Volume Serial Number is 94E9-D1D5

 Directory of C:\oracle\product\10.2.0\db_1

07/20/2011  10:52 AM    <DIR>          .
07/20/2011  10:52 AM    <DIR>          ..
07/16/2011  04:07 PM    <DIR>          admin
07/16/2011  04:07 PM    <DIR>          assistants
07/20/2011  10:37 AM    <DIR>          BIN
07/16/2011  04:13 PM    <DIR>          cdata
07/16/2011  04:23 PM    <DIR>          cfgtoollogs
07/16/2011  04:07 PM    <DIR>          clone
07/16/2011  04:07 PM    <DIR>          com
07/16/2011  04:13 PM    <DIR>          config
07/16/2011  04:07 PM    <DIR>          crs
07/16/2011  04:07 PM    <DIR>          css
07/16/2011  04:13 PM    <DIR>          ctx
07/20/2011  10:51 AM    <DIR>          database
07/20/2011  10:51 AM    <DIR>          dbs
07/16/2011  04:07 PM    <DIR>          demo
07/16/2011  04:07 PM    <DIR>          diagnostics
07/16/2011  04:07 PM    <DIR>          has
07/16/2011  04:07 PM    <DIR>          hs
07/20/2011  10:52 AM    <DIR>          install
07/16/2011  04:07 PM                43 install.platform
07/16/2011  04:15 PM    <DIR>          inventory
07/16/2011  04:07 PM    <DIR>          javavm
07/16/2011  04:12 PM    <DIR>          jdbc
07/16/2011  04:13 PM    <DIR>          jdk
07/16/2011  04:13 PM    <DIR>          jlib
07/16/2011  04:07 PM    <DIR>          jre
07/16/2011  04:13 PM    <DIR>          ldap
07/16/2011  04:12 PM    <DIR>          LIB
07/16/2011  04:15 PM    <DIR>          log
07/16/2011  04:07 PM    <DIR>          md
07/16/2011  04:08 PM    <DIR>          mesg
07/16/2011  04:07 PM    <DIR>          mgw
07/16/2011  04:10 PM    <DIR>          MMC Snap-Ins
07/16/2011  04:14 PM    <DIR>          NETWORK
07/16/2011  04:07 PM    <DIR>          nls
07/16/2011  04:15 PM    <DIR>          oc4j
07/16/2011  04:07 PM    <DIR>          OCI
07/16/2011  04:13 PM    <DIR>          odbc
07/16/2011  04:07 PM    <DIR>          odp.net
07/16/2011  04:07 PM    <DIR>          olap
07/16/2011  04:07 PM    <DIR>          oledb
07/16/2011  04:13 PM    <DIR>          oo4o
07/16/2011  04:13 PM    <DIR>          OPatch
07/16/2011  04:13 PM    <DIR>          opmn
07/16/2011  04:10 PM    <DIR>          oraconfig
07/16/2011  04:07 PM    <DIR>          oracore
07/16/2011  04:13 PM    <DIR>          oradata
07/16/2011  04:14 PM    <DIR>          ORAINST
07/16/2011  04:07 PM    <DIR>          ord
07/16/2011  04:13 PM    <DIR>          oui
07/16/2011  04:07 PM    <DIR>          owm
07/16/2011  04:07 PM    <DIR>          perl
07/16/2011  04:08 PM    <DIR>          plsql
07/16/2011  04:07 PM    <DIR>          precomp
07/16/2011  04:13 PM    <DIR>          racg
07/16/2011  04:15 PM    <DIR>          RDBMS
07/16/2011  04:12 PM    <DIR>          relnotes
07/16/2011  04:07 PM    <DIR>          slax
07/16/2011  04:07 PM    <DIR>          sqlj
07/20/2011  10:38 AM             2,285 sqlnet.log
07/16/2011  04:13 PM    <DIR>          sqlplus
07/16/2011  04:13 PM    <DIR>          srvm
07/16/2011  04:13 PM    <DIR>          sysman
07/20/2011  10:54 AM    <DIR>          TEGUHTH_TGH
07/16/2011  04:07 PM    <DIR>          uix
07/16/2011  04:07 PM    <DIR>          wwg
07/16/2011  04:07 PM    <DIR>          xdk
               2 File(s)          2,328 bytes
              66 Dir(s)   3,079,868,416 bytes free

C:\oracle\product\10.2.0\db_1>
C:\oracle\product\10.2.0\db_1>cd BIN

C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>dir
C:\oracle\product\10.2.0\db_1\BIN>dir rman.exe
 Volume in drive C has no label.
 Volume Serial Number is 94E9-D1D5

 Directory of C:\oracle\product\10.2.0\db_1\BIN

08/29/2005  08:38 PM         1,552,384 rman.exe
               1 File(s)      1,552,384 bytes
               0 Dir(s)   3,079,995,392 bytes free

C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>set ORACLE_SID=TGH

C:\oracle\product\10.2.0\db_1\BIN>echo %ORACLE_SID%
TGH

C:\oracle\product\10.2.0\db_1\BIN>

C:\oracle\product\10.2.0\db_1\BIN>rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jul 20 11:26:03 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: TGH (DBID=941403268)

RMAN>
RMAN> backup database;

Starting backup at 20-JUL-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=143 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/20/2011 11:26:
47
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 20-JUL-11
channel ORA_DISK_1: finished piece 1 at 20-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
20\O1_MF_NCSNF_TAG20110720T112647_72DP89MK_.BKP tag=TAG20110720T112647 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/20/2011 11:26:
47
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

RMAN>
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd c:\

C:\>
C:\>cd C:\oracle\product\10.2.0\db_1

C:\oracle\product\10.2.0\db_1>
C:\>cd C:\oracle\product\10.2.0\db_1

C:\oracle\product\10.2.0\db_1>dir
 Volume in drive C has no label.
 Volume Serial Number is 94E9-D1D5

 Directory of C:\oracle\product\10.2.0\db_1

07/20/2011  10:52 AM    <DIR>          .
07/20/2011  10:52 AM    <DIR>          ..
07/16/2011  04:07 PM    <DIR>          admin
07/16/2011  04:07 PM    <DIR>          assistants
07/20/2011  10:37 AM    <DIR>          BIN
07/16/2011  04:13 PM    <DIR>          cdata
07/16/2011  04:23 PM    <DIR>          cfgtoollogs
07/16/2011  04:07 PM    <DIR>          clone
07/16/2011  04:07 PM    <DIR>          com
07/16/2011  04:13 PM    <DIR>          config
07/16/2011  04:07 PM    <DIR>          crs
07/16/2011  04:07 PM    <DIR>          css
07/16/2011  04:13 PM    <DIR>          ctx
07/20/2011  10:51 AM    <DIR>          database
07/20/2011  10:51 AM    <DIR>          dbs
07/16/2011  04:07 PM    <DIR>          demo
07/16/2011  04:07 PM    <DIR>          diagnostics
07/16/2011  04:07 PM    <DIR>          has
07/16/2011  04:07 PM    <DIR>          hs
07/20/2011  10:52 AM    <DIR>          install
07/16/2011  04:07 PM                43 install.platform
07/16/2011  04:15 PM    <DIR>          inventory
07/16/2011  04:07 PM    <DIR>          javavm
07/16/2011  04:12 PM    <DIR>          jdbc
07/16/2011  04:13 PM    <DIR>          jdk
07/16/2011  04:13 PM    <DIR>          jlib
07/16/2011  04:07 PM    <DIR>          jre
07/16/2011  04:13 PM    <DIR>          ldap
07/16/2011  04:12 PM    <DIR>          LIB
07/16/2011  04:15 PM    <DIR>          log
07/16/2011  04:07 PM    <DIR>          md
07/16/2011  04:08 PM    <DIR>          mesg
07/16/2011  04:07 PM    <DIR>          mgw
07/16/2011  04:10 PM    <DIR>          MMC Snap-Ins
07/16/2011  04:14 PM    <DIR>          NETWORK
07/16/2011  04:07 PM    <DIR>          nls
07/16/2011  04:15 PM    <DIR>          oc4j
07/16/2011  04:07 PM    <DIR>          OCI
07/16/2011  04:13 PM    <DIR>          odbc
07/16/2011  04:07 PM    <DIR>          odp.net
07/16/2011  04:07 PM    <DIR>          olap
07/16/2011  04:07 PM    <DIR>          oledb
07/16/2011  04:13 PM    <DIR>          oo4o
07/16/2011  04:13 PM    <DIR>          OPatch
07/16/2011  04:13 PM    <DIR>          opmn
07/16/2011  04:10 PM    <DIR>          oraconfig
07/16/2011  04:07 PM    <DIR>          oracore
07/16/2011  04:13 PM    <DIR>          oradata
07/16/2011  04:14 PM    <DIR>          ORAINST
07/16/2011  04:07 PM    <DIR>          ord
07/16/2011  04:13 PM    <DIR>          oui
07/16/2011  04:07 PM    <DIR>          owm
07/16/2011  04:07 PM    <DIR>          perl
07/16/2011  04:08 PM    <DIR>          plsql
07/16/2011  04:07 PM    <DIR>          precomp
07/16/2011  04:13 PM    <DIR>          racg
07/16/2011  04:15 PM    <DIR>          RDBMS
07/16/2011  04:12 PM    <DIR>          relnotes
07/16/2011  04:07 PM    <DIR>          slax
07/16/2011  04:07 PM    <DIR>          sqlj
07/20/2011  10:38 AM             2,285 sqlnet.log
07/16/2011  04:13 PM    <DIR>          sqlplus
07/16/2011  04:13 PM    <DIR>          srvm
07/16/2011  04:13 PM    <DIR>          sysman
07/20/2011  10:54 AM    <DIR>          TEGUHTH_TGH
07/16/2011  04:07 PM    <DIR>          uix
07/16/2011  04:07 PM    <DIR>          wwg
07/16/2011  04:07 PM    <DIR>          xdk
               2 File(s)          2,328 bytes
              66 Dir(s)   3,079,868,416 bytes free

C:\oracle\product\10.2.0\db_1>
C:\oracle\product\10.2.0\db_1>cd BIN

C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>dir
C:\oracle\product\10.2.0\db_1\BIN>dir rman.exe
 Volume in drive C has no label.
 Volume Serial Number is 94E9-D1D5

 Directory of C:\oracle\product\10.2.0\db_1\BIN

08/29/2005  08:38 PM         1,552,384 rman.exe
               1 File(s)      1,552,384 bytes
               0 Dir(s)   3,079,995,392 bytes free

C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>set ORACLE_SID=TGH

C:\oracle\product\10.2.0\db_1\BIN>echo %ORACLE_SID%
TGH

C:\oracle\product\10.2.0\db_1\BIN>

C:\oracle\product\10.2.0\db_1\BIN>rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jul 20 11:26:03 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: TGH (DBID=941403268)

RMAN>
RMAN> backup database;

Starting backup at 20-JUL-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=143 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/20/2011 11:26:
47
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 20-JUL-11
channel ORA_DISK_1: finished piece 1 at 20-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
20\O1_MF_NCSNF_TAG20110720T112647_72DP89MK_.BKP tag=TAG20110720T112647 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/20/2011 11:26:
47
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

RMAN>
RMAN>
RMAN> list backup;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.80M      DISK        00:00:03     20-JUL-11
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20110720T102427
        Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_20\O1_MF_NCSNF_TAG20110720T102427_72DLMFG5_.BKP
  Control File Included: Ckp SCN: 633348       Ckp time: 20-JUL-11
  SPFILE Included: Modification time: 20-JUL-11

RMAN>
RMAN> quit

Recovery Manager complete
2. Backup Database Oracle With PreBackup
     2.1 Pre Backup Database Oracle

C:\oracle\product\10.2.0\db_1\BIN>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 21 11:52:59 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1248600 bytes
Variable Size             100663976 bytes
Database Buffers          184549376 bytes
Redo Buffers                7139328 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archivelog list;

SQL> ARCHIVE LOG LIST
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     1
Next log sequence to archive   2
Current log sequence           2
SQL> alter system archive log start;

System altered.

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options

    2.2 Backup Database Oracle With PreBackup

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd c:\

C:\>cd C:\oracle\product\10.2.0\db_1\BIN

C:\oracle\product\10.2.0\db_1\BIN>rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 21 14:00:34 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: TGH (DBID=941491037)

RMAN> backup database plus archivelog;

Starting backup at 21-JUL-11
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=148 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2 recid=1 stamp=757080494
input archive log thread=1 sequence=3 recid=2 stamp=757087335
channel ORA_DISK_1: starting piece 1 at 21-JUL-11
channel ORA_DISK_1: finished piece 1 at 21-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
21\O1_MF_ANNNN_TAG20110721T140232_72HMS02G_.BKP tag=TAG20110721T140232 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:27
Finished backup at 21-JUL-11

Starting backup at 21-JUL-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\SYSTEM01.DBF
input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\SYSAUX01.DBF
input datafile fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\EXAMPLE01.DBF

input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\UNDOTBS01.DBF

input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 21-JUL-11
channel ORA_DISK_1: finished piece 1 at 21-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
21\O1_MF_NNNDF_TAG20110721T140414_72HMWSJ3_.BKP tag=TAG20110721T140414 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:12:08
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 21-JUL-11
channel ORA_DISK_1: finished piece 1 at 21-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
21\O1_MF_NCSNF_TAG20110721T140414_72HNLK0H_.BKP tag=TAG20110721T140414 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:12
Finished backup at 21-JUL-11

Starting backup at 21-JUL-11
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=4 recid=3 stamp=757088198
channel ORA_DISK_1: starting piece 1 at 21-JUL-11
channel ORA_DISK_1: finished piece 1 at 21-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
21\O1_MF_ANNNN_TAG20110721T141639_72HNLS3F_.BKP tag=TAG20110721T141639 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 21-JUL-11

RMAN>
RMAN> list backup;


List of Backup Sets
===================

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1       55.59M     DISK        00:01:21     21-JUL-11
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20110721T140232
        Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_21\O1_MF_ANNNN_TAG20110721T140232_72HMS02G_.BKP

  List of Archived Logs in backup set 1
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    2       567803     21-JUL-11 585347     21-JUL-11
  1    3       585347     21-JUL-11 592362     21-JUL-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    605.70M    DISK        00:11:59     21-JUL-11
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20110721T140414
        Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_21\O1_MF_NNNDF_TAG20110721T140414_72HMWSJ3_.BKP
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 592750     21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\SYSTEM0
1.DBF
  2       Full 592750     21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\UNDOTBS
01.DBF
  3       Full 592750     21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\SYSAUX0
1.DBF
  4       Full 592750     21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\USERS01
.DBF
  5       Full 592750     21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\EXAMPLE
01.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.80M      DISK        00:00:11     21-JUL-11
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20110721T140414
        Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_21\O1_MF_NCSNF_TAG20110721T140414_72HNLK0H_.BKP
  Control File Included: Ckp SCN: 593395       Ckp time: 21-JUL-11
  SPFILE Included: Modification time: 21-JUL-11

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4       998.50K    DISK        00:00:01     21-JUL-11
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20110721T141639
        Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_21\O1_MF_ANNNN_TAG20110721T141639_72HNLS3F_.BKP

  List of Archived Logs in backup set 4
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    4       592362     21-JUL-11 593403     21-JUL-11

RMAN>
RMAN> list backup summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1       B  A  A DISK        21-JUL-11       1       1       NO         TAG201107
21T140232
2       B  F  A DISK        21-JUL-11       1       1       NO         TAG201107
21T140414
3       B  F  A DISK        21-JUL-11       1       1       NO         TAG201107
21T140414
4       B  A  A DISK        21-JUL-11       1       1       NO         TAG201107
21T141639

RMAN> list backup by file;


List of Datafile Backups
========================

File Key     TY LV S Ckp SCN    Ckp Time  #Pieces #Copies Compressed Tag
---- ------- -  -- - ---------- --------- ------- ------- ---------- ---
1    2       B  F  A 592750     21-JUL-11 1       1       NO         TAG20110721
T140414
2    2       B  F  A 592750     21-JUL-11 1       1       NO         TAG20110721
T140414
3    2       B  F  A 592750     21-JUL-11 1       1       NO         TAG20110721
T140414
4    2       B  F  A 592750     21-JUL-11 1       1       NO         TAG20110721
T140414
5    2       B  F  A 592750     21-JUL-11 1       1       NO         TAG20110721
T140414

List of Archived Log Backups
============================

Thrd Seq     Low SCN    Low Time  BS Key  S #Pieces #Copies Compressed Tag
---- ------- ---------- --------- ------- - ------- ------- ---------- ---
1    2       567803     21-JUL-11 1       A 1       1       NO         TAG201107
21T140232
1    3       585347     21-JUL-11 1       A 1       1       NO         TAG201107
21T140232
1    4       592362     21-JUL-11 4       A 1       1       NO         TAG201107
21T141639

List of Control File Backups
============================

CF Ckp SCN Ckp Time  BS Key  S #Pieces #Copies Compressed Tag
---------- --------- ------- - ------- ------- ---------- ---
593395     21-JUL-11 3       A 1       1       NO         TAG20110721T140414
List of SPFILE Backups
======================

Modification Time BS Key  S #Pieces #Copies Compressed Tag
----------------- ------- - ------- ------- ---------- ---
21-JUL-11         3       A 1       1       NO         TAG20110721T140414

RMAN>
RMAN> quit


Recovery Manager complete.

C:\oracle\product\10.2.0\db_1\BIN>

C:\oracle\product\10.2.0\db_1\BIN>cd ..

C:\oracle\product\10.2.0\db_1>cd ..

C:\oracle\product\10.2.0>cd flash_recovery_area\TGH

C:\oracle\product\10.2.0\flash_recovery_area\TGH>dir
 Volume in drive C has no label.
 Volume Serial Number is 94E9-D1D5

 Directory of C:\oracle\product\10.2.0\flash_recovery_area\TGH

07/21/2011  02:02 PM    <DIR>          .
07/21/2011  02:02 PM    <DIR>          ..
07/21/2011  12:08 PM    <DIR>          ARCHIVELOG
07/21/2011  02:02 PM    <DIR>          BACKUPSET
07/21/2011  11:10 AM    <DIR>          ONLINELOG
               0 File(s)              0 bytes
               5 Dir(s)   2,642,710,528 bytes free

C:\oracle\product\10.2.0\flash_recovery_area\TGH>cd BACKUPSET\2011_07_21

C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07_21>
C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07_21>dir
 Volume in drive C has no label.
 Volume Serial Number is 94E9-D1D5

 Directory of C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07
_21

07/21/2011  02:16 PM    <DIR>          .
07/21/2011  02:16 PM    <DIR>          ..
07/21/2011  02:04 PM        58,292,736 O1_MF_ANNNN_TAG20110721T140232_72HMS02G_.
BKP
07/21/2011  02:16 PM         1,022,976 O1_MF_ANNNN_TAG20110721T141639_72HNLS3F_.
BKP
07/21/2011  02:16 PM         7,143,424 O1_MF_NCSNF_TAG20110721T140414_72HNLK0H_.
BKP
07/21/2011  02:16 PM       635,133,952 O1_MF_NNNDF_TAG20110721T140414_72HMWSJ3_.
BKP
               4 File(s)    701,593,088 bytes
               2 Dir(s)   2,642,710,528 bytes free

C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07_21>

C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07_21>cd ..

C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET>cd ..

C:\oracle\product\10.2.0\flash_recovery_area\TGH>cd ..

C:\oracle\product\10.2.0\flash_recovery_area>cd ..

C:\oracle\product\10.2.0>cd oradata/

C:\oracle\product\10.2.0\oradata>cd TGH

C:\oracle\product\10.2.0\oradata\TGH>dir
 Volume in drive C has no label.
 Volume Serial Number is 94E9-D1D5

 Directory of C:\oracle\product\10.2.0\oradata\TGH

07/21/2011  11:11 AM    <DIR>          .
07/21/2011  11:11 AM    <DIR>          ..
07/21/2011  02:20 PM         7,061,504 CONTROL01.CTL
07/21/2011  02:20 PM         7,061,504 CONTROL02.CTL
07/21/2011  02:20 PM         7,061,504 CONTROL03.CTL
07/21/2011  02:20 PM       104,865,792 EXAMPLE01.DBF
07/21/2011  11:54 AM        52,429,312 REDO01.LOG
07/21/2011  11:54 AM        52,429,312 REDO02.LOG
07/21/2011  11:54 AM        52,429,312 REDO03.LOG
07/21/2011  02:20 PM       251,666,432 SYSAUX01.DBF
07/21/2011  02:20 PM       503,324,672 SYSTEM01.DBF
07/21/2011  11:13 AM        20,979,712 TEMP01.DBF
07/21/2011  02:20 PM        36,708,352 UNDOTBS01.DBF
07/21/2011  02:20 PM        22,290,432 USERS01.DBF
              12 File(s)  1,118,307,840 bytes
               2 Dir(s)   2,642,722,816 bytes free

C:\oracle\product\10.2.0\oradata\TGH>

 3. Restore Database Oracle
You can visit backup and restore oracle other post in
http://fakta-dan-unik.blogspot.com/search/label/Oracle

Thursday 28 July 2011

Image Beauty of The Sea gallery

Free Wallpapers Sea  | Sea  Wallpapers | Sea | Free Wallwapapers 2011 | New Sea Wallpapers| Beautiful Sea Wallpapers | Sea Picture | Free Wallpapers Beautiful Sea Desktop

Stunning Pictures Ocean Phenomena

Free Wallpapers Ocean Phenomena | Ocean Phenomena Wallpapers | Ocean Phenomena | Free Wallwapapers 2011 | New Ocean Phenomena Wallpapers| Stunning Ocean Phenomena | Ocean Phenomena Pictures

Dragon 3D Strong Wallpapers

Free Wallpapers Dragon  | Dragon  Wallpapers | Dragon  | Free Wallwapapers 2011 | New Dragon Wallpapers| Dragon 3D Wallpapers | Dragon Movie Wallpapers | Dragon  Strong Wallpapers | Free Dragon Desktop Background

Digital Girls Wallpapers

Free Wallpapers Digital Girls  | Digital Girls  Wallpapers | Digital Girls  | Free Wallwapapers 2011 | New Digital Girls  Wallpapers| Digital Girls Wallpapers 2011 | Digital Girls Cartoon

Wednesday 27 July 2011

Priscil Master Chef Indonesia Finalists Gallery

Free Wallpapers Priscil  | Priscil  Wallpapers | Priscil | Free Wallwapapers 2011 | New Priscil Wallpapers| Priscil Modeling | Priscil Master Chef Indonesia | Master Chef Indonesia | Master Chef Indonesia Gallery | Priscil Picture | Priscil & Fero

Hot Picture Celebrity Couple Andy Soraya & Ferly Putra

Free Wallpapers Andy Soraya & Ferly Putra | Andy Soraya & Ferly Putra Wallpapers | Andy Soraya & Ferly Putra | Free Wallwapapers 2011 | New Andy Soraya & Ferly Putra Wallpapers| Andy Soraya & Ferly Putra Hot Picture | Andy Soraya & Ferly Putra Seks | Andy Soraya & Ferly Putra Celebrity Couple | Andy Soraya Wallpapers | Ferly Putra Wallpapers | Andy Soraya | Ferly Putra

Tuesday 26 July 2011

Handika Pratama Cool Gallery

Free Wallpapers Handika Pratama  | Handika Pratama  Wallpapers | Handika Pratama  | Free Wallwapapers 2011 | New Handika Pratama Wallpapers| Handika Pratama Dari Sujud Ke Sujud | Handika Pratama & Donita | Donita | Handika Pratama Soap Opera | Handika Pratama Religious

Marshanda Veiled Picture

Free Wallpapers Marshanda Veiled | Marshanda Veiled Wallpapers | Marshanda Veiled | Free Wallwapapers 2011 | New Marshanda Veiled Wallpapers| Marshanda Wallpapers | Marshanda 2011 | Marshanda Dari Sujud Ke Sujud | Marshanda & Ben Kasyafani

.::: How To Restore Control File Using RMAN ( Oracle Backup Tool ):::.

=====================
Overview
=====================
Oracle provides many ways to restore the controlfile for recovery using RMAN (Recovery Manager). This article provides several examples of how to get the controlfile back quickly so the restore of the database can occur.

      If you do not specify the location where to restore the controlfile to, the parameter control_files is used with the respective names and locations listed in the parameter file (init.ora or spfile).
Several of the examples in this article make use the autobackup controlfile created by RMAN. By default, the format of the autobackup file for all configured devices is the substitution variable %F in the FORMAT clause. This variable format translates into c-IIIIIIIIII-YYYYMMDD-QQ, with the placeholders defined as follows:

    IIIIIIIIII stands for the DBID.

    YYYYMMDD is a time stamp of the day the backup is generated.

    QQ is the hex sequence that starts with 00 and has a maximum of FF.

Example OMF autobackup controlfile:

    o1_mf_s_716574721_5wn6p1hj_.bkp


=====================
Example
=====================

The following examples use Oracle Database 10g and make use of a Recovery Catalog and the Flash Recovery Area (FRA).

1.   Restore controlfile from autobackup.

RMAN> restore controlfile from autobackup;

2.   Restore controlfile from a specific backup piece.

RMAN> restore controlfile from '/backup_dir/piece_name';

3.   Restore controlfile from most recent available controlfile backup.

RMAN> restore controlfile;

The following examples use Oracle Database 10g and do not require the use of a Recovery Catalog or a Flash Recovery Area (FRA). The big difference is the requirement to set the dbid of the database before executing restore with the instance in a nomount state.

4.   The following backup used all defaults. If not using a FRA, this backup should be in $ORACLE_HOME/dbs.

RMAN> set dbid=nnnnnnnnn;
RMAN> restore controlfile from autobackup;

5.   Restore from autobackup looks at the most recent 7 days backups by default. If you want to restore an autobackup that's older then the default you can use the 'maxdays' parameter..

RMAN> set dbid=nnnnnnnnn;
RMAN> restore controlfile from autobackup maxdays 20;

6.   Restore from autobackup increasing the number of autobackup sequences looked for restore in case your database generated many autobackups in a given day.

RMAN> set dbid=nnnnnnnnn;
RMAN> restore controlfile from autobackup maxseq 10;

7.   Restoring from autobackup when the backup location is not default.
C:\Documents and Settings\Administrator>rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 26 14:36:54 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: PME (DBID=941578866)

RMAN> set dbid=941578866;
RMAN> set controlfile autobackup format for device type disk to '/tmp/%F';
RMAN> restore controlfile from autobackup;

8.   Restore the controlfile from this specific autobackup.

RMAN> set dbid=nnnnnnnnn;
RMAN> restore controlfile from '/tmp/c-1140771490-20080502-03';

9.   Restore the controlfile from a specific autobackup file to a temporary disk location the replicate the temp controlfile to the respective locations and names given in control_files..

RMAN> set dbid=nnnnnnnnn;
RMAN> restore controlfile from '/tmp/c-1140771490-2008050203' to '/tmp/control.tmp';
RMAN> replicate controlfile from '/tmp/control.tmp'

Once you have the controlfile restored and mounted you have access to your previous backup configuration which will also be used during restore as well as the backup information required to restore and recover your database.

After you mount the controlfiles from Oracle101g 10.2.x > you can use the RESTORE PREVIEW command to see what backups will be required to restore and recover and what checkpoint you must exceed to open the database resetlogs.