Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "Alter system switch logfile" hangs
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