day, April 02, 2002 10:28 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: archive log curr v. switch logfile
>
> I use Alter system archive log current. If your archiver process is
> caught up, you will get this error message when issuing Alter system
> ar
c.
954-935-4117
> -Original Message-
> From: Post, Ethan [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 29, 2002 11:48 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: archive log curr v. switch logfile
>
> I believe alter system archive log current will
That's exactly, what I meant (besides the fact, that "alter system archive
log current" will return only after Archiver is done archiving "current"
log).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Frid
gency.com> cc:
Sent by:Subject: archive log curr v.
switch
PROTECTED]
> Sent: Friday, March 29, 2002 9:48 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: archive log curr v. switch logfile
>
> Will "alter system archive log current" work, if the database is not in
> "archive" mod
SQL> alter system archive log current;
alter system archive log current
*
ERROR at line 1:
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
1* alter system archive log current to '/tmp/dummy.log'
SQL> /
alter system archive log current to '/tmp/dummy.log'
*
ERROR at line 1:
I believe alter system archive log current will wait until archiver has
successfully archived the file, thus this is the one you would want to use
in any backup scripts.
- Ethan
-Original Message-
Sent: Friday, March 29, 2002 10:24 AM
To: Multiple recipients of list ORACLE-L
Can an
Fairfield Resorts, Inc.
954-935-4117
> -Original Message-
> From: Post, Ethan [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 29, 2002 11:48 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: archive log curr v. switch logfile
>
> I believe alt
Will "alter system archive log current" work, if the database is not in
"archive" mode?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 29, 2002 11:23 AM
>
>
> Can anyone tell me the differe
Can anyone tell me the difference between
alter system archive log current
and
alter system switch logfile
(Seems they both perform checkpoint and both switch a log file).
Is one preferred over the other for purposes of switching log files prior to
applying to a standby database
10 matches
Mail list logo