These are some of the issues which i have faced while managing the physical standby database:
1. ORA-00368: Checksum error 2. ORA-01119: Error in creating database file
1. ORA-00368: Checksum error ORA-00368: checksum error in redo log blockORA-00353: log corruption near block 10241 change 2700 time 11/22/2007 ORA-00334: archived log: ‘/archivelog/oradb1_arc_10444_596803436.arc’
Reason for the above error:If checksum of [...]
Archive for November, 2007
STANDBY DB ISSUES
Posted in Standby Database on November 22, 2007 | Leave a Comment »
RMAN Resoter and Recover
Posted in RMAN on November 22, 2007 | Leave a Comment »
1. The whole databaseRMAN> startup force mount;RMAN> restore database;RMAN> recover database;RMAN> alter database open;
2. TablespaceRMAN> sql ‘alter tablespace tbs1 offline’;RMAN> restore tablespace tbs1;RMAN> recover tablespace tbs1;RMAN> sql ‘alter tablespace tbs1 online’;
3. DatafileRMAN> sql ‘alter database datafile 5 offline’;RMAN> restore datafile 5;RMAN> recover datafile 5;RMAN> sql ‘alter database datafile 5 online’;
4. Block of a DatafileRMAN> blockrecover [...]
SQL stetment of a USER
Posted in SQL on November 11, 2007 | Leave a Comment »
Below SQL query is used to find the SQL statement of a USER:
select sess.sid, sqltext.piece, sqltext.sql_text, sqltext.command_type
from v$sqltext sqltext, v$session sess
where sqltext.address = sess.sql_address
and sqltext.hash_value = sess.sql_hash_value
and sess.username = ‘NAIKH‘
order by 2;
Bloking Locks
Posted in SQL on November 11, 2007 | Leave a Comment »
SQL query to identify blocking locks:
1.select s.username “Blocking Username”,l1.sid “Blocking SID”, l2.sid “Blocked SID”,s2.username “Blocked Username”from v$lock l1, v$lock l2,v$session s,v$session s2where l1.block =1 and l2.request > 0 and l1.id1=l2.id1 and l1.id2=l2.id2and l1.sid=s.sidand l2.sid=s2.sid;
2.select l.sid SID, decode(l.type,’TM’,’DML’,’TX’,‘Trans’,’UL’,’User’,l.type) Lock_Type,decode(l.lmode,0,’None’,1,’Null’,2,’Row-S’,3,’Row-X’, 4,’Share’,5,’S/Row-X’,6,’Exclusive’, l.lmode) Lock_Held_In,decode(l.request,0,’None’,1,’Null’,2,’Row-S’,3,’Row-X’, 4,’Share’,5,’S/Row-X’,6,’Exclusive’,l.request) Lock_Req_In, l.ctime Duration_Seconds, decode(l.block,0,’NO’,1,’YES’) Blocking from v$lock lwhere l.request != 0 or l.block [...]
Links Part 1
Posted in Documentation on November 5, 2007 | Leave a Comment »
Some useful links:
OracleOracle 9i funda1,funda2 and PT PPTs
Shell Scripting1. Bash Guide for Beginners2. Easy Shell Scripting3. Advanced Bash-Scripting GuideOne Liners1. AWK2. AWK23. SED4. Perl 5. Solaris
Linux 1. Linux in a Nutshell2. Red Hat Linux Unleashed3. Linux Documentation Collection
Solaris1. System Administration Commands2. Solaris 10 Documentation collection3. Solaris Tips & Tricks
UnixUNIX Unleashed
