学习笔记

Network error: Connection timed out

──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────

Session stopped
- Press <return> to exit tab
- Press R to restart session
- Press S to save terminal output to file
┌──────────────────────────────────────────────────────────────────────┐
│ • MobaXterm Personal Edition v21.3 • │
│ (SSH client, X server and network tools) │
│ │
│ ➤ SSH session to root@192.168.122.1 │
│ • Direct SSH : ✔ │
│ • SSH compression : ✔ │
│ • SSH-browser : ✔ │
│ • X11-forwarding : ✔ (remote display is forwarded through SSH) │
│ │
│ ➤ For more info, ctrl+click on help or visit our website. │
└──────────────────────────────────────────────────────────────────────┘

Last login: Thu Oct 28 22:07:28 2021 from 192.168.122.6
[root@localhost ~]# su - oracle
Last login: Thu Oct 28 22:07:33 CST 2021 on pts/0
[oracle@localhost ~]$ ps -ef | grep pmon
oracle 5430 5384 0 10:32 pts/0 00:00:00 grep --color=auto pmon
[oracle@localhost ~]$ export ORACLE_SID=orcl
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 29 10:32:22 2021
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1191181696 bytes
Fixed Size 8895872 bytes
Variable Size 318767104 bytes
Database Buffers 855638016 bytes
Redo Buffers 7880704 bytes
Database mounted.
Database opened.
SQL> select event#,name,parameter1,parameter2,parameter3 from v$event_name where name = 'latch free';

EVENT# NAME
---------- ----------------------------------------------------------------
PARAMETER1
----------------------------------------------------------------
PARAMETER2
----------------------------------------------------------------
PARAMETER3
----------------------------------------------------------------
529 latch free
address
number
why


SQL> set lines 200 pages 999
SQL> col name for a35
SQL> select event#,name,parameter1,paremeter2,paremeter3 from v$event_name where name='latch free';
select event#,name,parameter1,paremeter2,paremeter3 from v$event_name where name='latch free'
*
ERROR at line 1:
ORA-00904: "PAREMETER3": invalid identifier


SQL> select event#,name,parameter1,parameter2,parameter3 from v$event_name where name = 'latch free';

EVENT# NAME PARAMETER1 PARAMETER2
---------- ----------------------------------- ---------------------------------------------------------------- ----------------------------------------------------------------
PARAMETER3
----------------------------------------------------------------
529 latch free address number
why


SQL> col name for a20
SQL> col parameter1 fro a30
SP2-0158: unknown COLUMN option "fro"
SQL> col parameter1 for a30
SQL> col parameter2 for a30
SQL> col parameter3 for a30
SQL> select event#,name,parameter1,parameter2,parameter3 from v$event_name where name = 'latch free';

EVENT# NAME PARAMETER1 PARAMETER2 PARAMETER3
---------- -------------------- ------------------------------ ------------------------------ ------------------------------
529 latch free address number why

SQL> select event#,name,parameter1,parameter2,parameter3 from v$event_name where name = 'latch free';

EVENT# NAME PARAMETER1 PARAMETER2 PARAMETER3
---------- -------------------- ------------------------------ ------------------------------ ------------------------------
529 latch free address number why

SQL> select * from v$latchname where latch# = 'number';
select * from v$latchname where latch# = 'number'
*
ERROR at line 1:
ORA-01722: invalid number


SQL> select event#,name,parameter1,parameter2,parameter3 from v$event_name where name like '%latch%';

EVENT# NAME PARAMETER1 PARAMETER2 PARAMETER3
---------- -------------------- ------------------------------ ------------------------------ ------------------------------
87 latch: MGA shared co address number why
ntext root latch

88 latch: MGA shared co address number why
ntext latch

89 latch: MGA heap latc address number why
h

90 latch: MGA pid alloc address number why
latch

91 latch: MGA asr alloc address number why
latch

113 latch: cache buffers address number why
chains

164 latch: redo writing address number why
165 latch: redo copy address number why
313 latch: Undo Hint Lat address number why
ch

315 latch: In memory und address number why
o latch

