# 步骤1：启动RMAN
$ rman target /# 步骤2：启动数据库到NOMOUNT状态
RMAN> startup nomount;# 步骤3：从备份恢复控制文件
RMAN> restore controlfile from autobackup;# 步骤4：启动数据库到MOUNT状态
RMAN> alter database mount;# 步骤5：恢复数据库
RMAN> restore database;RMAN> recover database;# 步骤6：打开数据库
RMAN> alter database open;

# 启动数据库到MOUNT状态
SQL> startup mount;# 执行完全恢复
RMAN> recover database;# 打开数据库
SQL> alter database open;

# 将损坏的数据文件置为OFFLINE
SQL> alter database datafile ‘/oradata/fgedudb/users01.dbf’ offline immediate;# 恢复数据文件
RMAN> restore datafile ‘/oradata/fgedudb/users01.dbf’;RMAN> recover datafile ‘/oradata/fgedudb/users01.dbf’;# 将数据文件置为ONLINE
SQL> alter database datafile ‘/oradata/fgedudb/users01.dbf’ online;

# 启动数据库到NOMOUNT状态
SQL> startup nomount;# 从自动备份恢复控制文件
RMAN> restore controlfile from autobackup;# 启动数据库到MOUNT状态
SQL> alter database mount;# 恢复数据库
RMAN> restore database;RMAN> recover database;# 打开数据库
SQL> alter database open;

# 检查数据库状态
SQL> select status from v$instance;STATUS
————
OPEN

# 检查所有数据文件状态
SQL> select file_name, status from dba_data_files;FILE_NAME STATUS
—————————————— ———
/oradata/fgedudb/system01.dbf AVAILABLE
/oradata/fgedudb/sysaux01.dbf AVAILABLE
/oradata/fgedudb/undotbs01.dbf AVAILABLE
/oradata/fgedudb/users01.dbf AVAILABLE

# 检查所有表空间状态
SQL> select tablespace_name, status from dba_tablespaces;TABLESPACE_NAME STATUS
—————————— ———
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
USERS ONLINE

# 检查数据库一致性
SQL> select name, open_mode, database_status from v$database;NAME OPEN_MODE DATABASE_STATUS
——— ——————– —————–
FGEDUDB READ WRITE ACTIVE

# 运行DBVERIFY验证数据文件
$ dbv file=/oradata/fgedudb/users01.dbf

DBVERIFY: Release 19.0.0.0.0 – Production on Thu Mar 31 10:00:00 2026
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

DBVERIFY – Verification starting : FILE = /oradata/fgedudb/users01.dbf
DBVERIFY – Verification complete

Total Pages Examined : 12800
Total Pages Processed (Data) : 3560
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 1240
Total Pages Failing (Index): 0
Total Pages Processed (Other): 8000
Total Pages Failing (Other): 0
Total Pages Empty : 0
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 1234567 (0.1234567)

# 步骤1：启动RMAN
$ rman target /# 步骤2：启动数据库到MOUNT状态
RMAN> startup mount;# 步骤3：执行完全恢复
RMAN> recover database;# 步骤4：打开数据库
RMAN> alter database open;# 步骤5：验证数据库状态
RMAN> select status from v$instance;STATUS
————
OPEN

# 步骤6：验证数据完整性
SQL> select count(*) from fgedu.employees;COUNT(*)
———-
1000

# 步骤1：连接到数据库
$ sqlplus / as sysdba

# 步骤2：将损坏的数据文件置为OFFLINE
SQL> alter database datafile ‘/oradata/fgedudb/users01.dbf’ offline immediate;# 步骤3：启动RMAN
$ rman target /# 步骤4：恢复数据文件
RMAN> restore datafile ‘/oradata/fgedudb/users01.dbf’;RMAN> recover datafile ‘/oradata/fgedudb/users01.dbf’;# 步骤5：将数据文件置为ONLINE
SQL> alter database datafile ‘/oradata/fgedudb/users01.dbf’ online;# 步骤6：验证数据文件状态
SQL> select file_name, status from dba_data_files where file_name=’/oradata/fgedudb/users01.dbf’;FILE_NAME STATUS
—————————————— ———
/oradata/fgedudb/users01.dbf AVAILABLE

# 步骤7：验证数据
SQL> select count(*) from fgedu.employees;COUNT(*)
———-
1000

# 步骤1：启动数据库到NOMOUNT状态
$ sqlplus / as sysdba
SQL> startup nomount;# 步骤2：启动RMAN
$ rman target /# 步骤3：从自动备份恢复控制文件
RMAN> restore controlfile from autobackup;# 步骤4：启动数据库到MOUNT状态
RMAN> alter database mount;# 步骤5：恢复数据库
RMAN> restore database;RMAN> recover database;# 步骤6：打开数据库
RMAN> alter database open;# 步骤7：验证数据库状态
RMAN> select status from v$instance;STATUS
————
OPEN

# 步骤8：验证控制文件状态
SQL> select name from v$controlfile;NAME
—————————————-
/oradata/fgedudb/control01.ctl
/oradata/fgedudb/control02.ctl