Re: System Modes QUIESCE / SUSPEND

On Tue, 31 Jan 2006 05:57:22 -0800, Daniel wrote:

> "The SUSPEND clause lets you suspend all I/O (datafile, control file,
> and file header) as well as queries, in all instances, enabling you to
> make copies of the database without having to handle ongoing
> transactions.".

His question signifies (the "begin/end backup" part) that he wants to
copy database by splitting BCV's. With the suspend command, you don't
need begi/end backup. You do the following:
alter system checkpoint;
(wait until the checkpoint is done)
alter system suspend;

split 'em!

Alter system resume.


On the copied machine you can just restart the database and it
be OK.


--
http://www.mgogala.com

.

Relevant Pages

  • Re: Korn shell scripting quanry
    ... alter system suspend command. ... echo "Enter Oracle SID you are processing" ...
    (comp.unix.shell)
  • RE: updating datagrid after returning
    ... The dataGrid which show dsSize1 doesn't get updated, ... They will wait for the newSizeDeleteForm to close, ... database and continue executing with updated values. ... Actually, the code didn't suspend. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Exchange 2007 missing log
    ... This don't work, i have problem on active database, not on replication copy database. ... i try this procedure in EMS: ... Suspend ... update-storegegroupcopy -deleteexistingfiles ...
    (microsoft.public.exchange.admin)