|
|
[oracle@localhost ORACLE19]$ ll
total 3984936
-rw-r-----. 1 oracle oinstall 11354112 Oct 1 16:26 control01.ctl
-rw-r-----. 1 oracle oinstall 11354112 Oct 1 16:26 control02.ctl
-rw-r-----. 1 oracle oinstall 10493952 Oct 1 16:26 deldel.dbf
-rw-r-----. 1 oracle oinstall 209715712 Oct 1 16:26 redo01b.log
-rw-r-----. 1 oracle oinstall 209715712 Oct 1 16:26 redo01.log
-rw-r-----. 1 oracle oinstall 209715712 Oct 1 16:26 redo02b.log
-rw-r-----. 1 oracle oinstall 209715712 Oct 1 16:26 redo02.log
-rw-r-----. 1 oracle oinstall 209715712 Oct 1 16:26 redo03b.log
-rw-r-----. 1 oracle oinstall 209715712 Oct 1 16:26 redo03.log
-rw-r-----. 1 oracle oinstall 104865792 Oct 1 16:26 rman_tbs.dbf
-rw-r-----. 1 oracle oinstall 660611072 Oct 1 16:26 sysaux01.dbf
-rw-r-----. 1 oracle oinstall 975183872 Oct 1 16:26 system01.dbf
-rw-r-----. 1 oracle oinstall 52436992 Oct 1 16:18 temp02.dbf
-rw-r-----. 1 oracle oinstall 52436992 Oct 1 16:26 ts702_01.dbf
-rw-r-----. 1 oracle oinstall 52436992 Oct 1 16:26 ts702idx_01.dbf
-rw-r-----. 1 oracle oinstall 52436992 Oct 1 16:26 ts704_01.dbf
-rw-r-----. 1 oracle oinstall 52436992 Oct 1 16:26 ts704idx_01.dbf
-rw-r-----. 1 oracle oinstall 10493952 Oct 1 16:26 ts709b.dbf
-rw-r-----. 1 oracle oinstall 10493952 Oct 1 16:26 ts899.dbf
-rw-r-----. 1 oracle oinstall 5251072 Oct 1 16:26 ts91.dbf
-rw-r-----. 1 oracle oinstall 361766912 Oct 1 16:26 undotbs01.dbf
-rw-r-----. 1 oracle oinstall 104865792 Oct 1 16:26 undotbs07.dbf
-rw-r-----. 1 oracle oinstall 344727552 Oct 1 16:26 users01.dbf
[oracle@localhost ORACLE19]$
[oracle@localhost ORACLE19]$ rm *
[oracle@localhost ORACLE19]$ ll
total 0
[oracle@localhost ORACLE19]$ cd $ORACLE_HOME/dbs
[oracle@localhost dbs]$ ll
total 18034540
-rw-r-----. 1 oracle oinstall 10682368 Sep 23 14:42 0144dadn_1_1
-rw-r-----. 1 oracle oinstall 1424867328 Sep 1 16:36 0n42jgru_1_1
-rw-r-----. 1 oracle oinstall 1357316096 Sep 29 10:51 1g44sn5a_1_1
-rw-r-----. 1 oracle oinstall 1581572096 Sep 29 11:15 1i44soif_1_1
-rw-r-----. 1 oracle oinstall 1706926080 Oct 1 16:19 5u4557gi_1_1
-rw-r-----. 1 oracle oinstall 7168 Oct 1 16:19 5v4557go_1_1
-rw-r-----. 1 oracle oinstall 168617472 Sep 16 14:41 arch1_100_1209485221.dbf
-rw-r-----. 1 oracle oinstall 181399040 Sep 16 14:42 arch1_101_1209485221.dbf
-rw-r-----. 1 oracle oinstall 4608 Aug 20 15:29 arch1_10_1209485221.dbf
-rw-r-----. 1 oracle oinstall 6996992 Sep 5 10:15 arch1_10_1210165597.dbf
-rw-r-----. 1 oracle oinstall 177118720 Sep 16 14:43 arch1_102_1209485221.dbf
-rw-r-----. 1 oracle oinstall 177196032 Sep 16 14:44 arch1_103_1209485221.dbf
-rw-r-----. 1 oracle oinstall 175463424 Sep 16 14:45 arch1_104_1209485221.dbf
-rw-r-----. 1 oracle oinstall 168805888 Sep 16 14:46 arch1_105_1209485221.dbf
-rw-r-----. 1 oracle oinstall 168513536 Sep 16 15:35 arch1_106_1209485221.dbf
-rw-r-----. 1 oracle oinstall 166911488 Sep 16 15:52 arch1_107_1209485221.dbf
-rw-r-----. 1 oracle oinstall 165891584 Sep 16 16:14 arch1_108_1209485221.dbf
-rw-r-----. 1 oracle oinstall 165597696 Sep 16 17:39 arch1_109_1209485221.dbf
-rw-r-----. 1 oracle oinstall 90871808 Sep 17 10:09 arch1_110_1209485221.dbf
-rw-r-----. 1 oracle oinstall 113091584 Sep 17 14:07 arch1_111_1209485221.dbf
-rw-r-----. 1 oracle oinstall 11408384 Aug 21 09:44 arch1_11_1209485221.dbf
-rw-r-----. 1 oracle oinstall 7030784 Sep 5 11:50 arch1_11_1210165597.dbf
-rw-r-----. 1 oracle oinstall 19565568 Sep 22 09:51 arch1_112_1209485221.dbf
-rw-r-----. 1 oracle oinstall 10412032 Aug 21 10:18 arch1_12_1209485221.dbf
-rw-r-----. 1 oracle oinstall 42557952 Sep 8 09:48 arch1_12_1210165597.dbf
-rw-r-----. 1 oracle oinstall 8663552 Aug 21 11:18 arch1_13_1209485221.dbf
-rw-r-----. 1 oracle oinstall 71268352 Sep 8 15:05 arch1_13_1210165597.dbf
-rw-r-----. 1 oracle oinstall 19389952 Aug 21 14:53 arch1_14_1209485221.dbf
-rw-r-----. 1 oracle oinstall 49362944 Sep 8 16:29 arch1_14_1210165597.dbf
-rw-r-----. 1 oracle oinstall 11659776 Aug 22 10:12 arch1_15_1209485221.dbf
-rw-r-----. 1 oracle oinstall 5008896 Sep 8 16:52 arch1_15_1210165597.dbf
-rw-r-----. 1 oracle oinstall 4941312 Aug 22 10:24 arch1_16_1209485221.dbf
-rw-r-----. 1 oracle oinstall 1706496 Sep 8 16:56 arch1_16_1210165597.dbf
-rw-r-----. 1 oracle oinstall 4631552 Aug 22 10:49 arch1_17_1209485221.dbf
-rw-r-----. 1 oracle oinstall 49969664 Sep 9 09:55 arch1_17_1210165597.dbf
-rw-r-----. 1 oracle oinstall 33786880 Aug 25 09:55 arch1_18_1209485221.dbf
-rw-r-----. 1 oracle oinstall 198679552 Sep 9 16:27 arch1_18_1210165597.dbf
-rw-r-----. 1 oracle oinstall 84667904 Aug 26 10:07 arch1_19_1209485221.dbf
-rw-r-----. 1 oracle oinstall 197281280 Sep 9 16:34 arch1_19_1210165597.dbf
-rw-r-----. 1 oracle oinstall 1998848 Aug 26 10:20 arch1_20_1209485221.dbf
-rw-r-----. 1 oracle oinstall 198672896 Sep 9 16:50 arch1_20_1210165597.dbf
-rw-r-----. 1 oracle oinstall 3624960 Aug 26 10:41 arch1_21_1209485221.dbf
-rw-r-----. 1 oracle oinstall 198680064 Sep 9 16:52 arch1_21_1210165597.dbf
-rw-r-----. 1 oracle oinstall 4096 Oct 1 16:19 arch1_2_1213373897.dbf
-rw-r-----. 1 oracle oinstall 1740288 Aug 26 11:02 arch1_22_1209485221.dbf
-rw-r-----. 1 oracle oinstall 198680064 Sep 9 17:13 arch1_22_1210165597.dbf
-rw-r-----. 1 oracle oinstall 5532160 Aug 26 11:29 arch1_23_1209485221.dbf
-rw-r-----. 1 oracle oinstall 198680064 Sep 9 17:15 arch1_23_1210165597.dbf
-rw-r-----. 1 oracle oinstall 14858240 Aug 26 15:50 arch1_24_1209485221.dbf
-rw-r-----. 1 oracle oinstall 102359040 Sep 9 17:16 arch1_24_1210165597.dbf
-rw-r-----. 1 oracle oinstall 5852160 Aug 26 16:14 arch1_25_1209485221.dbf
-rw-r-----. 1 oracle oinstall 27648 Sep 9 17:19 arch1_25_1210165597.dbf
-rw-r-----. 1 oracle oinstall 8253440 Aug 27 09:57 arch1_26_1209485221.dbf
-rw-r-----. 1 oracle oinstall 147121152 Sep 9 17:24 arch1_26_1210165597.dbf
-rw-r-----. 1 oracle oinstall 2075648 Aug 27 10:07 arch1_27_1209485221.dbf
-rw-r-----. 1 oracle oinstall 182768640 Sep 9 17:27 arch1_27_1210165597.dbf
-rw-r-----. 1 oracle oinstall 5440000 Aug 27 10:23 arch1_28_1209485221.dbf
-rw-r-----. 1 oracle oinstall 198676480 Sep 9 17:38 arch1_28_1210165597.dbf
-rw-r-----. 1 oracle oinstall 1691136 Aug 27 10:28 arch1_29_1209485221.dbf
-rw-r-----. 1 oracle oinstall 69987328 Sep 10 09:44 arch1_29_1210165597.dbf
-rw-r-----. 1 oracle oinstall 7196672 Aug 27 11:12 arch1_30_1209485221.dbf
-rw-r-----. 1 oracle oinstall 158085632 Sep 11 00:10 arch1_30_1210165597.dbf
-rw-r-----. 1 oracle oinstall 1681920 Aug 27 11:13 arch1_31_1209485221.dbf
-rw-r-----. 1 oracle oinstall 5747200 Sep 11 09:47 arch1_31_1210165597.dbf
-rw-r-----. 1 oracle oinstall 4608 Oct 1 16:26 arch1_3_1213373897.dbf
-rw-r-----. 1 oracle oinstall 1800192 Aug 27 11:16 arch1_32_1209485221.dbf
-rw-r-----. 1 oracle oinstall 174374400 Sep 11 22:08 arch1_32_1210165597.dbf
-rw-r-----. 1 oracle oinstall 25442304 Sep 12 09:44 arch1_33_1210165597.dbf
-rw-r-----. 1 oracle oinstall 175631360 Sep 12 15:32 arch1_34_1210165597.dbf
-rw-r-----. 1 oracle oinstall 105779200 Sep 12 19:00 arch1_35_1210165597.dbf
-rw-r-----. 1 oracle oinstall 2573824 Sep 14 22:56 arch1_36_1210165597.dbf
-rw-r-----. 1 oracle oinstall 39368192 Sep 1 15:18 arch1_37_1209485221.dbf
-rw-r-----. 1 oracle oinstall 46564352 Sep 15 09:57 arch1_37_1210165597.dbf
-rw-r-----. 1 oracle oinstall 1994752 Sep 1 15:30 arch1_38_1209485221.dbf
-rw-r-----. 1 oracle oinstall 153856000 Sep 16 09:59 arch1_38_1210165597.dbf
-rw-r-----. 1 oracle oinstall 3885056 Sep 1 15:50 arch1_39_1209485221.dbf
-rw-r-----. 1 oracle oinstall 154735104 Sep 17 10:09 arch1_39_1210165597.dbf
-rw-r-----. 1 oracle oinstall 8411648 Sep 1 16:46 arch1_40_1209485221.dbf
-rw-r-----. 1 oracle oinstall 17888768 Sep 17 14:07 arch1_40_1210165597.dbf
-rw-r-----. 1 oracle oinstall 6577664 Sep 2 10:17 arch1_41_1209485221.dbf
-rw-r-----. 1 oracle oinstall 63399424 Sep 22 09:52 arch1_41_1210165597.dbf
-rw-r-----. 1 oracle oinstall 1024 Oct 1 16:26 arch1_4_1213373897.dbf
-rw-r-----. 1 oracle oinstall 68191232 Sep 3 11:46 arch1_42_1209485221.dbf
-rw-r-----. 1 oracle oinstall 1781760 Sep 3 11:50 arch1_43_1209485221.dbf
-rw-r-----. 1 oracle oinstall 1726976 Sep 3 11:53 arch1_44_1209485221.dbf
-rw-r-----. 1 oracle oinstall 10209280 Sep 3 14:00 arch1_45_1209485221.dbf
-rw-r-----. 1 oracle oinstall 1723392 Sep 3 14:02 arch1_46_1209485221.dbf
-rw-r-----. 1 oracle oinstall 6813184 Sep 3 14:23 arch1_47_1209485221.dbf
-rw-r-----. 1 oracle oinstall 19786752 Sep 4 09:50 arch1_48_1209485221.dbf
-rw-r-----. 1 oracle oinstall 191676928 Sep 4 11:22 arch1_49_1209485221.dbf
-rw-r-----. 1 oracle oinstall 44331520 Sep 4 15:49 arch1_50_1209485221.dbf
-rw-r-----. 1 oracle oinstall 12744192 Sep 5 09:50 arch1_51_1209485221.dbf
-rw-r-----. 1 oracle oinstall 1024 Oct 1 16:26 arch1_5_1213373897.dbf
-rw-r-----. 1 oracle oinstall 7804416 Sep 5 10:15 arch1_52_1209485221.dbf
-rw-r-----. 1 oracle oinstall 87493632 Sep 5 11:50 arch1_53_1209485221.dbf
-rw-r-----. 1 oracle oinstall 5566976 Sep 5 12:08 arch1_54_1209485221.dbf
-rw-r-----. 1 oracle oinstall 10785792 Sep 5 14:00 arch1_55_1209485221.dbf
-rw-r-----. 1 oracle oinstall 14593536 Sep 5 15:05 arch1_56_1209485221.dbf
-rw-r-----. 1 oracle oinstall 96906240 Sep 8 09:48 arch1_57_1209485221.dbf
-rw-r-----. 1 oracle oinstall 166853120 Sep 8 17:15 arch1_58_1209485221.dbf
-rw-r-----. 1 oracle oinstall 170584576 Sep 8 17:17 arch1_59_1209485221.dbf
-rw-r-----. 1 oracle oinstall 165806080 Sep 8 17:23 arch1_60_1209485221.dbf
-rw-r-----. 1 oracle oinstall 165851136 Sep 8 17:43 arch1_61_1209485221.dbf
-rw-r-----. 1 oracle oinstall 62909440 Sep 9 09:55 arch1_62_1209485221.dbf
-rw-r-----. 1 oracle oinstall 165406208 Sep 9 14:50 arch1_63_1209485221.dbf
-rw-r-----. 1 oracle oinstall 77173248 Sep 10 09:43 arch1_64_1209485221.dbf
-rw-r-----. 1 oracle oinstall 168517632 Sep 10 14:14 arch1_65_1209485221.dbf
-rw-r-----. 1 oracle oinstall 168721920 Sep 10 16:33 arch1_66_1209485221.dbf
-rw-r-----. 1 oracle oinstall 14528512 Sep 11 00:10 arch1_67_1209485221.dbf
-rw-r-----. 1 oracle oinstall 174702592 Sep 11 00:21 arch1_68_1209485221.dbf
-rw-r-----. 1 oracle oinstall 101888 Sep 11 09:47 arch1_69_1209485221.dbf
-rw-r-----. 1 oracle oinstall 165379584 Sep 11 13:52 arch1_70_1209485221.dbf
-rw-r-----. 1 oracle oinstall 167635456 Sep 11 15:59 arch1_71_1209485221.dbf
-rw-r-----. 1 oracle oinstall 26735104 Aug 29 13:55 arch1_7_1210165597.dbf
-rw-r-----. 1 oracle oinstall 170836480 Sep 11 16:40 arch1_72_1209485221.dbf
-rw-r-----. 1 oracle oinstall 137121280 Sep 11 22:07 arch1_73_1209485221.dbf
-rw-r-----. 1 oracle oinstall 165330432 Sep 11 22:45 arch1_74_1209485221.dbf
-rw-r-----. 1 oracle oinstall 181302272 Sep 12 11:09 arch1_75_1209485221.dbf
-rw-r-----. 1 oracle oinstall 165637120 Sep 12 12:02 arch1_76_1209485221.dbf
-rw-r-----. 1 oracle oinstall 168078848 Sep 12 15:24 arch1_77_1209485221.dbf
-rw-r-----. 1 oracle oinstall 174837760 Sep 12 16:08 arch1_78_1209485221.dbf
-rw-r-----. 1 oracle oinstall 169284608 Sep 12 16:53 arch1_79_1209485221.dbf
-rw-r-----. 1 oracle oinstall 177150464 Sep 12 17:54 arch1_80_1209485221.dbf
-rw-r-----. 1 oracle oinstall 4221952 Sep 12 18:59 arch1_81_1209485221.dbf
-rw-r-----. 1 oracle oinstall 96337408 Sep 2 16:19 arch1_8_1210165597.dbf
-rw-r-----. 1 oracle oinstall 2802176 Sep 14 22:56 arch1_82_1209485221.dbf
-rw-r-----. 1 oracle oinstall 168098304 Sep 15 00:01 arch1_83_1209485221.dbf
-rw-r-----. 1 oracle oinstall 169495040 Sep 15 00:02 arch1_84_1209485221.dbf
-rw-r-----. 1 oracle oinstall 168134144 Sep 15 00:32 arch1_85_1209485221.dbf
-rw-r-----. 1 oracle oinstall 181671424 Sep 15 00:32 arch1_86_1209485221.dbf
-rw-r-----. 1 oracle oinstall 35603968 Sep 15 09:56 arch1_87_1209485221.dbf
-rw-r-----. 1 oracle oinstall 184012800 Sep 15 10:28 arch1_88_1209485221.dbf
-rw-r-----. 1 oracle oinstall 171084288 Sep 15 11:56 arch1_89_1209485221.dbf
-rw-r-----. 1 oracle oinstall 167271936 Sep 15 13:54 arch1_90_1209485221.dbf
-rw-r-----. 1 oracle oinstall 165530112 Sep 15 17:05 arch1_91_1209485221.dbf
-rw-r-----. 1 oracle oinstall 36084224 Aug 20 15:29 arch1_9_1209485221.dbf
-rw-r-----. 1 oracle oinstall 9866752 Sep 5 09:50 arch1_9_1210165597.dbf
-rw-r-----. 1 oracle oinstall 2814464 Sep 16 09:59 arch1_92_1209485221.dbf
-rw-r-----. 1 oracle oinstall 167249920 Sep 16 11:59 arch1_93_1209485221.dbf
-rw-r-----. 1 oracle oinstall 177513472 Sep 16 14:25 arch1_94_1209485221.dbf
-rw-r-----. 1 oracle oinstall 172943872 Sep 16 14:35 arch1_95_1209485221.dbf
-rw-r-----. 1 oracle oinstall 174343168 Sep 16 14:36 arch1_96_1209485221.dbf
-rw-r-----. 1 oracle oinstall 180400640 Sep 16 14:37 arch1_97_1209485221.dbf
-rw-r-----. 1 oracle oinstall 172784128 Sep 16 14:38 arch1_98_1209485221.dbf
-rw-r-----. 1 oracle oinstall 179365888 Sep 16 14:40 arch1_99_1209485221.dbf
-rw-r-----. 1 oracle oinstall 10715136 Sep 12 15:50 c-149179035-20250912-03
-rw-r-----. 1 oracle oinstall 10747904 Sep 15 11:22 c-1737265955-20250915-00
-rw-r-----. 1 oracle oinstall 10747904 Sep 16 15:55 c-1737265955-20250916-00
-rw-r-----. 1 oracle oinstall 10715136 Sep 22 16:29 c-3392683987-20250922-02
-rw-r-----. 1 oracle oinstall 10747904 Sep 29 10:51 c-3392683987-20250929-02
-rw-r-----. 1 oracle oinstall 10813440 Sep 29 11:15 c-3392683987-20250929-04
-rw-r-----. 1 oracle oinstall 10878976 Sep 30 09:56 c-3392683987-20250930-00
-rw-r-----. 1 oracle oinstall 10878976 Sep 30 10:14 c-3392683987-20250930-03
-rw-r-----. 1 oracle oinstall 10878976 Sep 30 10:24 c-3392683987-20250930-05
-rw-r-----. 1 oracle oinstall 11042816 Sep 30 11:15 c-3392683987-20250930-08
-rw-r-----. 1 oracle oinstall 11173888 Sep 30 16:28 c-3392683987-20250930-20
-rw-r-----. 1 oracle oinstall 11173888 Sep 30 17:43 c-3392683987-20250930-24
-rw-r-----. 1 oracle oinstall 11468800 Oct 1 16:19 c-3392683987-20251001-11
-rw-r-----. 1 oracle oinstall 10715136 Sep 23 14:42 c-513918623-20250923-00
-rw-r-----. 1 oracle oinstall 10600448 Sep 25 13:32 cntrlorcl19.dbf
-rw-rw----. 1 oracle oinstall 1544 Sep 23 16:19 hc_oracle19.dat
-rw-rw----. 1 oracle oinstall 1544 Oct 1 16:18 hc_orcl19.dat
-rw-rw----. 1 oracle oinstall 1544 Sep 22 10:03 hc_orcl.dat
-rw-rw----. 1 oracle oinstall 1544 Sep 22 09:58 hc_orcldw.dat
-rw-rw----. 1 oracle oinstall 1544 Aug 29 18:12 hc_orcllph.dat
-rw-r--r--. 1 oracle oinstall 3079 May 14 2015 init.ora
-rw-r-----. 1 oracle oinstall 24 Sep 25 12:18 lkDUMMY
-rw-r-----. 1 oracle oinstall 24 Sep 25 13:32 lkORACLE19
-rw-r-----. 1 oracle oinstall 24 Sep 23 14:34 lkORCL19
-rw-r-----. 1 oracle oinstall 2048 Sep 22 10:10 orapworacle19
-rw-r-----. 1 oracle oinstall 6144 Oct 1 15:04 orapworcl19
-rw-r-----. 1 oracle oinstall 2048 Aug 26 17:38 orapworcllph
-rw-r-----. 1 oracle oinstall 10600448 Sep 23 10:38 snapcf_oracle19.f
-rw-r-----. 1 oracle oinstall 11354112 Oct 1 16:19 snapcf_orcl19.f
-rw-r-----. 1 oracle oinstall 4608 Oct 1 16:17 spfileorcl19.ora
[oracle@localhost dbs]$ rm spfileorcl19.ora
[oracle@localhost dbs]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 1 16:27:04 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SYS@orcl19> ll
SP2-0042: unknown command "ll" - rest of line ignored.
SYS@orcl19>
SYS@orcl19> select * from user_tables;
select * from user_tables
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SYS@orcl19> exit;
Disconnected
[oracle@localhost dbs]$ rman target / rc_user/rman@RC
Argument Value Description
-----------------------------------------------------------------------------
target quoted-string connect-string for target database
catalog quoted-string connect-string for recovery catalog
auxiliary quoted-string connect-string for auxiliary database
nocatalog none if specified, then no recovery catalog
cmdfile quoted-string name of input command file
log quoted-string name of output message log file
trace quoted-string name of output debugging message log file
append none if specified, log is opened in append mode
debug optional-args activate debugging
msgno none show RMAN-nnnn prefix for all messages
send quoted-string send a command to the media manager
pipe string building block for pipe names
script string name of catalog script to execute
using list of args arguments for rman variables
timeout integer number of seconds to wait for pipe input
checksyntax none check the command file for syntax errors
-----------------------------------------------------------------------------
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00552: syntax error in command line arguments
RMAN-01009: syntax error: found "identifier": expecting one of: "append, auxiliary, catalog, checksyntax, cmdfile, log, msgno, nocatalog, pipe, script, send, target, timeout, using, @, ;"
RMAN-01008: the bad identifier was: rc_user
RMAN-01007: at line 2 column 1 file: command line arguments
[oracle@localhost dbs]$ rman target / catalog rc_user/rman@RC
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Oct 1 16:47:44 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
connected to recovery catalog database
RMAN> statup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release"
RMAN-01008: the bad identifier was: statup
RMAN-01007: at line 1 column 1 file: standard input
RMAN> startup
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/19c/db_1/dbs/initorcl19.ora'
starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 10/01/2025 16:48:03
ORA-01103: database name 'ORACLE19' in control file is not 'DUMMY'
RMAN> restore spfile;
Starting restore at 2025-10-01 16:48:13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=151 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: restoring SPFILE
output file name=/u01/app/oracle/product/19c/db_1/dbs/spfileorcl19.ora
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/19c/db_1/dbs/c-3392683987-20251001-11
channel ORA_DISK_1: piece handle=/u01/app/oracle/product/19c/db_1/dbs/c-3392683987-20251001-11 tag=TAG20251001T161938
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 2025-10-01 16:48:14
RMAN> startup force;
Oracle instance started
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 10/01/2025 16:48:30
ORA-00205: error in identifying control file, check alert log for more info
RMAN> list failure;
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------------- -------
9641 CRITICAL OPEN 2025-10-01 16:48:30 Control file /u01/app/oracle/oradata/ORACLE19/control02.ctl is missing
9638 CRITICAL OPEN 2025-10-01 16:48:30 Control file /u01/app/oracle/oradata/ORACLE19/control01.ctl is missing
RMAN> advise failure;
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------------- -------
9641 CRITICAL OPEN 2025-10-01 16:48:30 Control file /u01/app/oracle/oradata/ORACLE19/control02.ctl is missing
9638 CRITICAL OPEN 2025-10-01 16:48:30 Control file /u01/app/oracle/oradata/ORACLE19/control01.ctl is missing
analyzing automatic repair options; this may take some time
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=136 device type=DISK
analyzing automatic repair options complete
Mandatory Manual Actions
========================
no manual actions available
Optional Manual Actions
=======================
1. If file /u01/app/oracle/oradata/ORACLE19/control02.ctl was unintentionally renamed or moved, restore it
2. If file /u01/app/oracle/oradata/ORACLE19/control01.ctl was unintentionally renamed or moved, restore it
3. If this is a standby database, restore the controlfile for a standby database using RESTORE STANDBY CONTROLFILE FROM AUTOBACKUP command
4. If this is a primary database and a standby database is available, then perform a Data Guard failover initiated from the standby
Automated Repair Options
========================
Option Repair Description
------ ------------------
1 Restore a backup control file
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/oracle19/orcl19/hm/reco_3427469360.hm
RMAN> repair failure preview;
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/oracle19/orcl19/hm/reco_3427469360.hm
contents of repair script:
# restore control file
restore controlfile;
sql 'alter database mount';
RMAN> repair failure;
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/oracle19/orcl19/hm/reco_3427469360.hm
contents of repair script:
# restore control file
restore controlfile;
sql 'alter database mount';
Do you really want to execute the above repair (enter YES or NO)? yes
executing repair script
Starting restore at 2025-10-01 16:48:57
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/19c/db_1/dbs/c-3392683987-20251001-11
channel ORA_DISK_1: piece handle=/u01/app/oracle/product/19c/db_1/dbs/c-3392683987-20251001-11 tag=TAG20251001T161938
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/ORACLE19/control01.ctl
output file name=/u01/app/oracle/oradata/ORACLE19/control02.ctl
Finished restore at 2025-10-01 16:48:58
sql statement: alter database mount
released channel: ORA_DISK_1
repair failure complete
RMAN> list failure;
Database Role: PRIMARY
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------------- -------
9692 CRITICAL OPEN 2025-10-01 16:49:05 System datafile 1: '/u01/app/oracle/oradata/ORACLE19/system01.dbf' is missing
9689 CRITICAL OPEN 2025-10-01 16:49:04 Control file needs media recovery
262 HIGH OPEN 2025-10-01 16:49:05 One or more non-system datafiles are missing
RMAN> advise failure;
Database Role: PRIMARY
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------------- -------
9692 CRITICAL OPEN 2025-10-01 16:49:05 System datafile 1: '/u01/app/oracle/oradata/ORACLE19/system01.dbf' is missing
9689 CRITICAL OPEN 2025-10-01 16:49:04 Control file needs media recovery
262 HIGH OPEN 2025-10-01 16:49:05 One or more non-system datafiles are missing
analyzing automatic repair options; this may take some time
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=136 device type=DISK
analyzing automatic repair options complete
Mandatory Manual Actions
========================
no manual actions available
Optional Manual Actions
=======================
1. If you have the correct version of the control file, then shutdown the database and replace the old control file
2. If file /u01/app/oracle/oradata/ORACLE19/system01.dbf was unintentionally renamed or moved, restore it
3. If file /u01/app/oracle/oradata/ORACLE19/ts702idx_01.dbf was unintentionally renamed or moved, restore it
4. If file /u01/app/oracle/oradata/ORACLE19/sysaux01.dbf was unintentionally renamed or moved, restore it
5. If file /u01/app/oracle/oradata/ORACLE19/undotbs01.dbf was unintentionally renamed or moved, restore it
6. If file /u01/app/oracle/oradata/ORACLE19/ts702_01.dbf was unintentionally renamed or moved, restore it
7. If file /u01/app/oracle/oradata/ORACLE19/users01.dbf was unintentionally renamed or moved, restore it
8. If file /u01/app/oracle/oradata/ORACLE19/ts91.dbf was unintentionally renamed or moved, restore it
9. If file /u01/app/oracle/oradata/ORACLE19/deldel.dbf was unintentionally renamed or moved, restore it
10. If file /u01/app/oracle/oradata/ORACLE19/ts704idx_01.dbf was unintentionally renamed or moved, restore it
11. If file /u01/app/oracle/oradata/ORACLE19/ts704_01.dbf was unintentionally renamed or moved, restore it
12. If file /u01/app/oracle/oradata/ORACLE19/ts899.dbf was unintentionally renamed or moved, restore it
13. If file /u01/app/oracle/oradata/ORACLE19/ts709b.dbf was unintentionally renamed or moved, restore it
14. If file /u01/app/oracle/oradata/ORACLE19/undotbs07.dbf was unintentionally renamed or moved, restore it
15. If file /u01/app/oracle/oradata/ORACLE19/rman_tbs.dbf was unintentionally renamed or moved, restore it
Automated Repair Options
========================
Option Repair Description
------ ------------------
1 Perform incomplete database recovery
Strategy: The repair includes point-in-time recovery with some data loss
Repair script: /u01/app/oracle/diag/rdbms/oracle19/orcl19/hm/reco_1320983061.hm
RMAN> repair failure preview;
Strategy: The repair includes point-in-time recovery with some data loss
Repair script: /u01/app/oracle/diag/rdbms/oracle19/orcl19/hm/reco_1320983061.hm
contents of repair script:
# database point-in-time recovery until a missing log
restore database until scn 5959772;
recover database until scn 5959772;
alter database open resetlogs;
RMAN> repair failure;
Strategy: The repair includes point-in-time recovery with some data loss
Repair script: /u01/app/oracle/diag/rdbms/oracle19/orcl19/hm/reco_1320983061.hm
contents of repair script:
# database point-in-time recovery until a missing log
restore database until scn 5959772;
recover database until scn 5959772;
alter database open resetlogs;
Do you really want to execute the above repair (enter YES or NO)? yes
executing repair script
Starting restore at 2025-10-01 16:49:45
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/ORACLE19/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/ORACLE19/ts702idx_01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/ORACLE19/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/ORACLE19/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/ORACLE19/ts702_01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/ORACLE19/users01.dbf
channel ORA_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/ORACLE19/ts91.dbf
channel ORA_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/ORACLE19/deldel.dbf
channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/ORACLE19/ts704idx_01.dbf
channel ORA_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/ORACLE19/ts704_01.dbf
channel ORA_DISK_1: restoring datafile 00012 to /u01/app/oracle/oradata/ORACLE19/ts899.dbf
channel ORA_DISK_1: restoring datafile 00013 to /u01/app/oracle/oradata/ORACLE19/ts709b.dbf
channel ORA_DISK_1: restoring datafile 00014 to /u01/app/oracle/oradata/ORACLE19/undotbs07.dbf
channel ORA_DISK_1: restoring datafile 00015 to /u01/app/oracle/oradata/ORACLE19/rman_tbs.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/19c/db_1/dbs/5u4557gi_1_1
channel ORA_DISK_1: piece handle=/u01/app/oracle/product/19c/db_1/dbs/5u4557gi_1_1 tag=TAG20251001T161928
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 2025-10-01 16:49:49
Starting recover at 2025-10-01 16:49:49
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 2 is already on disk as file /u01/app/oracle/product/19c/db_1/dbs/arch1_2_1213373897.dbf
archived log for thread 1 with sequence 3 is already on disk as file /u01/app/oracle/product/19c/db_1/dbs/arch1_3_1213373897.dbf
archived log for thread 1 with sequence 4 is already on disk as file /u01/app/oracle/product/19c/db_1/dbs/arch1_4_1213373897.dbf
archived log for thread 1 with sequence 5 is already on disk as file /u01/app/oracle/product/19c/db_1/dbs/arch1_5_1213373897.dbf
archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_2_1213373897.dbf thread=1 sequence=2
archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_3_1213373897.dbf thread=1 sequence=3
archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_4_1213373897.dbf thread=1 sequence=4
archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_5_1213373897.dbf thread=1 sequence=5
media recovery complete, elapsed time: 00:00:01
Finished recover at 2025-10-01 16:49:50
Statement processed
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
repair failure complete
RMAN> backup database plus archivelog;
Starting backup at 2025-10-01 16:50:11
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=214 STAMP=1213375811
channel ORA_DISK_1: starting piece 1 at 2025-10-01 16:50:12
channel ORA_DISK_1: finished piece 1 at 2025-10-01 16:50:13
piece handle=/u01/app/oracle/product/19c/db_1/dbs/634559a4_1_1 tag=TAG20251001T165012 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=2 RECID=210 STAMP=1213373973
input archived log thread=1 sequence=3 RECID=211 STAMP=1213375759
input archived log thread=1 sequence=4 RECID=212 STAMP=1213375759
input archived log thread=1 sequence=5 RECID=213 STAMP=1213375759
channel ORA_DISK_1: starting piece 1 at 2025-10-01 16:50:13
channel ORA_DISK_1: finished piece 1 at 2025-10-01 16:50:14
piece handle=/u01/app/oracle/product/19c/db_1/dbs/644559a5_1_1 tag=TAG20251001T165012 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2025-10-01 16:50:14
Starting backup at 2025-10-01 16:50:14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORACLE19/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORACLE19/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORACLE19/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/ORACLE19/users01.dbf
input datafile file number=00014 name=/u01/app/oracle/oradata/ORACLE19/undotbs07.dbf
input datafile file number=00015 name=/u01/app/oracle/oradata/ORACLE19/rman_tbs.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ORACLE19/ts702idx_01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORACLE19/ts702_01.dbf
input datafile file number=00010 name=/u01/app/oracle/oradata/ORACLE19/ts704idx_01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/ORACLE19/ts704_01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/ORACLE19/deldel.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/ORACLE19/ts899.dbf
input datafile file number=00013 name=/u01/app/oracle/oradata/ORACLE19/ts709b.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/ORACLE19/ts91.dbf
channel ORA_DISK_1: starting piece 1 at 2025-10-01 16:50:15
channel ORA_DISK_1: finished piece 1 at 2025-10-01 16:50:18
piece handle=/u01/app/oracle/product/19c/db_1/dbs/654559a7_1_1 tag=TAG20251001T165014 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 2025-10-01 16:50:18
Starting backup at 2025-10-01 16:50:18
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=2 RECID=215 STAMP=1213375818
channel ORA_DISK_1: starting piece 1 at 2025-10-01 16:50:20
channel ORA_DISK_1: finished piece 1 at 2025-10-01 16:50:21
piece handle=/u01/app/oracle/product/19c/db_1/dbs/664559ac_1_1 tag=TAG20251001T165019 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2025-10-01 16:50:21
Starting Control File and SPFILE Autobackup at 2025-10-01 16:50:21
piece handle=/u01/app/oracle/product/19c/db_1/dbs/c-3392683987-20251001-13 comment=NONE
Finished Control File and SPFILE Autobackup at 2025-10-01 16:50:23
RMAN> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORACLE19/control01.ctl
/u01/app/oracle/oradata/ORACLE19/control02.ctl
RMAN> select name from v$logfile;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 10/01/2025 16:51:12
ORA-00904: "NAME": invalid identifier
RMAN> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORACLE19/redo03.log
/u01/app/oracle/oradata/ORACLE19/redo02.log
/u01/app/oracle/oradata/ORACLE19/redo01.log
/u01/app/oracle/oradata/ORACLE19/redo01b.log
/u01/app/oracle/oradata/ORACLE19/redo02b.log
/u01/app/oracle/oradata/ORACLE19/redo03b.log
RMAN> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORACLE19/control01.ctl
/u01/app/oracle/oradata/ORACLE19/control02.ct
|
|
