Why doesn't Oracle kill dead connections?

Hi I have a Reporting appliaction. The reports are run from the browser . The reports are basically Pl/SQL packages .the request is made from the browser and then communicated to the database thru OAS .(oracle application server) which acts as web server. The problem is when a user executes

Disaster recovery using RMAN

Hi Here in my company we are planning to put together a disaster recovery plan using RMAN would like to test various recovery scenarios using RMAN. Couldanyone provide the information on the procedures followed in a testing like this? TIA

Using RMAN

Hi Currently we are using Unix scripts to do backups.We keep last 2 days of backups on the disk and also take the backups on tape daily. We are planning to use RMAN for backups and would like to maintain the the same policy of 2 days backup on disk and daily tape backups. Is it possible to

Re: Why doesn't Oracle kill dead connections?

'![if !supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p p class=MsoNormal style='margin-left:.5in'font size=2 color=black face=Tahomaspan style='font-size:10.0pt;font-family:Tahoma;color:black'-Original Message-br bspan style='font-weight:bold'From:/span/b Sona [mailto:[EMAIL

Re: limit user CPU usage

: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: RMAN backup and restore Q?

This error occurs when you are trying recovery on an open database.the database should be in MOUNT mode for recovery. Sona - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 4:25 AM Hi All, I'm in the process

Re: Using RMAN

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Disaster recovery using RMAN

: Sent by: Subject: RE: Disaster recovery using RMAN [EMAIL PROTECTED] m 01/17/02 05:05 AM Please respond to ORACLE-L Sona - I am planning

Re: Using RMAN

what media magmt sortware are you using .We will be using Veritas Netbackup here. Thanks Sona - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 11:55 AM We use rman to backup all of our databases. But most importantly, we

RMAN-20202 error while recovery

name system Any ideas why this error occurs The intersting thing is that if i use recover datafile ,the recovery goes thru. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Re: RMAN - restoring archive logs

to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RMAN error

HI I trying to recoverfrom loss of all controlfiles and a datafile which was not backed upusing RMAN . these are the steps i followed startup nomount These are the RMAN commands executed. {allocate channel c1 type disk;restore controlfile;sql 'alter database mount';restore

RMAN problem

exception during command execution on channel default RMAN-20009: database incarnation already registered How do we successfilly restore a prevous cold backup and use the RMAN to take backups on that database? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona

RMAN error while TSPITR

tablespace admin; release channel c1; } Any ideas about this one? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: RMAN error while TSPITR

What do i set the NLS_DATE_FORMAT as? I tried setting it as export NLS_DATE_FORMAT=MON DD HH24:MI:SS But got this error : ksh: HH24:MI:SS: is not an identifier Setting it to export NLS_DATE_FORMAT=MON-DD-HH24:MI:SS worked but i still get the same error. Sona - Original

Re: RMAN error while TSPITR

of failing SQL statement: select to_date('30-JAN-2002 14:53:56') from sys.dual RMAN-06099: error occurred in source file: krmk.pc, line: 4354 Am I missing something? I also set the nls_date_format for the target database to DD-MON- HH24:MI:SS Sona - Original Message - To: Multiple

Sending email from Unix

Title: Oracle standby strange behavior Hi I want to send an email from Unix with an attachment .does anyone know how to do this? TIA

Re: Sending email from Unix

: Sending email from Unix use PINE, that is the best and easiest email program on UNIX (IMHO). Easy to send attachments :) HTH ReedK -Original Message-From: Sona [mailto:[EMAIL PROTECTED]]Sent: Friday, February 01, 2002 12:07 PMTo: Multiple recipients of list

RMAN question

LV Type Ckp SCNCkp Time - -- -- -- --- 3/ora/data01/bkuptest/dbfiles/admin.1.dbf 0 Full 162956 04-FEB-02 TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL

White paper on Partitioning

Hi Is there a white paper on benchmarking done by Oracle on Partitioning? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RMAN question

-FEB-02 TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RMAN full backup Vs Incremental level 0

Hi I would like to know what are the advantages /disadvantages of full backups vs. incremental level 0 backups.Which one should bedone if we decide to take backups only once daily? How is the recovery operation going to be affected if we choose either? for e.g if i decided to do incremental

Limiting RMAN backup size

HiI am doing RMAN incremental level 0 backup .The database size is about 150GB out of which used would be about 100GB.I don't have a single volume with 100GB of space.So I need to distribute the backup across several disks. Also I need to limit the backup size in each of the volumes

Finding out used blocks in the database

Hi As we all know RMAN backs up only the used blocks in the database.Was wondering if there is any way to query the database to find out if a block is used or not so as to find out how much of the database is currently being used ? TIA

Re: Finding out used blocks in the database

Vadim Howdo you do block dump to find out used blocks? TIA - Original Message - From: Vadim Gorbounov To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 2:38 PM Subject: RE: Finding out used blocks in the database Sona, AFAIK

Changing backup locations in RMAN

Hi, I have taken a incr backup using RMAN at location /ora/backup.Now I want to change the location of the backup to /ora/backup1. How do I change the backup location in the recovery catalog? TIA