Server Administration :: How To Clean Corrupted Dba_tables

Feb 5, 2013

I have a table enrty in dba_tables:

SQL> select OWNER,TABLE_NAME from dba_tables where TABLE_NAME='Viep_Porteur_Etudiant';
OWNER TABLE_NAME
------------------------------ ------------------------------
IEP_PESSAC Viep_Porteur_Etudiant

But this tables doesn't exist then I can't drop this table:

SQL> desc IEP_PESSAC.Viep_Porteur_Etudiant;
ERROR:
ORA-04043: objet IEP_PESSAC.Viep_Porteur_Etudiant inexistant
SQL> drop table IEP_PESSAC.Viep_Porteur_Etudiant;
drop table IEP_PESSAC.Viep_Porteur_Etudiant
*
ERREUR à la ligne 1 :
ORA-00942: Table ou vue inexistante

How can I clean dba_table? I suppose that that's happened because the user tablespace was full when he tried to create this table...

View 6 Replies


ADVERTISEMENT

Server Administration :: Clean Up Duplicate Objects Owned By SYS And SYSTEM?

Dec 1, 2011

we are doing database upgradation 10g2 to 11gr2, while doing pre check before upgrdation ..we have found few duplicate objectes on sys and system schema..

SQL> column object_name format a30
select object_name, object_type
from dba_objects
where object_name||object_type in
(select object_name||object_type
from dba_objects
where owner = 'SYS')

[code]...

As per metalink note "How to Clean Up Duplicate Objects Owned by SYS and SYSTEM Schema [ID 1030426.6]"..

im going to do drop only below objects ..

DROP TABLE SYS.HELP;
DROP INDEX SYS.HELP_TOPIC_SEQ;
DROP TABLE SYSTEM.PLAN_TABLE;

and ignore below objects ...

DROP TABLE SYSTEM.AQ$_SCHEDULES;
DROP INDEX SYSTEM.AQ$_SCHEDULES_PRIMARY;
DROP PACKAGE SYSTEM.DBMS_REPCAT_AUTH;
DROP PACKAGE BODY SYSTEM.DBMS_REPCAT_AUTH;

View 1 Replies View Related

Server Administration :: Temporary Tablespace Was Corrupted

Aug 8, 2013

i found a temporary tablespace was corrupted,what happens to the database level, how to recover that tablespace? If need any recovery?

View 3 Replies View Related

Server Administration :: Find Database Is Corrupted Or Crashed

Mar 3, 2012

how will you find your db is Corrupted or crashed. how will u recover it.

View 2 Replies View Related

Server Administration :: ORA-01578 - ORACLE Data Block Corrupted

Sep 4, 2012

I am having 3 oracle database instances running on 3 seperate Linux Node(RHEL Node).

Instance -1 named - DS
Instance -2 named - MIS
Instance -3 named - OAS

Among of these 3 nodes, we are facing Block Corruption issues with sysaux tablespace.Error in Instance name DS is

Errors in file /u01/home/dba/oracle/diag/rdbms/ds4db/DS/trace/DS_j000_655388.trc (incident=300847):
ORA-01578: ORACLE data block corrupted (file # 2, block # 38428)
ORA-01110: data file 2: '/DSdb1/dssysaux.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
GATHER_STATS_JOB encountered errors. Check the trace file.
[code]....

for this I googled and found some solution as oracle doc [430230.1] related to sysaux couruption.After this again we are facing the same issue in sysaux tablespace.

View 19 Replies View Related

Server Administration :: How Control File Is Corrupted And Database Not Open

Apr 27, 2011

I am using oracle 10g R2. Some how control file is corrupted and database is not open. and there is no backup of control file. Now i need to open the database without recreating the database.

View 5 Replies View Related

Server Administration :: How To Repair Blocks That Gets Corrupted Found In Dbverify

Aug 8, 2013

how to repair the blocks that gets corrupted found in dbverify

View 8 Replies View Related

How To Clean Up Database USER_IDENTIFIERS

Aug 5, 2013

I am using 11g express r2, sqldevloper. i want to clean up my database of object which are not relevent, the object i have created or user creates they are known to me.but other objects which are created automatically they are not known to me.one thing i am doing ispurging the recycle bin

PURGE RECYCLEBIN;PURGE DBA_RECYCLEBIN; 

1) Is there any thing else i can do?
2) I found one table USER_IDENTIFIERS can this be cleaned?

View 8 Replies View Related

How To Clean Oracle Database

Jul 21, 2012

My company wish to give old computer to school local. We have Oracle database on this server. My boss want to be sure that school not get any Oracle data. Some data is bank material and should be a secret. The bank is important client and if information get out, this mean big problem for us.

