rman备份恢复到异机报ORA-01110 ORA-01180错误
[Oracle@server1 ORACLE]$ rman target /
Recovery Manager: Release 10.2.0.5.0 - Production on Thu Jul 31 13:51:40 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database (not started)
RMAN> set dbid 1619708557
executing command: SET DBID
RMAN> startup nomount
Oracle instance started
Total System Global Area 8388608000 bytes
Fixed Size 2109640 bytes
Variable Size 5117054776 bytes
Database Buffers 3221225472 bytes
Redo Buffers 48218112 bytes
RMAN> restore controlfile from '/home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854376584_9xmsr8fm_.bkp';
Starting restore at 31-JUL-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1084 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output filename=/home/oracle/orabase/oradata/ORACLE/control01.ctl
output filename=/home/oracle/orabase/oradata/ORACLE/control02.ctl
output filename=/home/oracle/orabase/oradata/ORACLE/control03.ctl
Finished restore at 31-JUL-14
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
--------------------------------------------------------------------------------
RMAN 配置归档日志删除策略
Oracle基础教程之通过RMAN复制数据库
RMAN备份策略制定参考内容
RMAN备份学习笔记
Oracle数据库备份加密 RMAN加密
Linux-6-64下安装Oracle 12C笔记
在CentOS 6.4下安装Oracle 11gR2(x64)
Oracle 11gR2 在VMWare虚拟机中安装步骤
Debian 下 安装 Oracle 11g XE R2
--------------------------------------------------------------------------------
RMAN> restore database;
启动 restore 于 31-7月-14
使用通道 ORA_DISK_1
创建数据文件 fno = 1 名称 = /home/oracle/orabase/oradata/ORACLE/system01.dbf
MAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: restore 命令 (在 07/31/2014 12:06:00 上) 失败
ORA-01180: 无法创建数据文件 1
ORA-01110: 数据文件 1: '/home/oracle/orabase/oradata/ORACLE/system01.dbf'
RMAN>
RMAN> crosscheck backupset;
Starting implicit crosscheck backup at 31-JUL-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1084 devtype=DISK
Crosschecked 10 objects
Finished implicit crosscheck backup at 31-JUL-14
Starting implicit crosscheck copy at 31-JUL-14
using channel ORA_DISK_1
Finished implicit crosscheck copy at 31-JUL-14
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /home/oracle/orabase/flash_recovery_area/ORACLE/archivelog/2014_07_31/o1_mf_1_116_9xm5yprp_.arc
File Name: /home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/fulldb_nvpeiou9_1_1.bak recid=3836 stamp=854156234
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/arch_o0peir6m_1_1.bak recid=3837 stamp=854158551
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o2peld7e_1_1.bak recid=3839 stamp=854242543
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/fulldb_o3peldbg_1_1.bak recid=3840 stamp=854242673
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o4pelfhd_1_1.bak recid=3841 stamp=854244910
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak recid=3843 stamp=854328882
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak recid=3844 stamp=854329003
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak recid=3845 stamp=854331139
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp recid=3846
stamp=854373190
Crosschecked 9 objects
由于备份集过期导致无法还原数据库，重新注册备份片。
RMAN> catalog backuppiece '/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak';
cataloged backuppiece
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak recid=3847 stamp=854373756
RMAN> catalog backuppiece '/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak';
cataloged backuppiece
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak recid=3848 stamp=854373783
RMAN> catalog backuppiece '/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak';
cataloged backuppiece
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak recid=3849 stamp=854373809
注册成功之后再次查看
RMAN> crosscheck backupset;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1087 devtype=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/fulldb_nvpeiou9_1_1.bak recid=3836 stamp=854156234
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/arch_o0peir6m_1_1.bak recid=3837 stamp=854158551
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o2peld7e_1_1.bak recid=3839 stamp=854242543
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/fulldb_o3peldbg_1_1.bak recid=3840 stamp=854242673
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o4pelfhd_1_1.bak recid=3841 stamp=854244910
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak recid=3847 stamp=854373756
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak recid=3848 stamp=854373783
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak recid=3849 stamp=854373809
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp recid=3846
stamp=854373190
Crosschecked 9 objects
还原数据库
RMAN> restore database;
恢复数据库到指定序列。
RMAN> recover database until sequence 13908
恢复结束后，，启动数据库。
RMAN> alter database open resetlogs
本文永久更新链接地址：
MySQL的角色：Web应用程序中的数据库Apr 17, 2025 am 12:23 AMMySQL在Web应用中的主要作用是存储和管理数据。1.MySQL高效处理用户信息、产品目录和交易记录等数据。2.通过SQL查询，开发者能从数据库提取信息生成动态内容。3.MySQL基于客户端-服务器模型工作，确保查询速度可接受。
mysql：构建您的第一个数据库Apr 17, 2025 am 12:22 AM构建MySQL数据库的步骤包括：1.创建数据库和表，2.插入数据，3.进行查询。首先，使用CREATEDATABASE和CREATETABLE语句创建数据库和表，然后用INSERTINTO语句插入数据，最后用SELECT语句查询数据。
MySQL：一种对数据存储的初学者友好方法Apr 17, 2025 am 12:21 AMMySQL适合初学者，因为它易用且功能强大。1.MySQL是关系型数据库，使用SQL进行CRUD操作。2.安装简单，需配置root用户密码。3.使用INSERT、UPDATE、DELETE、SELECT进行数据操作。4.复杂查询可使用ORDERBY、WHERE和JOIN。5.调试需检查语法，使用EXPLAIN分析查询。6.优化建议包括使用索引、选择合适数据类型和良好编程习惯。
MySQL初学者友好吗？评估学习曲线Apr 17, 2025 am 12:19 AMMySQL适合初学者，因为：1)易于安装和配置，2)有丰富的学习资源，3)SQL语法直观，4)工具支持强大。尽管如此，初学者需克服数据库设计、查询优化、安全管理和数据备份等挑战。
SQL是一种编程语言吗？澄清术语Apr 17, 2025 am 12:17 AM是的，sqlisaprogramminglanguges pecialized fordatamanage.1）它具有焦点，focusingonwhattoachieveratherthanhow.2）sqlisessential forquerying forquerying，插入，更新，更新，和detletingdatainrelationalDatabases.3）
解释酸的特性（原子，一致性，隔离，耐用性）。Apr 16, 2025 am 12:20 AMACID属性包括原子性、一致性、隔离性和持久性，是数据库设计的基石。1.原子性确保事务要么完全成功，要么完全失败。2.一致性保证数据库在事务前后保持一致状态。3.隔离性确保事务之间互不干扰。4.持久性确保事务提交后数据永久保存。
MySQL：数据库管理系统与编程语言Apr 16, 2025 am 12:19 AMMySQL既是数据库管理系统（DBMS），也与编程语言紧密相关。1）作为DBMS，MySQL用于存储、组织和检索数据，优化索引可提高查询性能。2）通过SQL与编程语言结合，嵌入在如Python中，使用ORM工具如SQLAlchemy可简化操作。3）性能优化包括索引、查询、缓存、分库分表和事务管理。
mySQL：使用SQL命令管理数据Apr 16, 2025 am 12:19 AMMySQL使用SQL命令管理数据。1.基本命令包括SELECT、INSERT、UPDATE和DELETE。2.高级用法涉及JOIN、子查询和聚合函数。3.常见错误有语法、逻辑和性能问题。4.优化技巧包括使用索引、避免SELECT*和使用LIMIT。
热AI工具
Undresser.AI Undress
人工智能驱动的应用程序，用于创建逼真的裸体照片
AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。
Undress AI Tool
免费脱衣服图片
Clothoff.io
AI脱衣机
AI Hentai Generator
免费生成ai无尽的。
热门文章
热工具
EditPlus 中文破解版
体积小，语法高亮，不支持代码提示功能
WebStorm Mac版
好用的JavaScript开发工具
安全考试浏览器
Safe Exam Browser是一个安全的浏览器环境，用于安全地进行在线考试。该软件将任何计算机变成一个安全的工作站。它控制对任何实用工具的访问，并防止学生使用未经授权的资源。
SublimeText3 英文版
推荐：为Win版本，支持代码提示！
禅工作室 13.0.1
功能强大的PHP集成开发环境
