移动Oracle home和数据文件控制文件临时文件到其他目录

本文链接：https://blog.youkuaiyun.com/weixin_tank88921/article/details/140446988

环境说明

[root@testos ~]# lsblk 
NAME   MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
sr0     11:0    1 1024M  0 rom  
sda      8:0    0  100G  0 disk 
├─sda1   8:1    0  200M  0 part /boot
├─sda2   8:2    0    4G  0 part [SWAP]
└─sda3   8:3    0 95.8G  0 part /
sdb      8:16   0  200G  0 disk 
[root@testos ~]# 
[oracle@testos:/home/oracle]$df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda3        95G   18G   73G  20% /
tmpfs           2.0G  485M  1.5G  25% /dev/shm
/dev/sda1       190M   32M  149M  18% /boot
[oracle@testos:/home/oracle]$env|grep ORACLE
ORACLE_SID=testdb
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1
[oracle@testos:/home/oracle]$sqlplus -s / as sysdba
select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/testdb/users01.dbf
/u01/app/oracle/oradata/testdb/undotbs01.dbf
/u01/app/oracle/oradata/testdb/system01.dbf
/u01/app/oracle/oradata/testdb/sysaux01.dbf

如上当前Oracle环境有几个问题

没有单独为oracle创建分区
oracle数据文件也存放路径不规范

现在需要单独为oracle创建分区，把对应的文件移动过去

创建文件系统

pvcreate /dev/sdb
vgcreate oravg /dev/sdb
lvcreate -n oralv -L 200000M oravg
mkfs.ext4 /dev/oravg/oralv
echo "/dev/oravg/oralv /oracle ext4 defaults 0 0" >> /etc/fstab
mkdir /oracle
mount /oracle



[root@testos ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda3              95G   18G   73G  20% /
tmpfs                 2.0G  485M  1.5G  25% /dev/shm
/dev/sda1             190M   32M  149M  18% /boot
/dev/mapper/oravg-oralv
                      193G   60M  183G   1% /oracle

创建目录和修改权限

mkdir -p /oracle/app/oracle/product/12.2.0/db_1
mkdir -p /oracle/app/oraInventory
mkdir -p /oracle/{
   oradata,backup,archive}
chown -R oracle:oinstall /oracle
chmod -R 775 /oracle

移动Oracle Home

关闭监听程序和数据库

[oracle@testos:/home/oracle]$lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 19-SEP-2023 23:33:04

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testos)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                19-SEP-2023 23:06:24
Uptime                    0 days 0 hr. 26 min. 39 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/testos/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testos)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "testdb" has 1 instance(s).
  Instance "testdb", status READY, has 1 handler(s) for this service...
Service "testdbXDB" has 1 instance(s).
  Instance "testdb", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@testos:/home/oracle]$
[oracle@testos:/home/oracle]$lsnrctl stop

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 19-SEP-2023 23:33:41

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testos)(PORT=1521)))
The command completed successfully
[oracle@testos:/home/oracle]$sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Sep 19 23:33:43 2023

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

sys@testdb(50)> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@testdb(50)>

移动Oracle Home

