利用RMAN恢复整个数据库

听雪楼主. 听雪楼主. 博客等级 墨衍会员 · AI 创作全网分发 墨衍智能分发 本文由作者通过墨衍一键同步至各平台 1分发平台 1.7k累计阅读 1.8k平均单平台 已同步平台 优快云 微信公众号 微博 知乎 掘金 百家号 博客园 抖音 小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网 我也要 码龄10年
关注
原创 最新推荐文章于 2026-08-05 14:22:48 发布 1.7k 阅读 AI 写同款· GEO 优化 ›
RMAN异机恢复数据库详解 通过RMAN完成数据库异机恢复，保姆级教程 阅读详情

利用RMAN恢复整个数据库


利用RMAN恢复整个数据库案例一

适合场合：恢复的目录一致，同时备份的过程中有归档日志
恢复的数据库目录和down机的数据库一致，还有一个就是RMAN备份的时候已经备份了归档日志。
备份脚本：
run{
allocalte channel ch1 type disk;
sql ‘alter system archive log current’;
backup as compressed backupset database format ‘/u02/rman/proddb_%T_%U’;
sql ‘alter system archive log current’;
backup as compressed backupset archivelog all format ‘/u02/rman/prodarc_%T_%U’;
backup current controlfile format ‘/u02/rman/prodcon_%T_%U’;
release channel ch1;
}
delete force noprompt expired backup;
delete force noprompt obsoelet;
 
1.    安装Oracle服务器软件
版本尽量对应，安装过程中选择只安装软件，不创建数据库
2.    设置环境变量
su – oracle
vim ~/.bash_profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/11g/db_1
export ORACLE_SID=prod    --这个一定要对应
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
unset USERNAME
生效：source ~/.bash_profile
3.    创建相应的目录和文件，和之前服务器的一致，信息可以从rman备份的log文件看到，包括如下：
mkdir $ORACLE_BASE/admin/SID/{a,b,c,d,u}dump –p
mkdir $ORACLE_BASE/admin/SID/pfile–p
mkdir $ORACLE_BASE/oradata/SID –p
创建口令文件：
orapwd file=$ORACLE_HOME/dbs/orapwprod password=oracle entires=10
4.    拷贝备份和归档到恢复机器对应的路径下，特别是rman备份的路径，否则会报错
5.    配置主机名，监听，IP
6.    恢复数据库的过程
1）rman target / nocatalog
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Sep 16 13:55:31 2017
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database (not started)
2）RMAN> startup nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/11g/db_1/dbs/initprod.ora'
starting Oracle instance without parameter file for retrival of spfile
Oracle instance started
上面的意思是说：没有实例需要的初始化参数文件，由于没有参数文件，所以会报错，但实例已经启动
Total System Global Area     159383552 bytes
Fixed Size                     1266344 bytes
Variable Size                 54529368 bytes
Database Buffers             100663296 bytes
Redo Buffers                   2924544 bytes
3）恢复初始化参数文件
这里需要注意的是，要找对对应的备份文件，逐一尝试，一般找备份比较后而且小的
RMAN> restore spfile from '/u02/rman/proddb_20170916_05lo1lg0_1_1';
Starting restore at 16-SEP-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK
channel ORA_DISK_1: autobackup found: /u02/rman/proddb_20170916_05lo1lg0_1_1
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 16-SEP-10
4）恢复控制文件
RMAN> shutdown immediate;
Oracle instance shut down
RMAN> startup nomount;
connected to target database (not started)
Oracle instance started
Total System Global Area     167772160 bytes
Fixed Size                     1266392 bytes
Variable Size                 62917928 bytes
Database Buffers             100663296 bytes
Redo Buffers                   2924544 bytes
RMAN> restore controlfile from '/u02/rman/prodcon_20170916_07lo1lg8_1_1';
Starting restore at 16-SEP-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=101 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/u01/app/oracle/oradata/prod/control01.ctl
output filename=/u01/app/oracle/oradata/prod/control02.ctl
output filename=/u01/app/oracle/oradata/prod/control03.ctl
Finished restore at 16-SEP-10
5）将数据启动到mount状态
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
6）恢复数据库
后面出现的错误是指个别日志不同步，所以最好就是把归档一起拷贝全
RMAN> run{
2> restore database;
3> recover database;
4> }
7）以resetlogs打开数据库
 [oracle@sdb dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 - Production on Thu Sep 16 14:02:58 2017
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application proding options
SQL> alter database open resetlogs;
Database altered.
若在6)数据库恢复的过程中出现问题，可以参考如下的步骤进行
在恢复完控制文件后，启动到mount状态下，在sqlplus提示符下运行如下查询
1.  sql>select file#,checkpoint_change# from v$datafile;
注：如果出现科学记数法显示不了checkpoint_change#列的时候，可以通过如下命令让其显示完全
set numw 15;
发现所有数据文件的checkpoint scn是52873354，因此需要scn大于52873354的归档日志来修复数据库
2.在rman提示符下运行list backup of archivelog all，发现scn大于52873354的归档日志的sequence范围是1052至1097，在rman提示符下运行
restore archivelog sequence between 1052 and 1097;    恢复归档日志（mount）
3.在sqlplus提示符下运行命令alter database flashback off;关闭flashback，然后在rman提示符下运行如下命令块修复数据库
rman>Run {
Set until sequence=1098;
retore database;
Recover database;
}
 
 
利用RMAN恢复整个数据库案例二 
适合场合：目录一致，没有进行归档的备份
恢复的数据库目录和down机的数据库一致，RMAN备份的时候没有备份归档，恢复的时候，应该尽可能的把数据库做全备的开始的所有后面的归档尽可能拷贝过去，这个和目前公司的有些服务器备份策略一致
说明：做数据库备份的前，用户prod/prod下只有hello,hell2,hello4,hello3表，备份完成后创建了表hello5,结合RMAN和归档日志进行恢复，验证备份恢复完以后，hello5表也存在
备份脚本：
run{
allocate channel ch1 type disk;
sql ‘alter system archive log current’;
backup as compressed backupset database format ‘/u02/rman/proddb_%T_%U’;
sql ‘alter system archive log current’;
backup current controlfile format ‘/u02/rman/prodcon_%T_%U’;
release channel ch1;
}
 
