Oracle BRtools Table Space erweitern

Table Space Erweitern

"brtools"
	2 - Space management
	1 = Extend tablespace
	c
	c
	c	
	Anzeige der Tabellen. Hier 95,03 % Belegung
		1 - PSAPSR3         103/0       395411456     95.03    19645696    395411456

	1	(Tabelle 1 auswählen)
		Darauf Achten. wichtig "autoextend off"
		alle prüfen:
		 Options for extension of tablespace PSAPSR3 (1. file)

		 1 * Last added file name (lastfile) ....... [/oracle/PR1/sapdata5/sr3_103/sr3.data103]
		 2 * Last added file size in MB (lastsize) . [4000]
		 3 - New file to be added (file) ........... [/oracle/PR1/sapdata5/sr3_104/sr3.data104]
		 4 ~ Raw disk / link target (rawlink) ...... []
		 5 - Size of the new file in MB (size) ..... [4000]
		 6 - File autoextend mode (autoextend) ..... [no]
		 7 # Maximum file size in MB (maxsize) ..... []
		 8 # File increment size in MB (incrsize) .. []
		 9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/PR1/sapdata5/sr3_104/sr3.data104' size 4000M autoextend off]

	c
 
		BR0662I Enter your choice:
	c
		BR0280I BRSPACE time stamp: 2015-08-07 07.52.03
		BR0663I Your choice: 'c'
		BR0259I Program execution will be continued...

		BR1091I Next data file can be specified now													!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

		BR0280I BRSPACE time stamp: 2015-08-07 07.52.03
		BR0675I This is a optional action - do you want to execute it now?
		BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
	y
		BR0280I BRSPACE time stamp: 2015-08-07 07.52.45
		BR0257I Your reply: 'y'
		BR0677I The action will be executed...

		BR0280I BRSPACE time stamp: 2015-08-07 07.52.45
		BR0657I Input menu 303 - please enter/check input values
		-------------------------------------------------------------------------------
		Options for extension of tablespace PSAPSR3 (2. file)

		 1 * Last added file name (lastfile) ....... [/oracle/PR1/sapdata5/sr3_103/sr3.data103]
		 2 * Last added file size in MB (lastsize) . [4000]
		 3 - New file to be added (file) ........... [/oracle/PR1/sapdata5/sr3_105/sr3.data105]
		 4 ~ Raw disk / link target (rawlink) ...... []
		 5 - Size of the new file in MB (size) ..... [4000]
		 6 - File autoextend mode (autoextend) ..... [no]
		 7 # Maximum file size in MB (maxsize) ..... []
		 8 # File increment size in MB (incrsize) .. []
		 9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/PR1/sapdata5/sr3_104/sr3.data104' size 4000M autoextend off, '/oracle/PR1/sapdata5/sr3_105/sr3.data105' size 4000M autoextend off]

		Standard keys: c - cont, b - back, s - stop, r - refr, h - help
		-------------------------------------------------------------------------------
		BR0662I Enter your choice:
	c	(hier C weil zwei Files angelegt werden)
	c
		BR0280I BRSPACE time stamp: 2015-08-07 07.53.41
		BR0257I Your reply: 'c'
		BR0678I The action will be skipped...
		BR0259I Program execution will be continued...

		BR0370I Directory /oracle/PR1/sapreorg/sercuvpm created

		BR0280I BRSPACE time stamp: 2015-08-07 07.53.42
		BR0319I Control file copy created: /oracle/PR1/sapreorg/sercuvpm/cntrlPR1.old 34455552

		BR0370I Directory /oracle/PR1/sapdata5/sr3_104 created
		BR0370I Directory /oracle/PR1/sapdata5/sr3_105 created

		BR0280I BRSPACE time stamp: 2015-08-07 07.53.42
		BR1088I Extending tablespace PSAPSR3 ...
	c
		R0280I BRSPACE time stamp: 2015-08-07 07.54.16
		BR1016I SQL statement 'alter tablespace PSAPSR3 add datafile '/oracle/PR1/sapdata5/sr3_104/sr3.data104' size 4000M autoextend off, '/oracle/PR1/sapdata5/sr3_105/sr3.data105' size 4000M autoextend off' executed successfully

		BR1051I Tablespace PSAPSR3 extended successfully with files: 
		/oracle/PR1/sapdata5/sr3_104/sr3.data104 4000M,
		/oracle/PR1/sapdata5/sr3_105/sr3.data105 4000M

		BR0280I BRSPACE time stamp: 2015-08-07 07.54.16
		BR0340I Switching to the next online redolog file for database instance PR1 ...
		BR0321I Switch to the next online redolog file for database instance PR1 successful

		BR0280I BRSPACE time stamp: 2015-08-07 07.54.19
		BR0319I Control file copy created: /oracle/PR1/sapreorg/sercuvpm/cntrlPR1.new 34455552

		BR0280I BRSPACE time stamp: 2015-08-07 07.54.19
		BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRSPACE:
	s
	y
	s
	y

Post Revisions: