URGENT - Cannot switch logfile while importing!
Hi,
Oracle 8.1.7.2
I've issued the command to switch log
> alter system switch logfile;
but its hanging!!
the v$log looks like this
GROUP# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_TIME
------- --------- --------- --------- --- ---------------- ----------
9 22525 10485760 2 NO ACTIVE 28/12/2003
7 22526 10485760 2 NO ACTIVE 28/12/2003
10 22527 52428800 2 NO ACTIVE 28/12/2003
11 22528 52428800 2 NO ACTIVE 28/12/2003
12 22529 52428800 2 NO ACTIVE 28/12/2003
13 22530 52428800 2 NO CURRENT 28/12/2003
The db is not in archivelog mode... I'm importing so I switched it off..
Please help!! URGENT!!
P.S - I was trying to create bigger logfiles and wanted to drop the old (small) ones... but they are ACTIVE.
Kev
Re: URGENT - Cannot switch logfile while importing!
Quote:
Originally posted by krw
Hi,
Oracle 8.1.7.2
I've issued the command to switch log
> alter system switch logfile;
but its hanging!!
the v$log looks like this
GROUP# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_TIME
------- --------- --------- --------- --- ---------------- ----------
9 22525 10485760 2 NO ACTIVE 28/12/2003
7 22526 10485760 2 NO ACTIVE 28/12/2003
10 22527 52428800 2 NO ACTIVE 28/12/2003
11 22528 52428800 2 NO ACTIVE 28/12/2003
12 22529 52428800 2 NO ACTIVE 28/12/2003
13 22530 52428800 2 NO CURRENT 28/12/2003
The db is not in archivelog mode... I'm importing so I switched it off..
Please help!! URGENT!!
P.S - I was trying to create bigger logfiles and wanted to drop the old (small) ones... but they are ACTIVE.
Kev
Is log_archive_start=true? After you switched to noarchivelog mode, did you stop also the archiver?
log_archive_start should be false!
BTW, this parameter is obsolete in 10g.
Re: Re: URGENT - Cannot switch logfile while importing!
Quote:
Originally posted by julian
Is log_archive_start=true? After you switched to noarchivelog mode, did you stop also the archiver?
log_archive_start should be false!
BTW, this parameter is obsolete in 10g.
Correct me if I am wrong BUT as per my understanding LOG_ARCHIVE_START value doesn't matter when you have switched to NOARCHIVELOG mode.
BTW Julian, where are you getting 10g information from? Did you get Docs with the beta copy??