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
  15. cathrine juliet16 June 2020 at 19:39

    very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.

    Big Data Hadoop Training In Chennai | Big Data Hadoop Training In anna nagar | Big Data Hadoop Training In omr | Big Data Hadoop Training In porur | Big Data Hadoop Training In tambaram | Big Data Hadoop Training In velachery





    ReplyDelete
  16. Data Science Course10 July 2020 at 17:07

    I’m excited to uncover this page. I need to to thank you for ones time for this particularly fantastic read !! I definitely really liked every part of it and i also have you saved to fav to look at new information in your site.

    Data Science Course

    ReplyDelete
  17. Data Science Training10 July 2020 at 18:52

    It's really nice and meanful. it's really cool blog. Linking is very useful thing.you have really helped lots of people who visit blog and provide them usefull information.

    Data Science Training

    ReplyDelete
  18. Data Science Institute In Banglore11 July 2020 at 13:06

    Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
    Data Science Training Institute in Bangalore

    ReplyDelete
  19. Best Data Science Courses In Bangalore 11 July 2020 at 18:00


    Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
    Best Data Science Courses in Bangalore

    ReplyDelete
  20. Data Science Training12 July 2020 at 01:21

    I have recently started a blog, the info you provide on this site has helped me greatly. Thanks for all of your time & work.
    Data Science Course in Hyderabad | Data Science Training in Hyderabad

    ReplyDelete
  21. hrithiksai4 August 2020 at 16:44

    This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing, data sciecne course in hyderabad

    ReplyDelete
  22. Data Science Training 29 August 2020 at 11:48

    Thanks for the Information.Interesting stuff to read.Great Article.
    I enjoyed reading your post, very nice share.
    Data Science Course Training in Hyderabad

    ReplyDelete
  23. Tableau Course in Raipur - 360DigiTMG3 September 2020 at 16:22

    Wonderful blog found to be very impressive to come across such an awesome blog. I should really appreciate the blogger for the efforts they have put in to develop such an amazing content for all the curious readers who are very keen of being updated across every corner. Ultimately, this is an awesome experience for the readers. Anyways, thanks a lot and keep sharing the content in future too.

    360DigiTMG Tableau Course

    ReplyDelete
  24. Business Analytics Course in Raipur - 360DigiTMG3 September 2020 at 19:03

    Highly appreciable regarding the uniqueness of the content. This perhaps makes the readers feels excited to get stick to the subject. Certainly, the learners would thank the blogger to come up with the innovative content which keeps the readers to be up to date to stand by the competition. Once again nice blog keep it up and keep sharing the content as always.

    360DigiTMG Business Analytics Course

    ReplyDelete
  25. Data Science 18 September 2020 at 00:20

    Really impressed by the information shared it was very useful and unique thank you.
    typeerror nonetype object is not subscriptable

    ReplyDelete
  26. Best Web Development Company in Hyderabad26 September 2020 at 10:11

    Thank you for share us. For more information visit our Best App Development Company in Hyderabad

    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