¿Se pueden mover la carpeta oraarch?

Colapsar
X
Colapsar
 
  • Página de 1
  • Tiempo
  • Mostrar
Limpiar Todo
nuevos mensajes
Anterior template Próximo
  • eraso
    Junior Member
    • dic
    • 8
    #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
    Etiquetas: Ninguno
    • johangonz
      Moderator
      • may
      • 816
      #2
      Originalmente publicado por 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
      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
      www.nwcs.website
      Siguenos en Facebook: www.facebook.com/nwconsultingservices
      Moderador www.mundosap.com
      ---------------------------

        Comentario

        • eraso
          Junior Member
          • dic
          • 8
          #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.

            Comentario

            • koletas
              Senior Member
              • feb
              • 370
              #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
              koletas23@hotmail.com

                Comentario

                Anterior template Próximo
                Trabajando...