MUNDOSAP

Regresar   MUNDOSAP > ADMINISTRACION SAP > Administración de Sistemas SAP
Nombre de Usuario
Contraseña
Home Descargas Registrar FAQ Miembros Calendario Buscar Temas de Hoy Marcar Foros Como Leídos




 
Respuesta
 
Herramientas Buscar en Tema Desplegado
  #1  
Viejo 10/08/10, 13:18:51
eraso eraso is offline
Junior Member
 
Fecha de Ingreso: dic 2009
Mensajes: 8
¿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
Responder Con Cita
  #2  
Viejo 10/08/10, 18:27:26
Avatar de johangonz
johangonz johangonz is offline
Moderator
 
Fecha de Ingreso: may 2006
Mensajes: 816
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

---------------------------
Responder Con Cita
  #3  
Viejo 12/08/10, 07:47:52
eraso eraso is offline
Junior Member
 
Fecha de Ingreso: dic 2009
Mensajes: 8
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.
Responder Con Cita
  #4  
Viejo 20/08/10, 11:37:58
koletas koletas is offline
Senior Member
 
Fecha de Ingreso: feb 2006
Localización: Aranda De Duero, España
Mensajes: 370
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
Responder Con Cita
Respuesta


Herramientas Buscar en Tema
Buscar en Tema:

Búsqueda Avanzada
Desplegado

Reglas de Mensajes
no puedes crear nuevos temas
no puedes responder temas
no puedes adjuntar archivos
no puedes editar tus mensajes

El código vB está On
Las caritas están On
Código [IMG] está On
Código HTML está Off
Saltar a Foro


Husos Horarios son GMT. La hora en este momento es 23:24:00.


www.mundosap.com 2006 - Spain
software crm, crm on demand, software call center, crm act, crm solutions, crm gratis, crm web