RE: [sap-basis] DB02, Alerts Database Check
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Al Fournier (SAP Basis Administrative Staff) on Jul 31 at 3:58 PM |  Mark as helpful |
I am in full agreement. The problem you are encountering is that your system now recognizes that you may be running out of space on your existing drive.....My advice is to exercise caution, check and verify your database growth and prepare to/or obtain more disk space to accommodate future growth.
From: Lars-Erik Hallsten via sap-basis [mailto:sap-basis@groups.ittoolbox.com]
Sent: Friday, July 31, 2009 3:47 PM
To: Fournier, Albert
Subject: RE: [sap-basis] DB02, Alerts Database Check
[http://userimages.toolbox.com/user/b_170849.jpg]
Posted by Lars-Erik Hallsten (CEO & Senior Consultant)
on Jul 31 at 3:36 PM
[http://images.ittoolbox.com/vt/icons/vote.png]Mark as helpful<http://it.toolbox.com/api/ContentVote/2910659/1/1/>
Hi,
This is up to every system administrator to decide. I'm always using
autoextend in my systems.
I believe that is the recommendations from SAP, as well. Afterall all the
new SAP systems on Oracle are all installed with autoextend activated by
default. However, I know some admins want to deactivate it to have better
control, but do you really get better control? Maybe you get better control
on the data file growth, but it might cause more downtime on the system, if
not handeled correctly. That's my experience, anyway.
Regards,
LEH
From: Maverick via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 31. juli 2009 21:17
To: Lars-Erik Hallsten
Subject: [sap-basis] DB02, Alerts Database Check
Posted by Maverick
on Jul 31 at 3:23 PM
DB02, Alerts Database Check
I got the following messages:
CRITICAL_FILE
File: /oracle/<sid>/sapdata1/sr3_1/sr3.data1, value: (max_extn) 7639040 KB
(> 4358592 KB) # File autoextend can cause file system
I have to change the max_extn or turn off autoextend for data file. I want
to turn off autoextend for all the datafiles, but just keep the last one
datafile with autoextend, what do you think?
CRITICAL_TABLESPACE
Tablespace: PSAPSR3 # Tablespace files autoextend can cause file system
overflow
I think I should turn off autoextend in all tablespaces to have a better
control, but the problem I have is when I add a new datafile the space used
in filesystem is increased and I don?t have a lot of space. I?m not sure if
I should reduce the new datafile size or keep autoextend on.
Regards,
Mav
__.____._ From: Lars-Erik Hallsten via sap-basis [mailto:sap-basis@groups.ittoolbox.com]
Sent: Friday, July 31, 2009 3:47 PM
To: Fournier, Albert
Subject: RE: [sap-basis] DB02, Alerts Database Check
[http://userimages.toolbox.com/user/b_170849.jpg]
Posted by Lars-Erik Hallsten (CEO & Senior Consultant)
on Jul 31 at 3:36 PM
[http://images.ittoolbox.com/vt/icons/vote.png]Mark as helpful<http://it.toolbox.com/api/ContentVote/2910659/1/1/>
Hi,
This is up to every system administrator to decide. I'm always using
autoextend in my systems.
I believe that is the recommendations from SAP, as well. Afterall all the
new SAP systems on Oracle are all installed with autoextend activated by
default. However, I know some admins want to deactivate it to have better
control, but do you really get better control? Maybe you get better control
on the data file growth, but it might cause more downtime on the system, if
not handeled correctly. That's my experience, anyway.
Regards,
LEH
From: Maverick via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 31. juli 2009 21:17
To: Lars-Erik Hallsten
Subject: [sap-basis] DB02, Alerts Database Check
Posted by Maverick
on Jul 31 at 3:23 PM
DB02, Alerts Database Check
I got the following messages:
CRITICAL_FILE
File: /oracle/<sid>/sapdata1/sr3_1/sr3.data1, value: (max_extn) 7639040 KB
(> 4358592 KB) # File autoextend can cause file system
I have to change the max_extn or turn off autoextend for data file. I want
to turn off autoextend for all the datafiles, but just keep the last one
datafile with autoextend, what do you think?
CRITICAL_TABLESPACE
Tablespace: PSAPSR3 # Tablespace files autoextend can cause file system
overflow
I think I should turn off autoextend in all tablespaces to have a better
control, but the problem I have is when I add a new datafile the space used
in filesystem is increased and I don?t have a lot of space. I?m not sure if
I should reduce the new datafile size or keep autoextend on.
Regards,
Mav
Copyright © 2009 CEB Toolbox, Inc. and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Al FournierSAP Basis Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Have an SAP Question? Ask Your Peers at Toolbox for IT
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
