主页 / dba / 问题 / 318838
Accepted
József Kökény
Asked: 2022-10-28 06:48:14 +0800 CST

恢复已删除的重做日志文件

  • 772

我有以下问题：Oracle 19C 数据库中的所有重做日志文件在数据库运行时已被删除。该数据库在 Linux 服务器上运行。当我尝试连接到数据库时，会显示错误 ORA-12514（“TNS：侦听器当前不知道连接描述符中请求的服务”）。如何恢复数据库？

oracle

1 个回答

  1. Best Answer

    您将需要从 RMAN 备份中恢复。恢复过程将重新创建在线重做日志。例如，请参见此处：https ://oracledbwr.com/oracle-19c-recover-a-loss-of-all-online-redo-log-files-using-rman/

    $ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jun 19 11:56:52 2019
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> shut immediate 
Database closed.
Database dismounted.
ORACLE instance shut down.

$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 20 00:41:38 2019
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 2415917880 bytes
Fixed Size            8899384 bytes
Variable Size       520093696 bytes
Database Buffers   1879048192 bytes
Redo Buffers          7876608 bytes
Database mounted.
SQL>

... Connect to RMAN and recover until the available sequence...

RMAN> run
2> {
3> restore database;
4> recover database;
5> alter database open resetlogs;
6> }
    • 1

相关问题