View 4 Replies View Related

Real Application Clusters :: Alert Log Clean Up In Rac?

Jun 18, 2012

is there any alarm in moving alert logs generated in the grid infrastructure. The alert log in the grid log directory has grown around 2gb .Our CRS version 11.2.02. on linux. Also pls, Sample script for automating the same.

View 4 Replies View Related

Parenthesis Create Error In Query / How To Clean Text Before Use

Nov 10, 2008

i am binding a string to a CONTAINS search (oracle text) and its throwing an error because of characters within the string.

this causes the error.
Quote:
(A. A.)
if i take out ( and ) it works
Quote:
A. A.

i thought binding took care of these issues as well as sql injection?

example:

SELECT
score(1) the_score,
id
FROM
t_table
WHERE
contains(text_column, :BINDVAR1, 1) > 0

how can i get around this and other character errors on the fly?

View 4 Replies View Related

Enterprise Manager :: OEM 11gR2 - How To Configure / Clean Up Unwanted Old Data

Jul 21, 2011

Is there any document out there for OEM11gR2? Particulary how to configure/clean up unwanted old data within OEM repository.

View 1 Replies View Related

Oracle DB Corrupted

Feb 7, 2013

Recently we have a weird thing happens in our Oracle Queries to the views return "ORA-00942: table or view does not exist" unless there are a where clause

select * from VIEW1 failed
select * from VIEW1 where 1 = 1 works

What happening? and how we can fix it?

View 11 Replies View Related

Hyperlink Inside A Mail Got Corrupted

May 4, 2012

I have an application written in Pl SQL Oracle which suppose to send email using utl_smtp. For users that are using Exchange Server 2010 Windows the hyperlinks inside the email are correctly but for users that have a Postfix version installed on a Debian 5 Linux mail server the hyperlinks contains some extra spaces. I think that the CRLF that I'm using inside my code to create the MIME message is not ok interpreted.

View 5 Replies View Related

Windows :: Delete Corrupted Files In Win 7?

Mar 12, 2012

I was having troubles with deleting some files and folders in windows 7, I used a software called SPAM. It works fine. Do I have any other options to do that thing? Or is it ok to be with SPAM? This tool has more options too.

View -1 Replies View Related

RMAN :: How To Restore Corrupted Database

Dec 19, 2012

We have Oracle 10.2.0.3 database installed on Itanium server.

1. One day we found some packages got invalid & not compiling at all with error – ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], [].

2. Then we successfully restored the database from old RMAN backup of previous date that caused this error.

3. After 2 days again we found the same error in alert_prd log - ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], [] ORA-06512: at "SYS.DBMS_STATS", line 19089 ], [], [], [], [], [], [], []     

4. Then for testing we exported database using exp command & found 3 tables are not exporting because of data block corruption issue.

5. Then we truncated the data from all 3 tables and then able to export successfully.

6. After all this we manually run SYS.DMS_STATS job but found same error logged in prd_alert log.

This looks like, still database block corruption issue is there & we are unable to cure it 100% This is a production system & in very critical state now.

View 1 Replies View Related

Recreate Parameter File When Lost Or Corrupted?

Jul 1, 2010

recreate paramater file if you lost init.ora or spfile.ora

STEPS

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:ORACLEORA92DATABASEINITGPT2.ORA'
How to resolve ORA-01078 with LRM-00109 error?

For resolving these error, you should need to replace init.ora or spfile if you have backup of same files. If you don't have backup then go to alert.log and copy all parameters in one file and save as "init.ora". Modify same init.ora with some parameters which need single quotation mark " ' " like background_dump_dest,controlfiles,db_name and "dispatchers ......)". Connect as sysdba in SQL*Plus and execute command "create spfile from pfile=" or startup pfile or startup.

View 2 Replies View Related

Backup & Recovery :: Oracle Crashed And Data Corrupted?

May 20, 2013

I am the only DBA in my company and Oracle just crashed on me. The data is corrupted as well as the data on my backup! Is there ANY way I can get the information back?

View 2 Replies View Related

Ora-01578 ORACLE Data Block Corrupted For New Site

Nov 14, 2012

Oracle 10gR2 on red hat.

I have an application that writes blobs via pro*c. It is running at several sites without errors for a few years now. One of the newer sites has started reporting "ora-01578 ORACLE data block corrupted".

I've tried using rman backup validate - it does not report any errors.

I've tried using rman restore and recover to correct the problem.

I've tried deleting the file with the corrupt block and using rman restore and recover to recreate it.

In any of the above cases, I do not see any errors being encountered, and when I restart the application, it works for a while and then starts reporting "ora-01578 ORACLE data block corrupted".

