|
-
Hi DBA's
I have a database which is not set to archive log. Every one hour it is generating a redolog file approximately. I checked my init.ora parameters and they are set as:: log_checkpoint_interval = 999999999
log_checkpoint_timeout = 0
my svrmgr session is:
SVRMGR> connect internal
Connected.
SVRMGR> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle/product/8.1.6/dbs/arch
Oldest online log sequence 17348
Current log sequence 17350
my bdump shows:
$ pwd
/u01/app/oracle/admin/nbs/bdump
$ tail -15 alert_nbs.log
Wed Nov 29 11:17:54 2000
Thread 1 advanced to log sequence 17346
Current log# 3 seq# 17346 mem# 0: /u02/oradata/nbs/redo03.log
Wed Nov 29 12:14:00 2000
Thread 1 advanced to log sequence 17347
Current log# 1 seq# 17347 mem# 0: /u02/oradata/nbs/redo01.log
Wed Nov 29 13:10:06 2000
Thread 1 advanced to log sequence 17348
Current log# 2 seq# 17348 mem# 0: /u02/oradata/nbs/redo02.log
Wed Nov 29 14:06:10 2000
Thread 1 advanced to log sequence 17349
Current log# 3 seq# 17349 mem# 0: /u02/oradata/nbs/redo03.log
Wed Nov 29 15:02:18 2000
Thread 1 advanced to log sequence 17350
Current log# 1 seq# 17350 mem# 0: /u02/oradata/nbs/redo01.log
Can you please justify:::
Thanks
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
|