Re: RMAN Recovery - RBS (Non System) tbs

2003-04-05 Thread Layzee DBA
--- Layzee DBA <[EMAIL PROTECTED]> wrote: > Hi DBA's > > I am in the process of establishing Crash Recovery > scenarios using RMAN and i came across one situation > > wherein i am able to recover a tbs having (non > system > tbs) rbs in it using svrmgrl but the same damn thing > > does not wo

Re: daily clone

2003-04-05 Thread Hemant K Chitale
"REUSE" applies to the ControlFile [ie, reuse if file exists, error if file exists and REUSE not specified]. "SET" applies to the Database Name [SET is used when changing the datababase name] Hemant At 05:44 AM 03-04-03 -0800, you wrote: Jared, Thanks for the reply. I will try next time. I j

RE: Memory strangeness on Win2k

2003-04-05 Thread Ashish
You need to increase value for SGA_MAX_SIZE parameter. Ashish OCP DBA -Original Message- Baumgartel Sent: Friday, April 04, 2003 5:04 PM To: Multiple recipients of list ORACLE-L So I have DB (9.2.0.1) running on Win2K, with db_cache_size of 32M. Windows Task Manager shows 600+ MB of fr

Re: SunCluster 3. 0 Veritas File system RAC

2003-04-05 Thread Murali Vallath
You will be better off recommending veritas file system, you can assure yourself of some good performance matrix and easy transisition and off course some good nights of sleep.  Allowing Sun to manage the file system or for that matter the raw partitions is a nightmare.  I am speaking from experien

Re: RE: Autoallocate vs Uniform extent performance

2003-04-05 Thread Richard Foote
Hi Jonathan, OK let's give it a go (note that I'm now doing this at home on my not quite so powerful PC with Best of Bowie playing on the CD so it's just me having a play) SQL> create tablespace biggish 2 datafile 'c:\bowie\biggish01.dbf' size 3000m 3 uniform size 24k; Tablespace created.

Re: submitting statspack.snap through dbms_job

2003-04-05 Thread Murali Vallath
If you are not already aware there is an spauto.sql in the $ORACLE_HOME/rdbms/admin directory  which could be modified with the following for example: next_date=>trunc(sysdate)+10/24, interval=>'trunc(sysdate)+10/24'); Regards Murali  Zabair Ahmed <[EMAIL PROTECTED]> wrote: Quick question, I want

Re: Rollback and what table's DML caused an ORA-1555?

2003-04-05 Thread Jonathan Lewis
alter rollback segment XXX storage (optimal null); Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutori