Tranferir BD Oracle 9i

[GuiLL3]

Environment information:
* Oracle version: 9i
* Operating system: HR 4

Galera my first topic in the forum ..
First I say I'm a beginner in Oracle.

Happens the following, we have a server here in the company with Oracle 9i installed,
in fact the machine where the BD is only has the 76GB SCSI HD, and is almost crowded.
We recently purchased an HP server with HD 250 GB, and a more robust configuration than that of the current server.

What I want is to know what it takes to be passing this database from one machine to another.
If I have to install Linux, and if you have any way to export and import this database, without having to redo all

database configuration. I have all CDs for the installation of Oracle 9i.
More I would like to know which solution you recommend me.
Thanks in advance.
Thanks!

[pedroedu]

Okay, first thing we need to know is how many discs you have, it's just a 250 GB or two or more totalized 250 GB and this your bank is OLTP or DSS ... from these information we can set the appropriate RAID type.

[GuiLL3]

Dude ... It's only a 250 GB disk, and sorry I do not know what OLTP or DSS is, how do I see it? And I do not think I need to work with RAID No..somente this same HD ..
Sorry for the lack of knowledge ..
Thanks

[pedroedu]

Do not worry, where are you, I'vê come, everyone before being a medium or big, it was little ... Talk to you, my friend, I do not advise anyone to put a production bank in just one HD reasons:

- If you damage your HD will not have to recover bench quickly (you will have a standby, a rac, or another site (replicate database) will not have to recover, because only one disk can mirror, If they were two miles mirroring with physical or logic RAID.
- Your bank will be slow because it will stay out of the OFA standard, where the controlling, logging and datafiles will get together, that is, only one head of the in just a HD writing all this at the same time.

OLTP - Online Transactional Processing (Bank with a lot of reading and writing)
DSS- Decision Support Systems (Bank with little lastness in the data, as a DW, where the data They are loaded and not altered)

I advise you to get another 250GB HD, so we can do a mirroring at RAID 1 (HDS mirroring, if you lose one another assumes, there is only Place another 250GB Disk QO RAID system fills you with the main data), to ensure a bit of safety in case of a defect in a HD.

[GuiLL3]

I understood the reason for the 2 hds face.
So..vou get another 250 GB HD
The server we get is the HP ProLiant ML110 plus with SATA HD, I do not know if it supports SATA!

Surely the bank is OLTP, there are more or less 10 machines accessing the BD.

After acquiring the other HD, what are the steps I should follow?

Thanks!

[pedroedu]

Right, after adiking the disc, you will see if the server has controller raid, if you do not have you will have to do logical raid (RAID 1), can not forget to put the grub on the two disk, because if one fails the other goes Climbing the SO quietly, create the Oracle installation according to the OFA, to be all well organized. To change to a new machine, we will need to know the init.ora of your bank, so we will know how this configuration of it, as well as the others locations of physical files (controlling and others), with it to know also if your bank is in archivelog mode or not ... do not worry that with these information I will pass a simple way to make this operation.

[GuiLL3]

It has controlling RAID yes..vou give a deal about this Standard OFA, if you have any article to pass me thank you. Face a question .. it is more work for me to change the only, for example, I am thinking of installing the centos, which is free, because I do not have HR here, because the staff of the system that installed it. If you do more work, I have to get the RH ..
the only init.ora file I found was located in /u01/app/oracle/product/9.2.0.1.0/dbs ..
And within it is as follows:

Select all

*:/u01/app/oracle/product/9.2.0.1.0:N 
orcl:/u01/app/oracle/product/9.2.0.1.0:Y

outside the comments. I do not know if this is what you need ..
Thanks!

[pedroedu]

The init.ora then must be in the Pfile directory (/u01/oracle/product/9.2.0.1.0/admin/orcl/pfile/). While at HR or hundreds so much, because you can continue using HR without buying it the problem is the updates and the support, but if you want to use the centos no problem, I use the two in my clients quietly.

[pedroedu]

If you do not find the init with a find / -name initorcl.ora, this as usual root, you do the following steps and send me the exit:

Select all

#su - oracle 
#sqlplus / as sysdba 
sql> sho parameter pfile 
sql> sho parameter sga_target 
sql> sho parameter archive

[diegolenhardt]

Preferably to approved versions,

even the Oracle support will only suit it if the only is used in the list of oracle,

Much safer to use Rhel, Oel,

[diegolenhardt]

Another face, see the possibility of using version 64bits,
with ASM, a very good gain in performance,

[pedroedu]

Does anyone still work with 32bit ???

[diegolenhardt]

Look, man, I think about 80% huh: P

[pedroedu]

It was joking, lol ...: Wink:

[GuiLL3]

Pedroedu,
inside the pfile folder had an initorcl file
see if and that is right.

Select all

############################################################################## 
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation 
############################################################################## 
  
########################################### 
# Cursors and Library Cache 
########################################### 
open_cursors=300 
  
########################################### 
# Cache and I/O 
########################################### 
db_block_size=8192 
db_cache_size=25165824 
db_file_multiblock_read_count=16 
  
########################################### 
# Sort, Hash Joins, Bitmap Indexes 
########################################### 
pga_aggregate_target=25165824 
sort_area_size=524288 
  
########################################### 
# File Configuration 
########################################### 
control_files=("/u01/app/oracle/oradata/orcl/control01.ctl", "/u01/app/oracle/oradata/orcl/control02.ctl", "/u01/app/oracle/oradata/orcl/control03.ctl") 
  
########################################### 
# Diagnostics and Statistics 
########################################### 
background_dump_dest=/u01/app/oracle/admin/orcl/bdump 
core_dump_dest=/u01/app/oracle/admin/orcl/cdump 
timed_statistics=TRUE 
user_dump_dest=/u01/app/oracle/admin/orcl/udump 
  
########################################### 
# Miscellaneous 
########################################### 
aq_tm_processes=1 
compatible=9.2.0.0.0 
  
########################################### 
# Job Queues 
########################################### 
job_queue_processes=10 
  
########################################### 
# Instance Identification 
########################################### 
instance_name=orcl 
  
########################################### 
# Database Identification 
########################################### 
db_domain="" 
db_name=orcl 
  
########################################### 
# MTS 
########################################### 
dispatchers="(PROTOCOL=TCP) (SERVICE=orclXDB)" 
  
########################################### 
# Optimizer 
########################################### 
hash_join_enabled=TRUE 
query_rewrite_enabled=FALSE 
star_transformation_enabled=FALSE 
  
########################################### 
# Pools 
########################################### 
java_pool_size=83886080 
large_pool_size=8388608 
shared_pool_size=83886080 
  
########################################### 
# Processes and Sessions 
########################################### 
processes=150 
  
########################################### 
# Redo Log and Recovery 
########################################### 
fast_start_mttr_target=300 
  
########################################### 
# System Managed Undo and Rollback Segments 
########################################### 
undo_management=AUTO 
undo_retention=10800 
undo_tablespace=UNDOTBS1 
  
########################################### 
# Security and Auditing 
########################################### 
remote_login_passwordfile=EXCLUSIVE 
optimizer_mode=RULE 

and referring to OS, I think I go from centos even ..

[pedroedu]

Very well, that's right ... now send out the exits:

Select all

#su - oracle  
#sqlplus / as sysdba  
 
 
sql> sho parameter pfile  
sql> sho parameter sga_target  
sql> sho parameter archive

[GuiLL3]

Look at Pedroedu

Select all

[root@granjagn root]# su - oracle 
[oracle@granjagn oracle]$ sqlplus / as sysdba 
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ] 
where <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ] 
      <logon>  ::= <username>[/<password>][@<connect_string>] | / | /NOLOG 
      <start>  ::= @<URI>|<filename>[.<ext>] [<parameter> ...] 
        "-H" displays the SQL*Plus version banner and usage syntax 
        "-V" displays the SQL*Plus version banner 
        "-L" attempts log on just once 
        "-M <o>" uses HTML markup options <o> 
        "-R <n>" uses restricted mode <n> 
        "-S" uses silent mode 
[oracle@granjagn oracle]$

[pedroedu]

Enter then:

Select all

sqlplus /nolog 
conn / as sysdba 
 
sql> sho parameter pfile  
sql> sho parameter sga_target  
sql> sho parameter archive

I need to know the size of your bank, from one:

Select all

select sum(bytes)/1024/1024/1024 mb  from dba_segments;

[GuiLL3]

ta ai ..

Select all

SQL> conn / as sysdba 
Connected. 
SQL> sho parameter pfile 
 
NAME                                 TYPE        VALUE 
------------------------------------ ----------- ------------------------------ 
spfile                               string      ?/dbs/spfile@.ora 
SQL> sho parameter sga_target 
SQL> sho parameter archive 
 
NAME                                 TYPE        VALUE 
------------------------------------ ----------- ------------------------------ 
archive_lag_target                   integer     0 
log_archive_dest                     string 
log_archive_dest_1                   string 
log_archive_dest_10                  string 
log_archive_dest_2                   string 
log_archive_dest_3                   string 
log_archive_dest_4                   string 
log_archive_dest_5                   string 
log_archive_dest_6                   string 
log_archive_dest_7                   string 
log_archive_dest_8                   string 
 
NAME                                 TYPE        VALUE 
------------------------------------ ----------- ------------------------------ 
log_archive_dest_9                   string 
log_archive_dest_state_1             string      enable 
log_archive_dest_state_10            string      enable 
log_archive_dest_state_2             string      enable 
log_archive_dest_state_3             string      enable 
log_archive_dest_state_4             string      enable 
log_archive_dest_state_5             string      enable 
log_archive_dest_state_6             string      enable 
log_archive_dest_state_7             string      enable 
log_archive_dest_state_8             string      enable 
log_archive_dest_state_9             string      enable 
 
NAME                                 TYPE        VALUE 
------------------------------------ ----------- ------------------------------ 
log_archive_duplex_dest              string 
log_archive_format                   string      %t_%s.dbf 
log_archive_max_processes            integer     2 
log_archive_min_succeed_dest         integer     1 
log_archive_start                    boolean     FALSE 
log_archive_trace                    integer     0 
remote_archive_enable                string      true 
standby_archive_dest                 string      ?/dbs/arch 
SQL>

and the size of the bank

Select all

SQL> select sum(bytes)/1024/1024/1024 mb from dba_segments; 
 
        MB 
---------- 
4.98735046

Embrace!

[pedroedu]

Your bank is very small, we can do even via Export Import, want to go by the path of stones ??? Generating a cold backup and restoring ???

[pedroedu]

Have you installed Linux, configured it (Kernela, Users' Creation, Groups) and installed Oracle ever?

[GuiLL3]

It's small yes..uai guy ... if it does not work, I would like to learn in both ways, easy..exp / imp..and in a way that I can learn and understand the process, since I'm starting to study About..Linux / Oracle ..

And the maximum I have already installed from Linux, was Ubuntu, and I read about Configs.
And I'vê never installed Oracle no! ..

[GuiLL3]

I want to learn more in the background too, because in the future, I want to set up a server, type of backup, and I want it to copy only certain tables from this bd ..

[pedroedu]

Right, you have any step-by-step of linux ??? porque has some chatinhas configurations that we have to do and have to be careful also not to install thing d + and leave the server slow because of processes running unnecessaries ... Sendmail, Cups ...)

[GuiLL3]

I have a step by step .. I'm installing here..the centos ..

[pedroedu]

beleza ... When you finish installing Oracle you speak, leave everything on the point.