Using the ALTER DATABASE Command

Using the ALTER DATABASE Command

Log files or log file groups can be added or modified with the ALTER DATABASE command, as shown on Day 6. I prefer the command-line utilities because they can be scripted, and as such are a permanent record that can be used over and over again. An example of how to use the ALTER DATABASE command to add a log file is shown here:

ALTER DATABASE database

ADD LOGFILE ( `log3a', `log3b' ) SIZE 10M;

To add a new log file to an already existing group, you can use this command:

ALTER DATABASE database

ADD LOGFILE MEMBER `log3c' TO GROUP 3;

If you don't know the group name, you can use the same command and specify the other members of the log file group, as in

ALTER DATABASE database

ADD LOGFILE MEMBER `log3c' TO GROUP ( `log3a', `log3b');

As I have said before, by using a SQL script and the ALTER DATABASE command, you can preserve a permanent record of the change and then use the file as a template for other, similar operations. 

Thank you

Asraful

Postal Code of Bangladesh, All Division & District.search by district or thana name or by Post Code numbe

Postal Code of Bangladesh

BARISAL :: CHITTAGONG :: DHAKA :: KHULNA :: RAJSHAHI :: SYLHET ::

*** For searching Post Code, search by district or thana name or by Post Code number.

DISTRICT     THANA     SUBOFFICE     POST CODE
Dhaka     Dhaka Main PO     Dhaka Main PO     1100
Dhaka     Dhaka GPO     Dhaka GPO     1000
Dhaka     Demra     Matuail     1362
Dhaka     Demra     Sarulia     1361
Dhaka     Demra     Demra     1360
Dhaka     Dhaka Sadar     Wari TSO     1203
Dhaka     Dhaka Sadar     Gendaria TSO     1204
Dhaka     Dhaka Sadar     New Market TSO     1205
Dhaka     Dhaka Sadar     Dhaka CantonmentTSO     1206
Dhaka     Dhaka Sadar     Mohammadpur Housing     1207
Dhaka     Dhaka Sadar     Dhaka Politechnic     1208
Dhaka     Dhaka Sadar     Jigatala TSO     1209
Dhaka     Dhaka Sadar     Posta TSO     1211
Dhaka     Dhaka Sadar     Gulshan Model Town     1212
Dhaka     Dhaka Sadar     Banani TSO     1213
Dhaka     Dhaka Sadar     Basabo TSO     1214
Dhaka     Dhaka Sadar     Tejgaon TSO     1215
Dhaka     Dhaka Sadar     Shantinagr TSO     1217
Dhaka     Dhaka Sadar     Mirpur TSO     1218
Dhaka     Dhaka Sadar     KhilgaonTSO     1219
Dhaka     Dhaka Sadar     BangabhabanTSO     1222
Dhaka     Dhaka Sadar     DilkushaTSO     1223
Dhaka     Dhaka Sadar     Sangsad BhabanTSO     1225
Dhaka     Dhaka Sadar     KhilkhetTSO     1229
Dhaka     Dhaka Sadar     Uttara Model TwonTSO     1231
Dhaka     Dhaka Sadar     Dhania TSO     1232
Dhaka     Dhamrai     Dhamrai     1350
Dhaka     Dhamrai     Kamalpur     1351
Dhaka     Joypara     Joypara     1330
Dhaka     Joypara     Palamganj     1331
Dhaka     Joypara     Narisha     1332
Dhaka     Keraniganj     Keraniganj     1310
Dhaka     Keraniganj     Dhaka Jute Mills     1311
Dhaka     Keraniganj     Ati     1312
Dhaka     Keraniganj     Kalatia     1313
Dhaka     Nawabganj     Nawabganj     1320
Dhaka     Nawabganj     Hasnabad     1321
Dhaka     Nawabganj     Daudpur     1322
Dhaka     Nawabganj     Agla     1323
Dhaka     Nawabganj     Khalpar     1324
Dhaka     Nawabganj     Churain     1325
Dhaka     Savar     Savar     1340
Dhaka     Savar     Dairy Farm     1341
Dhaka     Savar     Jahangirnagar Univer     1342
Dhaka     Savar     Saver P.A.T.C     1343
Dhaka     Savar     Savar Canttonment     1344
Dhaka     Savar     Shimulia     1345
Dhaka     Savar     Kashem Cotton Mills     1346
Dhaka     Savar     Rajphulbaria     1347
Dhaka     Savar     Amin Bazar     1348
Dhaka     Savar     EPZ     1349
Faridpur     Alfadanga     Alfadanga     7870
Faridpur     Bhanga     Bhanga     7830
Faridpur     Boalmari     Boalmari     7860
Faridpur     Boalmari     Rupatpat     7861
Faridpur     Charbhadrasan     Charbadrashan     7810
Faridpur     Faridpur Sadar     Faridpursadar     7800
Faridpur     Faridpur Sadar     Kanaipur     7801
Faridpur     Faridpur Sadar     Ambikapur     7802
Faridpur     Faridpur Sadar     Baitulaman Politecni     7803
Faridpur     Madukhali     Madukhali     7850
Faridpur     Madukhali     Kamarkali     7851
Faridpur     Nagarkanda     Nagarkanda     7840
Faridpur     Nagarkanda     Talma     7841
Faridpur     Sadarpur     Sadarpur     7820
Faridpur     Sadarpur     Hat Krishapur     7821
Faridpur     Sadarpur     Bishwa jaker Manjil     7822
Faridpur     Shriangan     Shriangan     7804
Gazipur     Gazipur Sadar     Gazipur Sadar     1700
Gazipur     Gazipur Sadar     B.R.R     1701
Gazipur     Gazipur Sadar     Chandna     1702
Gazipur     Gazipur Sadar     B.O.F     1703
Gazipur     Gazipur Sadar     National University     1704
Gazipur     Kaliakaar     Kaliakaar     1750
Gazipur     Kaliakaar     Safipur     1751
Gazipur     Kaliganj     Kaliganj     1720
Gazipur     Kaliganj     Pubail     1721
Gazipur     Kaliganj     Santanpara     1722
Gazipur     Kaliganj     Vaoal Jamalpur     1723
Gazipur     Kapashia     kapashia     1730
Gazipur     Monnunagar     Monnunagar     1710
Gazipur     Monnunagar     Nishat Nagar     1711
Gazipur     Monnunagar     Ershad Nagar     1712
Gazipur     Shipur     Shipur     1740
Gazipur     Shipur     Barmi     1743
Gazipur     Shipur     Satkhamair     1744
Gazipur     Shipur     Kawraid     1745
Gazipur     Shipur     Bashamur     1747
Gazipur     Shipur     Boubi     1748
Gazipur     Sripur     Rajendrapur     1741
Gazipur     Sripur     Rajendrapur Canttome     1742
Gopalganj     Gopalganj Sadar     Chandradighalia     8013
Gopalganj     Gopalganj Sadar     Gopalganj Sadar     8100
Gopalganj     Gopalganj Sadar     Ulpur     8101
Gopalganj     Gopalganj Sadar     Barfa     8102
Gopalganj     Kashiani     Kashiani     8130
Gopalganj     Kashiani     Ramdia College     8131
Gopalganj     Kashiani     Ratoil     8132
Gopalganj     Kashiani     Jonapur     8133
Gopalganj     Kotalipara     Kotalipara     8110
Gopalganj     Maksudpur     Maksudpur     8140
Gopalganj     Maksudpur     Batkiamari     8141
Gopalganj     Maksudpur     Khandarpara     8142
Gopalganj     Tungipara     Tungipara     8120
Gopalganj     Tungipara     Patgati     8121
Jamalpur     Dewangonj     Dewangonj     2030
Jamalpur     Dewangonj     Dewangonj S. Mills     2031
Jamalpur     Islampur     Islampur     2020
Jamalpur     Islampur     Durmoot     2021
Jamalpur     Islampur     Gilabari     2022
Jamalpur     Jamalpur     Jamalpur     2000
Jamalpur     Jamalpur     Nandina     2001
Jamalpur     Jamalpur     Narundi     2002
Jamalpur     Malandah     Malandah     2010
Jamalpur     Malandah     Jamalpur     2011
Jamalpur     Malandah     Malancha     2012
Jamalpur     Malandah     Mahmoodpur     2013
Jamalpur     Mathargonj     Mathargonj     2040
Jamalpur     Mathargonj     Balijhuri     2041
Jamalpur     Shorishabari     Shorishabari     2050
Jamalpur     Shorishabari     Gunerbari     2051
Jamalpur     Shorishabari     Bausee     2052
Jamalpur     Shorishabari     Jagannath Ghat     2053
Jamalpur     Shorishabari     Pingna     2054
Jamalpur     Shorishabari     Jamuna Sar Karkhana     2055
Kishoreganj     Bajitpur     Bajitpur     2336
Kishoreganj     Bajitpur     Sararchar     2337
Kishoreganj     Bajitpur     Laksmipur     2338
Kishoreganj     Bhairob     Bhairab     2350
Kishoreganj     Hossenpur     Hossenpur     2320
Kishoreganj     Itna     Itna     2390
Kishoreganj     Karimganj     Karimganj     2310
Kishoreganj     Katiadi     Katiadi     2330
Kishoreganj     Katiadi     Gochhihata     2331
Kishoreganj     Kishoreganj Sadar     Kishoreganj Sadar     2300
Kishoreganj     Kishoreganj Sadar     Kishoreganj S.Mills     2301
Kishoreganj     Kishoreganj Sadar     Maizhati     2302
Kishoreganj     Kishoreganj Sadar     Nilganj     2303
Kishoreganj     Kuliarchar     Kuliarchar     2340
Kishoreganj     Kuliarchar     Chhoysuti     2341
Kishoreganj     Mithamoin     MIthamoin     2370
Kishoreganj     Mithamoin     Abdullahpur     2371
Kishoreganj     Nikli     Nikli     2360
Kishoreganj     Ostagram     Ostagram     2380
Kishoreganj     Pakundia     Pakundia     2326
Kishoreganj     Tarial     Tarial     2316
Madaripur     Barhamganj     Barhamganj     7930
Madaripur     Barhamganj     Nilaksmibandar     7931
Madaripur     Barhamganj     Bahadurpur     7932
Madaripur     Barhamganj     Umedpur     7933
Madaripur     kalkini     Kalkini     7920
Madaripur     kalkini     Sahabrampur     7921
Madaripur     Madaripur Sadar     Madaripur Sadar     7900
Madaripur     Madaripur Sadar     Charmugria     7901
Madaripur     Madaripur Sadar     Kulpaddi     7902
Madaripur     Madaripur Sadar     Habiganj     7903
Madaripur     Madaripur Sadar     Mustafapur     7904
Madaripur     Rajoir     Rajoir     7910
Madaripur     Rajoir     Khalia     7911
Manikganj     Doulatpur     Doulatpur     1860
Manikganj     Gheor     Gheor     1840
Manikganj     Lechhraganj     Lechhraganj     1830
Manikganj     Lechhraganj     Jhitka     1831
Manikganj     Manikganj Sadar     Manikganj Sadar     1800
Manikganj     Manikganj Sadar     Manikganj Bazar     1801
Manikganj     Manikganj Sadar     Gorpara     1802
Manikganj     Manikganj Sadar     Mahadebpur     1803
Manikganj     Manikganj Sadar     Barangail     1804
Manikganj     Saturia     Saturia     1810
Manikganj     Saturia     Baliati     1811
Manikganj     Shibloya     Shibaloy     1850
Manikganj     Shibloya     Aricha     1851
Manikganj     Shibloya     Tewta     1852
Manikganj     Shibloya     Uthli     1853
Manikganj     Singari     Singair     1820
Manikganj     Singari     Baira     1821
Manikganj     Singari     joymantop     1822
Munshiganj     Gajaria     Gajaria     1510
Munshiganj     Gajaria     Hossendi     1511
Munshiganj     Gajaria     Rasulpur     1512
Munshiganj     Lohajong     Haridia     1333
Munshiganj     Lohajong     Gouragonj     1334
Munshiganj     Lohajong     Madini Mandal     1335
Munshiganj     Lohajong     Lohajang     1530
Munshiganj     Lohajong     Korhati     1531
Munshiganj     Lohajong     Haldia SO     1532
Munshiganj     Lohajong     Haridia DESO     1533
Munshiganj     Lohajong     Gouragonj     1534
Munshiganj     Lohajong     Medini Mandal EDSO     1535
Munshiganj     Munshiganj Sadar     Munshiganj Sadar     1500
Munshiganj     Munshiganj Sadar     Rikabibazar     1501
Munshiganj     Munshiganj Sadar     Mirkadim     1502
Munshiganj     Munshiganj Sadar     Kathakhali     1503
Munshiganj     Sirajdikhan     Sirajdikhan     1540
Munshiganj     Sirajdikhan     Kola     1541
Munshiganj     Sirajdikhan     Ichapur     1542
Munshiganj     Sirajdikhan     Malkha Nagar     1543
Munshiganj     Sirajdikhan     Shekher Nagar     1544
Munshiganj     Srinagar     Srinagar     1550
Munshiganj     Srinagar     Barikhal     1551
Munshiganj     Srinagar     Mazpara     1552
Munshiganj     Srinagar     Hashara     1553
Munshiganj     Srinagar     Kolapara     1554
Munshiganj     Srinagar     Kumarbhog     1555
Munshiganj     Srinagar     Vaggyakul SO     1556
Munshiganj     Srinagar     Baghra     1557
Munshiganj     Srinagar     Bhaggyakul     1558
Munshiganj     Tangibari     Tangibari     1520
Munshiganj     Tangibari     Betkahat     1521
Munshiganj     Tangibari     Baligao     1522
Munshiganj     Tangibari     Bajrajugini     1523
Munshiganj     Tangibari     Hasail     1524
Munshiganj     Tangibari     Dighirpar     1525
Munshiganj     Tangibari     Pura EDSO     1526
Munshiganj     Tangibari     Pura     1527
Mymensingh     Bhaluka     Bhaluka     2240
Mymensingh     Fulbaria     Fulbaria     2216
Mymensingh     Gaforgaon     Gaforgaon     2230
Mymensingh     Gaforgaon     Shibganj     2231
Mymensingh     Gaforgaon     Usti     2232
Mymensingh     Gaforgaon     Kandipara     2233
Mymensingh     Gaforgaon     Duttarbazar     2234
Mymensingh     Gouripur     Gouripur     2270
Mymensingh     Gouripur     Ramgopalpur     2271
Mymensingh     Haluaghat     Haluaghat     2260
Mymensingh     Haluaghat     Dhara     2261
Mymensingh     Haluaghat     Munshirhat     2262
Mymensingh     Isshwargonj     Isshwargonj     2280
Mymensingh     Isshwargonj     Sohagi     2281
Mymensingh     Isshwargonj     Atharabari     2282
Mymensingh     Muktagachha     Muktagachha     2210
Mymensingh     Mymensingh Sadar     Mymensingh Sadar     2200
Mymensingh     Mymensingh Sadar     Kawatkhali     2201
Mymensingh     Mymensingh Sadar     Agriculture Universi     2202
Mymensingh     Mymensingh Sadar     Shombhuganj     2203
Mymensingh     Mymensingh Sadar     Biddyaganj     2204
Mymensingh     Mymensingh Sadar     Pearpur     2205
Mymensingh     Nandail     Nandail     2290
Mymensingh     Nandail     Gangail     2291
Mymensingh     Phulpur     Phulpur     2250
Mymensingh     Phulpur     Beltia     2251
Mymensingh     Phulpur     Tarakanda     2252
Mymensingh     Trishal     Trishal     2220
Mymensingh     Trishal     Ahmadbad     2221
Mymensingh     Trishal     Ram Amritaganj     2222
Mymensingh     Trishal     Dhala     2223
Narayanganj     Araihazar     Araihazar     1450
Narayanganj     Araihazar     Gopaldi     1451
Narayanganj     Baidder Bazar     Baidder Bazar     1440
Narayanganj     Baidder Bazar     Bara Nagar     1441
Narayanganj     Baidder Bazar     Barodi     1442
Narayanganj     Bandar     Bandar     1410
Narayanganj     Bandar     D.C Mills     1411
Narayanganj     Bandar     Nabiganj     1412
Narayanganj     Bandar     BIDS     1413
Narayanganj     Bandar     Madanganj     1414
Narayanganj     Fatullah     Fatullah     1420
Narayanganj     Fatullah     Fatulla Bazar     1421
Narayanganj     Narayanganj Sadar     Narayanganj Sadar     1400
Narayanganj     Rupganj     Rupganj     1460
Narayanganj     Rupganj     Kanchan     1461
Narayanganj     Rupganj     Bhulta     1462
Narayanganj     Rupganj     Nagri     1463
Narayanganj     Rupganj     Murapara     1464
Narayanganj     Siddirganj     Siddirganj     1430
Narayanganj     Siddirganj     Adamjeenagar     1431
Narayanganj     Siddirganj     LN Mills     1432
Narshingdi     Belabo     Belabo     1640
Narshingdi     Monohordi     Monohordi     1650
Narshingdi     Monohordi     Hatirdia     1651
Narshingdi     Monohordi     Katabaria     1652
Narshingdi     Narshingdi Sadar     Narshingdi Sadar     1600
Narshingdi     Narshingdi Sadar     UMC Jute Mills     1601
Narshingdi     Narshingdi Sadar     Narshingdi College     1602
Narshingdi     Narshingdi Sadar     Panchdona     1603
Narshingdi     Narshingdi Sadar     Madhabdi     1604
Narshingdi     Narshingdi Sadar     Karimpur     1605
Narshingdi     Palash     Palash     1610
Narshingdi     Palash     Ghorashal Urea Facto     1611
Narshingdi     Palash     Char Sindhur     1612
Narshingdi     Palash     Ghorashal     1613
Narshingdi     Raypura     Raypura     1630
Narshingdi     Raypura     Bazar Hasnabad     1631
Narshingdi     Raypura     Radhaganj bazar     1632
Narshingdi     Shibpur     Shibpur     1620
Netrakona     Susung Durgapur     IBH WAs Here     $mart
Netrakona     Susung Durgapur     Susnng Durgapur     2420
Netrakona     Atpara     Atpara     2470
Netrakona     Barhatta     Barhatta     2440
Netrakona     Dharmapasha     Dharampasha     2450
Netrakona     Dhobaura     Dhobaura     2416
Netrakona     Dhobaura     Sakoai     2417
Netrakona     Kalmakanda     Kalmakanda     2430
Netrakona     Kendua     Kendua     2480
Netrakona     Khaliajuri     Khaliajhri     2460
Netrakona     Khaliajuri     Shaldigha     2462
Netrakona     Madan     Madan     2490
Netrakona     Moddhynagar     Moddoynagar     2456
Netrakona     Mohanganj     Mohanganj     2446
Netrakona     Netrakona Sadar     Netrakona Sadar     2400
Netrakona     Netrakona Sadar     Baikherhati     2401
Netrakona     Purbadhola     Purbadhola     2410
Netrakona     Purbadhola     Shamgonj     2411
Netrakona     Purbadhola     Jaria Jhanjhail     2412
Rajbari     Baliakandi     Baliakandi     7730
Rajbari     Baliakandi     Nalia     7731
Rajbari     Pangsha     Pangsha     7720
Rajbari     Pangsha     Ramkol     7721
Rajbari     Pangsha     Ratandia     7722
Rajbari     Pangsha     Mrigibazar     7723
Rajbari     Rajbari Sadar     Rajbari Sadar     7700
Rajbari     Rajbari Sadar     Goalanda     7710
Rajbari     Rajbari Sadar     Khankhanapur     7711
Shariatpur     Bhedorganj     Bhedorganj     8030
Shariatpur     Damudhya     Damudhya     8040
Shariatpur     Gosairhat     Gosairhat     8050
Shariatpur     Jajira     Jajira     8010
Shariatpur     Naria     Naria     8020
Shariatpur     Naria     Bhozeshwar     8021
Shariatpur     Naria     Gharisar     8022
Shariatpur     Naria     Upshi     8023
Shariatpur     Naria     Kartikpur     8024
Shariatpur     Shariatpur Sadar     Shariatpur Sadar     8000
Shariatpur     Shariatpur Sadar     Angaria     8001
Shariatpur     Shariatpur Sadar     Chikandi     8002
Sherpur     Bakshigonj     Bakshigonj     2140
Sherpur     Jhinaigati     Jhinaigati     2120
Sherpur     Nakla     Nakla     2150
Sherpur     Nakla     Gonopaddi     2151
Sherpur     Nalitabari     Nalitabari     2110
Sherpur     Nalitabari     Hatibandha     2111
Sherpur     Sherpur Shadar     Sherpur Shadar     2100
Sherpur     Shribardi     Shribardi     2130
Tangail     Basail     Basail     1920
Tangail     Bhuapur     Bhuapur     1960
Tangail     Delduar     Delduar     1910
Tangail     Delduar     Jangalia     1911
Tangail     Delduar     Patharail     1912
Tangail     Delduar     Elasin     1913
Tangail     Delduar     Hinga Nagar     1914
Tangail     Delduar     Lowhati     1915
Tangail     Ghatail     Ghatial     1980
Tangail     Ghatail     Zahidganj     1981
Tangail     Ghatail     D. Pakutia     1982
Tangail     Ghatail     Dhalapara     1983
Tangail     Ghatail     Lohani     1984
Tangail     Gopalpur     Gopalpur     1990
Tangail     Gopalpur     Jhowail     1991
Tangail     Gopalpur     Hemnagar     1992
Tangail     Kalihati     Kalihati     1970
Tangail     Kalihati     Rajafair     1971
Tangail     Kalihati     Nagbari     1972
Tangail     Kalihati     Ballabazar     1973
Tangail     Kalihati     Elinga     1974
Tangail     Kalihati     Palisha     1975
Tangail     Kalihati     Nagarbari SO     1976
Tangail     Kalihati     Nagarbari     1977
Tangail     Kashkaolia     Kashkawlia     1930
Tangail     Madhupur     Madhupur     1996
Tangail     Madhupur     Dhobari     1997
Tangail     Mirzapur     Mirzapur     1940
Tangail     Mirzapur     Gorai     1941
Tangail     Mirzapur     M.C. College     1942
Tangail     Mirzapur     Warri paikpara     1943
Tangail     Mirzapur     Jarmuki     1944
Tangail     Mirzapur     Mohera     1945
Tangail     Nagarpur     Nagarpur     1936
Tangail     Nagarpur     Dhuburia     1937
Tangail     Nagarpur     Salimabad     1938
Tangail     Sakhipur     Sakhipur     1950
Tangail     Sakhipur     Kochua     1951
Tangail     Tangail Sadar     Tangail Sadar     1900
Tangail     Tangail Sadar     Kagmari     1901
Tangail     Tangail Sadar     Santosh     1902
Tangail     Tangail Sadar     Korotia     1903
Tangail     Tangail Sadar     Purabari     1904

Thank you
Asraful

Administering Redo Logs, Control Files, and Rollback Segments

In the last few days you saw how to create a database and how to add datafiles and tablespaces to customize that database for your own use. Remember, the instance is made up of the files used by Oracle, the processes or threads, and the memory used by Oracle. The files used by the database are made up of the following:

• The datafiles. These are the actual files that are used to store tablespaces.
• The redo log files (sometimes just known as the redo log). This is where all redo information is kept. Without the redo log files you would not be able to recover from a system failure.
• The control files. These files contain information vital to the Oracle database. The information that is used to tell the instance where the datafiles and log files reside is stored in the control file.
• The parameter file. This file contains tuning information that is used by Oracle at startup. This is commonly referred to as the init.ora file.

There are also the RDBMS binaries and other files such as backup files, archive log files, and so on, but they are not really part of the database itself, even though they are essential to the RDBMS.

As you saw on Day 7, "Administering Tablespaces," a tablespace can hold four different types of segments:

• Data segment--Used to hold tables and clusters
• Index segment--Used to hold indexes
• Rollback segment--Special types of segments that are used to store undo information
• Temporary segment--Used for storing temporary data

Today you will look at the rollback segments. Data segments, index segments, and temp-orary segments are covered on Days 12-15. The rollback segment is not only important to the basic function of the Oracle RDBMS, but it has performance implications as well.

Redo Log Files

The redo log files are used to store redo information. Each time data is changed in the database, a log record is written describing the change(s). With this information the database can be recovered in the event of a system failure.

If a catastrophic system failure occurs, such as a power failure, component failure, or similar occurrence, the Oracle instance will be aborted. The instance will be cut off immediately or, in the event of a disk failure, the instance might crash. If this occurs, all changed data in the buffer cache will be lost; only changes that have been written out to disk will be saved.

New Term: When Oracle is restarted, the information in the redo log file will be used to reproduce changes that have been made to the database, thus saving as much work as possible. All previously committed transactions will be recovered; this is also known as being rolled forward. All transactions that had modified data but had not been committed will be backed out; this is known as rolling back.

The redo log file is necessary for proper recovery. If this file is lost due to a disk failure, you will not be able to recover in the event of a system failure; therefore, you must protect the redo log file against this kind of failure. I recommend you use disk mirroring or RAID-1 on all redo log files.

Because the redo log files are so critical to the recoverability of the system, it is recommended that you do not use a caching disk controller with write-caching unless that cache is backed up with a battery. In the event of a power failure, you must make sure that no redo information is lost. It is often recommended that write-caching not be used at all on the redo log, but I feel that if you have a battery back-up your risk is reduced.

---

WARNING: If you use a write-caching on the controller that has the redo log files and it is not backed up with a battery, you are in danger of losing data. In the event of a power failure, you will lose redo information and might not be able to recover. 

Thank you

Asraful

Regent Airways Bangladesh & Regent Flight Schedule

Regent Airways (HG Aviation Limited) is a private airline in Bangladesh. It is fully-owned subsidiary of Habib Group which is a Chittagong-based conglomerate in business since 1947. At present regent airlines fleet consists of Canadian-built Bombardier Dash-8-Q300 aircrafts. It operates domestic flights daily from Dhaka to Chittagong and other local destinations.

Fares to Fly By
Dhaka to Chittagong - From BDT 4000
Dhaka to Cox's Bazar - From BDT 5000
Dhaka to Jessore - From BDT 2500
Chittagong To Dhaka - From BDT 4000
Dhaka to Sylhet - From BDT 3200

Regent Airways contact address:
HG Aviation Ltd.
Level-7, Siaam Tower
Plot: 15, Dhaka Mymensingh Road, Sector: 3
Uttara Model Town, Dhaka-1230

Website: www.flyregent.com

Hunting Number: +88028953003

Flight	Day	Departure Time	Arrival Time
Dhaka to Kualalumpur
RX782	Daily	2000 DAC LT	0155 KUL LT
Kualalumpur to Dhaka
RX783	Daily	0245 KUL LT	0440 DAC LT
Dhaka to Bangkok
RX780	MON/WED/FRI/SUN	1030 DAC LT	1345 BKK LT
Bangkok to Dhaka
RX781	MON/WED/FRI/SUN	1500 BKK LT	1625 DAC LT
Dhaka to Singapore
RX784	MON/TUE/THU/FRI/SAT	1220 DAC LT	1835 SIN LT
Singapore to Dhaka
RX785	MON/TUE/THU/FRI/SAT	1925 SIN LT	2140 DAC LT
Dhaka to Kolkata
RX791	Daily	0830 DAC LT	0900 CCU LT
Kolkata to Dhaka
RX792	Daily	0940 CCU LT	1110 DAC LT
Chittagong to Kolkata
RX797	TUE/FRI/SUN	1020 DAC LT	1100 CCU LT
Kolkata to Chittagong
RX798	TUE/FRI/SUN	1130 CCU LT	1310 DAC LT

Flight	Day	Departure Time	Arrival Time
Dhaka to Chittagong
RX711	Daily	0730	0815
RX713	Daily	0900	0950
RX715	Daily	1530	1620
RX717	Daily	1810	1900
RX719	Daily	2040	2130
Chittagong to Dhaka
RX712	Daily	0845	0930
RX714	Daily	1010	1100
RX716	Daily	1640	1730
RX718	Daily	1920	2010
RX720	Daily	2150	2240
Dhaka to Sylhet
RX731	Daily	1640	1725
Sylhet to Dhaka
RX732	Daily	1745	1830
Dhaka to Cox's Bazaar
RX741	Daily	1350	1450
Coxs Bazaar to Dhaka
RX742	Daily	1510	1610
Dhaka to Jessore
RX761	Daily	1140	1220
RX763	Daily	1900	1940
Jessore to Dhaka
RX762	Daily	1240	1320
RX764	Daily	2000	2040

 Thank you
Asraful

Teletalk Youth 3G Internet Package Details in Bangladesh

Teletalk Youth 3G Internet Package Details in Bangladesh
http://www.teletalk.com.bd/services/youth_package_2013.php


Teletalk youth 3g package (prepaid) brings a new update for its users. Teletalk Bangladesh Limited has brings this offer first, so that it's all of the subscribers can use high-speed data within a very short time and can enjoy internet with comfortably.With the help  of Teletalk youth 3g prepaid package , all customers can use it for video calling with his/her friends and family can download any kinds of videos, audio, files, and images with minimum speed of 512 Kbps.
That is obviously a piece of good news for all of the  Teletalk youth 3g prepaid package users. If you have no Teletalk youth 3g prepaid SIM Card then you can Purchases Teletalk youth 3g prepaid SIM-only @  129Tk from any Teletalk Bangladesh Limited customer care or their permitted representative.
If you want to know what is 3g network then you can see our another article about 3g,3.5g and 3.75 so dear reader,

Today's 2G, 3G has expired technology in the world, One the other hand, Our country 4G services able and upcoming 5G technology. Bangladesh government

Embassy of the People's Republic of Bangladesh and Prerequisites for Bangladesh Visa

Prerequisites for Bangladesh Visa

For Tourism: It requires hotel booking & confirmation of air ticket, 3 passport size photograph and NOC of your sponsor along with the filled in visa application form.

For Business/to Attend Seminar/conference: It requires hotel booking & confirmation of air ticket, 3 passport size photograph, invitation letter from the host in Bangladesh (Company/University, etc.) and NOC of your sponsor along with the filled in visa application form.

For Recruitment of Bangladeshi Manpower: It requires photo copy of demand letter attested from this Embassy, 3 passport size photograph, invitation letter from the host in Bangladesh (Recruiting Agency) and no objection letter from concerned company of UAE along with the filled in visa application form. 

Visa processing time depends on Nationality. (It takes minimum 2 & maximum 15 working days.)

Visa Application Form

How to Create webmail account and help for webmail.

 Instructions

        1.        Decide which type of Web mail account you want to open. Popular Web mail services include Yahoo!, Gmail, Hotmail, Comcast and Excite. Evaluate each service depending on its SPAM options (how does the service determine what is SPAM and how is it routed?), virus-checking abilities (for instance, does the system check attachments for viruses?), server reliability, and storage limits (some sites such as Yahoo and Gmail offer unlimited storage).
       

    2.    Click "Register," "Sign Up" or something similar to start the registration process. Fill in pertinent information, including your name, birth date, ZIP code, and desired user name and password. You will most likely be asked to create a security question. This is so you can retrieve your password and account information if you lose it.

3. Select an appropriate role (e.g. "Student Using Student ID").
4. Click on PROCEED TO NEXT STEP.


5. After reading the Acceptable Use Policy click on I ACCEPT.



6. Fill in appropriate information and click PROCEED TO NEXT STEP.

• Be sure to use a four-digit birth year.
• Do not use hyphens when entering your Social Security number.
• If you are having trouble being validated, technical support can be obtained by telephone at 973-443-8822 and by e-mail to FDUTAC@fdu.edu. It is possible that the system may not have middle initial entered or may have an incorrect birth date.

7. You may be required to select a PRIMARY E-MAIL ADDRESS from the two choices provided. The choices will be based on your name, as entered in FDU's database, with and without your middle initial (e.g. albert_einstein@student.fdu.edu, or albert_x_einstein@student.fdu.edu).

8. You will be required to create a LOGIN NAME. This login name must be 2-8 characters in length using only letters (a-z), numbers (0-9), and underscore followed by @student.fdu.edu (e.g. einstein@student.fdu.edu). This Login Name cannot be changed once it is created. You will use this Login Name to access your e-mail using the web interface. E-mail can be sent to this address as well as your Primary E-mail address.

9. You will be required to enter and re-enter a PASSWORD that is 6-8 characters in length.

10. You will need to provide a SECRET QUESTION and ANSWER that will be used for verification if you forget your password.

11. Click on PROCEED TO NEXT STEP.

12. You will be required to enter additional personal information. Fields marked with a red asterisk are mandatory. Click on PROCEED TO NEXT STEP.

13. Be sure to print or copy down your e-mail addresses. Click OK.

Note: E-mail can be addressed to either your PRIMARY E-MAIL ADDRESS (e.g. albert_einstein@student.fdu.edu) or your LOGIN NAME (e.g. Einstein@student.fdu.edu).
Help: There are a number of resources available on-line at http://webdocs.fdu.edu/. This site contains information about the new mail system, including how to create and maintain your account, the different methods of accessing the system, and the benefits of each of these different methods.
After you access your mailbox, a HELP button is also available with information on using the Webmail interface.
Additional technical support can be obtained by telephone at 973-443-8822 and by e-mail at fdutac@fdu.edu.

Thank you
Asraful 

3G Pack Tariff Table and 3G packs.

• http://bd.airtel.com/commonpage.php?cat_id=179
•  Price ratio of 2G and 3G packs are similar upto 500 MB pack.
• 1mbps speed for all packs.
• Auto renewal applicable for all packs. To stop auto renewal of any pack, type "3GOFF" and send SMS to 5000.
• Once the pack volume gets consumed within the validity period, further usage will be charged as Tk. 0.01/10KB. Customers will be notified about their pack consumption.
• All packs can be purchased through USSD, SMS, and IVR. Regular USSD dialing number is *121*7# for all airtel internet packs. Informative IVR Number: 1212.
• Pay As You Go Tariff is Tk. 0.01/Kilo Byte. This applies if customer does not have a 3G pack, but activates only 3G services for video calling. Only 3G service can be activated by typing “START3G" and send SMS to 5000. To stop 3G service, type "STOP3G" and send SMS to 5000.
• A customer can use maximum 10 Mega Bytes of internet under Pay As You Go tariff plan.
• Promotional Video Call Tariff: Tk. 1/min (10 second pulse)
• To make a video call, both caller and called party must be under 3G coverage area and must use 3G Video Call capable handset.
• Purchase of any 3G pack will activate 3G services for customers; this will enable Video Calling unless customer opts out from 3G.
• Speed that a customer gets will depend on his or her place of usage and the device used.
• 3G Pack Tariff Table:

Pack	Validity	Price	USSD Direct Dial	SMS Keyword
15 MB	3 days	15	*121*5001#	15MB
30 MB	7 days	30	*121*5002#	30MB
50 MB	7 days	50	*121*5003#	50MB
250 MB	7 days	100	*121*5011#	250MB
500 MB	15 days	200	*121*5014#	500MB
1 GB	30 days	350	*121*5020#	1GB
5 GB	30 days	950	*121*5030#	5GB

 15% VAT Applicable

Thank you
Asraful

What is shower gel used for? how to use it.

 Shower gel is really easy to use! Drop about a quarter size of the gel into a wash sponge or on a wash cloth. Then all you need to do is lather your body. Rinse when done.

Body wash, also commonly known as shower gel, is a pretty recent newcomer to the field of spa products.  Body wash is a generic term for liquid soap used to clean the body during a shower.  Many people wonder why one would purchase body wash when one could just use soap instead.  The reason that body washes are so popular is that they offer quite a number of convenient benefits over soap, and have a wide variety of applications, as well!

Ease of Use

The number one benefit of using body wash over shower gels is neatness and ease of use.  Soap can be slippery, can fall apart on you, and often leaves a lot of difficult to remove residue in your soap dish.  It can also be difficult to lather soap to the point that you feel really clean.  Body wash, on the other hand, comes packaged in a bottle, so it is easy to use exactly the amount you want without leaving any mess.  The best way to apply a body wash is to use a body sponge or pouf, which you can purchase for a dollar or two at any drug store.  Just pour a little bit of body wash on to the pouf to create a rich lather which you can use to wash yourself all over.  This method has the added benefit of being extremely exfoliating!

Versatility

Another benefit of using body wash is its versatility.  If you are using a natural body wash that foams well, you can even use it to wash your hair!  This is not recommended for every day use, but can come in handy on a vacation when you don't want to have to bring a bunch of separate bottles in order to have a nice shower!  Some body washes actually seem to work better as shampoos than certain products labeled as shampoos.  However, only do this with natural body washes that do not contain loads of synthetic chemicals, or you may dry your hair our.

The versatility of body wash does not end there.  Many natural body washes can be used as a lovely foaming bubble bath.  You can even use body wash as a beautifully scented hand soap, although it will probably be a bit expensive.

Sugar Scrub

Body wash can even be used to make a luxurious sugar scrub!  Sugar scrubs are moisturizing and exfoliating and cleanse away dry, dead skin, especially in wintertime.  Many shops charge incredible amounts of money for sugar scrubs.  Instead of spending all that money, try using the following recipe:  Take about 3 cups of turbandino or regular table sugar, 1/4 cups of sweet almond or other lightly scented carrier oil, 1/4 cup of jojoba oil (or more, if the sugar is not saturated with oil), and two or three teaspoons of your favorite shower gel.  Blend everything together and you will have an amazing, moisturizing sugar scrub at a very low price!


Here at Spiritual Scents we offer a wide variety of luxurious body washes formulated from all-organic, non-synthetic formulas.  They are delicately perfumed with beautiful essential oils and moisturize and nourish the skin.  Our Zen Shower Gel line also contains jojoba oil, Vitamin A, D & E, as well as chamomile extract for a healing, moisturizing aromatherapeutic experience. There are a vast variety of natural body washes to choose from, so you will be certain to find the scent that you like the best.  Try to look for a body wash that contains moisturizing oils and healing plant essences so that every time you use your body wash, your body and mind will be healed and refreshed!

JavaScript RegExp Tester Source Code

 JavaScript RegExp Tester Source Code

<SCRIPT LANGUAGE="JavaScript"><!--
function demoMatchClick() {
  var re = new RegExp(document.demoMatch.regex.value);
  if (document.demoMatch.subject.value.match(re)) {
    alert("Successful match");
  } else {
    alert("No match");
  }
}

function demoShowMatchClick() {
  var re = new RegExp(document.demoMatch.regex.value);
  var m = re.exec(document.demoMatch.subject.value);
  if (m == null) {
    alert("No match");
  } else {
    var s = "Match at position " + m.index + ":\n";
    for (i = 0; i < m.length; i++) {
      s = s + m[i] + "\n";
    }
    alert(s);
  }
}

function demoReplaceClick() {
  var re = new RegExp(document.demoMatch.regex.value, "g");
  document.demoMatch.result.value = 
    document.demoMatch.subject.value.replace(re, 
      document.demoMatch.replacement.value);
}
// -->
</SCRIPT>

<FORM ID="demoMatch" NAME="demoMatch" METHOD=POST ACTION="javascript:void(0)">
<P>Regexp: <INPUT TYPE=TEXT NAME="regex" VALUE="\bt[a-z]+\b" SIZE=50></P>
<P>Subject string: <INPUT TYPE=TEXT NAME="subject" 
   VALUE="This is a test of the JavaScript RegExp object" SIZE=50></P>
<P><INPUT TYPE=SUBMIT VALUE="Test Match" ONCLICK="demoMatchClick()">
<INPUT TYPE=SUBMIT VALUE="Show Match" ONCLICK="demoShowMatchClick()"></P>

<P>Replacement text: <INPUT TYPE=TEXT NAME="replacement" VALUE="replaced" SIZE=50></P>
<P>Result: <INPUT TYPE=TEXT NAME="result" 
   VALUE="click the button to see the result" SIZE=50></P>
<P><INPUT TYPE=SUBMIT VALUE="Replace" ONCLICK="demoReplaceClick()"></P>
</FORM>