Oracle: How to Find the Database ID (DBID)

Every Oracle database has it's unique identifier called DBID which is necessary in most critical situations like recovery from loss of all control file using rman autobackup.

How to find Oracle DBID ?

Method 1:

You can easily find using V$database view:

SQL> select dbid from v$database;

      DBID

----------

3561501577

Method 2:

Find using RMAN:

C:\windows\system32>rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Aug 1 18:06:14 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TEST11 (DBID=3561501508)

READ MORE ...

How to Restore/Recover Lost of Control File Using Rman

Oracle database maintain three copies of Controlfile at three different locations. There are some situations arises when you loses all your controlfile. So in this case how to restore and recover controlfile using RMAN autobackup option.

One day when I tried to mount the Database I encountered with an error code:
ORA-00205: error in identifying control file, check alert log for more info

SQL> startup mount
ORACLE instance started.

Total System Global Area  606806016 bytes
Fixed Size                  1376268 bytes
Variable Size             394268660 bytes
Database Buffers          205520896 bytes
Redo Buffers                5640192 bytes
ORA-00205: error in identifying control file, check alert log for more info
=============================================================
How to restore control file using RMAN

C:\windows\system32>rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Aug 1 15:45:17 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TEST11 (not mounted)

RMAN> restore controlfile from autobackup;

Starting restore at 01-AUG-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/01/2014 15:46:27
RMAN-06495: must explicitly specify DBID with SET DBID command

RMAN> restore controlfile;

Starting restore at 01-AUG-14
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/01/2014 15:47:03
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP

STEP 1: You need to set DBID before recovery

 SQL> host rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Aug 1 17:26:13 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TEST11 (DBID=3561501508)

SQL> select dbid from v$database;

      DBID
----------

3561501508

But if your database is not mounted, you cannot find DBID. So set ID to any number you want.
ex: 

RMAN> set DBID=3561501508


executing command: SET DBID

STEP2: Restore control file from autobackup:

RMAN> restore controlfile from autobackup;

Starting restore at 01-AUG-14
using channel ORA_DISK_1

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20140801
channel ORA_DISK_1: AUTOBACKUP found: c-3561501508-20140801-00
channel ORA_DISK_1: restoring control file from AUTOBACKUP c-3561501508-20140801-00
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=D:\APP\SANTOSHTIWARI\ORADATA\TEST11\CONTROL01.CTL
Finished restore at 01-AUG-14

STEP3: 

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

STEP4
RMAN> recover database;

Starting recover at 01-AUG-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK

starting media recovery

archived log for thread 1 with sequence 3 is already on disk as file D:\APP\SANTOSHTIWARI\ORADATA\TEST11\REDO03.LOG
archived log file name=D:\APP\SANTOSHTIWARI\ORADATA\TEST11\REDO03.LOG thread=1 sequence=3
media recovery complete, elapsed time: 00:00:01
Finished recover at 01-AUG-14

RMAN> alter database open resetlogs;

database opened

READ MORE ...

ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [65], [52510], [52529], []

ORA-00600 internal error code:

This error code is native to internal exceptions from the Oracle programs. It
indicates that the process has encountered an unexpected problem. It may be
due to:
Timeout
A corrupted file
A crash that has affected stored data
I/O issue "(physical memory)"

ORA-00600: internal error code resolved:



SQL> alter database open
  2  ;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_tha
[65], [52510], [52529], [], [], [], [], [], [], []

THIS ERROR IS DUE TO INVALID ENTRY IN THE CONTROL FILE:

SOLUTION TO  ORA-00600:

IT IS BETTER TO CREATE A NEW CONTROL FILE.

FIRST CHECK IF CONTROL FILE EXIST OR NOT?

SQL>STARTUP NOMOUNT

SQL> ed a.sql


IF THERE WILL BE A CONTROL FILE THEN IT WILL OPEN. NOW INSIDE CONTROL FILE CHECK THE LOCATION OF:
REDO LOGS
SYSTEM FILE
SYSAUX FILE
UDO FILE
USER FILE

FINALLY DELETE OR BACKUP OLDER CONTROL FILE AND RECREATE NEW ONE USING:
SQL>@ a.sql

CASE 2: IF CONTROL FILE DOESN'T EXIST THEN RECREATE NEW ONE:

SQL>SHUT IMMEDIATE
SQL>STARTUP MOUNT
SQL> alter database backup controlfile to trace
  2  ;

