手工恢复控制文件
一、bbed安装
cp *o $ORACLE_HOME/rdbms/lib/
cp *msb $ORACLE_HOME/rdbms/mesg/
cd $ORACLE_HOME/rdbms/lib/
make -f ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed
bbed
Password:
BBED: Release 2.0.0.0.0 - Limited Production on Tue Apr 12 19:49:05 2022
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED>
--默认密码为blockedit
1.1 配置
vi parameter.txt
blocksize=8192
listfile=filelist.txt
mode=edit
vi filelist.txt
7 /u01/app/oracle/oradata/EMDB/datafile/o1_mf_users_jszdpwqt_.dbf
4 /u01/app/oracle/oradata/EMDB/datafile/o1_mf_undotbs1_jszdpvo8_.dbf
1 /u01/app/oracle/oradata/EMDB/datafile/o1_mf_system_jszdo9hx_.dbf
3 /u01/app/oracle/oradata/EMDB/datafile/o1_mf_sysaux_jszdpdl4_.dbf
vi .bash_profile
alias bbed='bbed parfile=parameter.txt password=blockedit'
二、控制文件恢复
2.1、报错
SQL> shutdown immediate
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/EMDB/controlfile/o1_mf_jszdqwdl_.ctl'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1124072632 bytes
Fixed Size 8895672 bytes
Variable Size 369098752 bytes
Database Buffers 738197504 bytes
Redo Buffers 7880704 bytes
ORA-00205: error in identifying control file, check alert log for more info
2.2、alert日志报错
2022-04-12T20:58:19.617878+08:00
ORA-00210: ???????????
ORA-00202: ????: ''/u01/app/oracle/fast_recovery_area/EMDB/controlfile/o1_mf_jszdqwf0_.ctl''
ORA-27037: ????????
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ORA-00210: ???????????
ORA-00202: ????: ''/u01/app/oracle/oradata/EMDB/controlfile/o1_mf_jszdqwdl_.ctl''
ORA-27037: ????????
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ORA-205 signalled during: ALTER DATABASE MOUNT...
2022-04-12T20:58:19.632763+08:00
Errors in file /u01/app/oracle/diag/rdbms/emdb/emdb/trace/emdb_mz00_18731.trc:
ORA-00202: ????: ''/u01/app/oracle/oradata/EMDB/controlfile/o1_mf_jszdqwdl_.ctl''
ORA-27037: ????????
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2022-04-12T20:58:19.710021+08:00
Errors in file /u01/app/oracle/diag/rdbms/emdb/emdb/trace/emdb_mz00_18731.trc:
ORA-00202: ????: ''/u01/app/oracle/fast_recovery_area/EMDB/controlfile/o1_mf_jszdqwf0_.ctl''
ORA-27037: ????????
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ORA-00210: ???????????
ORA-00202: ????: ''/u01/app/oracle/oradata/EMDB/controlfile/o1_mf_jszdqwdl_.ctl''
ORA-27037: ????????
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
Checker run found 2 new persistent data failures
2.3、准备结构文件
alter database backup controlfile to trace as '/tmp/control.ora';--随便找个数据库执行
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '+DATA01/ORCL/ONLINELOG/group_1.262.1100737319' SIZE 200M BLOCKSIZE 512,
GROUP 2 '+DATA01/ORCL/ONLINELOG/group_2.263.1100737319' SIZE 200M BLOCKSIZE 512,
GROUP 3 '+DATA01/ORCL/ONLINELOG/group_3.266.1100737689' SIZE 200M BLOCKSIZE 512,
GROUP 4 '+DATA01/ORCL/ONLINELOG/group_4.267.1100737689' SIZE 200M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'+DATA01/ORCL/DATAFILE/system.257.1100737167',
'+DATA01/ORCL/DATAFILE/sysaux.258.1100737211',
'+DATA01/ORCL/DATAFILE/undotbs1.259.1100737237',
'+DATA01/ORCL/DATAFILE/undotbs2.265.1100737615',
'+DATA01/ORCL/DATAFILE/users.260.1100737237'
CHARACTER SET AL32UTF8
;
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS NOARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '+DATA01/ORCL/ONLINELOG/group_1.262.1100737319' SIZE 200M BLOCKSIZE 512,
GROUP 2 '+DATA01/ORCL/ONLINELOG/group_2.263.1100737319' SIZE 200M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'+DATA01/ORCL/DATAFILE/system.257.1100737167',
'+DATA01/ORCL/DATAFILE/sysaux.258.1100737211',
'+DATA01/ORCL/DATAFILE/undotbs1.259.1100737237',
'+DATA01/ORCL/DATAFILE/undotbs2.265.1100737615',
'+DATA01/ORCL/DATAFILE/users.260.1100737237'
CHARACTER SET AL32UTF8
;
2.3.1 、准备db_name
pfile、spfile、alert日志、数据文件有记录
[oracle@toshiba ~]$ bbed
BBED: Release 2.0.0.0.0 - Limited Production on Tue Apr 12 21:09:33 2022
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED> info
File# Name Size(blks)
----- ---- ----------
1 /u01/app/oracle/oradata/EMDB/datafile/o1_mf_system_jszdo9h 0
3 /u01/app/oracle/oradata/EMDB/datafile/o1_mf_sysaux_jszdpdl 0
4 /u01/app/oracle/oradata/EMDB/datafile/o1_mf_undotbs1_jszdp 0
7 /u01/app/oracle/oradata/EMDB/datafile/o1_mf_users_jszdpwqt 0
BBED> set file 1 block 1
FILE# 1
BLOCK# 1
BBED> map /v
File: /u01/app/oracle/oradata/EMDB/datafile/o1_mf_system_jszdo9hx_.dbf (1)
Block: 1 Dba:0x00400001
------------------------------------------------------------
Data File Header
struct kcvfh, 1272 bytes @0
struct kcvfhbfh, 20 bytes @0
struct kcvfhhdr, 76 bytes @20
ub4 kcvfhrdb @96
struct kcvfhcrs, 8 bytes @100
ub4 kcvfhcrt @108
ub4 kcvfhrlc @112
struct kcvfhrls, 8 bytes @116
ub4 kcvfhbti @124
struct kcvfhbsc, 8 bytes @128
ub2 kcvfhbth @136
ub2 kcvfhsta @138
struct kcvfhckp, 36 bytes @484
ub4 kcvfhcpc @140
ub4 kcvfhrts @144
ub4 kcvfhccc @148
struct kcvfhbcp, 36 bytes @152
ub4 kcvfhbhz @312
struct kcvfhxcd, 16 bytes @316
sword kcvfhtsn @332
ub2 kcvfhtln @336
text kcvfhtnm[30] @338
ub4 kcvfhrfn @368
struct kcvfhrfs, 8 bytes @372
ub4 kcvfhrft @380
struct kcvfhafs, 8 bytes @384
ub4 kcvfhbbc @392
ub4 kcvfhncb @396
ub4 kcvfhmcb @400
ub4 kcvfhlcb @404
ub4 kcvfhbcs @408
ub2 kcvfhofb @412
ub2 kcvfhnfb @414
ub4 kcvfhprc @416
struct kcvfhprs, 8 bytes @420
struct kcvfhprfs, 8 bytes @428
ub4 kcvfhtrt @444
ub4 tailchk @8188
BBED> p kcvfh
struct kcvfh, 1272 bytes @0
struct kcvfhbfh, 20 bytes @0
ub1 type_kcbh @0 0x0b
ub1 frmt_kcbh @1 0xa2
ub2 wrp2_kcbh @2 0x0000
ub4 rdba_kcbh @4 0x00400001
ub4 bas_kcbh @8 0x00000000
ub2 wrp_kcbh @12 0x0000
ub1 seq_kcbh @14 0x01
ub1 flg_kcbh @15 0x04 (KCBHFCKV)
ub2 chkval_kcbh @16 0x923f
ub2 spare3_kcbh @18 0x0000
struct kcvfhhdr, 76 bytes @20
ub4 kccfhswv @20 0x00000000
ub4 kccfhcvn @24 0x13000000
ub4 kccfhdbi @28 0x83aae4fc
text kccfhdbn[0] @32 E
text kccfhdbn[1] @33 M
text kccfhdbn[2] @34 D
text kccfhdbn[3] @35 B
text kccfhdbn[4] @36
text kccfhdbn[5] @37
text kccfhdbn[6] @38
text kccfhdbn[7] @39
ub4 kccfhcsq @40 0x00002360
ub4 kccfhfsz @44 0x002de100
s_blkz kccfhbsz @48 0x00
ub2 kccfhfno @52 0x0001
ub2 kccfhtyp @54 0x0003
ub4 kccfhacid @56 0x00000000
ub4 kccfhcks @60 0x00000000
text kccfhtag[0] @64
text kccfhtag[1] @65
text kccfhtag[2] @66
text kccfhtag[3] @67
text kccfhtag[4] @68
text kccfhtag[5] @69
text kccfhtag[6] @70
text kccfhtag[7] @71
text kccfhtag[8] @72
text kccfhtag[9] @73
text kccfhtag[10] @74
text kccfhtag[11] @75
text kccfhtag[12] @76
text kccfhtag[13] @77
text kccfhtag[14] @78
text kccfhtag[15] @79
text kccfhtag[16] @80
text kccfhtag[17] @81
text kccfhtag[18] @82
text kccfhtag[19] @83
text kccfhtag[20] @84
text kccfhtag[21] @85
text kccfhtag[22] @86
text kccfhtag[23] @87
text kccfhtag[24] @88
text kccfhtag[25] @89
text kccfhtag[26] @90
text kccfhtag[27] @91
text kccfhtag[28] @92
text kccfhtag[29] @93
text kccfhtag[30] @94
text kccfhtag[31] @95
ub4 kcvfhrdb @96 0x00400208
struct kcvfhcrs, 8 bytes @100
ub4 kscnbas @100 0x00000009
ub2 kscnwrp @104 0x8000
ub2 kscnwrp2 @106 0x0000
ub4 kcvfhcrt @108 0x3bf312a9
ub4 kcvfhrlc @112 0x40f1d47e
struct kcvfhrls, 8 bytes @116
ub4 kscnbas @116 0x001d4fd1
ub2 kscnwrp @120 0x8000
ub2 kscnwrp2 @122 0x0000
ub4 kcvfhbti @124 0x00000000
struct kcvfhbsc, 8 bytes @128
ub4 kscnbas @128 0x00000000
ub2 kscnwrp @132 0x0000
ub2 kscnwrp2 @134 0x0000
ub2 kcvfhbth @136 0x0000
ub2 kcvfhsta @138 0x2004 (KCVFHOFZ)
struct kcvfhckp, 36 bytes @484
struct kcvcpscn, 8 bytes @484
ub4 kscnbas @484 0x0051bdb4
ub2 kscnwrp @488 0x8000
ub2 kscnwrp2 @490 0x0000
ub4 kcvcptim @492 0x41aca907
ub2 kcvcpthr @496 0x0001
union u, 12 bytes @500
struct kcvcprba, 12 bytes @500
ub4 kcrbaseq @500 0x0000009e
ub4 kcrbabno @504 0x00001bae
ub2 kcrbabof @508 0x0010
ub1 kcvcpetb[0] @512 0x02
ub1 kcvcpetb[1] @513 0x00
ub1 kcvcpetb[2] @514 0x00
ub1 kcvcpetb[3] @515 0x00
ub1 kcvcpetb[4] @516 0x00
ub1 kcvcpetb[5] @517 0x00
ub1 kcvcpetb[6] @518 0x00
ub1 kcvcpetb[7] @519 0x00
ub4 kcvfhcpc @140 0x000000de
ub4 kcvfhrts @144 0x41aca307
ub4 kcvfhccc @148 0x000000dd
struct kcvfhbcp, 36 bytes @152
struct kcvcpscn, 8 bytes @152
ub4 kscnbas @152 0x00000000
ub2 kscnwrp @156 0x0000
ub2 kscnwrp2 @158 0x0000
ub4 kcvcptim @160 0x00000000
ub2 kcvcpthr @164 0x0000
union u, 12 bytes @168
struct kcvcprba, 12 bytes @168
ub4 kcrbaseq @168 0x00000000
ub4 kcrbabno @172 0x00000000
ub2 kcrbabof @176 0x0000
ub1 kcvcpetb[0] @180 0x00
ub1 kcvcpetb[1] @181 0x00
ub1 kcvcpetb[2] @182 0x00
ub1 kcvcpetb[3] @183 0x00
ub1 kcvcpetb[4] @184 0x00
ub1 kcvcpetb[5] @185 0x00
ub1 kcvcpetb[6] @186 0x00
ub1 kcvcpetb[7] @187 0x00
ub4 kcvfhbhz @312 0x00000000
struct kcvfhxcd, 16 bytes @316
ub4 space_kcvmxcd[0] @316 0x00000000
ub4 space_kcvmxcd[1] @320 0x00000000
ub4 space_kcvmxcd[2] @324 0x00000000
ub4 space_kcvmxcd[3] @328 0x00000000
sword kcvfhtsn @332 0
ub2 kcvfhtln @336 0x0006
text kcvfhtnm[0] @338 S
text kcvfhtnm[1] @339 Y
text kcvfhtnm[2] @340 S
text kcvfhtnm[3] @341 T
text kcvfhtnm[4] @342 E
text kcvfhtnm[5] @343 M
text kcvfhtnm[6] @344
text kcvfhtnm[7] @345
text kcvfhtnm[8] @346
text kcvfhtnm[9] @347
text kcvfhtnm[10] @348
text kcvfhtnm[11] @349
text kcvfhtnm[12] @350
text kcvfhtnm[13] @351
text kcvfhtnm[14] @352
text kcvfhtnm[15] @353
text kcvfhtnm[16] @354
text kcvfhtnm[17] @355
text kcvfhtnm[18] @356
text kcvfhtnm[19] @357
text kcvfhtnm[20] @358
text kcvfhtnm[21] @359
text kcvfhtnm[22] @360
text kcvfhtnm[23] @361
text kcvfhtnm[24] @362
text kcvfhtnm[25] @363
text kcvfhtnm[26] @364
text kcvfhtnm[27] @365
text kcvfhtnm[28] @366
text kcvfhtnm[29] @367
ub4 kcvfhrfn @368 0x00000001
struct kcvfhrfs, 8 bytes @372
ub4 kscnbas @372 0x00000000
ub2 kscnwrp @376 0x0000
ub2 kscnwrp2 @378 0x0000
ub4 kcvfhrft @380 0x00000000
struct kcvfhafs, 8 bytes @384
ub4 kscnbas @384 0x00000000
ub2 kscnwrp @388 0x0000
ub2 kscnwrp2 @390 0x0000
ub4 kcvfhbbc @392 0x00000000
ub4 kcvfhncb @396 0x00000000
ub4 kcvfhmcb @400 0x00000000
ub4 kcvfhlcb @404 0x00000000
ub4 kcvfhbcs @408 0x00000000
ub2 kcvfhofb @412 0x000a
ub2 kcvfhnfb @414 0x000a
ub4 kcvfhprc @416 0x3bf3129f
struct kcvfhprs, 8 bytes @420
ub4 kscnbas @420 0x00000001
ub2 kscnwrp @424 0x0000
ub2 kscnwrp2 @426 0x0000
struct kcvfhprfs, 8 bytes @428
ub4 kscnbas @428 0x00000000
ub2 kscnwrp @432 0x0000
ub2 kscnwrp2 @434 0x0000
ub4 kcvfhtrt @444 0x00000000
2.3.2、是否归档
检查alert日志
control_files = "/u01/app/oracle/oradata/EMDB/controlfile/o1_mf_jszdqwdl_.ctl"
control_files = "/u01/app/oracle/fast_recovery_area/EMDB/controlfile/o1_mf_jszdqwf0_.ctl"
db_block_size = 8192
compatible = "19.0.0"
db_create_file_dest = "/u01/app/oracle/oradata"
db_recovery_file_dest = "/u01/app/oracle/fast_recovery_area"
.... (PID:25360): Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST [krsd.c:18167]
LGWR (PID:25317): STARTING ARCH PROCESSES
2.3.3、字符集
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 12 22:34:02 2022
Version 19.9.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.0.0.0
SQL> select distinct dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) block# from props$;
FILE# BLOCK#
---------- ----------
1 1321
dd if=/u01/app/oracle/oradata/EMDB/datafile/o1_mf_system_jszdo9hx_.dbf of=/tmp/charset bs=8192 skip=1321 count=1
[oracle@toshiba trace]$ strings /tmp/charset
GLOBAL_DB_NAME
EMDB
Global database name,
DBTIMEZONE
00:00
DB time zone,
CON_VSN
27version number for the CDB or the Application Container<
DBTIMEZONE
00:00
DB time zone,
OLS_OID_STATUS
0&OLS OID Status used for Label Security,
NO_USERID_VERIFIER_SALT AC198494D2611286E6E4DF94A6FCE0F3,
WORKLOAD_REPLAY_MODE
bPREPARE implies external replay clients can connect; REPLAY implies workload replay is in progress,
WORKLOAD_CAPTURE_MODE
/CAPTURE implies workload capture is in progress,
EXPORT_VIEWS_VERSION
Export views revision #,
DEFAULT_PERMANENT_TABLESPACE
USERS$Name of default permanent tablespace,
MAX_PDB_SNAPSHOTS
8+maximum number of snapshots for a given PDB,
MAX_STRING_SIZE
STANDARD6MAX_STRING_SIZE parameter used for dictionary metadata,
DST_UPGRADE_STATE
NONE&State of Day Light Saving Time Upgrade,
DST_PRIMARY_TT_VERSION
32%Version of primary timezone data file,
DST_SECONDARY_TT_VERSION
0'Version of secondary timezone data file,
NLS_LANGUAGE
AMERICAN
Language,
NLS_TERRITORY
AMERICA Territory,
NLS_CURRENCY
Local currency,
NLS_ISO_CURRENCY
AMERICA
ISO currency,
NLS_NUMERIC_CHARACTERS
Numeric characters,
NLS_CHARACTERSET
AL32UTF8
Character set,
NLS_CALENDAR GREGORIAN
Calendar system,
NLS_DATE_FORMAT DD-MON-RR
Date format,
NLS_DATE_LANGUAGE
AMERICAN
Date language,
NLS_SORT
BINARY
Linguistic definition,
NLS_TIME_FORMAT
HH.MI.SSXFF AM
Time format,
NLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
Time stamp format,
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR
Time with timezone format,
NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR
Timestamp with timezone format,
NLS_DUAL_CURRENCY
Dual currency symbol,
NLS_COMP
BINARY
NLS comparison,
NLS_LENGTH_SEMANTICS
BYTE
NLS length semantics,
NLS_NCHAR_CONV_EXCP
FALSE
NLS conversion exception,
NLS_NCHAR_CHARACTERSET AL16UTF16
NCHAR Character set,
NLS_RDBMS_VERSION
19.0.0.0.0 RDBMS version for NLS parameters,
GLOBAL_DB_NAME
SEEDDATA
Global database name,
DICTIONARY_ENDIAN_TYPE
LITTLE"Endian type of the data dictionary,
DEFAULT_TBS_TYPE SMALLFILE
Default tablespace type<
DBTIMEZONE
-07:00
DB time zone,
TDE_MASTER_KEY_ID,
Flashback Timestamp TimeZone
GMT"Flashback timestamp created in GMT,
DEFAULT_TEMP_TABLESPACE
TEMP$Name of default temporary tablespace,
LOCAL_UNDO_ENABLED
TRUE
true if local undo is enabled,
DEFAULT_EDITION
ORA$BASE$Name of the database default edition,
DEFAULT_PERMANENT_TABLESPACE
SYSTEM$Name of default permanent tablespace,
DEFAULT_TEMP_TABLESPACE
SYSTEM$Name of default temporary tablespace,
DICT.BASE
2 dictionary base tables version #
2.4、重建控制文件
此处redo存在，选择NORESETLOGS
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "EMDB" NORESETLOGS ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/EMDB/onlinelog/o1_mf_1_jszdqyhj_.log' SIZE 200M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/EMDB/onlinelog/o1_mf_2_jszdqyjn_.log' SIZE 200M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/EMDB/onlinelog/o1_mf_3_jszdqylj_.log' SIZE 200M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/oradata/EMDB/datafile/o1_mf_users_jszdpwqt_.dbf',
'/u01/app/oracle/oradata/EMDB/datafile/o1_mf_undotbs1_jszdpvo8_.dbf',
'/u01/app/oracle/oradata/EMDB/datafile/o1_mf_system_jszdo9hx_.dbf',
'/u01/app/oracle/oradata/EMDB/datafile/o1_mf_sysaux_jszdpdl4_.dbf'
CHARACTER SET AL32UTF8
;
SQL> CREATE CONTROLFILE REUSE DATABASE "EMDB" NORESETLOGS ARCHIVELOG
2 MAXLOGFILES 192
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 1024
5 MAXINSTANCES 32
6 MAXLOGHISTORY 292
7 LOGFILE
8 GROUP 1 '/u01/app/oracle/oradata/EMDB/onlinelog/o1_mf_1_jszdqyhj_.log' SIZE 200M BLOCKSIZE 512,
9 GROUP 2 '/u01/app/oracle/oradata/EMDB/onlinelog/o1_mf_2_jszdqyjn_.log' SIZE 200M BLOCKSIZE 512,
10 GROUP 3 '/u01/app/oracle/oradata/EMDB/onlinelog/o1_mf_3_jszdqylj_.log' SIZE 200M BLOCKSIZE 512
11 -- STANDBY LOGFILE
12 DATAFILE
13 '/u01/app/oracle/oradata/EMDB/datafile/o1_mf_users_jszdpwqt_.dbf',
14 '/u01/app/oracle/oradata/EMDB/datafile/o1_mf_undotbs1_jszdpvo8_.dbf',
15 '/u01/app/oracle/oradata/EMDB/datafile/o1_mf_system_jszdo9hx_.dbf',
16 '/u01/app/oracle/oradata/EMDB/datafile/o1_mf_sysaux_jszdpdl4_.dbf'
17 CHARACTER SET AL32UTF8
18 ;
Control file created.
2.5、数据库恢复
alter database register physical logfile '/u01/app/oracle/fast_recovery_area/EMDB/archivelog/2022_04_12/o1_mf_1_158_k5c19nsp_.arc';
alter database register physical logfile '/u01/app/oracle/fast_recovery_area/EMDB/archivelog/2022_04_12/o1_mf_1_159_k5c19pdg_.arc';
rman target /
catalog start with '/u01/app/oracle/fast_recovery_area/EMDB/archivelog/2022_04_12/';
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 12 22:03:19 2022
Version 19.11.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0
SQL> alter database register physical logfile '/u01/app/oracle/fast_recovery_area/EMDB/archivelog/2022_04_12/o1_mf_1_158_k5c19nsp_.arc';
Database altered.
SQL> alter database register physical logfile '/u01/app/oracle/fast_recovery_area/EMDB/archivelog/2022_04_12/o1_mf_1_159_k5c19pdg_.arc';
Database altered.
SQL> recover database;
Media recovery complete.
SQL> alter system archive log all;
System altered.
SQL> alter database open;
Database altered.
SQL> alter tablespace temp add tempfile;
Tablespace altered.
最后修改时间：2022-04-12 22:10:13
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