#查看当前环境变量里记录的信息
[oracle@testos:/home/oracle]$env|grep ORACLE
ORACLE_SID=testdb
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1
[oracle@testos:/home/oracle]$cd $ORACLE_HOME
[oracle@testos:/u01/app/oracle/product/12.2.0/db_1]$ll
total 316
drwxr-xr-x.  2 oracle oinstall  4096 Jul 31  2020 addnode
drwxr-xr-x.  6 oracle oinstall  4096 Jul 31  2020 apex
drwxr-xr-x. 10 oracle oinstall  4096 Jul 31  2020 assistants
drwxr-xr-x.  2 oracle oinstall 12288 Jul 31  2020 bin
drwxr-xr-x.  7 oracle oinstall  4096 Jul 31  2020 ccr
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 cdata
drwxr-xr-x.  5 oracle oinstall  4096 Jul 31  2020 cfgtoollogs
drwxr-xr-x.  4 oracle oinstall  4096 Jul 31  2020 clone
drwxr-xr-x.  6 oracle oinstall  4096 Jul 31  2020 crs
drwxr-xr-x.  6 oracle oinstall  4096 Jul 31  2020 css
drwxr-xr-x. 11 oracle oinstall  4096 Jul 31  2020 ctx
drwxr-xr-x.  7 oracle oinstall  4096 Jul 31  2020 cv
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 data
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 dbjava
drwxr-xr-x.  2 oracle oinstall  4096 Sep 19 23:34 dbs
drwxr-xr-x.  2 oracle oinstall  4096 Jul 31  2020 dc_ocm
drwxr-xr-x.  5 oracle oinstall  4096 Jul 31  2020 deinstall
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 demo
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 diagnostics
drwxr-xr-x.  8 oracle oinstall  4096 Jul 31  2020 dmu
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 dv
-rw-r--r--.  1 oracle oinstall   852 Aug 19  2015 env.ora
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 has
drwxr-xr-x.  5 oracle oinstall  4096 Jul 31  2020 hs
drwxr-xr-x.  9 oracle oinstall  4096 Jul 31  2020 install
drwxr-xr-x.  2 oracle oinstall  4096 Jul 31  2020 instantclient
drwxr-x---. 13 oracle oinstall  4096 Jul 31  2020 inventory
drwxr-xr-x.  8 oracle oinstall  4096 Jul 31  2020 javavm
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 jdbc
drwxr-xr-x.  7 oracle oinstall  4096 Jul 31  2020 jdk
drwxr-xr-x.  2 oracle oinstall  4096 Jul 31  2020 jlib
drwxr-xr-x. 12 oracle oinstall  4096 Jul 31  2020 ldap
drwxr-xr-x.  3 oracle oinstall 12288 Jul 31  2020 lib
drwxr-xr-x.  4 oracle oinstall  4096 Jul 31  2020 log
drwxr-xr-x.  7 oracle oinstall  4096 Jul 31  2020 md
drwxr-xr-x.  6 oracle oinstall  4096 Jul 31  2020 mgw
drwxr-xr-x. 10 oracle oinstall  4096 Jul 31  2020 network
drwxr-xr-x.  5 oracle oinstall  4096 Jul 31  2020 nls
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 oc4j
drwxr-xr-x.  7 oracle oinstall  4096 Jul 31  2020 odbc
drwxr-xr-x.  5 oracle oinstall  4096 Jul 31  2020 olap
drwxr-xr-x. 12 oracle oinstall  4096 Jul 31  2020 OPatch
drwxr-xr-x.  8 oracle oinstall  4096 Jul 31  2020 opmn
drwxr-xr-x.  4 oracle oinstall  4096 Jul 31  2020 oracore
-rw-r-----.  1 oracle oinstall    52 Jul 31  2020 oraInst.loc
drwxr-xr-x.  7 oracle oinstall  4096 Jul 31  2020 ord
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 ordim
drwxr-xr-x.  4 oracle oinstall  4096 Jul 31  2020 ords
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 oss
drwxr-xr-x.  8 oracle oinstall  4096 Jul 31  2020 oui
drwxr-xr-x.  4 oracle oinstall  4096 Jul 31  2020 owm
drwxr-xr-x.  5 oracle oinstall  4096 Jul 31  2020 perl
drwxr-xr-x.  6 oracle oinstall  4096 Jul 31  2020 plsql
drwxr-xr-x.  6 oracle oinstall  4096 Jul 31  2020 precomp
drwxr-xr-x.  2 oracle oinstall  4096 Jul 31  2020 QOpatch
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 R
drwxr-xr-x.  7 oracle oinstall  4096 Jul 31  2020 racg
drwxr-xr-x. 14 oracle oinstall  4096 Jul 31  2020 rdbms
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 relnotes
-rwx------.  1 oracle oinstall   610 Jul 31  2020 root.sh
-rw-r--r--.  1 oracle oinstall  2826 Mar  9  2016 schagent.conf
drwxr-xr-x.  4 oracle oinstall  4096 Jul 31  2020 scheduler
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 slax
drwxr-xr-x. 22 oracle oinstall  4096 Jul 31  2020 sqldeveloper
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 sqlj
drwxr-xr-x.  3 oracle oinstall  4096 Jul 31  2020 sqlpatch
drwxr-xr-x.  7 oracle oinstall  4096 Jul 31  2020 sqlplus
drwxr-xr-x.  9 oracle oinstall  4096 Jul 31  2020 srvm
drwxr-xr-x.  5 oracle oinstall  4096 Jul 31  2020 suptools
drwxr-xr-x.  4 oracle oinstall  4096 Jul 31  2020 sysman
drwxr-xr-x.