How to Increase Auto Extend Size of Auto Extend Datafiles

How to increase autoextend size of autoextend datafiles Last Updated Tuesday, 23 February 2010 12:17

Please try at first to increase the autoextend size of the autoextend datafiles with the brtools (standard autoextend autoextend size is 30 GB maxsize and 100MB to increase):

s96sapti:oralox s96sapti:oralox 9% brtools BR0651I BRTOOLS 7.00 (32) BR0280I BRTOOLS time stamp: 2009-05-26 10.36.29 BR0656I Choice menu 1 - please make a selection ------------------------------------------------------------------------------BR*Tools main menu 1 = Instance management 2 - Space management 3 - Segment management 4 - Backup and database copy 5 - Restore and recovery 6 - Check and verification 7 - Database statistics 8 - Additional functions 9 - Exit program Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------BR0662I Enter your choice: 2 BR0280I BRTOOLS time stamp: 2009-05-26 10.36.34 BR0663I Your choice: '2' BR0280I BRTOOLS time stamp: 2009-05-26 10.36.34 BR0656I Choice menu 5 - please make a selection ------------------------------------------------------------------------------Database space management 1 = Extend tablespace 2 - Create tablespace 3 - Drop tablespace 4 - Alter tablespace 5 - Alter data file

1/8


6 - Move data file 7 - Additional space functions 8 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------BR0662I Enter your choice: 5 BR0280I BRTOOLS time stamp: 2009-05-26 10.36.40 BR0663I Your choice: '5' BR0280I BRTOOLS time stamp: 2009-05-26 10.36.40 BR0657I Input menu 85 - please check/enter input values ------------------------------------------------------------------------------BRSPACE options for alter data file 1 - BRSPACE profile (profile) ....... [initLOX.sap] 2 - Database user/password (user) ... [/] 3 ~ Alter data file action (action) . [] 4 ~ Tablespace names (tablespace) ... [] 5 ~ Data file names (file) .......... [] 6 - Confirmation mode (confirm) ..... [yes] 7 - Scrolling line count (scroll) ... [20] 8 - Message language (language) ..... [E] 9 - BRSPACE command line (command) .. [-p initLOX.sap -s 20 -l E -f dfalter] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------BR0662I Enter your choice: c BR0280I BRTOOLS time stamp: 2009-05-26 10.36.43 BR0663I Your choice: 'c' BR0259I Program execution will be continued... BR0291I BRSPACE will be started with options '-p initLOX.sap -s 20 -l E -f dfalter' BR0280I BRTOOLS time stamp: 2009-05-26 10.36.43 BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort: c BR0280I BRTOOLS time stamp: 2009-05-26 10.36.45 BR0257I Your reply: 'c' BR0259I Program execution will be continued... ############################################################################### BR1001I BRSPACE 7.00 (32)

2/8


BR1002I Start of BRSPACE processing: seaqubdl.dfa 2009-05-26 10.36.45 BR0484I BRSPACE log file: /oracle/LOX/sapreorg/seaqubdl.dfa BR0280I BRSPACE time stamp: 2009-05-26 10.36.46 BR1009I Name of database instance: LOX BR1010I BRSPACE action ID: seaqubdl BR1011I BRSPACE function ID: dfa BR1012I BRSPACE function: dfalter BR0280I BRSPACE time stamp: 2009-05-26 10.36.46 BR0656I Choice menu 314 - please make a selection ------------------------------------------------------------------------------Alter data file main menu 1 - Set data file online 2 - Set data file offline 3 - Turn on and maintain autoextend 4 - Turn off autoextend 5 - Resize data file 6 - Rename data file 7 - Drop empty data file 8 - Show data files 9 - Show tablespaces 10 - Show disk volumes 11 * Exit program 12 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------BR0662I Enter your choice: 3 BR0280I BRSPACE time stamp: 2009-05-26 10.37.30 BR0663I Your choice: '3' BR0280I BRSPACE time stamp: 2009-05-26 10.37.31 BR0659I List menu 315 + please select one or more entries ------------------------------------------------------------------------------List of data files for alter Pos. Tablespace

Status Type

1 - PSAPSR3 2 - PSAPSR3 3 - PSAPSR3 4 - PSAPSR3 5 - PSAPSR3700

ONLINE FILE ONLINE FILE ONLINE FILE ONLINE FILE ONLINE FILE

Size[KB] AuExt. File 2048000 YES /oracle/LOX/sapdata1/sr3_1/sr3.data1 2048000 YES /oracle/LOX/sapdata1/sr3_2/sr3.data2 2048000 YES /oracle/LOX/sapdata1/sr3_3/sr3.data3 2048000 YES /oracle/LOX/sapdata1/sr3_4/sr3.data4 4014080 YES /oracle/LOX/sapdata1/sr3700_1/sr3700.data1

3/8