316 latch: MQL Tracking address number why
Latch

352 latch: row cache obj address number why
ects

366 latch: shared pool address number why
529 latch free address number why
530 latch activity address number process#
531 wait list latch free address number
540 latch: call allocati address number why
on

541 latch: session alloc address number why
ation

559 latch: ksm sga alloc address number why
latch

570 latch: messages address number why
573 latch: pdb enqueue h address number why
ash chains

574 latch: enqueue hash address number why
chains

616 latch: active servic address number why
e list

617 latch: service drain address number why
list

618 latch: last service address number why
list

619 latch: java patching address number why
638 latch: ksolt lwth al address number why
loc

646 GL: cross instance l
atch free

649 RMA: latch RMA Latch Latch Val
654 latch: ges resource address number why
hash list

667 ges2 proc latch in r
m latch get 1

668 ges2 proc latch in r
m latch get 2

676 gcs retry nowait lat location
ch get

677 gcs remastering wait flags idx1 idx2
for read latch

716 latch: kjci process address number why
context latch

717 latch: kjci request address number why
sequence latch

721 latch: kjoeq omni en address number why
queue hash bucket la
tch

723 latch: kjoer owner h address number why
ash bucket

729 latch: gcs resource address number why
hash

765 latch: GCS logfile b address number why
lock

766 latch: GCS logfile w address number why
rite queue

781 latch: cache buffers address number why
lru chain

783 latch: checkpoint qu address number why
eue latch

784 latch: cache buffer address number why
handles

788 buffer latch latch addr chain#
804 latch: object queue address number why
header operation

872 latch: redo allocati address number why
on

895 latch: gc element address number why
1000 latch: obj/range reu address number why
se redo processing

1060 recovery metadata la
tch

1080 latch: undo global d address number why
ata

1101 latch: Change Notifi address number why
cation Hash table la
tch

1104 latch: change notifi address number why
cation client cache
latch

1105 latch: SGA Logging L address number why
og Latch

1106 latch: SGA Logging B address number why
kt Latch

1114 latch: ILM activity address number why
tracking latch

1115 latch: ILM access tr address number why
acking extent

1121 latch: lob segment h address number why
ash table latch

1122 latch: lob segment q address number why
uery latch

1123 latch: lob segment d address number why
ispenser latch

1144 latch: IM area scb l address number why
atch

1145 latch: IM area sb la address number why
tch

1149 latch: IM seg hdr la address number why
tch

1150 latch: IM emb latch address number why
1178 latch: IMFS defer wr address number why
ite list

1181 latch: Column stats address number why
entry latch

1453 latch: virtual circu address number why
it queues

1479 PX qref latch function sleeptime qref
1498 latch: parallel quer address number why
y alloc buffer

1506 latch: PX hash array address number why
latch

1633 latch: AQ Sharded su address number why
bscriber statistics
latch

1635 latch: AQ OPT Backgr address number why
ound Master Latch

1882 latch: WCR: sync address number why
1883 latch: WCR: processe address number why
s HT


74 rows selected.

SQL> select event#,name,parameter1,parameter2,parameter3 from v$event_name where name = 'buffer latch';

EVENT# NAME PARAMETER1 PARAMETER2 PARAMETER3
---------- -------------------- ------------------------------ ------------------------------ ------------------------------
788 buffer latch latch addr chain#

SQL> select file#,name,status from v$datafile;

FILE# NAME STATUS
---------- -------------------- -------
1 /u01/app/oracle19/or SYSTEM
adata/ORCL/system01.
dbf

2 /u01/app/oracle19/or ONLINE
adata/ORCL/sysaux01.
dbf

3 /u01/app/oracle19/or ONLINE
adata/ORCL/undotbs01
.dbf

4 /u01/app/oracle19/or ONLINE
adata/ORCL/users01.d
bf

5 /u01/app/oracle19/or ONLINE
adata/ORCL/hwm_test.
dbf

6 /u01/app/oracle19/or ONLINE
adata/ORCL/data.dbf

7 /u01/app/oracle19/or ONLINE
adata/ORCL/data_ind.
dbf

