AskDBA.org Forum » Recent Topics

AskDBA.org Forum » Recent Topics http://www.forum.askdba.org/ AskDBA.org Forum » Recent Topics en Fri, 30 Jul 2010 08:53:44 +0000 Amit Bansal on "NO SPAM Entertained on this forum" http://www.forum.askdba.org/topic/no-spam-entertained-on-this-forum#post-167 Tue, 29 Jun 2010 12:58:47 +0000 Amit Bansal 167@http://www.forum.askdba.org/ Hi All, For past few days, I am observing spam ( some exams site) posting content on the forum. Tried deleting the content for 2-3 times so that concerned person desist from doing again but I have today finally deleted the user. Any kind of spam will not be entertained on this forum. Regards Amit bhatia.ish@gmail.com on "What are the pre-requisites of ASM on AIX 6.1?" http://www.forum.askdba.org/topic/what-are-the-pre-requisites-of-asm-on-aix-61#post-164 Tue, 22 Jun 2010 11:29:28 +0000 bhatia.ish@gmail.com 164@http://www.forum.askdba.org/ Hi, What are the pre-requisites of ASM on AIX 6.1? Regards, Bhatia daniesh on "PKRS-1009 failed to start ASM instance" http://www.forum.askdba.org/topic/pkrs-1009-failed-to-start-asm-instance#post-97 Mon, 12 Oct 2009 06:01:09 +0000 daniesh 97@http://www.forum.askdba.org/ Hi , I have installed RAC on AS-4 platform. cluster and database s/w is installed successfully however when i try to install ASM i am getting an following error. PKRS-1009 : failed to start ASM instance. CRS-1005: failed to get required resources. CRS:0223: node 1 has placement erro. could you please help me on this? Thanks, dinilocp on "ORA-16055" http://www.forum.askdba.org/topic/ora-16055#post-86 Fri, 11 Sep 2009 07:18:15 +0000 dinilocp 86@http://www.forum.askdba.org/ how can we solve this error: regularly comes in alertlog file of primary database: ora-19502 write error on file"",blockno(blocksize=) ora-16055: FAL REQUEST REJECT Arch: FAL Archive Failed,Archiver continuing. Database : 10g RAC with two nodes. egotah on "Datapump dumpfile with dates" http://www.forum.askdba.org/topic/datapump-dumpfile-with-dates#post-148 Thu, 13 May 2010 20:05:34 +0000 egotah 148@http://www.forum.askdba.org/ Can some one direct me how to generate Datapump Export Dump with Dumpfile name Containing Current Date and Time. I tried this format with error.. dumpfile=myexport-<code>date '+%d%m%Y_%H%M%S'</code>.dmp logfile=myexport-<code>date '+%d%m%Y_%H%M%S'</code>.log rbaclagan on "Oracle RAC OVM image" http://www.forum.askdba.org/topic/oracle-rac-ovm-image#post-146 Mon, 29 Mar 2010 21:47:41 +0000 rbaclagan 146@http://www.forum.askdba.org/ Does anyone know if it is possible to take a snapshot of an existing RAC environment running on OVM and redeploy this as a new RAC cluster with minor tweaks such as ip addresses, OCR, Vote disks, etc? bhagirathipatra on "how to connect 11gR2 RAC db using sql" http://www.forum.askdba.org/topic/how-to-connect-11gr2-rac-db-using-sql#post-141 Sat, 20 Mar 2010 03:17:15 +0000 bhagirathipatra 141@http://www.forum.askdba.org/ Hi, Our product support 11gR2 DB or higher.in my installation of the product my product installer need DB configuration parameter. i have a 11gR2 RAC setup. when my prod ask for db, i choose the RAC config and next screen it ask “provide RAC db in host1:port1:sid1,host2:port2:sid2″. Is it the right behavior of the installer or it should ask the SCAN parameter ? plz suggest Mahesh.G on "DR rebuild- Data restore issue" http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-131 Wed, 10 Mar 2010 11:27:43 +0000 Mahesh.G 131@http://www.forum.askdba.org/ Hi Experts, While doing DR rebuild ( physical standby ), after restoring standby controlfile in DR location, i am getting below error while restoring database. I took backup through RMAN ( hotbackup ) from primary database. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 03/10/2010 11:58:32 RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 28 found to restore RMAN-06023: no backup or copy of datafile 27 found to restore I tried the below options :- 1. Duplicate command :- while using duplicate command also i got the same error 2. " catalog backuppiece " of all backup pieces copied from primary database. 3. I used restore with set until time option also but no luck. In all cases i got same error. How can i restore primary database backup in DR ? Pls help. Mahesh Amit Bansal on "DB and Listener availability monitoring script" http://www.forum.askdba.org/topic/db-and-listener-availability-script#post-134 Thu, 11 Mar 2010 06:13:39 +0000 Amit Bansal 134@http://www.forum.askdba.org/ Hi, Find below a simple script to monitor db and listener. It uses utl_mail procedure to connect to a mailserver db and send a mail in case of failure. You can also use mailx function to send mail. I have hard-coded password , but you can also use Oracle wallet to store password. Refer to my blog post <a href="http://askdba.org/weblog/2009/09/using-oracle-wallet-to-execute-shell-scriptcron-without-hard-coded-oracle-database-password/"> here </a> for details You need to pass ORACLE_SID as parameter. So to schedule a cron to check every 10 mins, you need to specify like below <pre> 00,10,20,30,40,50 * * * * sh /home/oracle/monitor/db_check.sh orcl </pre> Find below the script. Any suggestions/improvements are welcome <pre> ################################################################### ## Check Database Availability ################################################################### ##########Env Variables ############# export DBA_MAIL1='amit.bansal@askdba.org' export DBA_MAIL2='saurabh.sood@askdba.org' export ORACLE_HOME=/oracle/ora_db export TNS_ADMIN=$ORACLE_HOME/network/admin export BASE_DIR=/home/oracle/monitor export ORACLE_SID=$1 export LOG_FILE=$BASE_DIR/$ORACLE_SID.log export PATH=$ORACLE_HOME/bin:$PATH export machinename=<code>hostname</code> ################################### cd $BASE_DIR echo "<code>date</code> " > $LOG_FILE echo "Oracle Database(s) Status <code>hostname</code> :\n" >> $LOG_FILE db_cnt=<code>ps -ef|grep pmon|grep $ORACLE_SID|wc -l</code> if [ $db_cnt -gt 0 ]; then echo "$ORACLE_SID is Up" >> $LOG_FILE else echo "$ORACLE_SID is Down" >> $LOG_FILE $ORACLE_HOME/bin/sqlplus -s "system@maildb/oracle123" <<EOF >> $LOG_FILE alter session SET smtp_out_server = 'mailserv:100'; BEGIN UTL_MAIL.send( sender => 'webmaster@askdba.org' ,recipients => '${DBA_MAIL1}' ,cc => '${DBA_MAIL2}' ,subject => '${ORACLE_SID} is down on ${machinename}' ,message => '${ORACLE_SID} is Down on ${machinename}' ,mime_type => 'text/plain; charset=us-ascii' ,priority => 3); END; / exit EOF fi lsn_cnt=<code>ps -ef|grep tnslsnr|grep oracle|grep -v grep|wc -l</code> if [ $lsn_cnt -gt 0 ]; then echo "Listener is up" >>$LOG_FILE else echo "Listener is down" >>$LOG_FILE $ORACLE_HOME/bin/sqlplus -s "system@maildb/oracle123" <<EOF >> $LOG_FILE alter session SET smtp_out_server = 'mailserv:100'; BEGIN UTL_MAIL.send( sender => 'webmaster@askdba.org' ,recipients => '${DBA_MAIL1}' ,cc => '${DBA_MAIL2}' ,subject => 'Listener is down on ${machinename}' ,message => 'Listener is Down on ${machinename}' ,mime_type => 'text; charset=us-ascii' ,priority => 3); END; / exit EOF fi </pre> wesguez on "OS Memory issue" http://www.forum.askdba.org/topic/os-memory-issue#post-127 Mon, 22 Feb 2010 19:44:02 +0000 wesguez 127@http://www.forum.askdba.org/ I am having a issue of OS memory crunch.The sever has 16Gb RAM, and hosts 2 db.The total sga+pga combined is ~10.5GB.For one of the database, i see in TOP command, RES column values like 1100M,1245M , though these sessions are inactive and the logon_time is of 9th Feb.The sessions are also having open_cursor.Can this is a bottleneck?Can snipping these sessions be useful? How to find why the cursor is still open for a session.I have a session with a logon date on 29-JAN-2010, which is INACTIVE and has 1 open_cursor.This session is having the maximum cpu usage,though inactive.How do i go ahead for analyzing it. waiting for your response. tsswamy on "Convert from 2 node RAC to single instance database" http://www.forum.askdba.org/topic/convert-from-2-node-rac-to-single-instance-database#post-128 Wed, 24 Feb 2010 20:09:17 +0000 tsswamy 128@http://www.forum.askdba.org/ We have several databases that were set up in RAC on 2 nodes with ASM and now we want to remove SOME of those databases from RAC and have them set up as single instance databases. Can you please provide step by step procedure to convert from a 2 node RAC environment in windows to a single instance database. I am looking for the steps involved to remove the entries from clusterware as well. Thanks Amit Bansal on "Linux:Capturing Top Output in text file" http://www.forum.askdba.org/topic/linuxcapturing-top-output-in-text-file#post-126 Mon, 15 Feb 2010 11:51:49 +0000 Amit Bansal 126@http://www.forum.askdba.org/ Came across this link for capturing Top output in text file <a href="http://magazine.redhat.com/2008/04/16/tips-and-tricks-how-do-i-capture-the-output-of-top-to-a-file/" rel="nofollow">http://magazine.redhat.com/2008/04/16/tips-and-tricks-how-do-i-capture-the-output-of-top-to-a-file/</a> I found following command to be very useful. top -b -n5 -d5 It captures top output 5 times and wait 5 seconds between each output. rtskrajan on "Database Hang" http://www.forum.askdba.org/topic/database-hang#post-124 Tue, 26 Jan 2010 11:14:23 +0000 rtskrajan 124@http://www.forum.askdba.org/ Hi experts, My server ram is 12GB. i installed 10r2 and implemented /3GB also. Eventhough my database is giving problem. Could you please give some valuable advice. Thanks. pratheep on "Database shutdown hangs." http://www.forum.askdba.org/topic/database-shutdown-hangs#post-122 Wed, 20 Jan 2010 04:25:12 +0000 pratheep 122@http://www.forum.askdba.org/ Hi, One of my production database shutdown process hangs every planned shutdown. (Both shutdown immediate and abort options). Database version & OS : 10.2.0.4 on SuSe Linux 10 SP2, All the latest patches, cpus installed. Some of the active database server process are preventing the database from shutdown. I tried to kill the process from OS root user also. But the process are not closing. When I check ps command the process are in 'D' state (uninterruptable sleep). For the particular pid, strace command also stuck. As I verified in v$session before shutdown immediate there is no active sessions or jobs in database. But above mentioned "D" state pid's are exist in v$process. Please suggest me, how to find the history of the process.? like when it is hanged/which session id/which sql statement caused that..? Thank you all, Pratheep jammoral on "What is the process/steps to start up a database in a RAC" http://www.forum.askdba.org/topic/what-is-the-processsteps-to-start-up-a-database-in-a-rac#post-120 Tue, 12 Jan 2010 14:51:42 +0000 jammoral 120@http://www.forum.askdba.org/ what steps are followed to startup an Oracle instance setup as part cluster. I understand powerpath 1st to allow access to the san, then CRSD ... not sure what is next!! nhameed on "SYSASM not granted to sys." http://www.forum.askdba.org/topic/sysasm-not-granted-to-sys#post-118 Sat, 09 Jan 2010 10:22:15 +0000 nhameed 118@http://www.forum.askdba.org/ I have upgraded 10 RAC database to 11g rac, now I cannot connect to ASM instance, in v$pwfile_users, sys dont have SYSASM privilege. How can I manually grant this privilege to SYS user. deepika.dhamija@gmail.com on "ASM Volumes and DiskGroups" http://www.forum.askdba.org/topic/asm-volumes-and-diskgroups#post-115 Mon, 28 Dec 2009 08:57:41 +0000 deepika.dhamija@gmail.com 115@http://www.forum.askdba.org/ Hi, I have a 2Node Oracle RAC Setup(10gR2). ASM Volumes were configured for 2 disk groups as follows, during the installation: /dev/sdb2 : VOL1 /dev/sdb3 : VOL2 /dev/sdb4 : VOL3 ORCL_DATA1 : VOL1 & VOL2 FLASH_RECOVERY_AREA : VOL3 I have some basic doubts about ASM and Database Groups. 1) I run the foll commands to know/query the ASM Volumes and devices # /etc/init.d/oracleasm querydisk /dev/sdb2 # /etc/init.d/oracleasm listdisks # ls -al /dev/oracleasm/disks/ Can I also get the 'Disk Group' information in a similar manner from ASM? eg: What are the disk group names and what vol's/devices form the diskgroup. Currently I am run the below query to get this information select d.name, e.name from v$asm_diskgroup d, v$asm_disk e where d.group_number=e.group_number; 2) Can my database have multiple data groups? eg: ORCL_DATA1 (VOL1 & VOL2) and ORCL_DATA2 (VOL3 & VOL4) 3) Can multiple datagroups share the same Flash Recovery Area? eg: ORCL_DATA1 & ORCL_DATA2 have the same Flash Recovery Area (FLASH_RECOVERY_AREA (VOL5 & VOL6) 4) Can disk groups span across databases? 5) When I create/alter tables, and if I have two data groups (ORCL_DATA1 & ORCL_DATA2) in the database, do I know where the information is being written or can I provide this information somewhere? 6) If my database contains multiple disk groups, and incase I wish to rollback the database to a previous good instant of time, can I just rollback some disk groups in the database or 'ALL' the diskgroups will have to be rolledback to maintain consistency. I am working on RAC as a user and not very clear on the underlying aspects of databases etc. Some of the questions above may sound flimsy. Any advise/suggestion is appreciated. Thanks deepika.dhamija@gmail.com on "Executing SQL from Shell Script" http://www.forum.askdba.org/topic/executing-sql-from-shell-script#post-112 Wed, 23 Dec 2009 07:25:14 +0000 deepika.dhamija@gmail.com 112@http://www.forum.askdba.org/ Hi, I have a two node RAC Cluster Setup (10R2) and I want to execute sql queries from a shell script, to be run as root. I have the foll test.sh script #! /bin/bash echo "In BASH" sqlplus / <<+ENDOFSQL+ select name, path from v$asm_disk; exit +ENDOFSQL+ echo "Back to Bash" exit and I get the foll O/P In BASH SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 23 07:25:32 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12546: TNS:permission denied Enter user-name: SP2-0306: Invalid option. Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] where <logon> ::= <username>[/<password>][@<connect_identifier>] | / Enter user-name: Enter password: ERROR: ORA-12546: TNS:permission denied SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus Back to Bash What permissions should for this? 2) Also I need to know the node names of the nodes that form the clustre. I add the foll lines to my script NODE_NAMES=<code>olsnodes</code> echo $NODE_NAMES ad I get O/P linux-1 linux-2 Is it possible to store these space separated node names in diff variables that can then be used. (the number of nodes are variable) Any suggestion/advise is appreciated. Thanks deepika.dhamija@gmail.com on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-103 Tue, 08 Dec 2009 09:37:34 +0000 deepika.dhamija@gmail.com 103@http://www.forum.askdba.org/ Hi I have a 2node RAC Setup 10gR2. I have three ASM Volumes configured, out of devices sdb2, sdb3, sdb4 /etc/init.d/oracleasm createdisk VOL1 /dev/sdb2 /etc/init.d/oracleasm createdisk VOL2 /dev/sdb3 /etc/init.d/oracleasm createdisk VOL3 /dev/sdb4. where VOL1 & VOL2 belong to the Disk Group ORCL_DATA1 and Vol3 to the group FLASH_RECOVERY_AREA. I want to use the multipath disks namely /dev/multipath/sdb2, /dev/multipath/sdb3 and /dev/multipath/sdb4 for asm volumes. I created the multipath disks on node1 and edited the file /etc/sysconfig/oracleasm and set ORACLEASM_SCANORDER="multipath" and ORACLEASM_SCANEXCLUDE="sdb2 sdb3 sdb4". After a Reboot, the crs_stat shows On Node1 -------------------------------------------------------------------------------- Name Type Target State Host -------------------------------------------------------------------------------- ora....SM1.asm application ONLINE ONLINE linux1 ora....X1.lsnr application ONLINE ONLINE linux1 ora.linux1.gsd application ONLINE ONLINE linux1 ora.linux1.ons application ONLINE ONLINE linux1 ora.linux1.vip application ONLINE ONLINE linux1 ora....SM2.asm application ONLINE ONLINE linux2 ora....X2.lsnr application ONLINE ONLINE linux2 ora.linux2.gsd application ONLINE ONLINE linux2 ora.linux2.ons application ONLINE ONLINE linux2 ora.linux2.vip application ONLINE ONLINE linux2 ora.orcl.db application ONLINE ONLINE linux1 ora....l1.inst application ONLINE OFFLINE ora....l2.inst application ONLINE ONLINE linux2 ora....test.cs application ONLINE ONLINE linux2 ora....cl1.srv application ONLINE OFFLINE ora....cl2.srv application ONLINE ONLINE linux2 oracle@linux1 ~$ sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 8 12:04:53 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> select name, path from v$asm_disk; select name, path from v$asm_disk * ERROR at line 1: ORA-01034: ORACLE not available I try to start the instance manually, oracle@linux1 ~$ srvctl start instance -d orcl -i orcl1 PRKP-1001 : Error starting instance orcl1 on node linux1 CRS-0215: Could not start resource 'ora.orcl.orcl1.inst'. Also from sql SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+ORCL_DATA1/orcl/spfileorcl.ora' ORA-17503: ksfdopn:2 Failed to open file +ORCL_DATA1/orcl/spfileorcl.ora ORA-15077: could not locate ASM instance serving a required diskgroup On Node2 -------------------------------------------------------------------------------- oracle@linux2 ~$ sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 8 11:56:13 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL> select name, path from v$asm_disk; NAME -------------------------------------------------------------------------------- PATH -------------------------------------------------------------------------------- VOL1 ORCL:VOL1 VOL2 ORCL:VOL2 VOL3 ORCL:VOL3 Plz note, that I have the multipath devices only on one node currently. I am new to the multipathing concept. Plz advise, on what (above) steps are wrong and what additional things are to be taken care of. And the causes/solutions to the errors. Saurabh Sood on "RMAN-05001 While Using RMAN Duplicate" http://www.forum.askdba.org/topic/rman-05001-while-using-rman-duplicate#post-102 Thu, 22 Oct 2009 10:40:58 +0000 Saurabh Sood 102@http://www.forum.askdba.org/ RMAN-05001 can occur while cloning if: 1. The target server have same directory structure as of the source i.e you have to use something like: db_file_name_convert=("/u01/app/oracle/1020/","/u01/app/oracle/1020/") and while issuing: RMAN > duplicate target database to aux; RMAN-05001: auxiliary filename /u01/app/1020/fact01.dbf conflicts with a file used by the target database SOLUTION: ========= Use "NOFILENAMECHECK" clause as: RMAN > duplicate target database to aux NOFILENAMECHECK; Cheers!!! Saurabh Sood daniesh on "asmcmd register" http://www.forum.askdba.org/topic/asmcmd-register#post-90 Mon, 21 Sep 2009 13:56:02 +0000 daniesh 90@http://www.forum.askdba.org/ Hi, Is there anyway to register a database using asmcmd command? daniesh on "load balance" http://www.forum.askdba.org/topic/load-balance#post-93 Fri, 25 Sep 2009 16:21:16 +0000 daniesh 93@http://www.forum.askdba.org/ Hi, How do we find the load balancing in RAC. Thanks and Regards, Amit Bansal on "SQL to find objects on which Full table scan is being performed" http://www.forum.askdba.org/topic/sql-to-find-objects-on-which-full-table-scan-is-being-performed#post-92 Thu, 24 Sep 2009 10:09:10 +0000 Amit Bansal 92@http://www.forum.askdba.org/ This is very straight forward SQL which can be used to identify objects on which Full Table Scan (FTS) is being performed. select object_owner,object_name from V$SQL_PLAN where operation='TABLE ACCESS' and options='FULL' and object_owner<>'SYS'; Please note that this will work with queries cached in shared pool. In 10g and above, you can also query DBA_HIST_SQL_PLAN to get historical information. alok on "Exclude parameter in Import Script??" http://www.forum.askdba.org/topic/exclude-parameter-in-import-script#post-88 Wed, 16 Sep 2009 07:23:52 +0000 alok 88@http://www.forum.askdba.org/ Hi All, I am a junior oracle dba. I know this is one is easy for you all. Just wanted to know whether we can exclude the tables, which we dont want to have the import of? I mean, i have a dump file *.dmp by export script on production db. I have copied the dump file to our development db. There are almost 300 tables in the *.dmp file and i want to exclude some 20 to 25 tables from the dump file. Is it possible to using any EXCLUDE parameter in the import scrip that would exclude the tables. Our db is oracle 9i. Hope i wud get a quick reponse from you guys :) Amit Bansal on "Disabling Tablespace threshold alert for particular tablespace" http://www.forum.askdba.org/topic/disabling-tablespace-threshold-alert-for-particular-tablespace#post-85 Thu, 10 Sep 2009 10:51:59 +0000 Amit Bansal 85@http://www.forum.askdba.org/ To disable Threshold for tablespace (Percent type), use following statement <pre> exec DBMS_SERVER_ALERT.SET_THRESHOLD( - metrics_id => DBMS_SERVER_ALERT.TABLESPACE_PCT_FULL, - warning_operator => DBMS_SERVER_ALERT.OPERATOR_DO_NOT_CHECK,- warning_value => '0', critical_operator => DBMS_SERVER_ALERT.OPERATOR_DO_NOT_CHECK,- critical_value => '0', observation_period => 1,- consecutive_occurrences => 1, instance_name => NULL, - object_type => DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE,- object_name => 'USERS'); </pre> Replace tablespace USER with the tablespace you want to exclude from monitoring If you have also enabled tablespace alerts based on Bytes left, then use following <pre> exec DBMS_SERVER_ALERT.SET_THRESHOLD( - metrics_id => DBMS_SERVER_ALERT.TABLESPACE_BYT_FREE, - warning_operator => DBMS_SERVER_ALERT.OPERATOR_DO_NOT_CHECK, - warning_value => '0', - critical_operator => DBMS_SERVER_ALERT.OPERATOR_DO_NOT_CHECK, - critical_value => '0', observation_period => 1, - consecutive_occurrences => 1, - instance_name => NULL, - object_type => DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE, - object_name => 'USERS'); </pre> Amit Bansal on "Easy conversion of Datablock address(DBA) to file# and block#" http://www.forum.askdba.org/topic/easy-conversion-of-datablock-addressdba-to-file-and-block#post-83 Sat, 29 Aug 2009 07:28:16 +0000 Amit Bansal 83@http://www.forum.askdba.org/ I was getting following errors while using Dbverify on a file <pre> >dbv file=dc_users_01.dbf blocksize=8192 DBVERIFY: Release 10.2.0.2.0 - Production on Thu Aug 27 11:09:04 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. DBVERIFY - Verification starting : FILE = dc_users_01.dbf Block Checking: DBA = 96495368, Block Type = KTB-managed data block data header at 0x10020aa7c kdbchk: bad row offset slot 16 offs 58 fseo 1683 dtl 8168 bhs 104 Page 26376 failed with check code 6135 DBVERIFY - Verification complete Total Pages Examined : 256000 Total Pages Processed (Data) : 25740 Total Pages Failing (Data) : 1 Total Pages Processed (Index): 1 Total Pages Failing (Index): 0 Total Pages Processed (Other): 664 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 229595 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Highest block SCN : 3211169690 (1408.3211169690) </pre> To find file# and block# I used dbms_utility package <pre> select dbms_utility.data_block_address_file(&&rdba) RFN, dbms_utility.data_block_address_block(&&rdba) BL from dual; 2 3 Enter value for rdba: 96495368 old 1: select dbms_utility.data_block_address_file(&&rdba) RFN, new 1: select dbms_utility.data_block_address_file(96495368) RFN, old 2: dbms_utility.data_block_address_block(&&rdba) BL new 2: dbms_utility.data_block_address_block(96495368) BL RFN BL ---------- ---------- 23 26376 </pre> On further analysis , found that the block number 26376 did not contain any object and maximum block used was 25225 <pre> SQL> select max(block_id) from dba_extents where file_id=23; MAX(BLOCK_ID) ------------- 25225 select (25225*8192)/1024/1024 from dual; (25225*8192)/1024/1024 ---------------------- 197.070313 SQL> alter database datafile '/lmsdb/lms01/dc_users_axlmsdb_tblspc_01.dbf' resize 200m; Database altered. </pre> Running dbv again, gave a clean output. Saurabh Sood on "Unix Tip: How To Remove Log Files Older Than 10 Days" http://www.forum.askdba.org/topic/unix-tip-how-to-remove-log-files-older-than-10-days#post-82 Fri, 28 Aug 2009 12:04:24 +0000 Saurabh Sood 82@http://www.forum.askdba.org/ Use the below given command to remove logfiles older than 10 days: cd to the directory where the files are located: $ cd /u01/app/oracle/admin/orcl/bdump $ find . -name "*.log" -mtime +10 -exec rm -f {} \; OR $ find /u01/app/oracle/admin/orcl/bdump/ -name "*.log" -mtime +10 -exec rm -f {} \; Amit Bansal on "Unix tip: Finding files not containing a pattern" http://www.forum.askdba.org/topic/unix-tip-finding-files-not-containing-a-pattern#post-81 Wed, 26 Aug 2009 17:27:41 +0000 Amit Bansal 81@http://www.forum.askdba.org/ Q. How do you find files which do not contain a specific pattern say 'ORA-' A. You can use below command find . -name "*log" \! -exec grep -q "ORA-" {} \; -print Amit Bansal on "Monitoring archive gap in standby" http://www.forum.askdba.org/topic/monitoring-archive-gap-in-standby#post-80 Tue, 25 Aug 2009 16:35:50 +0000 Amit Bansal 80@http://www.forum.askdba.org/ You can use following sql to monitor the gap in standby using following sql <pre> sqlplus -s "/ as sysdba" <<EOF set head off set feedb off select (select name from V\$DATABASE),(select max(sequence#) from v\$archived_log where dest_id=1) Current_primary_seq,( select max(sequence#) from v$\archived_log where to_date(next_time,'dd-mm-yyyy') > sysdate-1 and dest_id=2 ) max_stby,(select nvl((select max(sequence#) - min(sequence#) from v\$archived_log where to_date(next_time,'dd-mm-yyyy') > sysdate-1 and dest_id=2 and applied='NO'),0) from dual) "To be applied",((select max(sequence#) from v\$archived_log where dest_id=1) - (select max(sequence#) from v\$archived_log where dest_id=2)) "To be Shipped" from dual / </pre> Assumptions - Dest_id=1 --> Primary DB Dest_id=2 -->Standby site This query reports the number of archives which need's to be shipped along with number of archive log's which need to be applied. If you are looking for script, you can get the logic from following thread <a href="http://forums.oracle.com/forums/thread.jspa?messageID=3708034" rel="nofollow">http://forums.oracle.com/forums/thread.jspa?messageID=3708034</a> Amit Bansal on "Monitoring top 10 memory consuming process on AIX" http://www.forum.askdba.org/topic/monitoring-top-10-memory-consuming-process-on-aix#post-79 Tue, 25 Aug 2009 16:30:35 +0000 Amit Bansal 79@http://www.forum.askdba.org/ At times, you wish to find the processes with maximum memory consumption. This can be easily done using following command. Copy contents in file and run it like as vmstat command <pre> ### Usage mem_mon.sh (interval) (occurences) e.g sh mem_mon.sh 2 10 ### ### This will give top 10 memory consuming processes ##### wt_time=$1 lmt=$2 let a=0 while [[ $a -lt $lmt ]] ; do ps axwv |sort -nrk 7,7|grep -v "COMMAND" \ |awk 'BEGIN {printf ("MemoryinKb \t ProcessId \t PerCPU \t PerMem \t Command \n")}{t=t+$7 - $10 ;printf("%13d \t %10d \t %6.2f \t %6.2f \t %s \n",$7 - $10,$1,$11,$12,$13)}END{print t}'|head -10 let a+=1 sleep $wt_time done </pre>