Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: copy db, startup nomount /create controlfile hangs entire VMS system!

Re: copy db, startup nomount /create controlfile hangs entire VMS system!

From: Tim Smith <timasmith_at_hotmail.com>
Date: 27 Mar 2003 21:10:02 -0800
Message-ID: <a7234bb1.0303272110.46bda7b2@posting.google.com>


timasmith_at_hotmail.com (Tim Smith) wrote in message news:<a7234bb1.0303270842.27a688d3_at_posting.google.com>...
> Hi,
> We upgraded to vms7.2 and I have a copy of production 160GB
> database files on this new system. I am using STARTUP MOUNT and
> CREATE CONTROLFILE - see below - but it is hanging the entire system
> (2 CPU 2GB MEM). I have done this before with a small database and it
> did hang the system for 5 minutes - is there a reason this is taking
> so long, it has been going for 15 minutes as I write...
>
> STARTUP NOMOUNT
> CREATE CONTROLFILE REUSE set DATABASE "TEST" RESETLOGS ARCHIVELOG
> MAXLOGFILES 32
> MAXLOGMEMBERS 3
> MAXDATAFILES 1022
> MAXINSTANCES 16
> MAXLOGHISTORY 5000
> LOGFILE
> GROUP 10 (
> 'DISK_DB03:[D.DIR]LOG10_01.RDO'
> ) SIZE 100M,
> GROUP 11 (
> 'DISK_DB04:[D.DIR]LOG11_01.RDO'
> ) SIZE 100M,
> GROUP 12 (
> 'DISK_DB05:[D.DIR]LOG12_01.RDO'
> ) SIZE 100M,
> GROUP 13 (
> 'DISK_DB06:[D.DIR]LOG13_01.RDO'
> ) SIZE 100M
> DATAFILE
> 'DISK_DB03:[D.DIR]D_TS_01.DBS',
> ... etc for 600 data files

never mind seems I thought I edited the init.ora but did not and was using more memory than available... Received on Thu Mar 27 2003 - 23:10:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US