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
  11. TechCagy11 February 2020 at 15:58

    Change is the only constant. This applies in your professional life as well as personal life. Up-scaling yourself is a need nowadays, the reason is pretty simple, technology is evolving very quickly. I have listed top 10 trending technologies, which is expected to acquire a huge market in 2020.

    1. AI (Artificial Intelligence)
    2. Blockchain
    3. Augmented Reality and Virtual Reality
    4. Cognitive Cloud Computing
    5. Angular and React
    6. DevOps
    7. IoT (Internet of Things)
    8. Intelligent Apps (I – Apps)
    9. Big Data
    10. RPA (Robotic Process Automation)

    ReplyDelete
  12. Jaipur Hand Crafts18 February 2020 at 16:31

    Jaipur Hand Crafts, Jaipur (india ) is the premier BED LINENS MANUFACTURERS JAIPUR and premium Bed linens exporter from Jaipur India.

    ReplyDelete
  13. Vertex Exports18 February 2020 at 16:38

    Vertex Exports, aligarh (india ) is the premier builders hardware manufacturers bronze builders hardware from india.

    ReplyDelete
  14. Steve Roger2 March 2020 at 15:08

    Sales Force Automation Development is programming that streamlines the collection, analysis and distribution of data in a sales pipeline. The goal of SFA software is to get the right data to the right people at the right time, and reduce the number of administrative tasks that sales representatives and their managers have to perform manually. SFA software is used by various salespersons such as salespersons in B2B and B2C contexts, door-to-door salesmen, direct sellers, online sellers, etc. It is used by managers to track customers, manage sales pipelines, customize the offers, and generate reports.

    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