[oracle@oracle01 ~]$ [oracle@oracle01 ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jul 13 10:25:19 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: ORA11GR2 (DBID=297877687) RMAN> backup database; Starting backup at 2018-07-13 10:25:28 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=38 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=/u01/app/oracle/oradata/ora11gr2/system01.dbf input datafile file number=00002 name=/u01/app/oracle/oradata/ora11gr2/sysaux01.dbf input datafile file number=00005 name=/u01/app/oracle/oradata/ora11gr2/example01.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/ora11gr2/undotbs01.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/ora11gr2/users01.dbf channel ORA_DISK_1: starting piece 1 at 2018-07-13 10:25:28 channel ORA_DISK_1: finished piece 1 at 2018-07-13 10:26:15 piece handle=/u01/app/oracle/fast_recovery_area/ORA11GR2/backupset/2018_07_13/o1_mf_nnndf_TAG20180713T102528_fnj3dsn6_.bkp tag=TAG20180713T102528 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:47 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 2018-07-13 10:26:16 channel ORA_DISK_1: finished piece 1 at 2018-07-13 10:26:17 piece handle=/u01/app/oracle/fast_recovery_area/ORA11GR2/backupset/2018_07_13/o1_mf_ncsnf_TAG20180713T102528_fnj3g8bv_.bkp tag=TAG20180713T102528 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 2018-07-13 10:26:17 RMAN> quit Recovery Manager complete. [oracle@oracle01 ~]$ cd /u01/app/oracle/oradata/ora11gr2/ [oracle@oracle01 ora11gr2]$ rm -rf system01.dbf [oracle@oracle01 ora11gr2]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 13 10:27:13 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> shutdow abort; ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 1653518336 bytes Fixed Size 2253784 bytes Variable Size 1006636072 bytes Database Buffers 637534208 bytes Redo Buffers 7094272 bytes Database mounted. ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '/u01/app/oracle/oradata/ora11gr2/system01.dbf' SQL> startup mount; ORA-01081: cannot start already-running ORACLE - shut it down first SQL> shut immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 1653518336 bytes Fixed Size 2253784 bytes Variable Size 1006636072 bytes Database Buffers 637534208 bytes Redo Buffers 7094272 bytes Database mounted. SQL> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@oracle01 ora11gr2]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jul 13 10:28:24 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: ORA11GR2 (DBID=297877687, not open) RMAN> restore database; Starting restore at 2018-07-13 10:28:41 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=20 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/ora11gr2/system01.dbf channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/ora11gr2/sysaux01.dbf channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/ora11gr2/undotbs01.dbf channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/ora11gr2/users01.dbf channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/ora11gr2/example01.dbf channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORA11GR2/backupset/2018_07_13/o1_mf_nnndf_TAG20180713T102528_fnj3dsn6_.bkp channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORA11GR2/backupset/2018_07_13/o1_mf_nnndf_TAG20180713T102528_fnj3dsn6_.bkp tag=TAG20180713T102528 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:45 Finished restore at 2018-07-13 10:29:28 RMAN> recover database; Starting recover at 2018-07-13 10:29:38 using channel ORA_DISK_1 starting media recovery media recovery complete, elapsed time: 00:00:01 Finished recover at 2018-07-13 10:29:39 RMAN> quit Recovery Manager complete. [oracle@oracle01 ora11gr2]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 13 10:29:53 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter database open;
Database backup
来源:这里教程网
时间:2026-03-03 11:56:45
作者:
编辑推荐:
- Database backup03-03
- sqlplus连接报ORA-09925 Unable to create audit trail file03-03
- word2010怎么把文字替换成图片03-03
- 卸载grid软件03-03
- Word2010中段落怎样添加底纹03-03
- 12C Oracle ASM Filter Driver03-03
- OCP认证052考试最新题库及答案整理-1103-03
- word2010如何进行样式选择调用03-03
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- Oracle 12C Data Gurad RAC TO RAC
Oracle 12C Data Gurad RAC TO RAC
26-03-03 - 从 Oracle 转型 MySQL 分布式事务数据库的实战旅途
从 Oracle 转型 MySQL 分布式事务数据库的实战旅途
26-03-03 - Oracle 18c安装初体验
Oracle 18c安装初体验
26-03-03 - word2010怎么设置双行合一
word2010怎么设置双行合一
26-03-03 - 数据库服务:activemq 在灾备双活建设中的研究
数据库服务:activemq 在灾备双活建设中的研究
26-03-03 - 删除归档日志报RMAN-08137
删除归档日志报RMAN-08137
26-03-03 - SQL优化案例-分区索引之无前缀索引(六)
SQL优化案例-分区索引之无前缀索引(六)
26-03-03 - Debian服务端口绑定配置详解(手把手教你如何在Debian系统中正确绑定和配置服务端口)
- buffer busy waits引起的会话突增
buffer busy waits引起的会话突增
26-03-03 - Check FRA usage
Check FRA usage
26-03-03
