-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|