恢复过程如下：
其中1，2，3，4和上面的过程一样，下面是步骤5恢复数据的过程：
6.利用rman恢复
[oracle@sdb prod]$ rman target / nocatalog
 
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Sep 19 12:02:47 2017
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database (not started)
 
1）恢复spfile，一般找小的备份文件
RMAN> startup nomount;                                                                                                             
 
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/11g/db_1/dbs/initprod.ora'
 
starting Oracle instance without parameter file for retrival of spfile
Oracle instance started
 
Total System Global Area     159383552 bytes
 
Fixed Size                     1266344 bytes
Variable Size                 54529368 bytes
Database Buffers             100663296 bytes
Redo Buffers                   2924544 bytes
 
RMAN> restore spfile from '/u02/rman/proddb_20170919_0llo9foo_1_1';
 
Starting restore at 19-SEP-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK
channel ORA_DISK_1: autobackup found: /u02/rman/proddb_20170919_0llo9foo_1_1
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 19-SEP-10
 
RMAN> shutdown immediate;
Oracle instance shut down
RMAN> startup nomount;
 
connected to target database (not started)
Oracle instance started
Total System Global Area     167772160 bytes
 
Fixed Size                     1266392 bytes
Variable Size                 75500840 bytes
Database Buffers              88080384 bytes
Redo Buffers                   2924544 bytes
--说明恢复成功
 
2）恢复控制文件
RMAN> restore controlfile from '/u02/rman/prodcon_20170919_0mlo9fov_1_1';
 
Starting restore at 19-SEP-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=101 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/u01/app/oracle/oradata/prod/control01.ctl
output filename=/u01/app/oracle/oradata/prod/control02.ctl
output filename=/u01/app/oracle/oradata/prod/control03.ctl
Finished restore at 19-SEP-10
 
3）启动数据库到mount状态，恢复数据库
RMAN> alter database mount;
 
database mounted
released channel: ORA_DISK_1
 
 
RMAN> run{
2> allocate channel ch1 type disk;
3> restore database;
4> recover database;
5> release channel ch1;
6> }
 
allocated channel: ch1
channel ch1: sid=101 devtype=DISK
 
Starting restore at 19-SEP-10
 
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/prod/system01.dbf
restoring datafile 00002 to /u01/app/oracle/oradata/prod/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/prod/sysaux01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/prod/users01.dbf
channel ch1: reading from backup piece /u02/rman/proddb_20170919_0klo9fna_1_1
channel ch1: restored backup piece 1
piece handle=/u02/rman/proddb_20170919_0klo9fna_1_1 tag=TAG20170919T110514
channel ch1: restore complete, elapsed time: 00:00:36
Finished restore at 19-SEP-10
 
Starting recover at 19-SEP-10
 
starting media recovery
 
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/19/2017 13:36:12
RMAN-06053: unable to perform. media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 38 lowscn 493029 found to restore
RMAN-06025: no backup of log thread 1 seq 37 lowscn 492908 found to restore
RMAN-06025: no backup of log thread 1 seq 36 lowscn 492874 found to restore
--上面说没有找到归档文件，将尽可能的归档文件拷贝过去
RMAN> exit
 
4）利用SQL*PLUS来恢复归档日志中的内容
Recovery Manager complete.
[oracle@sdb prod]$ sqlplus / as sysdba
 
SQL*Plus: Release 11.2.0.4.0 - Production on Sun Sep 19 13:36:28 2017
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application proding options
 
SQL> recover database using backup controlfile;
ORA-00279: change 492881 generated at 09/19/2017 11:05:14 needed for thread 1
ORA-00289: suggestion : /u01/arclog/1_36_729861888.dbf
ORA-00280: change 492881 for thread 1 is in sequence #36
先AUTO再CANCLE
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 492908 generated at 09/19/2017 11:06:07 needed for thread 1
ORA-00289: suggestion : /u01/arclog/1_37_729861888.dbf
ORA-00280: change 492908 for thread 1 is in sequence #37
ORA-00278: log file '/u01/arclog/1_36_729861888.dbf' no longer needed for this
recovery
 
ORA-00279: change 493029 generated at 09/19/2017 11:07:40 needed for thread 1
ORA-00289: suggestion : /u01/arclog/1_38_729861888.dbf
ORA-00280: change 493029 for thread 1 is in sequence #38
ORA-00278: log file '/u01/arclog/1_37_729861888.dbf' no longer needed for this
recovery
 