Database altered.

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area  606806016 bytes
Fixed Size                  1376268 bytes
Variable Size             385880052 bytes
Database Buffers          213909504 bytes
Redo Buffers                5640192 bytes
SQL> ed a.sql
DELETE OLDER CONTROL FILE BEFORE CREATING NEW ONE:
SQL> @ a.sql

Control file created.

SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL> SELECT OPEN_MODE FROM V$DATABASE;

OPEN_MODE
--------------------
READ WRITE

READ MORE ...

Muskurane Ki Wajah Lyrics - Citylights | Arijit Singh

 Mukurane ki wajah song Lyrics of hindi film CITYLIGHTS.

 The music is composed by Jeet Ganguli, lyrics written by Rashmi Singh and music out on Sony Music. Here you will get this lyrics in both version I.,e hindi and English. You can prefer any one according to your needs.

Details:

SONG: Muskurane
 SINGER: Arijit Singh
LYRICS: Rashmi Singh
 MUSIC: Jeet Ganguli
 MOVIE: Citylights (2014)
 STARS: Rajkumar Rao, Patraleka
 MUSIC ON: Sony Music


Muskurane Lyrics:
=================================================

Muskurane ki wajah tum ho
 Gungunane ki wajah tum ho
 Jiya jaaye na, jaaye na, jaaye na..
 O re piya re...
 Jiya jaaye na, jaaye na, jaaye na..
 O re piya re....
 O re lamhe tu kahin mat jaa
 Ho sake toh umr bhar tham jaa
 Jiya jaaye na, jaaye na, jaaye naa..
 O re piya re..
 Jiya jaaye na, jaaye na, jaaye naa..
 O re piya re.. piyaa re..
 Dhoop aaye toh, chhaanv tum laana
 Khwahishon ki baarishon mein
 Bheeg sang jaana (x2)
 Jiya jaaye na jaaye na jaaye na
 O re piya re...
 Jiya jaaye na jaaye na jaaye na
 O re piya re.. piya re...
 Jo mile usme kaat lenge hum
 Thodi khushiyaan thode aansu baant lenge hum
 Jo mile usme kaat lenge hum
 Thodi khushiyaan thode aansu baant lenge hum
 Jiya jaaye na jaaye na jaaye na
 O re piya re...
 Jiya jaaye na jaaye na jaaye na
 O re piya re.. piya re..
 Muskurane ki wajah tum ho
 Gungunane ki wajah tum ho
 Jiya jaaye na, jaaye na, jaaye na
 O re piya re..
 Jiya jaaye na, jaaye na, jaaye na
 O re piya re.. piya re...
 Piya re...
 Wo o ho.. oo.....




================================================================

मुस्कुराने की वज़ह तुम हो
गुनगुनाने की वज़ह तुम हो
जिया जाए ना
जिया जाए ना
जिया जाए ना
ओ रे पिया रे…

 ओ रे लम्हे तू कहीं मत जा
हो सके तो उमर भर थम जा
जिया जाए ना
जाए ना, जाए ना
ओ रे पिया रे…
जिया जाए ना
जाए ना, जाए ना
ओ रे पिया रे…
पिया रे…

 धुप आए तो, छाँव तुम लाना
ख़्वाहिशों की बारिशों में
भीग संग जाना (X2)
जिया जाए ना
जाए ना, जाए ना
ओ रे पिया रे…
जिया जाए ना
जाए ना, जाए ना
ओ रे पिया रे…
पिया रे…

READ MORE ...

Aapki Najro Ne Samjha Lyrics In Hindi - Lata Mangeshkar

Aapki Najro Ne Samjha : is a lovely song from movie Anpadh and here you will get the lyrics of this song in both Hindi and English.

Song : Aapki Najro Ne Samjha
Movie : Anpadh
Singer : Lata Mangeshkar
Music By: Madan Mohan
Lyricist : Raja Mehdi Ali Khan


==============================================

 Aapki najro ne samjha pyar ke kabil mujhe
 Dil ki ai dhadkan thehar ja, mil gayi manjil mujhe
 Aapki najro ne samjha.............

 Ji hamen manjur hai aapka yeh faisla
 Keh rahi hai har najar banda parvar shukriya
 Do jahan ki aaj khushiya ho gayi hasil mujhe
 Aapki najro ne samjha.............

 Aapki manjil hu mai, meri manjil aap hain
 Kyo mai tufan se daru mere sahil aap hain
 Koyi tufano se keh de, mil gaya sahil mujhe
 Apki najro ne samjha.............

 Pad gayi dil par meri aapki parchhaiya
 Har taraf bajane lagin saikado shahnaiya
 Hanske apani jindgi me kar liya shamil mujhe
 Apki najro ne samjha.............

 

