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: "Alter system switch logfile" hangs

Re: "Alter system switch logfile" hangs

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 04 Jun 2003 18:32:59 +0800
Message-ID: <3EDDCADB.5A99@yahoo.com>


Gaetan wrote:
>
> Hello.
>
> I'm using Oracle 9.2.0.1.0 under AIX 5.1 to replicate a database using
> a 3rd party tool which we develop. I'm not a DBA and usually get all
> the help from this group or from Metalink but I'm running out of ideas
> and time.
>
> I wrote scripts to put the tablespace in hotbackup mode but the
> command "alter system switch logfile" just hangs when executed the
> second time.
>
> When I run the query manually, the command hangs after the 3rd time
>
> SQL> alter tablespace EXAMPLE begin backup
> Tablespace altered
> SQL> alter tablespace EXAMPLE end backup
> Tablespace altered
> SQL> alter database backup controlfile to trace;
> Database altered
> SQL> alter system switch logfile
> System altered
> SQL> alter tablespace EXAMPLE begin backup
> Tablespace altered
> SQL> alter tablespace EXAMPLE end backup
> Tablespace altered
> SQL> alter database backup controlfile to trace;
> Database altered
> SQL> alter system switch logfile
> HANGS AT THIS TIME UNTIL I PRESS CTRL^C
>
> No .ARC files are being created. I uncommented LOG_ARCHIVE_START and
> LOG_ARCHIVE_DEST in the init.ora, bounced the instance but it doesn't
> make any changes
>
> I'm not a DBA and usually get all the help from this group or from
> Metalink.
>
> - Also, Which SQL command shows if the tablespace is in hotbackup mode
> or not ??
>
> Thanks in advance
> Regards
> Gaetan

Take a look in the alert.log for any possible errors.

V$BACKUP is the view you want for backup mode

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"
Received on Wed Jun 04 2003 - 05:32:59 CDT

Original text of this message

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