Last time I did Oracle RMAN stuff was 18 years ago, so please bear with me if I seems to have forgotten some very basic things.
(I am attaching this text in a more reader-friendly Word-doc version as well, sorry for the wall of text…)
A RMAN backup of our database was done, and the files sent over to us:
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Feb 3 05:40:33 2023
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: OPERA (DBID=2420327252)
RMAN> run
2> {
3> allocate channel c1 DEVICE TYPE DISK;
11> backup as compressed backupset database format '/u05/rman_backup/230113-002007/DB_%u_%d_%s_%T';
12> backup as compressed backupset archivelog all format='/u05/rman_backup/230113-002007/ARC_%u_%d_%s_%T';
13> backup current controlfile format '/u05/rman_backup/230113-002007/CF_%u_%d_%s_%T';
14> release channel c1;
22> }
23>
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=3050 device type=DISK
allocated channel: c2
channel c2: SID=3193 device type=DISK
allocated channel: c3
channel c3: SID=3338 device type=DISK
allocated channel: c4
channel c4: SID=3485 device type=DISK
allocated channel: c5
channel c5: SID=3629 device type=DISK
allocated channel: c6
channel c6: SID=3775 device type=DISK
allocated channel: c7
channel c7: SID=3916 device type=DISK
allocated channel: c8
channel c8: SID=4064 device type=DISK
Starting backup at 2023-02-03 05:41:08
channel c1: starting compressed full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00006 name=+ORADATA/finindx01.dbf
… log truncated by me for easier readability
piece handle=/u05/rman_backup/230113-002007/DB_co1jhmrv_OPERA_26008_20230203 tag=TAG20230203T054114 comment=NONE
channel c4: backup set complete, elapsed time: 02:45:30
Finished backup at 2023-02-03 08:26:50
Starting backup at 2023-02-03 08:27:02
skipping archived log of thread 2 with sequence 1235144; already backed up
channel c1: starting compressed archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1318639 RECID=517734 STAMP=1127784638
… log truncated by me for easier readability
input archived log thread=1 sequence=1318702 RECID=517839 STAMP=1127808937
… log truncated by me for easier readability
piece handle=/u05/rman_backup/230113-002007/ARC_d51ji0jf_OPERA_26021_20230203 tag=TAG20230203T082706 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:16
Finished backup at 2023-02-03 08:27:43
piece handle=/u05/rman_backup/230113-002007/CF_d71ji0kc_OPERA_26023_20230203 tag=TAG20230203T082756 comment=NONE
Starting Control File and SPFILE Autobackup at 2023-02-03 08:27:59
piece handle=+ORAFRA/operaeldgs/autobackup/2023_02_03/s_1127808937.3059.1127809681 comment=NONE
Finished Control File and SPFILE Autobackup at 2023-02-03 08:28:03
Recovery Manager complete.
I have understood when I restore the database that it is considered a STANDBY database, but my problem starts already when preparing RMAN to do the restore of the database.
I have installed an Oracle Linux Server where I have installed Oracle Database 19c. I am aware of that there could be some incompatibility problems since the backup was done of a Database 11g version, but I don’t anticipate that the restore itself will be a problem.
I have set the following environmental parameters:
ORACLE_UNQNAME=opera
ORACLE_SID=opera
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
PDB_NAME=opera
At first I don’t install any database on the Linux server as manuals state that it is not needed when restoring a RMAN backup.
I connect to RMAN with command:
rman TARGET / NOCATALOG
I set the DBID from the RMAN logfile:
set dbid 24203227252;
I encounter a problem here when trying to restore the SPFILE from the backup:
RMAN> RUN
2> {
3> ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/u05/RMAN/c_%F';
4> RESTORE SPFILE FROM AUTOBACKUP maxdays 40;
5> }
released channel: ORA_DISK_1
allocated channel: disk2
channel disk2: SID=870 device type=DISK
Starting restore at 06-MAR-23
channel disk2: AUTOBACKUP found: c-2420327252-20230203-00
channel disk2: restoring spfile from AUTOBACKUP c-2420327252-20230203-00
channel disk2: the AUTOBACKUP does not contain an SPFILE
released channel: disk2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/06/2023 13:50:04
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
RMAN>
I do not know why it says that the AUTOBACKUP does not contain a SPFILE.
I work around this by using DBCA and create the database ‘opera’ this way to get a SPFILE that I can create a PFILE from to examine the values and correct them as needed.
SQL> create pfile='/u05/rman_backup/pfileopera.txt' from spfile;
File created.
SQL>
I don’t see that I really need to change something right now, before the restore of the database:
opera.__data_transfer_cache_size=0
opera.__db_cache_size=17381195776
opera.__inmemory_ext_roarea=0
opera.__inmemory_ext_rwarea=0
opera.__java_pool_size=0
opera.__large_pool_size=201326592
opera.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
opera.__pga_aggregate_target=6710886400
opera.__sga_target=20065550336
opera.__shared_io_pool_size=134217728
opera.__shared_pool_size=2281701376
opera.__streams_pool_size=0
opera.__unified_pga_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/opera/adump'
*.audit_trail='db'
*.compatible='19.0.0'
*.control_files='/u05/Database/OPERA/controlfile/o1_mf_l108g5vv_.ctl','/u05/Database/FRA/OPERA/controlfile/o1_mf_l108g5ws_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/u05/Database'
*.db_name='opera'
*.db_recovery_file_dest='/u05/Database/FRA'
*.db_recovery_file_dest_size=8256m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=operaXDB)'
*.open_cursors=300
*.pga_aggregate_target=6371m
*.processes=1920
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=19110m
*.undo_tablespace='UNDOTBS1'
Next step is to restore the controlfile from RMAN backup.
RMAN> restore controlfile from '/u05/rman_backup/230113-002007/CF_d71ji0kc_OPERA_26023_20230203';
Starting restore at 14-MAR-23
using channel ORA_DISK_1
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u05/Database/OPERA/controlfile/o1_mf_l108g5vv_.ctl
output file name=/u05/Database/FRA/OPERA/controlfile/o1_mf_l108g5ws_.ctl
Finished restore at 14-MAR-23
RMAN>
With the new controlfiles in place, I query the database and see that it has these filepaths:
File/Grp# NAME
---------- ------------------------------------------------------------1
1 +ORADATA/systemlin01.dbf
1 +ORAREDO/redo01_01
1 +ORAREDO/redo01_02
2 +ORADATA/undotbslin01.dbf
2 +ORAREDO/redo02_01
2 +ORAREDO/redo02_02
3 +ORADATA/sysaux01.dbf
3 +ORAREDO/redo03_01
3 +ORAREDO/redo03_02
4 +ORADATA/findata01.dbf
4 +ORAREDO/redo04_01
4 +ORAREDO/redo04_02
5 +ORADATA/findata02.dbf
5 +ORAREDO/redo05_01
5 +ORAREDO/redo05_02
6 +ORADATA/finindx01.dbf
6 +ORAREDO/redo06_01
6 +ORAREDO/redo06_02
7 +ORADATA/finindx02.dbf
7 +ORAREDO/redo07_01
7 +ORAREDO/redo07_02
8 +ORADATA/logdata01.dbf
8 +ORAREDO/redo08_01
8 +ORAREDO/redo08_02
9 +ORADATA/logdata02.dbf
9 +ORAREDO/redo09_01
9 +ORAREDO/redo09_02
10 +ORADATA/logindx01.dbf
10 +ORAREDO/redo10_01
10 +ORAREDO/redo10_02
11 +ORADATA/logindx02.dbf
11 +ORAREDO/redo11_01
11 +ORAREDO/redo11_02
12 +ORADATA/namedata01.dbf
12 +ORAREDO/redo12_01
12 +ORAREDO/redo12_02
13 +ORADATA/namedata02.dbf
13 +ORAREDO/redo13_01
13 +ORAREDO/redo13_02
14 +ORADATA/nameindx01.dbf
14 +ORAREDO/redo14_01
14 +ORAREDO/redo14_02
15 +ORADATA/nameindx02.dbf
15 +ORAREDO/redo15_01
15 +ORAREDO/redo15_02
16 +ORADATA/opera_data01.dbf
16 +ORAREDO/redo16_01
16 +ORAREDO/redo16_02
17 +ORADATA/opera_data02.dbf
17 +ORAREDO/redo17_01
17 +ORAREDO/redo17_02
18 +ORADATA/opera_indx01.dbf
18 +ORAREDO/redo18_01
18 +ORAREDO/redo18_02
19 +ORADATA/opera_indx02.dbf
19 +ORAREDO/redo19_01
19 +ORAREDO/redo19_02
20 +ORADATA/oxi_data01.dbf
20 +ORAREDO/redo20_01
20 +ORAREDO/redo20_02
21 +ORADATA/oxi_data02.dbf
21 +ORAREDO/srl21
22 +ORADATA/quickdata01.dbf
22 +ORAREDO/srl22
23 +ORADATA/quickdata02.dbf
23 +ORAREDO/srl23
24 +ORADATA/quickindx01.dbf
24 +ORAREDO/srl24
25 +ORADATA/quickindx02.dbf
25 +ORAREDO/srl25
26 +ORADATA/ratedata01.dbf
26 +ORAREDO/srl26
27 +ORADATA/ratedata02.dbf
27 +ORAREDO/srl27
28 +ORADATA/rateindx01.dbf
28 +ORAREDO/srl28
29 +ORADATA/rateindx02.dbf
29 +ORAREDO/srl29
30 +ORADATA/resvdata01.dbf
30 +ORAREDO/srl30
31 +ORADATA/resvdata02.dbf
31 +ORAREDO/srl31
32 +ORADATA/resvindx01.dbf
32 +ORAREDO/srl32
33 +ORADATA/resvindx02.dbf
33 +ORAREDO/srl33
34 +ORADATA/tools01.dbf
34 +ORAREDO/srl34
35 +ORADATA/oxi_indx01.dbf
35 +ORAREDO/srl35
36 +ORADATA/oxi_indx02.dbf
36 +ORAREDO/srl36
37 +ORADATA/opera_indx03.dbf
37 +ORAREDO/srl37
38 +ORADATA/opera_data03.dbf
38 +ORAREDO/srl38
39 +ORADATA/undotbslin02.dbf
39 +ORAREDO/srl39
40 +ORADATA/attachments01
40 +ORAREDO/srl40
41 +ORADATA/attachments02
41 +ORAREDO/srl41
42 +ORADATA/opera_data04.dbf
43 +ORADATA/opera_data05.dbf
44 +ORADATA/opera_data06.dbf
45 +ORADATA/finindx03.dbf
46 +ORADATA/opera_data07.dbf
47 +ORADATA/opera_data08.dbf
48 +ORADATA/opera_data09.dbf
49 +ORADATA/logindx03.dbf
50 +ORADATA/opera_data10.dbf
51 +ORADATA/logdata03.dbf
52 +ORADATA/opera_data11.dbf
53 +ORADATA/finindx04.dbf
54 +ORADATA/opera_data12.dbf
55 +ORADATA/quickindx03.dbf
56 +ORADATA/opera_indx04.dbf
57 +ORADATA/opera_data13.dbf
58 +ORADATA/opera_data14.dbf
59 +ORADATA/opera_data15.dbf
60 +ORADATA/findata03.dbf
61 +ORADATA/opera_data16.dbf
62 +ORADATA/opera_data17.dbf
63 +ORADATA/finindx05.dbf
64 +ORADATA/logindx04.dbf
65 +ORADATA/opera_data18.dbf
66 +ORADATA/sysaux02.dbf
67 +ORADATA/opera_data19.dbf
68 +ORADATA/opera_data20.dbf
69 +ORADATA/opera_data21.dbf
70 +ORADATA/opera_data22.dbf
71 +ORADATA/opera_data23.dbf
72 +ORADATA/opera_indx05.dbf
73 +ORADATA/quickdata03.dbf
74 +ORADATA/systemlin02.dbf
75 +ORADATA/finindx06.dbf
76 +ORADATA/logdata04.dbf
77 +ORADATA/logindx5.dbf
78 +ORADATA/finindx07
79 +ORADATA/opera_data24.dbf
80 +ORADATA/opera_data25.dbf
81 +ORADATA/findata04.dbf
82 +ORADATA/logdata05.dbf
83 +ORADATA/operaeldgs/datafile/tools.343.961925705
84 +ORADATA/operaeldgs/datafile/opera_indx.344.961926937
85 +ORADATA/operaeldgs/datafile/findata.345.961927173
86 +ORADATA/finindx08
87 +ORADATA/opera_data26.dbf
88 +ORADATA/opera_data27.dbf
89 +ORADATA/opera_data28.dbf
90 +ORADATA/opera_data29.dbf
91 +ORADATA/operaeldgs/datafile/undotbs2.351.984091189
92 +ORADATA/operaeldgs/datafile/finindx.352.984093373
93 +ORADATA/ohrcadmin01.dbf
94 +ORADATA/logindx06.dbf
95 +ORADATA/operaeldgs/datafile/opera_data.354.1022493497
96 +ORADATA/operaeldgs/datafile/opera_data.355.1022493563
97 +ORADATA/operaeldgs/datafile/opera_data.356.1022498373
98 +ORADATA/operaeldgs/datafile/opera_indx.357.1022498469
99 +ORADATA/operaeldgs/datafile/opera_indx.358.1022498859
100 +ORADATA/resvindx03.dbf
101 +ORADATA/operaeldgs/datafile/quickindx.360.1035985195
102 +ORADATA/operaeldgs/datafile/undotbs1.361.1047214935
103 +ORADATA/operaeldgs/datafile/undotbs1.362.1049899513
104 +ORADATA/operaeldgs/datafile/undotbs2.363.1049899561
105 +ORADATA/oxi_data03.dbf
106 +ORADATA/oxi_data04.dbf
107 +ORADATA/oxi_data05.dbf
108 +ORADATA/oxi_data06.dbf
109 +ORADATA/logindx07.dbf
110 +ORADATA/logdata06.dbf
111 +ORADATA/oxi_data07.dbf
112 +ORADATA/finindx09
173 rows selected.
I change the location of redo-logs first.
ALTER DATABASE RENAME FILE '+ORAREDO/redo10_01' TO '/u05/Database/OPERA/onlinelog/redo10_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo10_02' TO '/u05/Database/OPERA/onlinelog/redo10_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo09_01' TO '/u05/Database/OPERA/onlinelog/redo09_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo09_02' TO '/u05/Database/OPERA/onlinelog/redo09_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo08_01' TO '/u05/Database/OPERA/onlinelog/redo08_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo08_02' TO '/u05/Database/OPERA/onlinelog/redo08_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo07_01' TO '/u05/Database/OPERA/onlinelog/redo07_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo07_02' TO '/u05/Database/OPERA/onlinelog/redo07_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo06_01' TO '/u05/Database/OPERA/onlinelog/redo06_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo06_02' TO '/u05/Database/OPERA/onlinelog/redo06_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo05_01' TO '/u05/Database/OPERA/onlinelog/redo05_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo05_02' TO '/u05/Database/OPERA/onlinelog/redo05_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo04_01' TO '/u05/Database/OPERA/onlinelog/redo04_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo04_02' TO '/u05/Database/OPERA/onlinelog/redo04_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo03_01' TO '/u05/Database/OPERA/onlinelog/redo03_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo03_02' TO '/u05/Database/OPERA/onlinelog/redo03_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo02_01' TO '/u05/Database/OPERA/onlinelog/redo02_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo02_02' TO '/u05/Database/OPERA/onlinelog/redo02_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo01_01' TO '/u05/Database/OPERA/onlinelog/redo01_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo01_02' TO '/u05/Database/OPERA/onlinelog/redo01_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo11_01' TO '/u05/Database/OPERA/onlinelog/redo11_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo11_02' TO '/u05/Database/OPERA/onlinelog/redo11_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo12_01' TO '/u05/Database/OPERA/onlinelog/redo12_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo12_02' TO '/u05/Database/OPERA/onlinelog/redo12_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo13_01' TO '/u05/Database/OPERA/onlinelog/redo13_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo13_02' TO '/u05/Database/OPERA/onlinelog/redo13_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo14_01' TO '/u05/Database/OPERA/onlinelog/redo14_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo14_02' TO '/u05/Database/OPERA/onlinelog/redo14_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo15_01' TO '/u05/Database/OPERA/onlinelog/redo15_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo15_02' TO '/u05/Database/OPERA/onlinelog/redo15_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo16_01' TO '/u05/Database/OPERA/onlinelog/redo16_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo16_02' TO '/u05/Database/OPERA/onlinelog/redo16_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo17_01' TO '/u05/Database/OPERA/onlinelog/redo17_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo17_02' TO '/u05/Database/OPERA/onlinelog/redo17_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo18_01' TO '/u05/Database/OPERA/onlinelog/redo18_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo18_02' TO '/u05/Database/OPERA/onlinelog/redo18_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo19_01' TO '/u05/Database/OPERA/onlinelog/redo19_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo19_02' TO '/u05/Database/OPERA/onlinelog/redo19_02';
ALTER DATABASE RENAME FILE '+ORAREDO/redo20_01' TO '/u05/Database/OPERA/onlinelog/redo20_01';
ALTER DATABASE RENAME FILE '+ORAREDO/redo20_02' TO '/u05/Database/OPERA/onlinelog/redo20_02';
ALTER DATABASE RENAME FILE '+ORAREDO/srl21' TO '/u05/Database/OPERA/onlinelog/srl21';
ALTER DATABASE RENAME FILE '+ORAREDO/srl22' TO '/u05/Database/OPERA/onlinelog/srl22';
ALTER DATABASE RENAME FILE '+ORAREDO/srl23' TO '/u05/Database/OPERA/onlinelog/srl23';
ALTER DATABASE RENAME FILE '+ORAREDO/srl24' TO '/u05/Database/OPERA/onlinelog/srl24';
ALTER DATABASE RENAME FILE '+ORAREDO/srl25' TO '/u05/Database/OPERA/onlinelog/srl25';
ALTER DATABASE RENAME FILE '+ORAREDO/srl26' TO '/u05/Database/OPERA/onlinelog/srl26';
ALTER DATABASE RENAME FILE '+ORAREDO/srl27' TO '/u05/Database/OPERA/onlinelog/srl27';
ALTER DATABASE RENAME FILE '+ORAREDO/srl28' TO '/u05/Database/OPERA/onlinelog/srl28';
ALTER DATABASE RENAME FILE '+ORAREDO/srl29' TO '/u05/Database/OPERA/onlinelog/srl29';
ALTER DATABASE RENAME FILE '+ORAREDO/srl30' TO '/u05/Database/OPERA/onlinelog/srl30';
ALTER DATABASE RENAME FILE '+ORAREDO/srl31' TO '/u05/Database/OPERA/onlinelog/srl31';
ALTER DATABASE RENAME FILE '+ORAREDO/srl32' TO '/u05/Database/OPERA/onlinelog/srl32';
ALTER DATABASE RENAME FILE '+ORAREDO/srl33' TO '/u05/Database/OPERA/onlinelog/srl33';
ALTER DATABASE RENAME FILE '+ORAREDO/srl34' TO '/u05/Database/OPERA/onlinelog/srl34';
ALTER DATABASE RENAME FILE '+ORAREDO/srl35' TO '/u05/Database/OPERA/onlinelog/srl35';
ALTER DATABASE RENAME FILE '+ORAREDO/srl36' TO '/u05/Database/OPERA/onlinelog/srl36';
ALTER DATABASE RENAME FILE '+ORAREDO/srl37' TO '/u05/Database/OPERA/onlinelog/srl37';
ALTER DATABASE RENAME FILE '+ORAREDO/srl38' TO '/u05/Database/OPERA/onlinelog/srl38';
ALTER DATABASE RENAME FILE '+ORAREDO/srl39' TO '/u05/Database/OPERA/onlinelog/srl39';
ALTER DATABASE RENAME FILE '+ORAREDO/srl40' TO '/u05/Database/OPERA/onlinelog/srl40';
ALTER DATABASE RENAME FILE '+ORAREDO/srl41' TO '/u05/Database/OPERA/onlinelog/srl41';
First problem that I am not sure on how to fix:
ALTER DATABASE RENAME FILE '+ORAREDO/srl22' TO '/u05/Database/OPERA/onlinelog/srl22'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-00261: log 22 of thread 1 is being archived or modified
ORA-00312: online log 22 thread 1: '+ORAREDO/srl22'
And:
ALTER DATABASE RENAME FILE '+ORAREDO/srl32' TO '/u05/Database/OPERA/onlinelog/srl32'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-00261: log 32 of thread 2 is being archived or modified
ORA-00312: online log 32 thread 2: '+ORAREDO/srl32'
What is the correct way to continue here? I have during my attempts used the arguments:
Alter database clear logfile group 22, group 32;
This gives this response:
SQL> Alter database clear logfile group 22, group 32;
Alter database clear logfile group 22, group 32
*
ERROR at line 1:
ORA-00349: failure obtaining block size for '+ORAREDO/srl22'
ORA-29701: unable to connect to Cluster Synchronization Service
ORA-29701: unable to connect to Cluster Synchronization Service
ORA-29701: unable to connect to Cluster Synchronization Service
I am not sure if this query even indicates that the logfile 22 and 32 is even active:
SQL> select GROUP#,THREAD#,SEQUENCE#,MEMBERS,ARCHIVED,STATUS,FIRST_CHANGE# from v$log order by first_change# ;
GROUP# THREAD# SEQUENCE# MEMBERS ARC STATUS FIRST_CHANGE#
---------- ---------- ---------- ---------- --- ---------------- -------------
19 2 1235179 2 YES CLEARING 1.1165E+11
4 1 1318694 2 YES CLEARING 1.1165E+11
20 2 1235180 2 YES CLEARING 1.1165E+11
11 2 1235181 2 YES CLEARING 1.1165E+11
5 1 1318695 2 YES CLEARING 1.1165E+11
12 2 1235182 2 YES CLEARING 1.1165E+11
6 1 1318696 2 YES CLEARING 1.1165E+11
7 1 1318697 2 YES CLEARING 1.1165E+11
13 2 1235183 2 YES CLEARING 1.1165E+11
8 1 1318698 2 YES CLEARING 1.1165E+11
14 2 1235184 2 YES CLEARING 1.1165E+11
GROUP# THREAD# SEQUENCE# MEMBERS ARC STATUS FIRST_CHANGE#
---------- ---------- ---------- ---------- --- ---------------- -------------
9 1 1318699 2 YES CLEARING 1.1165E+11
15 2 1235185 2 YES CLEARING 1.1165E+11
10 1 1318700 2 YES CLEARING 1.1165E+11
16 2 1235186 2 YES CLEARING 1.1165E+11
1 1 1318701 2 YES CLEARING 1.1165E+11
2 1 1318702 2 YES CLEARING 1.1165E+11
17 2 1235187 2 YES CLEARING 1.1165E+11
3 1 1318703 2 YES CURRENT 1.1165E+11
18 2 1235188 2 YES CURRENT 1.1165E+11
20 rows selected.
I have tried to use:
Alter database drop logfile group 22, group 32;
This works at this stage, but it feels like when I recover the database in the later stage of restoring the RMAN database, data will be inconsistent and it’s related to the data stored in srl22 and srl32. So, would this be the right thing to do at this stage?
What is best practice to do in this case with those two redo files that wont be renamed?
Restore RMAN database.docx