الاثنين، 20 أبريل 2015

ORA-1578

error
===
db corruption

SQL> select * from scott.dept_view;
select * from scott.dept_view
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 11, block # 34)
ORA-01110: data file 5: '/home/oracle/oradata/users.dbf'



solution
=====
follow metalink DBMS_REPAIR example (Doc ID 68013.1)



sources
=====
How to identify the corrupt Object reported by ORA-1578 / RMAN / DBVERIFY (Doc ID 819533.1)

RMAN-20033

Error
=======
Rman backup failed with error 

Starting Control File and SPFILE Autobackup at Dec 13 13 12:59:20
piece handle=ORA_CFc-6717079-20131213-10 comment=API Version 2.0,MMS Version 4.2.0.0
Finished Control File and SPFILE Autobackup at Dec 13 13 13:00:29
released channel: B1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03008: error while performing automatic resync of recovery catalog
RMAN-20033: control file sequence# too


explanation
==========

2 rman backups running at the same time ,kill all the rman session and restart the backup again 


الأربعاء، 15 أبريل 2015

ORA-19550

Error:
===
Rman backup fail with :

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on B1 channel at 04/15/2015 10:11:01
ORA-19550: cannot use backup/restore functions while using dispatcher

Explanation
========
Doc ID 215934.1

Solution
=======
Create a new TNS alias with SERVER=DEDICATED in the TNSNAMES.ORA file and use 
this alias to connect to the target database.

Example
=======
SHAGGY =  (DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.25)(PORT =1521)))(CONNECT_DATA=(SERVICE_NAME =SHAGGY)(server =dedicated)    )  )

Sources
======
metalink Doc ID 215934.1
http://grokbase.com/t/freelists.org/oracle-l/01ck765az2/how-to-backup-mts-database-with-rman

الخميس، 9 أبريل 2015

Becoming ORALCE DBA



1-This career path need a lot of patient reading always read when you have time read ,reading  and practice is the BREAD of this Career Path

2-The following link give you the available choices in the admin
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getlppage?page_id=213&path=DBAN&columnNumber=5

3- you will get these courses by self study or taking courses and then begin practice

4-you must build your own lab ,you can use the following link

     http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getlppage?page_id=213&path=DBAN&columnNumber=5


5-  if you have any quesyion email me