8 /u01/app/oracle19/or ONLINE
adata/ORCL/data_ind1
.dbf

9 /u01/app/oracle19/or ONLINE
adata/ORCL/data1.dbf

10 /u01/app/oracle19/or ONLINE
adata/ORCL/data2.dbf


10 rows selected.

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle19/oradata/ORCL/system01.dbf
/u01/app/oracle19/oradata/ORCL/sysaux01.dbf
/u01/app/oracle19/oradata/ORCL/undotbs01.dbf
/u01/app/oracle19/oradata/ORCL/users01.dbf
/u01/app/oracle19/oradata/ORCL/hwm_test.dbf
/u01/app/oracle19/oradata/ORCL/data.dbf
/u01/app/oracle19/oradata/ORCL/data_ind.dbf
/u01/app/oracle19/oradata/ORCL/data_ind1.dbf
/u01/app/oracle19/oradata/ORCL/data1.dbf
/u01/app/oracle19/oradata/ORCL/data2.dbf

10 rows selected.

SQL>
SQL> select tablespace_name, file_id,file_name,
round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name; 2

TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TOTAL_SPACE
-----------
DATA 9
/u01/app/oracle19/oradata/ORCL/data1.dbf
100

DATA 6
/u01/app/oracle19/oradata/ORCL/data.dbf
500

DATA 10
/u01/app/oracle19/oradata/ORCL/data2.dbf
100

DATA_IND 8
/u01/app/oracle19/oradata/ORCL/data_ind1.dbf
5

Data_IND 7
/u01/app/oracle19/oradata/ORCL/data_ind.dbf
5

HWM_TEST 5
/u01/app/oracle19/oradata/ORCL/hwm_test.dbf
145

SYSAUX 2
/u01/app/oracle19/oradata/ORCL/sysaux01.dbf
550

SYSTEM 1
/u01/app/oracle19/oradata/ORCL/system01.dbf
700

UNDOTBS1 3
/u01/app/oracle19/oradata/ORCL/undotbs01.dbf
1520

USERS 4
/u01/app/oracle19/oradata/ORCL/users01.dbf
5


10 rows selected.

SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ sqlplus lwt/123456

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 29 11:10:33 2021
Version 19.3.0.0.0

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

Last Successful login time: Sat Oct 23 2021 15:30:28 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select tablespace_name, file_id,file_name,
round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name; 2
round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name
*
ERROR at line 2:
ORA-00942: table or view does not exist


SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 29 11:10:52 2021
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select tablespace_name, file_id,file_name,
round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name; 2

TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
TOTAL_SPACE
-----------
DATA 9
/u01/app/oracle19/oradata/ORCL/data1.dbf
100

DATA 6
/u01/app/oracle19/oradata/ORCL/data.dbf
500

TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
TOTAL_SPACE
-----------

DATA 10
/u01/app/oracle19/oradata/ORCL/data2.dbf
100

DATA_IND 8
/u01/app/oracle19/oradata/ORCL/data_ind1.dbf

TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
TOTAL_SPACE
-----------
5

Data_IND 7
/u01/app/oracle19/oradata/ORCL/data_ind.dbf
5

HWM_TEST 5

TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
TOTAL_SPACE
-----------
/u01/app/oracle19/oradata/ORCL/hwm_test.dbf
145

SYSAUX 2
/u01/app/oracle19/oradata/ORCL/sysaux01.dbf
550


TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
TOTAL_SPACE
-----------
SYSTEM 1
/u01/app/oracle19/oradata/ORCL/system01.dbf
700

UNDOTBS1 3
/u01/app/oracle19/oradata/ORCL/undotbs01.dbf
1520

TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
TOTAL_SPACE
-----------

USERS 4
/u01/app/oracle19/oradata/ORCL/users01.dbf
5


