Re: Help needed making a DB copy

From: Vince Laurent <eAddict_at_yahoo.com>
Date: Wed, 17 Mar 2004 10:45:08 -0600
Message-ID: <e30h50hhk60hvvditjkpl7lmh07pj2fhi5@4ax.com>

the stopdb script does a shutdown immediate:

connect / as sysdba;
alter system switch logfile;
connect / as sysdba;
shutdown immediate;

HTH and thanks,
Vince

On Thu, 18 Mar 2004 01:36:28 +1100, "Howard J. Rogers" <hjr_at_dizwell.com> wrote:
>
>"Vince Laurent" <eAddict_at_yahoo.com> wrote in message
>news:n5og50h8497qa07f1072fjfuquhgl6l1b2_at_4ax.com...
>> On 16 Mar 2004 23:38:05 -0800, srivenu_at_hotmail.com (srivenu) wrote:
>>
>> >How did you shutdown the database ?
>>
>> Stopsap - which does a shutdown command.
>
>Uh huh.
>
>> Why would I need to give log files if the database was shut down
>> cleanly?
>
>The command you issued sounds to me like a SAP command, not an Oracle one.
>And although you say it "does a shutdown", what sort of shutdown does it do?
>What's to stop "stopsap" from issuing a "shutdown abort" under the hood?
>
>So your question is spot on. It's the assumption that your database *was*
>shutdown cleanly that I'd question.

---

Come race with us!
www.mgpmrc.org Received on Wed Mar 17 2004 - 10:45:08 CST