#1
|
|||
|
|||
¿Se pueden mover la carpeta oraarch?
Buenas,
Me estoy quedando sin espacio en la particion de la BBDD y queria saber si puedo mover algunas carpetas a otra particion,por ejemplo la carpeta oraarch. Si es que si ¿me podriais indicar como? Gracias y un saludo |
#2
|
||||
|
||||
Sí claro, se puede mover, tendrias que detener la base de datos, arrancarla en nomount si mal no recuerdo y ajustar el parametro en el perfil de instancia y mover el directorio. Luego montas la base de datos, abres y listo. Ahora por lo que veo estás en Windows por los terminos carpetas y partición y la solución no necesariamente seria esa, porqué pudieras fácilmente agregar datafiles al tablespace(s) que está aumentando y llenando ese espacio en la otra partición, porqué te pregunto:
Que haras cuando muevas oraarch e igual se te llene la partición? Saludos,
__________________
Johan González CEO NW Consulting Services Siguenos en Facebook: Moderador --------------------------- |
#3
|
|||
|
|||
Lla verdad que tenia muy poco espacio porque tengo 2 instancias y la particion de la BBDD es de 250GB. Le voy a pinchar otro disco de otros 250 y espero que asi no tenga problemas.
Gracias por la respuesta y un saludo. |
#4
|
|||
|
|||
Un ejemplo práctico
Change archivelog destination: brtools BR0651I BRTOOLS 7.00 (31) BR0280I BRTOOLS time stamp: 2008-06-23 13.24.10 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: 1 BR0280I BRTOOLS time stamp: 2008-06-23 13.24.13 BR0663I Your choice: '1' BR0280I BRTOOLS time stamp: 2008-06-23 13.24.13 BR0656I Choice menu 3 - please make a selection ------------------------------------------------------------------------------- Database instance management 1 = Start up database 2 - Shut down database 3 - Alter database instance 4 - Alter database parameters 5 - Recreate database 6 - Show instance status 7 - Show database parameters 8 - Show database owners 9 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: 4 BR0280I BRTOOLS time stamp: 2008-06-23 13.24.17 BR0663I Your choice: '4' BR0280I BRTOOLS time stamp: 2008-06-23 13.24.17 BR0657I Input menu 74 - please check/enter input values ------------------------------------------------------------------------------- BRSPACE options for alter database parameter 1 - BRSPACE profile (profile) ....... [initPIP.sap] 2 - Database user/password (user) ... [/] 3 ~ Alter parameter action (action) . [] 4 ~ Database parameter (parameter) .. [] 5 - Confirmation mode (confirm) ..... [yes] 6 - Scrolling line count (scroll) ... [20] 7 - Message language (language) ..... [E] 8 - BRSPACE command line (command) .. [-p initPIP.sap -s 20 -l E -f dbparam] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: 3 BR0280I BRTOOLS time stamp: 2008-06-23 13.24.20 BR0663I Your choice: '3' BR0280I BRTOOLS time stamp: 2008-06-23 13.24.20 BR0681I Enter string value for "action" (change|reset|create) []: change BR0280I BRTOOLS time stamp: 2008-06-23 13.24.23 BR0683I New value for "action": 'change' BR0280I BRTOOLS time stamp: 2008-06-23 13.24.23 BR0657I Input menu 74 - please check/enter input values ------------------------------------------------------------------------------- BRSPACE options for alter database parameter 1 - BRSPACE profile (profile) ....... [initPIP.sap] 2 - Database user/password (user) ... [/] 3 ~ Alter parameter action (action) . [change] 4 ~ Database parameter (parameter) .. [] 5 - Confirmation mode (confirm) ..... [yes] 6 - Scrolling line count (scroll) ... [20] 7 - Message language (language) ..... [E] 8 - BRSPACE command line (command) .. [-p initPIP.sap -s 20 -l E -f dbparam -a change] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: 4 BR0280I BRTOOLS time stamp: 2008-06-23 13.24.25 BR0663I Your choice: '4' BR0280I BRTOOLS time stamp: 2008-06-23 13.24.25 BR0681I Enter string value for "parameter" []: log_archive_dest BR0280I BRTOOLS time stamp: 2008-06-23 13.24.33 BR0683I New value for "parameter": 'log_archive_dest' BR0280I BRTOOLS time stamp: 2008-06-23 13.24.33 BR0657I Input menu 74 - please check/enter input values ------------------------------------------------------------------------------- BRSPACE options for alter database parameter 1 - BRSPACE profile (profile) ....... [initPIP.sap] 2 - Database user/password (user) ... [/] 3 ~ Alter parameter action (action) . [change] 4 ~ Database parameter (parameter) .. [log_archive_dest] 5 - Confirmation mode (confirm) ..... [yes] 6 - Scrolling line count (scroll) ... [20] 7 - Message language (language) ..... [E] 8 - BRSPACE command line (command) .. [-p initPIP.sap -s 20 -l E -f dbparam -a change -p log_archive_dest] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: c BR0280I BRTOOLS time stamp: 2008-06-23 13.24.35 BR0663I Your choice: 'c' BR0259I Program execution will be continued... BR0291I BRSPACE will be started with options '-p initPIP.sap -s 20 -l E -f dbparam -a change -p log_archive_dest' BR0280I BRTOOLS time stamp: 2008-06-23 13.24.35 BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort: c BR0280I BRTOOLS time stamp: 2008-06-23 13.24.36 BR0257I Your reply: 'c' BR0259I Program execution will be continued... ############################################################################### BR1001I BRSPACE 7.00 (31) BR1002I Start of BRSPACE processing: sdyfbzvw.dbp 2008-06-23 13.24.36 BR0484I BRSPACE log file: /oracle/PIP/sapreorg/sdyfbzvw.dbp BR0280I BRSPACE time stamp: 2008-06-23 13.24.39 BR1009I Name of database instance: PIP BR1010I BRSPACE action ID: sdyfbzvw BR1011I BRSPACE function ID: dbp BR1012I BRSPACE function: dbparam BR0280I BRSPACE time stamp: 2008-06-23 13.24.39 BR0657I Input menu 212 - please check/enter input values ------------------------------------------------------------------------------- Options for alter of database parameter 'log_archive_dest' 1 * Parameter description (desc) ..... [archival destination text string] 2 * Parameter type (type) ............ [string] 3 * Current parameter value (parval) . [/oracle/PIP/oraarch/PIParch] 4 * Value in spfile (spfval) ......... [<same>] 5 ? New parameter value (value) ...... [] 6 - Scope for new value (scope) ...... [both] 7 # Database instance (instance) ..... [] 8 ~ Comment on update (comment) ...... [] 9 - SQL command (command) ............ [alter system set log_archive_dest = '' scope = both] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: 5 BR0280I BRSPACE time stamp: 2008-06-23 13.25.16 BR0663I Your choice: '5' BR0280I BRSPACE time stamp: 2008-06-23 13.25.16 BR0681I Enter string value for "value" []: /oracle/PIP/saparch/PIParch BR0280I BRSPACE time stamp: 2008-06-23 13.25.20 BR0683I New value for "value": '/oracle/PIP/saparch/PIParch' BR0280I BRSPACE time stamp: 2008-06-23 13.25.20 BR0657I Input menu 212 - please check/enter input values ------------------------------------------------------------------------------- Options for alter of database parameter 'log_archive_dest' 1 * Parameter description (desc) ..... [archival destination text string] 2 * Parameter type (type) ............ [string] 3 * Current parameter value (parval) . [/oracle/PIP/oraarch/PIParch] 4 * Value in spfile (spfval) ......... [<same>] 5 - New parameter value (value) ...... [/oracle/PIP/saparch/PIParch] 6 - Scope for new value (scope) ...... [both] 7 # Database instance (instance) ..... [] 8 ~ Comment on update (comment) ...... [] 9 - SQL command (command) ............ [alter system set log_archive_dest = '/oracle/PIP/saparch/PIParch' scope = both] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: 6 BR0280I BRSPACE time stamp: 2008-06-23 13.25.43 BR0663I Your choice: '6' BR0280I BRSPACE time stamp: 2008-06-23 13.25.43 BR0681I Enter string value for "scope" (memory|spfile|both) [both]: both BR0280I BRSPACE time stamp: 2008-06-23 13.25.48 BR0683I New value for "scope": 'both' BR0280I BRSPACE time stamp: 2008-06-23 13.25.48 BR0657I Input menu 212 - please check/enter input values ------------------------------------------------------------------------------- Options for alter of database parameter 'log_archive_dest' 1 * Parameter description (desc) ..... [archival destination text string] 2 * Parameter type (type) ............ [string] 3 * Current parameter value (parval) . [/oracle/PIP/oraarch/PIParch] 4 * Value in spfile (spfval) ......... [<same>] 5 - New parameter value (value) ...... [/oracle/PIP/saparch/PIParch] 6 - Scope for new value (scope) ...... [both] 7 # Database instance (instance) ..... [] 8 ~ Comment on update (comment) ...... [] 9 - SQL command (command) ............ [alter system set log_archive_dest = '/oracle/PIP/saparch/PIParch' scope = both] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: c BR0280I BRSPACE time stamp: 2008-06-23 13.25.54 BR0663I Your choice: 'c' BR0259I Program execution will be continued... BR0370I Directory /oracle/PIP/sapreorg/sdyfbzvw created BR0202I Copying /oracle/PIP/102_64/dbs/spfilePIP.ora BR0203I to /oracle/PIP/sapreorg/sdyfbzvw/spfilePIP.ora ... BR0280I BRSPACE time stamp: 2008-06-23 13.25.54 BR1016I SQL statement 'alter system set log_archive_dest = '/oracle/PIP/saparch/PIParch' scope = both' executed successfully BR1031I Database parameter log_archive_dest altered successfully from '/oracle/PIP/oraarch/PIParch' to '/oracle/PIP/saparch/PIParch' BR0280I BRSPACE time stamp: 2008-06-23 13.25.55 BR0477I Oracle pfile /oracle/PIP/102_64/dbs/initPIP.ora created from spfile /oracle/PIP/102_64/dbs/spfilePIP.ora BR0280I BRSPACE time stamp: 2008-06-23 13.25.55 BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort: c BR0280I BRSPACE time stamp: 2008-06-23 13.26.13 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRSPACE time stamp: 2008-06-23 13.26.13 BR1019I Number of parameters processed: 1 BR1003I BRSPACE function 'dbparam' completed BR1008I End of BRSPACE processing: sdyfbzvw.dbp 2008-06-23 13.26.13 BR0280I BRSPACE time stamp: 2008-06-23 13.26.13 BR1005I BRSPACE completed successfully ############################################################################### BR0292I Execution of BRSPACE finished with return code 0 BR0280I BRTOOLS time stamp: 2008-06-23 13.26.13 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRTOOLS: c BR0280I BRTOOLS time stamp: 2008-06-23 13.26.21 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRTOOLS time stamp: 2008-06-23 13.26.21 BR0656I Choice menu 3 - please make a selection ------------------------------------------------------------------------------- Database instance management 1 = Start up database 2 - Shut down database 3 - Alter database instance 4 + Alter database parameters 5 - Recreate database 6 - Show instance status 7 - Show database parameters 8 - Show database owners 9 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: b BR0280I BRTOOLS time stamp: 2008-06-23 13.26.23 BR0663I Your choice: 'b' BR0673I Going back to the previous menu... BR0280I BRTOOLS time stamp: 2008-06-23 13.26.23 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: 9 BR0280I BRTOOLS time stamp: 2008-06-23 13.26.25 BR0663I Your choice: '9' BR0280I BRTOOLS time stamp: 2008-06-23 13.26.25 BR0680I Do you really want to exit BRTOOLS? Enter y[es]/n[o]: y BR0280I BRTOOLS time stamp: 2008-06-23 13.26.26 BR0257I Your reply: 'y' BR0280I BRTOOLS time stamp: 2008-06-23 13.26.26 BR0652I BRTOOLS completed successfully
__________________
SAP Basis Consultant |
Herramientas | Buscar en Tema |
Desplegado | |
|
|