10 rows selected.

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ cd /u01/app/oracle19/oradata/ORCL/
[oracle@localhost ORCL]$ cp hwm_test.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 29 11:14:59 2021
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1191181696 bytes
Fixed Size 8895872 bytes
Variable Size 318767104 bytes
Database Buffers 855638016 bytes
Redo Buffers 7880704 bytes
Database mounted.
SQL> alter database rename file '/u01/app/oracle19/oradata/ORCL/hwm_test.dbf' to '/Data/oradata/orcl/hwm_test.dbf';

Database altered.

SQL> alter database oprn
2 ^H;
*
ERROR at line 2:
ORA-00911: invalid character


SQL> alter database open;

Database altered.

SQL> select file#,name,status from v$datafile;

FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS
-------
1
/u01/app/oracle19/oradata/ORCL/system01.dbf
SYSTEM

2
/u01/app/oracle19/oradata/ORCL/sysaux01.dbf
ONLINE

FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS
-------

3
/u01/app/oracle19/oradata/ORCL/undotbs01.dbf
ONLINE

4
/u01/app/oracle19/oradata/ORCL/users01.dbf

FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS
-------
ONLINE

5
/Data/oradata/orcl/hwm_test.dbf
ONLINE

6

FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS
-------
/u01/app/oracle19/oradata/ORCL/data.dbf
ONLINE

7
/u01/app/oracle19/oradata/ORCL/data_ind.dbf
ONLINE


FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS
-------
8
/u01/app/oracle19/oradata/ORCL/data_ind1.dbf
ONLINE

9
/u01/app/oracle19/oradata/ORCL/data1.dbf
ONLINE

FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS
-------

10
/u01/app/oracle19/oradata/ORCL/data2.dbf
ONLINE


