¿Se pueden mover la carpeta oraarch?

[eraso]

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

[johangonz]

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,

[eraso]

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.

[koletas]

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