1 创建测试用的表，以验证恢复前后数据一样
SYS@racdb3>create table test20180414 (id date);
Table created.
SYS@racdb3>alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
Session altered.
SYS@racdb3>insert into test20180414 values(sysdate);
1 row created.
SYS@racdb3>commit;
Commit complete.
SYS@racdb3>select * from test20180414;
ID
-------------------
2018-04-14 16:32:16
SYS@racdb3>
SYS@racdb2>show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/racdb/spfileracdb.ora
SYS@racdb2>create pfile='/home/oracle/pfile20180414' from spfile;
File created.
SYS@racdb2>2 准备备份脚本
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
backup as compressed backupset database format '/home/oracle/bakracdb/fulldb_%d_%T_%u_%p_%c';
sql 'alter system archive log current';
backup as compressed backupset format '/home/oracle/bakracdb/arc_%e_%h_%d_%T_%u_%p_%c' archivelog all;
backup current controlfile format '/home/oracle/bakracdb/control_%d_%T_%u_%p_%c';
backup spfile format '/home/oracle/bakracdb/spfile_%d_%T_%u_%p_%c';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}4 连接到任意一个节点上，启动到nomount状态
export ORACLE_SID=racdb3
rman target /
startup nomount注意，这里先恢复成pfile，用pfile启动，数据库全部恢复完毕后，再重新创建spfile（RAC下的spfile和单机有些不一样）
restore spfile to pfile '/home/oracle/bakracdb/pfile20180414' from '/home/oracle/bakracdb/spfile_RACDB_20180414_24t0b3jj_1_1';-- 虽然直接恢复spfile到ASM磁盘上，也是可以的。不过需要在两个节点上的$ORACLE_HOME/dbs下的init<SID>.ora文件夹内spfile指向ASM上的spfile位置。
RMAN> restore spfile to '+DATA/racdb/spfileracdb.ora' from '/home/oracle/bakracdb/spfile_RACDB_20180414_24t0b3jj_1_1';
Starting restore at 14-APR-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=25 device type=DISK
channel ORA_DISK_1: restoring spfile from AUTOBACKUP /home/oracle/bakracdb/spfile_RACDB_20180414_24t0b3jj_1_1
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 14-APR-18
RMAN> RMAN> restore spfile to pfile '/home/oracle/bakracdb/pfile20180414' from '/home/oracle/bakracdb/spfile_RACDB_20180414_24t0b3jj_1_1';
Starting restore at 14-APR-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=25 device type=DISK
channel ORA_DISK_1: restoring spfile from AUTOBACKUP /home/oracle/bakracdb/spfile_RACDB_20180414_24t0b3jj_1_1
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 14-APR-18
RMAN>
@>conn / as sysdba
Connected to an idle instance.
SYS@racdb3>startup nomount pfile='/home/oracle/bakracdb/pfile20180414'6 还原控制文件
sql "alter session set nls_date_format=''YYYY-MM-DD HH24:MI:SS''"; -- 好像没有起作用
restore controlfile from '/home/oracle/bakracdb/control_RACDB_20180414_23t0b3j8_1_1';
alter database mount;
RMAN> sql "alter session set nls_date_format=''YYYY-MM-DD HH24:MI:SS''";
sql statement: alter session set nls_date_format=''YYYY-MM-DD HH24:MI:SS''
RMAN> restore controlfile from '/home/oracle/bakracdb/control_RACDB_20180414_23t0b3j8_1_1';
Starting restore at 14-APR-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=37 instance=racdb3 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=+DATA/racdb/control01.ctl
output file name=+DATA/racdb/control02.ctl
Finished restore at 14-APR-18
RMAN> sql 'alter database mount';7 进行restore
RMAN> restore database;
Starting restore at 14-APR-18
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=37 instance=racdb3 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 00003 to +DATA/racdb/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00006 to +DATA/racdb/undotbs02.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/bakracdb/fulldb_RACDB_20180414_1pt0b3bs_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bakracdb/fulldb_RACDB_20180414_1pt0b3bs_1_1 tag=TAG20180414T164025
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
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 00004 to +DATA/racdb/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to +DATA/racdb/example01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/bakracdb/fulldb_RACDB_20180414_1ot0b3br_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bakracdb/fulldb_RACDB_20180414_1ot0b3br_1_1 tag=TAG20180414T164025
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
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 +DATA/racdb/system01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/bakracdb/fulldb_RACDB_20180414_1mt0b3bq_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bakracdb/fulldb_RACDB_20180414_1mt0b3bq_1_1 tag=TAG20180414T164025
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
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 00002 to +DATA/racdb/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00007 to +DATA/racdb/datafile/abc.448.966705497
channel ORA_DISK_1: reading from backup piece /home/oracle/bakracdb/fulldb_RACDB_20180414_1nt0b3bq_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bakracdb/fulldb_RACDB_20180414_1nt0b3bq_1_1 tag=TAG20180414T164025
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 14-APR-18
RMAN> recover database 8 进行recover
RMAN> recover database;
Starting recover at 14-APR-18
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 224 is already on disk as file +DATA/racdb/archivelog/2018_04_14/thread_1_seq_224.758.973442535
archived log for thread 1 with sequence 225 is already on disk as file +DATA/racdb/archivelog/2018_04_14/thread_1_seq_225.759.973442541
archived log for thread 2 with sequence 263 is already on disk as file +DATA/racdb/archivelog/2018_04_14/thread_2_seq_263.757.973442533
archived log for thread 2 with sequence 264 is already on disk as file +DATA/racdb/archivelog/2018_04_14/thread_2_seq_264.760.973442543
archived log file name=+DATA/racdb/archivelog/2018_04_14/thread_1_seq_224.758.973442535 thread=1 sequence=224
archived log file name=+DATA/racdb/archivelog/2018_04_14/thread_2_seq_263.757.973442533 thread=2 sequence=263
archived log file name=+DATA/racdb/archivelog/2018_04_14/thread_2_seq_264.760.973442543 thread=2 sequence=264
archived log file name=+DATA/racdb/archivelog/2018_04_14/thread_1_seq_225.759.973442541 thread=1 sequence=225
archived log file name=+DATA/racdb/archivelog/2018_04_14/thread_1_seq_226.762.973442959 thread=1 sequence=226
archived log file name=+DATA/racdb/archivelog/2018_04_14/thread_2_seq_265.761.973442807 thread=2 sequence=265
archived log file name=+DATA/racdb/archivelog/2018_04_14/thread_1_seq_227.763.973442961 thread=1 sequence=227
archived log file name=+DATA/racdb/archivelog/2018_04_14/thread_2_seq_266.765.973442963 thread=2 sequence=266
archived log file name=+DATA/racdb/archivelog/2018_04_14/thread_1_seq_228.764.973442963 thread=1 sequence=228
unable to find archived log
archived log thread=2 sequence=267
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/14/2018 18:56:26
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 267 and starting SCN of 2637058
RMAN-11003: failure during parse/execution of SQL statement: alter database recover continue
ORA-00279: change 2637058 generated at 04/14/2018 16:49:23 needed for thread 2
ORA-00289: suggestion : +DATA
ORA-00280: change 2637058 for thread 2 is in sequence #267
ORA-00278: log file '+DATA/racdb/archivelog/2018_04_14/thread_2_seq_266.765.973442963' no longer needed for this recovery
9 使用open resetlogs打开库
SYS@racdb3>alter database open resetlogs;
Database altered.
SYS@racdb3>10 创建spfile,在节点上创建initracdb3.ora 。两个节点上都需要有init<sid>.ora
create spfile='+DATA/racdb/spfileracdb.ora' from pfile='/home/oracle/bakracdb/pfile20180414'
[oracle@host03 dbs]$ cat initracdb3.ora
SPFILE='+DATA/racdb/spfileracdb.ora'
[oracle@host03 dbs]$
[oracle@host02 dbs]$ cat initracdb2.ora
SPFILE='+DATA/racdb/spfileracdb.ora'
[oracle@host02 dbs]$
11 数据验证
SYS@racdb3>select * from test20180414;
ID
-------------------
2018-04-14 16:32:16
SYS@racdb3>archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2
SYS@racdb3>
SYS@racdb2>select * from test20180414;
ID
-------------------
2018-04-14 16:32:16
SYS@racdb2>archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA
Oldest online log sequence 4
Next log sequence to archive 5
Current log sequence 5
SYS@racdb2>
这个时候，使用命令crsctl status resource -t 命令，是查看不到racdb这个数据库的信息的
[grid@host03 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE host02
ONLINE ONLINE host03
ora.LISTENER.lsnr
ONLINE ONLINE host02
ONLINE ONLINE host03
ora.OCR.dg
ONLINE ONLINE host02
ONLINE ONLINE host03
ora.asm
ONLINE ONLINE host02 Started
ONLINE ONLINE host03 Started
ora.gsd
OFFLINE OFFLINE host02
OFFLINE OFFLINE host03
ora.net1.network
ONLINE ONLINE host02
ONLINE ONLINE host03
ora.ons
ONLINE ONLINE host02
ONLINE ONLINE host03
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE host02
ora.cvu
1 OFFLINE OFFLINE
ora.host02.vip
1 ONLINE ONLINE host02
ora.host03.vip
1 ONLINE ONLINE host03
ora.oc4j
1 ONLINE ONLINE host02
ora.scan1.vip
1 ONLINE ONLINE host02
ora.test.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE 同样，使用 srvctl config database 命令也查看不到数据库信息
[grid@host03 ~]$ srvctl config database -d racdb
PRCD-1120 : The resource for database racdb could not be found.
PRCR-1001 : Resource ora.racdb.db does not exist
[grid@host03 ~]$
使用命令添加数据库到集群中
srvctl add database -d racdb -o /u01/app/oracle/product/11.2.0/db_1 -c RAC -s open
[grid@host03 ~]$ srvctl add database -d racdb -o /u01/app/oracle/product/11.2.0/db_1 -c RAC -s open
PRCS-1007 : Server pool racdb already exists
PRCR-1086 : server pool ora.racdb is already registered这是因为资源中已经有ora.racdb这个server pool，需要删除掉
[grid@host03 ~]$ crsctl delete serverpool ora.racdb
CRS-2557: Server pool 'ora.racdb' cannot be unregistered as it is referenced by server pool 'ora.racdb_service_taf'
CRS-4000: Command Delete failed, or completed with errors.
[grid@host03 ~]$ 上面的错误提示，提示有个相关的server pool，那么将这个server pool 'ora.racdb_service_taf' 先删除掉，再删除ora.racdb。可以看到可以删除了
[grid@host03 ~]$ crsctl delete serverpool ora.racdb_service_taf
[grid@host03 ~]$ crsctl delete serverpool ora.racdb
[grid@host03 ~]$ 添加数据库和instance
[oracle@host03 ~]$ srvctl add database -d racdb -o /u01/app/oracle/product/11.2.0/db_1 -c RAC -s open
[oracle@host03 ~]$ srvctl add instance -d racdb -i racdb2 -n host02
[oracle@host03 ~]$ srvctl add instance -d racdb -i racdb3 -n host03-- 修改数据库随着集群自动启动
crsctl modify resource ora.racdb.db -attr "AUTO_START=always" --- reboot 启动测试
[grid@host02 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE host02
ONLINE ONLINE host03
ora.LISTENER.lsnr
ONLINE ONLINE host02
ONLINE ONLINE host03
ora.OCR.dg
ONLINE ONLINE host02
ONLINE ONLINE host03
ora.asm
ONLINE ONLINE host02 Started
ONLINE ONLINE host03 Started
ora.gsd
OFFLINE OFFLINE host02
OFFLINE OFFLINE host03
ora.net1.network
ONLINE ONLINE host02
ONLINE ONLINE host03
ora.ons
ONLINE ONLINE host02
ONLINE ONLINE host03
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE host02
ora.cvu
1 OFFLINE OFFLINE
ora.host02.vip
1 ONLINE ONLINE host02
ora.host03.vip
1 ONLINE ONLINE host03
ora.oc4j
1 ONLINE ONLINE host02
ora.racdb.db
1 ONLINE ONLINE host03 Open
2 ONLINE ONLINE host02 Open
ora.scan1.vip
1 ONLINE ONLINE host02
ora.test.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
[grid@host02 ~]$
-- 检查TAF设置 。
[oracle@host03 ~]$ srvctl add service -d racdb -s test_taf -r "racdb3,racdb2" -e SELECT -m BASIC -w 5 -z 3
[oracle@host03 ~]$ srvctl start service -d racdb -s test_taf
SQL> conn system/oracle@test_taf
已连接。
SQL> select instance_name from v$instance;
INSTANCE_NAME
--------------------------------
racdb3
SQL> /
INSTANCE_NAME
--------------------------------
racdb2
SQL> /
INSTANCE_NAME
--------------------------------
racdb3
SQL> /
INSTANCE_NAME
--------------------------------
racdb2
SQL>
---
总结
1 rac全库的恢复，和单机恢复的思路一样
2 rac全库恢复完毕后，要考虑把数据库和instance添加到集群中去，这点和单机不一样。使用dbca是无法添加instance到集群的。必须通过命令添加。
3 在集群启动的情况下，可以通过RMAN将相关的文件（比如控制文件、数据文件、SPFILE）恢复到ASM磁盘组上。
End 。
文章浏览阅读2k次。Smartisan·T黑2019年10月31日19:30分在北京工业大学奥林匹克体育馆举行的坚果手机2019新品发布会上，Smartisan OS产品经理朱海舟正式发布了Smartisan OS 7.0。随着全新的Smartisan OS 7.0一同亮相的还有锤子科技向方正字库订制的系统UI字体：Smartisan T黑(锤子T黑)。锤子T黑有着几乎完美的特质：灰度均衡、重心统一、中宫内..._smartisan t黑
文章浏览阅读4.8k次，点赞4次，收藏6次。一.extends关键字 extends是实现(单)继承(一个类)的关键字，通过使用extends 来显式地指明当前类继承的父类。只要那个类不是声明为final或者那个类定义为abstract的就能继承。其基本声明格式如下： [修饰符] class 子类名 extends 父类名{ 类体 }_implements在java中的格式
文章浏览阅读2.1w次，点赞9次，收藏70次。There are two types of frame structure in the LTE standard, Type 1 and Type 2. Type 1 uses Frequency Division Duplexing (uplink and downlink separated by frequency), and TDD uses Time Division Duple_lte linear
文章浏览阅读3.3w次，点赞13次，收藏37次。原因配置缺失，比如为开启注解扫描驱动、注入组件为注册；使用 new 关键字创建的对象不受spring容器管理，无法注入；注入静态变量, 静态变量/类变量不是对象的属性,而是一个类的属性,spring则是基于对象层面上的依赖注入。静态注入的三种方式在一些工具类中可能会依赖 service 层的对象,一般情况下工具类都是使用静态方法,对应的成员变量也需要声明为静态的,此时如果直接使用 @..._spring autowired null
文章浏览阅读207次。通过对政府、央企、银行、证券、民生、运营商、互联网等行业的红队实战工作，发现各行业安全防护具备如下特点。一、 资产混乱、隔离策略不严格除了大型银行之外，很多行业对自身资产情况比较混乱，没有严格的访问控制（ACL）策略，且办公网和互联网之间大部分相通，可以直接使远程控制程序上线。除了大型银行与互联网行业外，其他很多行业在DMZ区和办公网之间不做或很少做隔离，网络区域划分也不严格，给了红队很多可乘之机。此外，几乎所有行业的下级单位和上级单位的业务网都可以互通。而除了大型银行之外，其他很多行业的办公网也大_红队 漏洞总是修复不好
文章浏览阅读1.1k次。船舶航向控制器设计(MATLAB,附仿真程序)(课题申报表,任务书,开题报告,中期检查表,外文翻译,论文15400字,仿真程序,答辩PPT)摘 要本文对反向递推(Backstepping)设计方法在非线性船舶航向控制器中的应用进行了研究。Backstepping设计方法是近几年兴起的一种基于Lyapunov稳定性理论的比较先进的非线性控制方法。因此，本文首先对目前常见的非线性控制方法进行了概述，简..._舵机模型matlab程序
文章浏览阅读2.7k次。关于背景图片background-attachment: fixed;属性在谷歌浏览器中失效的问题解决。最近在做文件打印的功能操作。我选择使用简单易用的window.print()来打印整个页面。具体操作网上有很多相关的方法，这里不再一一叙述。只在此说一下在打印背景图片时遇到的问题及解决方法。首先，背景图片设置好之后我对其进行平铺和固定设置如图所示。我的本意是将一个不大的图片平铺整个页面，并且打印时即使页面内容过多导致分页也能继续显示背景图片。但我使用谷歌浏览器时，出现问题。background-a_background-attachment: fixed;失效
文章浏览阅读226次。vi 和vim 的区别它们都是多模式编辑器，不同的是vim 是vi的升级版本，它不仅兼容vi的所有指令，而且还有一些新的特性在里面。vim的这些优势主要体现在以下几个方面：1、多级撤消我们知道在vi里，按 u只能撤消上次命令，而在vim里可以无限制的撤消。2、易用性vi只能运行于unix中，而vim不仅可以运行于unix,windows ,mac等多操作平台。3、语法加亮vi..._linux vi和vim有什么区别
文章浏览阅读10w+次，点赞158次，收藏1.3k次。Oracle数据库1.1 数据库环境安装1.Oracle数据库产品是免费的，我们可以从Oracle的官方网站(http://www.oracle.com)下载到程序安装包，Oracle在Windows下的安装非常方便，安装开始后，一直点击安装程序的“下一步”即可。2. 下载Oracle10g后，解压到一个文件夹下，单击“setup.exe”文件即可启动安装界面。。填写全局数据库名，以及管理员的密..._oracle数据库
文章浏览阅读2.2k次，点赞6次，收藏8次。1、找到nox的目录（本人不是默认安装，路径为：D:\Program Files\Nox\Nox\bin）2、打开cmd3、接着输入adb shell4、继续输入cd data\system5、输入ls查看data\system中的文件，如果设置了密码会有gesture.key（手势密码）或者password.key（密码）6、若设置的是图案密码请继续输入命令：rm gesture.key，若设置的是单纯密码请输入命令：rm password.key7、输入reboot命令或者手动重启手机生效，_夜神模拟器向上滑动解锁
文章浏览阅读826次。蛊毒传说问题描述：例如在命令窗口中 functionNumber=recrgb(Image,Image_HSV,h,w)电脑就会提示：Function业，但是在我的机子上运行的时候，我的matlab不认识load函数，我很郁闷，我是2007的版本，你的如果版本高，应该可以认识load函数件和所用图片放到matlab运行时所在的文件夹中，然后在commandwindow里运行Main即可，但是还有一..._matlab中function函数的用法
文章浏览阅读623次，点赞9次，收藏12次。HDFS，它是一个文件系统，用于存储文件，通过目录树来定位文件；其次，它是分布式的，由很多服务器联合起来实现其功能，集群中的服务 器有各自的角色。。_hadoop、hbase、hive 原理