ORA-00308: cannot open archived log '/u01/arclog/1_38_729861888.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
 
SQL> recover database using backup controlfile;
ORA-00279: change 493029 generated at 09/19/2017 11:07:40 needed for thread 1
ORA-00289: suggestion : /u01/arclog/1_38_729861888.dbf
ORA-00280: change 493029 for thread 1 is in sequence #38
 
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/prod/system01.dbf'
--上面的出错信息很正常说，system01.dbf文件需要进行media recovery，由于刚才应用了归档里面的信息，所以会报错，再进去RMAN中recover database即可
 
 
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application proding options
[oracle@sdb prod]$ rman target / nocatalog;
 
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Sep 19 13:38:51 2017
 
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 
connected to target database: prod (DBID=2028008317, not open)
using target database control file instead of recovery catalog
 
RMAN> recover database;
 
Starting recover at 19-SEP-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=104 devtype=DISK
 
starting media recovery
 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/19/2017 13:38:58
RMAN-06053: unable to perform. media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 38 lowscn 493029 found to restore
--上面出错的信息是说，没有找到seq 38号的日志，不影响
RMAN> exit
 
 
Recovery Manager complete.
 
5）测试恢复成功
[oracle@sdb prod]$ sqlplus / as sysdba
 
SQL*Plus: Release 11.2.0.4.0 - Production on Sun Sep 19 13:39:06 2017
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application proding options
 
SQL>shutdown immediate;   --最好先执行关闭再
SQL>startup;
SQL> alter database open resetlogs;
Database altered.
 
SQL>conn prod/prod;
SQL> select table_name from user_tables;
TABLE_NAME
------------------------------
HELLO2
HELLO
HELLO3
HELLO4
HELLO5
SQL> select count(*) from hello5;
 
  COUNT(*)
----------
153600
 
其实从3），4），5）步骤可以这样恢复，首先将尽可能的归档拷贝到归档的相应目录下
然后进行如下的操作步骤：
rman>alter database mount
rman>run{
restore database;
}
rman>catalog start with ‘/u03/backup/arcbak/’
rman>recover database;
rman>shutdown immediate;
rman>startup;
rman>alter database open reseglogs;
 
方法三：直接把那些归档拷贝到和原库一样的目录，然后执行如下的操作：
rman>alter database mount
rman>run{
restore database;
recover database;
}
rman>alter database open resetlogs;
rman>shutdown immediate;
rman>startup;
最后要检查下ps –ef |grep ora_实例进程数，如果进程过多，不用过于关注，只是数据库没有完全恢复的原因
 
 

利用RMAN恢复整个数据库案例三


恢复目录不一致
当数据库目录不一样的时候，一般没有必要这样做，但是有时候特殊的需要
备份脚本：
run{
allocate channel ch1 type disk;
sql ‘alter system archive log current’;
backup as compressed backupset database format ‘/u02/rman/proddb_%T_%U’;
sql ‘alter system archive log current’;
backup as compressed archivelog all format ‘/u02/rman/prodarc_%T_%U’;
backup current controlfile format ‘/u02/rman/prodcon_%T_U’;
release channel ch1;
}
crosscheck backup;
delete force noprompt obsolete;
 
1，2，3，4，5过程和案例一的基本一样。
下面是恢复过程：
[oracle@sdb rman]$ rman target / nocatalog
 
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Sep 19 17:08:33 2017
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database (not started)
 
1）恢复spfile文件
RMAN> startup nomount;
connected to target database (not started)
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/11g/db_1/dbs/initprod.ora'
 
starting Oracle instance without parameter file for retrival of spfile
Oracle instance started
Total System Global Area     159383552 bytes
Fixed Size                     1266344 bytes
Variable Size                 54529368 bytes
Database Buffers             100663296 bytes
Redo Buffers                   2924544 bytes
 
RMAN> restore spfile from '/u02/rman/proddb_20170919_0slo9uv5_1_1';
 
Starting restore at 19-SEP-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK
channel ORA_DISK_1: autobackup found: /u02/rman/proddb_20170919_0slo9uv5_1_1
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 19-SEP-10
 
3）恢复controlfile
RMAN> shutdown immediate;
Oracle instance shut down
RMAN> startup nomount;
 
connected to target database (not started)
Oracle instance started
Total System Global Area     167772160 bytes
Fixed Size                     1266392 bytes
Variable Size                 88083752 bytes
Database Buffers              75497472 bytes
Redo Buffers                   2924544 bytes
 
RMAN> restore controlfile from '/u02/rman/prodcon_20170919_0ulo9uvd_1_1';
Starting restore at 19-SEP-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=101 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output filename=/u01/app/oracle/oradata/prod/control01.ctl
output filename=/u01/app/oracle/oradata/prod/control02.ctl
output filename=/u01/app/oracle/oradata/prod/control03.ctl
Finished restore at 19-SEP-10
 
4）恢复数据库(restore，recover)
RMAN> alter database mount;
 
database mounted
released channel: ORA_DISK_1
 
RMAN> report schema;
 
Starting implicit crosscheck backup at 19-SEP-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=101 devtype=DISK
Crosschecked 7 objects
Finished implicit crosscheck backup at 19-SEP-10
Starting implicit crosscheck copy at 19-SEP-10
using channel ORA_DISK_1
Finished implicit crosscheck copy at 19-SEP-10
searching for all files in the recovery area
cataloging files...
no files cataloged
 
RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema
 
List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    0        SYSTEM               ***     /u01/app/oracle/oradata/prod/system01.dbf
2    0        UNDOTBS1             ***     /u01/app/oracle/oradata/prod/undotbs01.dbf
3    0        SYSAUX               ***     /u01/app/oracle/oradata/prod/sysaux01.dbf
4    0        USERS                ***     /u01/app/oracle/oradata/prod/users01.dbf
 
List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    0        TEMP                 32767       /u01/app/oracle/oradata/prod/temp01.dbf
 
RMAN> run{
2> set newname for datafile 1 to '/u03/oradata/prod/system01.dbf';
3> set newname for datafile 2 to '/u03/oradata/prod/undotbs01.dbf';
4> set newname for datafile 3 to '/u03/oradata/prod/sysaux01.dbf';
5> set newname for datafile 4 to '/u03/oradata/prod/users01.dbf';
6> restore datafile 1,2,3,4;
7> switch datafile all;
8> }    
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 19-SEP-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u03/oradata/prod/system01.dbf
restoring datafile 00002 to /u03/oradata/prod/undotbs01.dbf
restoring datafile 00003 to /u03/oradata/prod/sysaux01.dbf
restoring datafile 00004 to /u03/oradata/prod/users01.dbf
channel ORA_DISK_1: reading from backup piece /u02/rman/proddb_20170919_0rlo9utn_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u02/rman/proddb_20170919_0rlo9utn_1_1 tag=TAG20170919T152439
channel ORA_DISK_1: restore complete, elapsed time: 00:00:36
Finished restore at 19-SEP-10
datafile 1 switched to datafile copy
input datafile copy recid=5 stamp=730143305 filename=/u03/oradata/prod/system01.dbf
datafile 2 switched to datafile copy
input datafile copy recid=6 stamp=730143305 filename=/u03/oradata/prod/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=7 stamp=730143305 filename=/u03/oradata/prod/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=8 stamp=730143305 filename=/u03/oradata/prod/users01.dbf
 
RMAN> alter database mount;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 09/19/2017 17:35:25
ORA-01100: database already mounted
 
RMAN> recover database;
 
Starting recover at 19-SEP-10
using channel ORA_DISK_1
 
starting media recovery
 
archive log thread 1 sequence 43 is already on disk as file /u01/arclog/1_43_729861888.dbf
archive log thread 1 sequence 44 is already on disk as file /u01/arclog/1_44_729861888.dbf
archive log filename=/u01/arclog/1_43_729861888.dbf thread=1 sequence=43
archive log filename=/u01/arclog/1_44_729861888.dbf thread=1 sequence=44
unable to find archive log
archive log thread=1 sequence=45
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/19/2017 17:36:40
RMAN-06054: media recovery requesting unknown log: thread 1 seq 45 lowscn 500916
 
RMAN> alter database open resetlogs;
database opened
RMAN> exit
Recovery Manager complete.
 