I've had the client do a physical check of the disk and it indicated the media was okay.

We've failed over to the standby system, so I have a wee bit of breathing room - but I'm going to be away for 4 days and will have to get back on this when I get back. I'm a little puzzled that I can fix it for a short while and then it breaks again.

View 2 Replies View Related

RMAN - ORA-01578 Oracle Data Block Corrupted

Feb 11, 2013

we are running oracle 9iR2 ( 9.2.0.1.0) on windows server 2003 R2 and facing ORA-01578: ORACLE data block corrupted (file # 17, block # 312316)

SQL> select * from payrol.slip;
select * from payrol.slip
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 17, block # 312316)
ORA-01110: data file 17: 'E:ORACLEORADATAMTMASYSMTM.ORA'
ORA-26040: Data block was loaded using the NOLOGGING option

1) SELECT name FROM v$datafile WHERE file#=17;
output
E:ORACLEORADATAMTMASYSMTM.ORA

2) SELECT block_size FROM dba_tablespaces
WHERE tablespace_name =
(SELECT tablespace_name FROM dba_data_files WHERE file_id=17);
output
8192

3) SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id = &AFN
and &BL between block_id AND block_id + blocks - 1;

file_id=17, BL=312316
output
SYSMTM TABLE PAYROL SLIP

I am not using RMAN. How to recover payrol.slip table ?

View 7 Replies View Related

Backup & Recovery :: ORA-01578 - ORACLE Data Block Corrupted

Nov 21, 2012

What i have to do for this error:

ORA-01578: ORACLE data block corrupted (file # 3, block # 42348)
ORA-01110: data file 3: '+DGMETA/metadb/datafile/sysaux.257.783871811'
Wed Nov 21 09:30:00 2012
Corrupt Block Found
TSN = 2, TSNAME = SYSAUX
RFN = 3, BLK = 42348, RDBA = 12625260
OBJN = 50439, OBJD = 50439, OBJECT = MGMT_STRING_METRIC_HISTORY_PK, SUB
OBJECT = SEGMENT OWNER = SYSMAN, SEGMENT TYPE = Index Segment

Database version is :- Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi

View 11 Replies View Related

Recovery Manager (RMAN) :: How To Restore Database If Catalog Corrupted

Feb 27, 2013

How to restore database if rman catalog corrupted and we we dont have bacup of catalog db ..all the backup info are stored in catalog db for prod databases.

View 7 Replies View Related

Inputs On RMAN Backup N Recovery For Multiple Restore Of Clean Backup?

Nov 7, 2010

We have the requirement of performance testing of our proposed production platform, for this i am asked to take RMAN backup of clean position (Say Day0 or baseline backup) and restore it multiple times for few rounds of testing. My question is after 1st restore (with set until time of day0 position) if i open the database with resetlogs, would i be able to restore same clean backup again? I am using control file in the environment instead of RMAN catalog database. What i can do to make this scenario work? I am already in preperation of setting rman catalog database.

View 3 Replies View Related

Server Administration :: Create Tablespace For Administration

Nov 29, 2010

i'm a student currently learning database administration security.

I need to create a tablespace for administration of database but i don't know what datafile settings are best suited for admin usage.

I have attached the schema that was given to me for this assignment.

View 12 Replies View Related

Server Administration :: Monitoring Script Required For Oracle 9.2.0.7.0 On Windows 2000 Server

Apr 8, 2010

My manager is asking to create a SQL scrip, which will provide following information.

Our database is 9.2.0.7.0 on Windows 2000 Server

-How many records Insert / Update or Delete daily in my Oracle database?

- Check Archive log / Redo Log switching information?

-Check database growth ?

View 10 Replies View Related

Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?

Jan 11, 2011

i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.

"The image file D: is Valid, but is for a machine type other than the current machine."

View 1 Replies View Related

Server Administration :: Restoring The Oracle Services In Windows 2008 Server

Jun 27, 2012

I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).

All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.

View 3 Replies View Related

Server Administration :: How To Migrate Database From Windows 2003 To 2008 Server

Oct 31, 2012

I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server . So far i have just installed the oracle software on 64bit windows 2008 server. How to move the data or migrate from old server to new server .

View 22 Replies View Related

Server Administration :: Server Installation Gets Abruptly Ended For Client Get TNS Errors

Jan 11, 2011

after a long time,(i never remember when was the last time i installed 9i)i was asked to install 9i.So, whether i install server or cilent i get this error <attachment>

after i ignore it and finished the installation,The server installation gets abruptly ended for the client i get TNS errors.

View 2 Replies View Related

Server Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client

Feb 13, 2013

I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.

1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?

SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved