RE:[sap-basis] error when exteding tablespace in upgrade system.
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Kumar on May 3 at 1:52 AM |  Mark as helpful |
Dear Snowy,
Sorry for the last post I have miss the error when I am extending the tabesapce from brtools and there is 50 gb free space I the drive.
BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
f all database files of tablespace PSAPPRD located on this disk volume, missing
at least 722474.467 MB
BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
f all database files of tablespace PSAPPRD640 located on this disk volume, missi
ng at least 118714.467 MB
BR0668I Warnings or errors occurred - you can continue to ignore them or go back
to repeat the last action
BR0280I BRSPACE time stamp: 2010-04-30 18.57.38
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
In BRSPACE what option i have to choose
Information about the status of database instance DEV
1 - Instance number (number) ........... 1
2 - Instance thread (thread) ........... 1
3 - Instance status (status) ........... OPEN
4 - Instance start time (start) ........ 2010-04-09 17.11.52
5 - Oracle version (version) ........... 10.2.0.4.0
6 - Database creation time (create) .... 2010-04-08 14.07.11
7 - Last resetlogs time (resetlogs) .... 2010-04-08 14.07.23
8 - Archivelog mode (archmode) ......... ARCHIVELOG
9 - Archiver status (archiver) ......... STARTED
10 - Current redolog sequence (redoseq) . 267
11 - Current redolog SCN (redoscn) ...... 666746965
12 - Number of SAP connections (sapcon) . 23
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
Regards,
Kumar
---------------Original Message---------------
From: Kumar
Sent: Wednesday, April 21, 2010 7:58 AM
Subject: error when exteding tablespace in upgrade system.
> Dear all,
>
> I am getting error when we are getting extend the tablespace PSAPPRD.
> We have upgraded from ecc5 to ecc6 and this the first time I am extending the tablespace in upgrade system.
>
> I am not able to find the error
> 1. In the l drive there is 50 gb free space
> 2 why the old tablespace PSAPPRD640 is coming
>
> Options for extension of tablespace PSAPPRD (1. file)
>
> 1 * Last added file name (lastfile) ....... [L:\ORACLE\DEV\SAPDATA4\PRD_94\PRD.
> DATA94]
> 2 * Last added file size in MB (lastsize) . [2000]
> 3 - New file to be added (file) ........... [L:\oracle\DEV\sapdata4\prd_97\prd.
> data95]
> 4 # Raw disk / link target (rawlink) ...... []
> 5 - Size of the new file in MB (size) ..... [2000]
> 6 - File autoextend mode (autoextend) ..... [yes]
> 7 - Maximum file size in MB (maxsize) ..... [10000]
> 8 - File increment size in MB (incrsize) .. [20]
> 9 - SQL command (command) ................. [alter tablespace PSAPPRD add dataf
> ile 'L:\oracle\DEV\sapdata4\prd_95\prd.data95' size 2000M autoextend on next 20M
> maxsize 10000M]
>
>
>
> BR0662I Enter your choice:
> c
> BR0280I BRSPACE time stamp: 2010-04-21 16.44.08
> BR0663I Your choice: 'c'
> BR0259I Program execution will be continued...
>
> BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
> f all database files of tablespace PSAPPRD located on this disk volume, missing
> at least 722473.425 MB
> BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
> f all database files of tablespace PSAPPRD640 located on this disk volume, missi
> ng at least 118713.425 MB
>
> BR0668I Warnings or errors occurred - you can continue to ignore them or go back
> to repeat the last action
>
> Regards,
> Kumar
__.____._ Sorry for the last post I have miss the error when I am extending the tabesapce from brtools and there is 50 gb free space I the drive.
BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
f all database files of tablespace PSAPPRD located on this disk volume, missing
at least 722474.467 MB
BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
f all database files of tablespace PSAPPRD640 located on this disk volume, missi
ng at least 118714.467 MB
BR0668I Warnings or errors occurred - you can continue to ignore them or go back
to repeat the last action
BR0280I BRSPACE time stamp: 2010-04-30 18.57.38
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
In BRSPACE what option i have to choose
Information about the status of database instance DEV
1 - Instance number (number) ........... 1
2 - Instance thread (thread) ........... 1
3 - Instance status (status) ........... OPEN
4 - Instance start time (start) ........ 2010-04-09 17.11.52
5 - Oracle version (version) ........... 10.2.0.4.0
6 - Database creation time (create) .... 2010-04-08 14.07.11
7 - Last resetlogs time (resetlogs) .... 2010-04-08 14.07.23
8 - Archivelog mode (archmode) ......... ARCHIVELOG
9 - Archiver status (archiver) ......... STARTED
10 - Current redolog sequence (redoseq) . 267
11 - Current redolog SCN (redoscn) ...... 666746965
12 - Number of SAP connections (sapcon) . 23
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
Regards,
Kumar
---------------Original Message---------------
From: Kumar
Sent: Wednesday, April 21, 2010 7:58 AM
Subject: error when exteding tablespace in upgrade system.
> Dear all,
>
> I am getting error when we are getting extend the tablespace PSAPPRD.
> We have upgraded from ecc5 to ecc6 and this the first time I am extending the tablespace in upgrade system.
>
> I am not able to find the error
> 1. In the l drive there is 50 gb free space
> 2 why the old tablespace PSAPPRD640 is coming
>
> Options for extension of tablespace PSAPPRD (1. file)
>
> 1 * Last added file name (lastfile) ....... [L:\ORACLE\DEV\SAPDATA4\PRD_94\PRD.
> DATA94]
> 2 * Last added file size in MB (lastsize) . [2000]
> 3 - New file to be added (file) ........... [L:\oracle\DEV\sapdata4\prd_97\prd.
> data95]
> 4 # Raw disk / link target (rawlink) ...... []
> 5 - Size of the new file in MB (size) ..... [2000]
> 6 - File autoextend mode (autoextend) ..... [yes]
> 7 - Maximum file size in MB (maxsize) ..... [10000]
> 8 - File increment size in MB (incrsize) .. [20]
> 9 - SQL command (command) ................. [alter tablespace PSAPPRD add dataf
> ile 'L:\oracle\DEV\sapdata4\prd_95\prd.data95' size 2000M autoextend on next 20M
> maxsize 10000M]
>
>
>
> BR0662I Enter your choice:
> c
> BR0280I BRSPACE time stamp: 2010-04-21 16.44.08
> BR0663I Your choice: 'c'
> BR0259I Program execution will be continued...
>
> BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
> f all database files of tablespace PSAPPRD located on this disk volume, missing
> at least 722473.425 MB
> BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
> f all database files of tablespace PSAPPRD640 located on this disk volume, missi
> ng at least 118713.425 MB
>
> BR0668I Warnings or errors occurred - you can continue to ignore them or go back
> to repeat the last action
>
> Regards,
> Kumar
Copyright © 2010 Toolbox.com 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
KumarSAP Basis Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Your SAP Security is at Risk...Learn How to Stay Protected. Read the free white paper from SenSage
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
_.____.__ 