10 rows selected.

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1191181696 bytes
Fixed Size 8895872 bytes
Variable Size 318767104 bytes
Database Buffers 855638016 bytes
Redo Buffers 7880704 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ORCL]$ ls
control01.ctl data1.dbf data.dbf data_ind.dbf redo02.log sysaux01.dbf temp01.dbf users01.dbf
control02.ctl data2.dbf data_ind1.dbf redo01.log redo03.log system01.dbf undotbs01.dbf
[oracle@localhost ORCL]$ mv data1.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv data2.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv data.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv data_ind1.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv data_ind.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv sysaux01.dbf /Data/oradata/orcl/
mv =mv: setting attribute ‘security.selinux’ for ‘security.selinux’: Operation not permitted
[oracle@localhost ORCL]$ ls
control01.ctl control02.ctl redo01.log redo02.log redo03.log system01.dbf temp01.dbf undotbs01.dbf users01.dbf
[oracle@localhost ORCL]$ mv system01.dbf /Data/oradata/orcl/
mv: setting attribute ‘security.selinux’ for ‘security.selinux’: Operation not permitted
[oracle@localhost ORCL]$ ls
control01.ctl control02.ctl redo01.log redo02.log redo03.log temp01.dbf undotbs01.dbf users01.dbf
[oracle@localhost ORCL]$ mv temp01.dbf /Data/oradata/orcl/
mv: setting attribute ‘security.selinux’ for ‘security.selinux’: Operation not permitted
[oracle@localhost ORCL]$ ls
control01.ctl control02.ctl redo01.log redo02.log redo03.log undotbs01.dbf users01.dbf
[oracle@localhost ORCL]$ mv undotbs01.dbf /Data/oradata/orcl/
mvmv: setting attribute ‘security.selinux’ for ‘security.selinux’: Operation not permitted
[oracle@localhost ORCL]$ mv users01.dbf /Data/oradata/orcl/
mv: setting attribute ‘security.selinux’ for ‘security.selinux’: Operation not permitted
[oracle@localhost ORCL]$ cd
[oracle@localhost ~]$ cd /Data/oradata/orcl/
[oracle@localhost orcl]$ ls
data1.dbf data2.dbf data.dbf data_ind1.dbf data_ind.dbf hwm_test.dbf sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf
[oracle@localhost orcl]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 29 11:28:16 2021
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> shutdown
ORA-01116: error in opening database file 1
ORA-01110: data file 1: '/u01/app/oracle19/oradata/ORCL/system01.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost orcl]$ ls
data1.dbf data2.dbf data.dbf data_ind1.dbf data_ind.dbf hwm_test.dbf sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf
[oracle@localhost orcl]$ mv data1.dbf /u01/app/oracle19/oradata/ORCL/
[oracle@localhost orcl]$ mv data2.dbf /u01/app/oracle19/oradata/ORCL/
[oracle@localhost orcl]$ mv data.dbf /u01/app/oracle19/oradata/ORCL/
[oracle@localhost orcl]$ mv data_ind1.dbf /u01/app/oracle19/oradata/ORCL/
[oracle@localhost orcl]$ mv data_ind.dbf /u01/app/oracle19/oradata/ORCL/
[oracle@localhost orcl]$ mv sysaux01.dbf /u01/app/oracle19/oradata/ORCL/
[oracle@localhost orcl]$ mv system01.dbf /u01/app/oracle19/oradata/ORCL/
[oracle@localhost orcl]$ mv temp01.dbf /u01/app/oracle19/oradata/ORCL/
[oracle@localhost orcl]$ mv undotbs01.dbf /u01/app/oracle19/oradata/ORCL/
[oracle@localhost orcl]$ mv users01.dbf /u01/app/oracle19/oradata/ORCL/
[oracle@localhost orcl]$ ls
hwm_test.dbf
[oracle@localhost orcl]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 29 11:30:22 2021
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost orcl]$ ls
hwm_test.dbf
[oracle@localhost orcl]$ cd
[oracle@localhost ~]$ cd /u01
[oracle@localhost u01]$ cd app/oracle19/oradata/ORCL/
[oracle@localhost ORCL]$ ls
control01.ctl data1.dbf data.dbf data_ind.dbf redo02.log sysaux01.dbf temp01.dbf users01.dbf
control02.ctl data2.dbf data_ind1.dbf redo01.log redo03.log system01.dbf undotbs01.dbf
[oracle@localhost ORCL]$ mv data1.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv data2.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv data.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv data_ind1.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv data_ind.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv sysaux01.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv system01.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv temp01.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv undotbs01.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ mv users01.dbf /Data/oradata/orcl/
[oracle@localhost ORCL]$ ls
control01.ctl control02.ctl redo01.log redo02.log redo03.log
[oracle@localhost ORCL]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 29 11:32:39 2021
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1191181696 bytes
Fixed Size 8895872 bytes
Variable Size 318767104 bytes
Database Buffers 855638016 bytes
Redo Buffers 7880704 bytes
Database mounted.
SQL>
SQL> alter database rename file '/u01/app/oracle19/oradata/ORCL/system01.dbf' to '/Data/oradata/orcl/system01.dbf';

Database altered.

SQL>
SQL> alter database rename file '/u01/app/oracle19/oradata/ORCL/sysaux01.dbf' to '/Data/oradata/orcl/sysaux01.dbf';

Database altered.

SQL> alter database rename file '/u01/app/oracle19/oradata/ORCL/undotbs01.dbf' to '/Data/oradata/orcl/undotbs.dbf';
alter database rename file '/u01/app/oracle19/oradata/ORCL/undotbs01.dbf' to '/Data/oradata/orcl/undotbs.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01141: error renaming data file 3 - new file
'/Data/oradata/orcl/undotbs.dbf' not found
ORA-01110: data file 3: '/u01/app/oracle19/oradata/ORCL/undotbs01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7


SQL> alter database rename filr '/u01/app/oracle19/oradata/ORCL/undotbs01.dbf' to '/Data/oradata/orcl/undotbs01.dbf';
alter database rename filr '/u01/app/oracle19/oradata/ORCL/undotbs01.dbf' to '/Data/oradata/orcl/undotbs01.dbf'
*
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE


SQL> alter database rename file '/u01/app/oracle19/oradata/ORCL/undotbs01.dbf' to '/Data/oradata/orcl/undotbs01.dbf';

Database altered.

SQL> ^C

SQL> ^C^M

SQL>
SQL> ^C

SQL>
SQL>
SQL>
SQL>
SQL> alter database rename file '/u01/app/oracle19/oradata/ORCL/users01.dbf' to '/Data/oradata/orcl/users01.dbf';


