Dropping Oracle Database 11g Manually with Drop Database Statement

By -

Comments

  1. sheela rajesh18 March 2019 at 15:13

    good work done and keep update more.i like your information's and that is very much useful for readers.
    Python Training in Chennai
    Python Training in Tambaram
    Big data training in chennai
    JAVA Training in Chennai
    Software testing training in chennai
    Python Training in Chennai
    Python Course in Chennai

    ReplyDelete
  2. Chris Hemsworth12 August 2019 at 15:16

    The article is so informative. This is more helpful for our
    Learn best software testing online certification course class in chennai with placement
    Best selenium testing online course training in chennai
    Best online software testing training course institute in chennai with placement
    Magento 2 Developer course training institute in chennai
    Thanks for sharing.

    ReplyDelete
  3. divi14 September 2019 at 13:49

    thanks for your information really good and very nice web design company in velachery

    ReplyDelete
  4. TechCagy29 November 2019 at 17:52

    After the release of Android 10, rumours about Android 11 have already begun which is going to roll out in 2020 - Google has confirmed this news itself. With the release of Android 10 Google pledged to follow numerical system instead of names (As Android 9 was Pie but Android 10 has no catchy name), but there are some most awaited features will be there in this latest android update.

    ReplyDelete
  5. Indian Web Developers2 December 2019 at 13:07

    This comment has been removed by the author.

    ReplyDelete
  6. Indian Web Developers2 December 2019 at 18:42

    With the passing of 2019 and starting of a new beginning i.e. 2020, So many features are get manipulated and many more have been put to updations. Since the last 10 years, Web Development have seen many drastic changes. Future of web development 2020 is:
    1. AI
    2. Voice Commands
    3. Frameworks
    4. Chatbot

    ReplyDelete
  7. My Crypto Currency Help4 December 2019 at 16:22

    This comment has been removed by the author.

    ReplyDelete
  8. My Crypto Currency Help4 December 2019 at 16:54

    Binance is a multi-chain wallet that offers extraordinary help for seven different cryptographic money assets. In the event that you’re new to the digital currency space let’s check how might you make or receive payments with Binance?

    ReplyDelete
  9. Indian App Developer5 December 2019 at 11:35

    The founders of React Native proudly released React Native 0.62 Update for its users. The core reason for this update is fixing many issues. Moreover, the release handles the migration for both Android and iOS devices. Features of React Native 0.62 that makes it more native than ever are:
    1. Accessibility
    2. Support to Android X
    3. Cocoa Pods are now part of React Native's Project

    ReplyDelete
  10. theninehertz10 December 2019 at 16:18

    An Ad Network can be referred as a middleman that connects advertisers to the publishers. The main purpose of an mobile ad network is to strike a deal between the advertiser who is looking for reputed platforms to publish his ads and an app development company who is looking for suitable ads to be published on his app. Ads display has emerged as the most beneficial way to monetize mobile apps these days.

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle Architecture - Explained In Detailed - Administration I

By -
Image
Figures shown in these notes are from Oracle® Database Concepts 11g Release 2

Objectives
These notes introduce the Oracle server architecture.The architecture includes physical components, memory components, processes, and logical structures.


Primary Architecture Components


The figure shown above details the Oracle architecture.
Oracle server:An Oracle server includes an Oracle Instance and an Oracle database. ·An Oracle database includes several different types of files:datafiles, control files, redo log files and archive redo log files.The Oracle server also accesses parameter files and password files. ·This set of files has several purposes. oOne is to enable system users to process SQL statements. oAnother is to improve system performance. oStill another is to ensure the database can be recovered if there is a software/hardware failure. ·The database server must manage large amounts of data in a multi-user environment. ·The server must manage concurrent access to the same data. ·The server mu…
Read more

Step by Step - How to resolve redo log file corruption using ALTER DATABASE CLEAR UNARCHIVED LOGFILE command

By -
Image
Connect to sys using sqlplus in admin command prompt
Check whether your database is in archive log mode or not. Run command ARCHIVE LOG LIST. It will show you the following details:
It is always preferable to have your database in archive log mode. The reason being if your database is in archive log mode you can recover from all committed changes in the event of an OS or disk failure.
This query will display the path of redo log files, their group and their status. It is always recommended to have a minimum of two members in one group.

As you can see I have only 1 member in group 6 whose current status is INACTIVE. I intentionally have 1 member to generate a scenario for the sake of this practical.

Now go to the specified path where the redo log member of group 6 is located and open it in a notepad. It will show some symbolic data. Delete couple of lines and save it the original location which is the one we got as a result of query.

Why did we do the above step i.e. why did…
Read more