手工恢复控制文件
一、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进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
评论
筱悦星辰
1年前
评论
1当你找准方向不再犹豫，把脑中的想法转化为实际的行动，距离目标就已经近了一大步。早安！
1年前
1 评论
墨天轮福利君
3年前
评论
0您好，您的文章已入选墨力原创作者计划合格奖，10墨值奖励已经到账请查收！
❤️我们还会实时派发您的流量收益。
3年前
点赞 评论
相关阅读
【纯干货】Oracle 19C RU 19.27 发布，如何快速升级和安装？
Lucifer三思而后行
766次阅读
2025-04-18 14:18:38
Oracle RAC 一键安装翻车？手把手教你如何排错！
Lucifer三思而后行
649次阅读
2025-04-15 17:24:06
Oracle数据库一键巡检并生成HTML结果，免费脚本速来下载!
陈举超
575次阅读
2025-04-20 10:07:02
【ORACLE】你以为的真的是你以为的么?--ORA-38104: Columns referenced in the ON Clause cannot be updated
DarkAthena
526次阅读
2025-04-22 00:13:51
【活动】分享你的压箱底干货文档，三篇解锁进阶奖励！
墨天轮编辑部
521次阅读
2025-04-17 17:02:24
【ORACLE】记录一些ORACLE的merge into语句的BUG
DarkAthena
499次阅读
2025-04-22 00:20:37
一页概览：Oracle GoldenGate
甲骨文云技术
484次阅读
2025-04-30 12:17:56
火焰图--分析复杂SQL执行计划的利器
听见风的声音
449次阅读
2025-04-17 09:30:30
3月“墨力原创作者计划”获奖名单公布
墨天轮编辑部
381次阅读
2025-04-15 14:48:05
OR+DBLINK的关联SQL优化思路
布衣
374次阅读
2025-05-05 19:28:36
