Unfortunately one table-space is Corrupted then your database is hang.
By: Sugandh | 11 May 2015 5:31 pm | 550 times viewed | 0 Comments
May I know if your database is open mode, unfortunately one tablespace is corrupted then your database is hang.
What to do now?
a) Shut immediate.
b) Shut abort.
c) Shut transnational.
Please assist here, Thanks in advance.
No Comments Posted for this Article.
SAP comes to Rescue Indian RailwaysIndian railways were originally founded in the year 1853 and now are known as the largest rail network in Asia. It is interesting to know that there are more than 6000 stations and almost 20 million passengers travel daily through trains. Apart from being a favored mode of transport, the...
SAP All Set to Empower the Defense Forces of the CountryThe first thing that comes to our mind when we think about the way in which national emergencies are managed, the way our country's borders are protected is the defense services. The defense forces require a more rigorous solution which comes with a better tracking mechanism and thus enabling...
SAP Focuses On The Banking SectorSAP is known all over the world as the market leader in the field of ERP (Enterprise Resource Planning), CRM solutions and financial accounting. The brand has been consistently working towards achieving as well as delivering real standard software along with managing technology renewal cycles...
Top 10 Rising SAP Modules for Year 2016By the turn of the year, many things change. Numbers go upward and down letting in new trends to play the game of the day. SAP (Systems, Applications, Products in Data Processing) as an industry is no different in this regard. Google trends show a total revamp in the modules that is going to be...
SAP ECC6 IDES installation on Windows Server and Oracle 10.2 DatabaseSAP ECC6 IDES installation Before starting the SAP ECC6 IDES Installation u need to check your system wither it is ready for SAP Installation. System Hardware Requirements SAP ECC6 IDES Installation steps Installing Microsoft Loopbck Adapter Update Hosts file. (host name , saptranshost) ...
How to Recover Corrupted Incremental Database?
Hello Experts,I gave an interview recently and the interviewer has asked a stitution that Suppose Sunday you are having fullbackup and you are taking Rman increamental backup on daily basis Suddenly...
What is Consistency Check of ORACLE Database?
Hello Experts,Is there any commands for checking the complete database individual objects for corruption?What is consistency check procedures and its requirment?Kindly share your views here.Thanks in...
Blank tablespace how to remve it
Dear all friends,I investigated Oracle RAC Database in a company and I found this caseSQL> select distinct tablespace_name from dba_tables;TABLESPACE_NAME------------ ---------...
Oracle Database Deadlock
Hi, I am adding one update statement in the existing trigger on same table. So it gave an error mutating error. After that I added pragma autonomous transaction and after that it is throwing...
If Oratab loss then What will happen to Database?
Hello Experts,May I know that what is oracle_home and oracle_base?Â if oratab loss then what will happen to database?And what is snapshot standby? why it is used?Kindly share your views, thanks in...
Backup Database (Oracle 10g XE)
What I am dong is - set the ARCHIVLOG ON (which was off previously) from SQL COMMAND LINE Then I took the backup from - Backup Database. The result is - Doing online backup of the...