5）到此为至，数据文件，以及初始化参数文件，控制文件已经恢复完毕，但控制文件还是保存在以前记录的目录里，以及redo,temp文件，下面是这几个文件的恢复过程：
[oracle@sdb ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 - Production on Sun Sep 19 17:37:44 2017
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application proding options
 
A．查看当前日志的状态
SQL> select group#,status from v$log;
 
删除不在使用的归档日志，然后再添加回去
SQL> alter database drop logfile group 2;
 
SQL> alter database add logfile group 2 '/u03/oradata/prod/redo02.log' size 50m;
 
SQL> alter database drop logfile group 3;
 
SQL> alter database add logfile group 3 '/u03/oradata/prod/redo03.log' size 50m;
 
下面删除归档1的时候要注意，必须将其状态切换变为INACTIVE的时候，才可以删除归档1，否则会提示当前的还没有归档完
SQL> select group#,status from v$log;
SQL> alter system archive log current;
SQL> select group#,status from v$log;
 
SQL> alter system archive log current;
SQL> select group#,status from v$log;
 
SQL> alter system archive log current;
SQL> select group#,status from v$log;
 
SQL> alter system archive log current;
SQL> select group#,status from v$log;
 
SQL> alter database drop logfile group 1;
 
SQL> alter database add logfile group 1 '/u03/oradata/prod/redo01.log' size 50m;
 
SQL> select * from v$logfile;
看上面的信息redo联机日志恢复成功
 
B．恢复controlfile文件
SQL> create pfile='/home/oracle/initprod.ora' from spfile;    --先备份spfile 
SQL> shutdown immediate;
 
[oracle@sdb ~]$ vim initprod.ora   --加颜色的地方，就是要修改的地方，像*dump_dest目录也可以根据需要进行修改，还有归档目录
 
prod.__db_cache_size=75497472
prod.__java_pool_size=4194304
prod.__large_pool_size=4194304
prod.__shared_pool_size=79691776
prod.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/prod/adump'
*.background_dump_dest='/u01/app/oracle/admin/prod/bdump'
*.compatible='11.2.0.4.0'
*.control_files='/u03/oradata/prod/control01.ctl','/u03/oradata/prod/control02.ctl','/u03/oradata/prod/control03.ctl'#Restore Controlfile
*.core_dump_dest='/u01/app/oracle/admin/prod/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='prod'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=prodXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/u03/arclog'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=100
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=115
*.sga_target=167772160
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/prod/udump'
 
 [oracle@sdb ~]$ sqlplus / as sysdba
 SQL> startup nomount pfile='/home/oracle/initprod.ora';
 
[oracle@sdb ~]$ cd /u01/app/oracle/oradata/prod/
 
下面是重点，一定要将控制文件拷贝到恢复后相应的目录里
[oracle@sdb prod]$ cp ./control* /u03/oradata/prod/
[oracle@sdb prod]$ sqlplus / as sysdba
SQL> alter database mount;
SQL> alter database open;
 
SQL> create spfile from pfile;
create spfile from pfile
 
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/u01/app/oracle/11g/db_1/dbs/initprod.ora'
出现上面的错误原因是：在$ORACLE_HOME/dbs目录下没有找到pfile文件，将之前在/home/oracle/initprod.ora文件拷贝过去，再执行
 
SQL> create spfile from pfile;
 
C．修改temp文件：
先将数据文件离线，再修改名以及路径，最后让数据文件在线
SQL> alter database tempfile '/u01/app/oracle/oradata/prod/temp01.dbf' offline;
 
SQL> host cp /u01/app/oracle/oradata/prod/temp01.dbf /u03/oradata/prod/temp01.dbf;
SQL> alter database rename file '/u01/app/oracle/oradata/prod/temp01.dbf' to '/u03/oradata/prod/temp01.dbf';
SQL> alter database tempfile '/u03/oradata/prod/temp01.dbf' online;
 
5）检查恢复的整体情况，当然也可以再进行下归档的恢复
SQL> shutdown immediate;
SQL> startup;
SQL> select name from v$datafile;
SQL> select group#,member from v$logfile;
SQL> select name from v$controlfile;
收录于
Oracle

当前文章被收录于：

Oracle
70 篇文章 3 人学习
订阅专栏 查看详情
Oracle 备份恢复

当前文章被收录于：

Oracle 备份恢复
11 篇文章 2 人学习
订阅专栏 查看详情
Oracle-故障处理

当前文章被收录于：

Oracle-故障处理
11 篇文章 1 人学习
订阅专栏 查看详情
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
RMAN备份恢复常见报错及处理办法（一） 解决办法：RMAN-06102一般是由于备库缺少部分归档日志（可能已被清理），需要去别的地方备份缺少的归档日志，或者重新备份数据库（如果数据量整体不大），然后重新恢复数据库。恢复数据库时收到报错RMAN-11003，并且尝试关闭归档模式时会报错ORA-01143和ORA-01110。解决办法：备份对应的数据文件（这里是datafile 317），然后重新进行恢复。解决办法：去备库备份缺少的归档日志，从SCN最小的时间点开始备份，然后继续恢复。如果还是不行，可以尝试去重新备份数据库文件进行恢复。 阅读详情

相关推荐

RMAN备份与恢复数据库操作指南

RMAN是Oracle数据库中强大的备份和恢复工具，可以帮助保障数据的安全性和业务连续性。本文介绍了如何使用RMAN进行数据库备份和恢复，并提供了相应的源代码示例。使用RMAN进行数据库备份和恢复时，请确保在安全的环境下进行操作，并遵循最佳实践来保护数据库的完整性和可靠性。在Oracle数据库中，使用Recovery Manager（RMAN）工具可以进行可靠且高效的备份和恢复操作。这些命令只是RMAN功能的一小部分，使用RMAN可以进行更多复杂的备份和恢复操作。

HackGJN的博客 1280

RMAN备份归档日志时的not backed up与catalog数据库结合时的问题

在客户现场实施备份软件时， 客户环境中存在N套primary + 异地DG的Oracle数据库，同时客户要求primary与异地DG都需要备份. primary与异地DG都采用相同的catalog作为rman的...

congsong2560的博客 1120

YOLOv8 TensorRT C++部署实战详解：从XMake构建到推理流水线

本项目实现了一个基于YOLOv8和TensorRT的高性能火灾烟雾检测系统，具有以下核心特点： 技术架构：采用TensorRT 8.6+进行GPU加速推理，结合CUDA 12.1和OpenCV 4.8+，实现高效计算机视觉处理。系统使用XMake替代CMake构建，配置更简洁高效。

hscing的博客 1065

linux数据库只恢复数据库数据,利用RMAN恢复整个数据库

恢复目录不一致当数据库目录不一样的时候，一般没有必要这样做，但是有时候特殊的需要备份脚本：run{allocate channel ch1 type disk;sql ‘alter system archive log current’;backup as compressed backupset database format ‘/u02/rman/testdb_%T_%U’;sql ‘alte...

weixin_34552525的博客 451

从零构建AI智能体：基于opencode框架的Agent开发全流程指南

AI智能体（AI Agent）作为人工智能领域的重要发展方向，正从概念走向工程实践。其核心原理在于赋予AI自主规划、执行和迭代的能力，使其不再局限于简单的问答，而是能够理解复杂目标、分解任务、调用工具并完成闭环。这一技术价值在于将AI从“对话伙伴”升级为“执行伙伴”，极大地拓展了自动化边界，在智能客服、数据分析、自动化运维等场景展现出巨大潜力。本文聚焦于如何利用opencode这一热门开发框架，快速构建具备实际能力的智能体。通过拆解其核心组件如技能库、规划器与运行时，并结合具体实践案例，系统阐述了从环境搭建

weixin_29055699的博客 434

【03】海康MVS V4.3.0 ——安装教程、查看示例、库、头文件、开发指南

海康威视MVS机器视觉软件安装与使用指南：首先从官网下载MVS 4.3.0安装包，默认设置完成安装。安装后可在Development目录查看示例代码、开发文档及头文件，支持C++/C#/Python等多语言开发。软件内置虚拟相机功能，通过工具菜单添加虚拟设备后即可模拟真实相机操作，支持中英文界面切换、参数调节（曝光/增益等）及图像采集功能。虚拟相机虽仅能显示预设图像，但完整保留了参数调节功能，适合开发者进行功能测试。

程序员，他们想的是什么?他们想的永远都是技术，他们崇尚的也永远都是技术。 3305

flashback database 恢复删除的表空间

当误删除表空间，且没有备份，开启归档和闪回，可以使用flashback database恢复表空间1.数据库版本 sys@TEST> select * from v$version;BANNEROracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0

Vincent的专栏 1431

Unity 实现动态网格地图生成与交互组件

本文详细介绍了在Unity中实现动态网格地图生成与交互组件的完整方案。从基础网格单元实现到高级交互功能，涵盖网格生成器核心逻辑、事件驱动架构、性能优化技巧以及六边形网格等特殊实现。特别适合游戏开发者学习如何构建战棋、模拟经营类游戏的可交互地图系统，提升开发效率与用户体验。

weixin_29015483的博客 1068

Oracle（2-13） RMAN Complete Recove

RMAN Complete Recove RMAN完全恢复

DBA成长之路 652

医学图像标注工具教程——从零开始使用3D Slicer进行医学图像手动分割

3D Slicer手动分割软件下载及安装数据导入导入CT序列文件夹导入单张超声基本交互操作窗位和窗宽的调整改变切片及寻找特定点对应的三维切片图像分割功能介绍PaintDrawEraseLevel tracingGrow from seedsFill between slicesThreshold & Margin & HollowSmoothingScissors & IslandsLogical operator分割结果的保存 软件下载及安装 下载地址：官网的4.11.0版本 数据

神仙院B栋4楼保安的博客 1万+

22、计算智能在自闭症检测与管理中的应用

本文探讨了计算智能在自闭症谱系障碍（ASD）检测与管理中的应用。在检测方面，结合可穿戴设备、传感技术与多模态数据（如眼动追踪、问卷、神经成像等），利用机器学习和深度学习算法提升诊断准确性，并介绍了多种公开数据集及研究方法。在管理方面，通过生理指标（HRV、GSR、呼吸频率）监测情绪状态，结合智能可穿戴设备与支持性应用平台（如LetMeTalk、MITA、Rethink Ed等），实现对ASD患者的实时干预与个性化支持。文章还展示了多模态筛查与管理流程的系统架构，强调未来技术整合与个性化服务的发展方向。

star的博客 91

Oracle Flashback 和 RMAN 示例

新建了一张表t_table1, 在某个时间点插入两条数据，后续又误插入一条数据，现在需要恢复到误插入数据之前的状态。启用RMAN备份以后，同时数据库文件（.DBF）丢失，通过RMAN恢复数据文件。删除：C:\app\orcl\oradata\orcl目录下的.DBF文件。新建一张表，误删除（drop）了这张表，现在需要恢复这张表。RMAN备份/恢复之前必须要开启数据库归档功能。接场景1，drop这个表t_table1,接下来恢复到误差数据之前的情况，检查一下，数据已经恢复。

Practitioner 215

4、教育数据挖掘：公共数据集与研究进展

本文综述了教育数据挖掘（EDM）领域的研究进展与公共数据集应用情况。从2013年至2020年，EDM在电子学习系统、大规模开放在线课程（MOOC）等方面快速发展，涵盖了多种研究任务、工具与方法。文章梳理了UCI、Mendeley、DataShop等平台的公开数据集，分析了其特点与局限性，并介绍了KDD Cup、Kaggle等竞赛中的教育数据集及其评价指标。同时，探讨了多模态、心理行为等特色数据集的应用场景。最后指出当前EDM面临的主要挑战是缺乏系统性数据集综述、数据预处理复杂及可重复性不足，呼吁加强数据共享

rgv2345678的博客 170

RMAN恢复

Typical Media Recovery Scenarios The steps you take during a database recovery depend on the extent of the recovery and which of the files (datafiles, control files, online and archived redo logs) ar

juliaputao的专栏 743

【即插即用模块】Transformer篇 | CVPR 2025 | D2T：双域特征融合，完美适配缺陷检测/小目标检测和分割等频域细节敏感的任务！

本文提出了一种基于小波和原型增强的双域Transformer（WPFormer）用于像素级表面缺陷检测。该模型通过Dual-domain Transformer (D2T)模块融合频域和空间域特征：小波增强交叉注意力(WCA)分解高低频特征并加权平衡，增强缺陷细节捕捉；原型引导注意力(PCA)生成全局原型向量强化关键信息聚合。实验表明，该模块在缺陷检测任务中性能优于现有方法，通过频域细节增强和全局依赖建模有效提升了复杂场景下的检测效果。代码已开源，适用于对频域敏感的目标检测和分割任务。

主要更新底层视觉（去噪、超分等）相关的科研内容，形式为【论文精读】+【论文复现】 1374

ET2012新版免狗免安装绿色软件

ET2012新版免狗免安祖昂绿色软件。，新界面，新视觉，

实战rman恢复(1)丢失控制文件的恢复

一步一步学RMAN 第九篇 实战rman恢复(1)丢失控制文件的恢复   2007.7.18   无数次我对自己说，可以了，足够了，你已经明白了，需要学习的东西还很多，赶紧冲着下个目标去吧。尤幸的是在下一刻，另一个声音在脑海中响起，再加把劲，真的搞明白了，亲手去做个测试吧。   前面说过的，在非恢复目录(catalog)模式下，rman的备份信息都将存储在目标数据库的控制文件中，所以一旦

a15177733161的专栏 351

最新的sdio 4.0 spec 协议标准 带书签 高清完整PDF版

Part-E1-SDIO-Specification-Ver4.00-Final-120220.pdf：最新的sdio 4.0 spec 协议标准 带书签 高清完整PDF版，包括SDIO 接口的外设，SDIO 接口官方协议等。

通过RMAN备份duplicate异机克隆恢复数据库

说明： 本来是想做notarget目标库通过目标库备份集创建dataguard测试的，发现从原理上不能实现，但它有一个非常有用的功能，可以实现快速的rman备份异机恢复。 之前通过RMAN备份异机恢复要操作很多步骤，通过rmanduplicate方式来实现数据库将非常快速。将为今后有整库迁移工作任务提供又一种方案。 本文将记录完整过程。 一、环境介...

weixin_33827965的博客 271

VB摄像头监控

该VB模块可对摄像头捕获的画面进行录像等，可在创建的窗口进行控制

深度学习工具包 DeepLearningToolbox

深度学习工具包Deprecation notice.-----This toolbox is outdated and no longer maintained.There are much better tools available for deep learning than this toolbox, e.g. [Theano](http://deeplearning.net/software/theano/), [torch](http://torch.ch/) or [tensorflow](http://www.tensorflow.org/)I would suggest you use one of the tools mentioned above rather than use this toolbox.Best, Rasmus.DeepLearnToolbox================A Matlab toolbox for Deep Learning.Deep Learning is a new subfield of machine learning that focuses on learning deep hierarchical models of data.It is inspired by the human brain's apparent deep (layered, hierarchical) architecture.A good overview of the theory of Deep Learning theory is[Learning Deep Architectures for AI](http://www.iro.umontreal.ca/~bengioy/papers/ftml_book.pdf)For a more informal introduction, see the following videos by Geoffrey Hinton and Andrew Ng.* [The Next Generation of Neural Networks](http://www.youtube.com/watch?v=AyzOUbkUf3M) (Hinton, 2007)* [Recent Developments in Deep Learning](http://www.youtube.com/watch?v=VdIURAu1-aU) (Hinton, 2010)* [Unsupervised Feature Learning and Deep Learning](http://www.youtube.com/watch?v=ZmNOAtZIgIk) (Ng, 2011)If you use this toolbox in your research please cite [Prediction as a candidate for learning deep hierarchical models of data](http://www2.imm.dtu.dk/pubdb/views/publication_details.php?id=6284)```@MASTERSTHESIS\{IMM2012-06284, author = "R. B. Palm", title = "Prediction as a candidate for learning deep hierarchical models of data", year = "2012",}```Contact: rasmusbergpalm at gmail dot comDirectories included in the toolbox-----------------------------------`NN/` - A library for Feedforward Backpropagation Neural Networks`CNN/` - A library for Convolutional Neural Networks`DBN/` - A library for Deep Belief Networks`SAE/` - A library for Stacked Auto-Encoders`CAE/` - A library for Convolutional Auto-Encoders`util/` - Utility functions used by the libraries`data/` - Data used by the examples`tests/` - unit tests to verify toolbox is workingFor references on each library check REFS.mdSetup-----1. Download.2. addpath(genpath('DeepLearnToolbox'));Example: Deep Belief Network---------------------```matlabfunction test_example_DBNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit RBM and visualize its weightsrand('state',0)dbn.sizes = [100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);figure; visualize(dbn.rbm{1}.W'); % Visualize the RBM weights%% ex2 train a 100-100 hidden unit DBN and use its weights to initialize a NNrand('state',0)%train dbndbn.sizes = [100 100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);%unfold dbn to nnnn = dbnunfoldtonn(dbn, 10);nn.activation_function = 'sigm';%train nnopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.10, 'Too big error');```Example: Stacked Auto-Encoders---------------------```matlabfunction test_example_SAEload mnist_uint8;train_x = double(train_x)/255;test_x = double(test_x)/255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit SDAE and use it to initialize a FFNN% Setup and train a stacked denoising autoencoder (SDAE)rand('state',0)sae = saesetup([784 100]);sae.ae{1}.activation_function = 'sigm';sae.ae{1}.learningRate = 1;sae.ae{1}.inputZeroMaskedFraction = 0.5;opts.numepochs = 1;opts.batchsize = 100;sae = saetrain(sae, train_x, opts);visualize(sae.ae{1}.W{1}(:,2:end)')% Use the SDAE to initialize a FFNNnn = nnsetup([784 100 10]);nn.activation_function = 'sigm';nn.learningRate = 1;nn.W{1} = sae.ae{1}.W{1};% Train the FFNNopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.16, 'Too big error');```Example: Convolutional Neural Nets---------------------```matlabfunction test_example_CNNload mnist_uint8;train_x = double(reshape(train_x',28,28,60000))/255;test_x = double(reshape(test_x',28,28,10000))/255;train_y = double(train_y');test_y = double(test_y');%% ex1 Train a 6c-2s-12c-2s Convolutional neural network %will run 1 epoch in about 200 second and get around 11% error. %With 100 epochs you'll get around 1.2% errorrand('state',0)cnn.layers = { struct('type', 'i') %input layer struct('type', 'c', 'outputmaps', 6, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %sub sampling layer struct('type', 'c', 'outputmaps', 12, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %subsampling layer};cnn = cnnsetup(cnn, train_x, train_y);opts.alpha = 1;opts.batchsize = 50;opts.numepochs = 1;cnn = cnntrain(cnn, train_x, train_y, opts);[er, bad] = cnntest(cnn, test_x, test_y);%plot mean squared errorfigure; plot(cnn.rL);assert(er<0.12, 'Too big error');```Example: Neural Networks---------------------```matlabfunction test_example_NNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);% normalize[train_x, mu, sigma] = zscore(train_x);test_x = normalize(test_x, mu, sigma);%% ex1 vanilla neural netrand('state',0)nn = nnsetup([784 100 10]);opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samples[nn, L] = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.08, 'Too big error');%% ex2 neural net with L2 weight decayrand('state',0)nn = nnsetup([784 100 10]);nn.weightPenaltyL2 = 1e-4; % L2 weight decayopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex3 neural net with dropoutrand('state',0)nn = nnsetup([784 100 10]);nn.dropoutFraction = 0.5; % Dropout fraction opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex4 neural net with sigmoid activation functionrand('state',0)nn = nnsetup([784 100 10]);nn.activation_function = 'sigm'; % Sigmoid activation functionnn.learningRate = 1; % Sigm require a lower learning rateopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex5 plotting functionalityrand('state',0)nn = nnsetup([784 20 10]);opts.numepochs = 5; % Number of full sweeps through datann.output = 'softmax'; % use softmax outputopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex6 neural net with sigmoid activation and plotting of validation and training error% split training data into training and validation datavx = train_x(1:10000,:);tx = train_x(10001:end,:);vy = train_y(1:10000,:);ty = train_y(10001:end,:);rand('state',0)nn = nnsetup([784 20 10]); nn.output = 'softmax'; % use softmax outputopts.numepochs = 5; % Number of full sweeps through dataopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, tx, ty, opts, vx, vy); % nntrain takes validation set as last two arguments (optionally)[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');```[![Bitdeli Badge](https://d2weczhvl823v0.cloudfront.net/rasmusbergpalm/deeplearntoolbox/trend.png)](https://bitdeli.com/free "Bitdeli Badge")

用RMAN 备份异机恢复 迁移数据

先假设一种情况，假设有一个数据库，数据量是2T。 如果要对这个数据库进行迁移，在不考虑磁盘空间的前提下，要求在最短的时间内完成切换操作。          在不考虑磁盘空间前提下，备份时间，网络传输时间，恢复时间。 这个时间对于7*24*365的系统来说，肯定是没办法承受的。        如果在考虑下备份空间+迁移后的空间。 这个对磁盘的开销也是非常大。          在我的前一

好读书，每有会意，便欣然忘食。 869

oracle rman level0备份恢复验证,Oracle rman备份异机恢复

一、 实验环境db_A:192.168.0.3 db_B:192.168.0.4db_A为生产数据库，db_B为后备(不运行)；两个数据库的环境完全一样。二、操作1.db_A的操作在db_A上进行rman的0级备份$rman target /RMAN>backup incremental level=0 database format='/oradata/back/%u';添加...

weixin_39864682的博客 394

RMAN概览

RMAN的功能:备份整个数据库，数据文件，控制文件和归档日志文件；压缩备份，当压缩的备份有数据块更改的时候，只备份那些被更改的数据块；执行增量备份支持脚本的编写来对任务进行组合记录备份操作日志能够和第三方磁带软件集成能够提供catalog信息报告和列表能够将备

咸鱼翻身 687

oracle 12c 表恢复,ORACLE 12C使用RMAN进行表恢复

在12C以前的版本中rman可以进行db,tablespace,datafile,block级别和TSPITR的恢复,12C引入了table级别的恢复在没有打开flashback的时候可以进行单个表的恢复.例,创建表SQL> >Session>　　SQL> create table frank.t1 as select * from dba_tables;Table cre...

weixin_29358053的博客 347

一步一步学RMAN第九篇 实战rman恢复(1)丢失控制文件的恢复

　　无数次我对自己说，可以了，足够了，你已经明白了，需要学习的东西还很多，赶紧冲着下个目标去吧。尤幸的是在下一刻，另一个声音在脑海中响起，再加把劲，真的搞明白了，亲手去做个测试吧。一步一步学RMAN第一篇 进入RMAN http...

cqbh2011的博客 112
上一篇： 密码学入门：几种简单的密码
下一篇： 雪崩效应
点赞 2
评论 0
书签 书签 4
听雪楼主.
听雪楼主.
博客等级 码龄10年 513粉丝 214原创
+ 关注 专栏目录 订阅专栏
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值