6 - PSAPSR3700 ONLINE FILE 3850240 YES /oracle/LOX/sapdata1/sr3700_2/sr3700.data2 7 - PSAPSR3700 ONLINE FILE 3850240 YES /oracle/LOX/sapdata1/sr3700_3/sr3700.data3 8 - PSAPSR3700 ONLINE FILE 4034560 YES /oracle/LOX/sapdata1/sr3700_4/sr3700.data4 9 - PSAPSR3DB ONLINE FILE 2048000 YES /oracle/LOX/sapdata1/sr3db_1/sr3db.data1 10 - PSAPSR3DB ONLINE FILE 2048000 YES /oracle/LOX/sapdata1/sr3db_2/sr3db.data2 11 - PSAPSR3DB ONLINE FILE 1024000 YES /oracle/LOX/sapdata1/sr3db_3/sr3db.data3 12 - PSAPSR3USR ONLINE FILE 20480 YES /oracle/LOX/sapdata1/sr3usr_1/sr3usr.data1 13 - PSAPTEMP ONLINE FILE 1024000 YES /oracle/LOX/sapdata1/temp_1/temp.data1 14 - PSAPUNDO ONLINE FILE 6307840 YES /oracle/LOX/sapdata1/undo_1/undo.data1 15 - SYSAUX ONLINE FILE 204800 YES /oracle/LOX/sapdata1/sysaux_1/sysaux.data1 16 - SYSTEM SYSTEM FILE 512000 YES /oracle/LOX/sapdata1/system_1/system.data1 Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------BR0662I Enter your selection: 8 BR0280I BRSPACE time stamp: 2009-05-26 10.37.44 BR0663I Your selection: '8' BR0280I BRSPACE time stamp: 2009-05-26 10.37.44 BR0657I Input menu 316 - please check/enter input values ------------------------------------------------------------------------------Options for alter of data file /oracle/LOX/sapdata1/sr3700_4/sr3700.data4 1 * Current data file status (status) ....... [AUTOEXTEND] 2 * Current data file size in MB (currsize) . [3940] 3 * Alter data file action (action) ......... [autoext] 4 - Maximum file size in30000 MB (maxsize) ....... [ ] 5 - File increment size in100 MB (incrsize) .... [ ] 6 # New data file size in MB (size) ......... [] 7 # New data file name (name) ............... [] 8 # Force data file alter (force) ........... [no] 9 - SQL command (command) ................... [alter database datafile '/oracle/LOX/sapdata1/sr3700_4/sr Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------BR0662I Enter your choice: c BR0280I BRSPACE time stamp: 2009-05-26 10.37.50 BR0663I Your choice: 'c' BR0259I Program execution will be continued... BR1049W Not enough free space in /oracle/LOX/sapdata1 for total maximum size of all database files BR1049W Not enough free space in /oracle/LOX/sapdata1 for total maximum size of all database files BR1049W Not enough free space in /oracle/LOX/sapdata1 for total maximum size of all database files

4/8


BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last a BR0280I BRSPACE time stamp: 2009-05-26 10.37.50 BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort: c BR0280I BRSPACE time stamp: 2009-05-26 10.38.04 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRSPACE time stamp: 2009-05-26 10.38.04 BR0370I Directory /oracle/LOX/sapreorg/seaqubdl created BR0280I BRSPACE time stamp: 2009-05-26 10.38.05 BR0319I Control file copy created: /oracle/LOX/sapreorg/seaqubdl/cntrlLOX.old 12664832 BR0280I BRSPACE time stamp: 2009-05-26 10.38.05 BR1016I SQL statement 'alter database datafile '/oracle/LOX/sapdata1/sr3700_4/sr3700.data4' autoext BR1078I Data file /oracle/LOX/sapdata1/sr3700_4/sr3700.data4 altered successfully BR0280I BRSPACE time stamp: 2009-05-26 10.38.05 BR0340I Switching to next online redo log file for database instance LOX ... BR0321I Switch to next online redo log file for database instance LOX successful BR0280I BRSPACE time stamp: 2009-05-26 10.38.07 BR0319I Control file copy created: /oracle/LOX/sapreorg/seaqubdl/cntrlLOX.new 12664832

BR0280I BRSPACE time stamp: 2009-05-26 10.38.07 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRSPACE: c BR0280I BRSPACE time stamp: 2009-05-26 10.38.11 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRSPACE time stamp: 2009-05-26 10.38.11 BR0656I Choice menu 314 - please make a selection ------------------------------------------------------------------------------Alter data file main menu 1 - Set data file online 2 - Set data file offline 3 + Turn on and maintain autoextend 4 - Turn off autoextend 5 - Resize data file 6 - Rename data file 7 - Drop empty data file

5/8


8 - Show data files 9 - Show tablespaces 10 - Show disk volumes 11 = Exit program 12 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------BR0662I Enter your choice:

If it is not possible to change the autoextend size (for example if there is not enought free disk space) pl

s96sapti:oralox 3% sqlplus / as sysdba SQL*Plus: Release 10.2.0.2.0 - Production on Wed Jun 3 09:16:31 2009 Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production With the Partitioning and Data Mining options SQL> alter database datafile '/oracle/LOX/sapdata1/sr3700_4/sr3700.data4' autoextend on next 100

M max

Database altered. SQL> commit;

6/8


Commit complete.

SQL>

7/8


8/8

How to Increase Auto Extend Size of Auto Extend Datafiles

Recommend Documents