ORA-01180 ORA-01110

最新推荐文章于 2023-12-25 18:29:41 发布

原创最新推荐文章于 2023-12-25 18:29:41 发布 · 4.7k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#optimization #database #parameters #file #disk #command

oracle 专栏收录该内容

53 篇文章

订阅专栏

在尝试使用RMAN进行数据库恢复时遇到错误ORA-01180和ORA-01110，问题出在创建datafile时。通过`list backup of database`命令发现备份集已过期。进一步检查RMAN配置参数显示保留策略为1天冗余，因此需要重新备份数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在进行rman恢复的时候总是报：

creating datafile file number=1 name=/home/oracle/app/oradata/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/09/2012 23:52:43
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/home/oracle/app/oradata/system01.dbf'

RMAN> list backup of database;

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 941.66M DISK 00:00:38 09-MAY-12
BP Key: 1 Status: EXPIRED Compressed: NO Tag: TAG20120509T015050
Piece Name: /home/oracle/rman/ORAL1_1_2012_05
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 802988 09-MAY-12 /home/oracle/app/oradata/system01.dbf
2 Full 802988 09-MAY-12 /home/oracle/app/oradata/sysaux01.dbf
3 Full 802988 09-MAY-12 /home/oracle/app/oradata/undotbs01.dbf
4 Full 802988 09-MAY-12 /home/oracle/app/oradata/users01.dbf

使用这个才发现备份文件已经过期了，到原库上查询备份文件的时间窗口
RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORAL1 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
发现只有1天，只好从新备份了