|
parece que el problema es un daño fisico en disco duro, la maquina tiene 2 disco internos 2 dos externos en RAID 0
ahora la pregunta es la siguiente yo puedo instalar oracle en otra maquina pero como recupero los datos pues el ultimo export que hice tiene mas de 20 dias de atraso, ahora como puedo hacer un export si conectarme a la bade de datos, o como recupera los datos del disco espejo...
se puenden copiar fisicamente los archivos de datos en la otra maquina...
aqui adjunto en init.ora
init.ora
db_name = "ufpso"
instance_name = ufpso
service_names = ufps
# db_files = 80 # SMALL
# db_files = 400 # MEDIUM
# db_files = 1500 # LARGE
control_files = ("/oracle/app/oracle/oradata/ufpso/control01.ctl", "/oracle/app/oracle/oradata/ufpso/control02.ctl", "/oracle/app/oracle/oradata/ufpso/control03.ctl")
open_cursors = 300
max_enabled_roles = 30
# db_file_multiblock_read_count = 8 # SMALL
# db_file_multiblock_read_count = 16 # MEDIUM
# db_file_multiblock_read_count = 32 # LARGE
db_block_buffers = 2048 # INITIAL
# db_block_buffers = 100 # SMALL
# db_block_buffers = 550 # MEDIUM
# db_block_buffers = 3200 # LARGE
shared_pool_size = 60000000 # changed FMB, Sept. 22, 2003
# shared_pool_size = 3500000 # SMALL
# shared_pool_size = 5000000 # MEDIUM
# shared_pool_size = 9000000 # LARGE
large_pool_size = 614400
#large_pool_size = 6000000
java_pool_size = 20971520
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 150 # INITIAL
# processes = 50 # SMALL
# processes = 100 # MEDIUM
# processes = 200 # LARGE
log_buffer = 163840 # INITIAL
# log_buffer = 32768 # SMALL
# log_buffer = 32768 # MEDIUM
# log_buffer = 163840 # LARGE
# audit_trail = false # if you want auditing
# timed_statistics = false # if you want timed statistics
# max_dump_file_size = 10000 # limit trace file size to 5M each
# Uncommenting the lines below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true
# log_archive_dest_1 = "location=/home/oracle/OraHome1/admin/ref63/arch"
# log_archive_format = arch_%t_%s.arc
# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
#rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )
# If using public rollback segments, define how many
# rollback segments each instance will pick up, using the formula
# # of rollback segments = transactions / transactions_per_rollback_segment
# In this example each instance will grab 40/10 = 4:
# transactions = 40
# transactions_per_rollback_segment = 10
# Global Naming -- enforce that a dblink has same name as the db it connects to
global_names = false
# Edit and uncomment the following line to provide the suffix that will be
# appended to the db_name parameter (separated with a dot) and stored as the
# global database name when a database is created. If your site uses
# Internet Domain names for e-mail, then the part of your e-mail address after
# the '@' is a good candidate for this parameter value.
# db_domain = us.acme.com # global database name is db_name.db_domain
# Uncomment the following line if you wish to enable the Oracle Trace product
# to trace server activity. This enables scheduling of server collections
# from the Oracle Enterprise Manager Console.
# Also, if the oracle_trace_collection_name parameter is non-null,
# every session will write to the named collection, as well as enabling you
# to schedule future collections from the console.
# oracle_trace_enable = true
# define directories to store trace and alert files
background_dump_dest = /oracle/app/oracle/admin/ufpso/bdump
core_dump_dest = /oracle/app/oracle/admin/ufpso/cdump
#Uncomment this parameter to enable resource management for your database.
#The SYSTEM_PLAN is provided by default with the database.
#Change the plan name if you have created your own resource plan.# resource_manager_plan = system_plan
user_dump_dest = /oracle/app/oracle/admin/ufpso/udump
db_block_size = 4096
|