===================================================

आप की नज़रों ने समझा प्यार के काबिल मुझे
दिल की ऐ धड़कन ठहर जा, मिल गयी मंझील मुझे

जी हमे मंजूर है, आप का ये फैसला
कह रही हैं हर नजर, बन्दा परवर शुक्रिया
हँस के अपनी जिन्दगी में, कर लिया शामिल मुझे

आप की मंझील हूँ मैं, मेरी मंझील आप है
क्यों मैं तूफ़ान से डरू, मेरा साहिल आप है
कोई तूफानोंसे कह दे, मिल गया साहिल मुझे

पड गयी दिल पर मेरे, आप की परछईयाँ
हर तरफ बजने लगी, सेकड़ों शहनाईयां
दो जहां की आज खुशियाँ, हो गयी हासिल मुझे

READ MORE ...

How to log out of your open Gmail account remotely

It is fact that sometimes you need to access your email from different locations using public networks which is visible to anyone, using different devices like laptops, smart phones, tabs etc.

In that case you must sign out of your Gmail account remotely so that it restrict access from unauthorized access.

There are many browsers and smartphones which automatically remember password on your request like Google Chrome, Mozilla Firefox blackberry hub etc. If you are working on workplace, then situations came when you forget to logout your account safely. In that situation you must remote your account from different computer to block Gmail account from unsecured login.

Step 1: Sing in to your Gmail account from anywhere.

Step 2: On the inbox, scroll to the bottom of the interface. On the right side you will see your last account activity and a link regarding Details of all the open sessions as shown below.


                                       Last Account activity: 1 day ago
                                                                              Details

Step 3: A new window will open and show all the details about few of your login sessions.
 If your account is open at the different place, you would be shown the corresponding information.
 Simply click on, Sign out all other sessions, to remotely log out of all places you may be logged in at  Gmail-Sessions. It is always better to remember and log out of your account when you use it on a different computer.  But if you forget, Gmail has this solution



When you click on show details, it will show browser name and operating system type using which you used to log in, IP address, date and time. So it is also a batter weapons to trace the activities of your open sessions.

READ MORE ...

Dil Aisa Kisi Ne Mera Toda Lyrics - Kishore Kumar

Dil Aisa Kisi Ne Mera Toda : is a romantic hindi song from movie Amanush, released in 1975, music by shyamal and performed by Kishore Kumar.

Movie/Album : Amanush -अमानुष (1975)
Music By : Shyamal Mitra - श्यामल मित्रा
Lyrics By : Indivar - इन्दीवर
Performed By : Kishore Kumar - किशोर कुमार

=========================================

Dil Aisaa Kisine Meraa Todaa
Barbaadi Ki Taraf Aisaa Modaa -2
Ek Bhale Maanush Ko
Amaanush Banaake Chhodaa
Dil Aisaa Kisine Meraa Todaa
Barbaadi Ki Taraf Aisaa Modaa
Saagar Kitanaa Mere Paas Hai
Mere Jivan MeN Phir Bhi Pyaas Hai -2
Hai Pyaas Badi Jivan Thodaa
Amaanush Banaake Chhodaa
Kahate HaiN Ye Duniyaa Ke Raaste
Koi MaNzil NahiN Tere Vaaste -2
NaakaamiyoN Se Naataa Meraa Jodaa
Amaanush Banaake Chhodaa
Duubaa Suuraj Phir Se Nikale
Rahataa NahiN Hai ANdheraa
Meraa Suuraj Aisaa Ruuthaa
Dekhaa Na MaiNne Saveraa
UjaaloN Ne Saath Meraa Chhodaa
Amaanush Banaake Chhodaa
Dil Aisaa Kisine Meraa Todaa

===============================================
Hindi Version

दिल ऐसा किसी ने मेरा तोड़ा
बर्बादी की तरफ ऐसा मोड़ा
एक भले मानुष को
अमानुष बना के छोड़ा

सागर कितना मेरे पास है
मेरे जीवन में फिर भी प्यास है
है प्यास बड़ी जीवन थोड़ा
अमानुष बना...

कहते है ये दुनिया के रास्ते
कोई मंजिल नहीं तेरे वास्ते
नाकामियों से नाता मेरा जोड़ा
अमानुष बना...

डूबा सूरज फिर से निकले
रहता नहीं है अँधेरा
मेरा सूरज ऐसा रूठा
देखा न मैंने सवेरा
उजालों ने साथ मेरा छोड़ा
अमानुष बना...

READ MORE ...