|
-
Originally posted by marist89
There's two possiblities why you may be getting log files that are not close to 5M:
1. an "alter system swith logfile" command is being executed.
I have hot backup script running once a day with switch log command. But there are archived logs with different size at time other than the backup time.
Originally posted by marist89
2. You have a redo log file out there that is not sized to 5M.
Here is the query v$log:
13:21:38 SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
FIRST_CHANGE# FIRST_TIM
--------- --------- --------- --------- --------- --- ----------------
------------- ---------
3 1 26 5242880 2 YES INACTIVE
627490 28-JUN-01
4 1 27 5242880 2 NO CURRENT
648478 29-JUN-01
5 1 25 5242880 2 YES INACTIVE
625038 28-JUN-01
Notice the group# is 3, 4, 5. I added these three new groups after the creation of the database and dropped 2 old redo log groups.
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
|