alter database rename file '/u01/app/oracle19/oradata/ORCL/data.dbf' to '/Data/oradata/orcl/data.dbf';

alter database rename file '/u01/app/oracle19/oradata/ORCL/data_ind.dbf' to '/Data/oradata/orcl/data_ind.dbf';

alter database rename file '/u01/app/oracle19/oradata/ORCL/data_ind1.dbf' to '/Data/oradata/orcl/data_ind1.dbf';

alter database rename file '/u01/app/oracle19/oradata/ORCL/data1.dbf' to '/Data/oradata/orcl/data1.dbf';

alter database rename file '/u01/app/oracle19/oradata/ORCL/data2.dbf' to '/Data/oradata/orcl/data2.dbf';
Database altered.

SQL> SQL> SQL>
Database altered.

SQL> SQL>
Database altered.

SQL> SQL>
Database altered.

SQL> SQL>
Database altered.

SQL> SQL>

Database altered.

SQL>
SQL>
SQL> alter database open
2 ;

Database altered.

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1191181696 bytes
Fixed Size 8895872 bytes
Variable Size 318767104 bytes
Database Buffers 855638016 bytes
Redo Buffers 7880704 bytes
Database mounted.
Database opened.
SQL> select * from lwt.lwt1;

A B C
---------- -------------------- --------------------
1 lwt abc
2 lwt abc
3 2222 abc
4 lwt abc
5 lwt abc
6 lwt abc
7 lwt abc
8 lwt abc
9 lwt abc
10 lwt abc
11 lwt abc

A B C
---------- -------------------- --------------------
12 lwt abc
13 lwt abc
14 lwt abc
15 lwt abc
16 lwt abc
17 lwt abc
18 lwt abc
19 lwt abc
20 lwt abc
21 lwt abc
22 lwt abc

A B C
---------- -------------------- --------------------
23 lwt abc
24 lwt abc
25 lwt abc
26 lwt abc
27 lwt abc
28 lwt abc
29 lwt abc
30 lwt abc
31 lwt abc
32 lwt abc
33 lwt abc

A B C
---------- -------------------- --------------------
34 lwt abc
35 lwt abc
36 lwt abc
37 lwt abc
38 lwt abc
39 lwt abc
40 lwt abc
41 lwt abc
42 lwt abc
43 lwt abc
44 lwt abc

A B C
---------- -------------------- --------------------
45 lwt abc
46 lwt abc
47 lwt abc
48 lwt abc
49 lwt abc
50 lwt abc
51 lwt abc
52 lwt abc
53 lwt abc
54 lwt abc
55 lwt abc

A B C
---------- -------------------- --------------------
56 lwt abc
57 lwt abc
58 lwt abc
59 lwt abc
60 lwt abc
61 lwt abc
62 lwt abc
63 lwt abc
64 lwt abc
65 lwt abc
66 lwt abc

A B C
---------- -------------------- --------------------
67 lwt abc
68 lwt abc
69 lwt abc
70 lwt abc
71 lwt abc
72 lwt abc
73 lwt abc
74 lwt abc
75 lwt abc
76 lwt abc
77 lwt abc

A B C
---------- -------------------- --------------------
78 lwt abc
79 lwt abc
80 lwt abc
81 lwt abc
82 lwt abc
83 lwt abc
84 lwt abc
85 lwt abc
86 lwt abc
87 lwt abc
88 lwt abc

A B C
---------- -------------------- --------------------
89 lwt abc
90 lwt abc
91 lwt abc
92 lwt abc
93 lwt abc
94 lwt abc
95 lwt abc
96 lwt abc
97 lwt abc
98 lwt abc
99 lwt abc

A B C
---------- -------------------- --------------------
100 lwt abc

100 rows selected.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ORCL]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 29 11:44:59 2021
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1191181696 bytes
Fixed Size 8895872 bytes
Variable Size 318767104 bytes
Database Buffers 855638016 bytes
Redo Buffers 7880704 bytes
Database mounted.
Database opened.
SQL>