Restore Archivelog


run {
allocate channel ch01 type 'SBT_TAPE';
send 'NB_ORA_CLIENT=mvnowrtdb1,NB_ORA_SERV=nbu-master';
set until time "to_date('05/08/2014 17:00:00','mm/dd/yyyy hh24:mi:ss')";
recover database;
release channel ch01;
}

run {
allocate channel ch01 type 'SBT_TAPE';
send 'NB_ORA_CLIENT=commdb1,NB_ORA_SERV=nbu-master';
restore controlfile from '/c-96354931-20140508-01';
release channel ch01;
}


 bplist -C mvnowrtdb1 -t 4 -R /
 
 
 run {
allocate channel ch01 type 'SBT_TAPE';
send 'NB_ORA_CLIENT=mvnowrtdb2,NB_ORA_SERV=nbu-master';
set until time "to_date('05/08/2014 17:00:00','mm/dd/yyyy hh24:mi:ss')";
recover database;
release channel ch01;
}


run {
allocate channel ch01 type 'SBT_TAPE';
send 'NB_ORA_CLIENT=ltewrtdb1,NB_ORA_SERV=nbu-master';
restore controlfile from '/c-118138165-20140510-00';
release channel ch01;
}

 

select 'alter  rollback segment '|| substr(SEGMENT_NAME, 2, 10)|| ' shrink;'
  from dba_undo_extents where STATUS='EXPIRED'  and rownum <90 order by bytes desc;
 
 
run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=commdb1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=commdb2,NB_ORA_SERV=nbu-master)';
restore controlfile from '/c-96354931-20140508-01';
release channel ch01;
}

rac 两个节点开辟通道:
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=commdb1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=commdb2,NB_ORA_SERV=nbu-master)';


将数据库改为mount状态
RMAN> sql 'alter database mount';
using target database control file instead of recovery catalog
sql statement: alter database mount

目录匹配:
run {
allocate channel ch01 type 'SBT_TAPE';
send 'NB_ORA_CLIENT=commdb1,NB_ORA_SERV=nbu-master';
set newname for database to '/data01/commdb/datafile/%U.dbf';
restore database;
switch datafile all;
release channel ch01;
}

目录分别指定:
run {
allocate channel ch01 type 'SBT_TAPE';
send 'NB_ORA_CLIENT=ossoipltedb11,NB_ORA_SERV=nbu-master';
set newname for datafile 1 to '/data01/prodb1/datafile/system.dbf';
set newname for datafile 2 to '/data01/prodb1/datafile/sysaux.dbf';
set newname for datafile 3 to '/data01/prodb1/datafile/undotbs1.dbf';
set newname for datafile 4 to '/data01/prodb1/datafile/user.dbf';
set newname for datafile 5 to '/data01/prodb1/datafile/example.dbf';
set newname for datafile 6 to '/data01/prodb1/datafile/undotbs2.dbf';
set newname for datafile 7 to '/data01/prodb1/datafile/tbs_tsaip01.dbf';
set newname for datafile 8 to '/data01/prodb1/datafile/tbs_jtoip01.dbf';
set newname for datafile 9 to '/data01/prodb1/datafile/itsm_data01.dbf';
set newname for datafile 10 to '/data01/prodb1/datafile/tbs_tsaip02.dbf';
set newname for datafile 11 to '/data01/prodb1/datafile/tbs_tsaip03.dbf';
restore database;
switch datafile all;
release channel ch01;
}

 

run {
allocate channel ch01 type 'SBT_TAPE';
send 'NB_ORA_CLIENT=ltewrtdb1,NB_ORA_SERV=nbu-master';
set newname for database to '/data01/ltefrdb/dbfile/%U.dbf';
restore database;
switch datafile all;
release channel ch01;
}


run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=commdb1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=commdb2,NB_ORA_SERV=nbu-master)';
send 'NB_ORA_CLIENT=ltewrtdb1,NB_ORA_SERV=nbu-master';
set until time "to_date('05/08/2014 17:00:00','mm/dd/yyyy hh24:mi:ss')";
recover database;
release channel ch01;
}


run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=ltewrtdb1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=ltewrtdb2,NB_ORA_SERV=nbu-master)';
set until time "to_date('05/08/2014 17:00:00','mm/dd/yyyy hh24:mi:ss')";
recover database;
release channel ch01;
}


 run {
set archivelog destination to '/u03/oracle/archivelog';    该路径根据归档日志实际路径设置
 allocate channel ch00 type 'SBT_TAPE';
 send 'NB_ORA_SERV=nbu-master,NB_ORA_CLIENT=commdb2';
 restore archivelog sequence between 222 and 223;
 release channel ch00;
}


startup mount exclusive restrict force;
drop database;


run {
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB1,NB_ORA_SERV=nbu-master)';
set archivelog destination to '/home/oracle';
restore archivelog sequence 73 from tag TAG20140514T010014;
release channel ch01;
}


run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB2,NB_ORA_SERV=nbu-master)';
set archivelog destination to '/home/oracle';
restore archivelog sequence 73 from tag TAG20140514T010014;
release channel ch00;
release channel ch01;
}


run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=mgm-db1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=mgm-db2,NB_ORA_SERV=nbu-master)';
set archivelog destination to '/home/oracle';
restore archivelog from  logseq 70 until logseq 74  thread 2;
release channel ch00;
release channel ch01;
}

RMAN> run {
2> allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=mgm-db1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=mgm-db2,NB_ORA_SERV=nbu-master)';
crosscheck archivelog sequence 73 thread 2;
3> 4> 5> release channel ch00;
6> release channel ch01;
7> }

released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=3059 instance=mgmdb1 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2013112320)

allocated channel: ch01
channel ch01: SID=4541 instance=mgmdb1 device type=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.5 (2013112320)

specification does not match any archived log in the repository

released channel: ch00

released channel: ch01

RMAN>

RMAN> list backup of archivelog sequence 73 thread 2;


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


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
70      337.25M    SBT_TAPE    00:01:55     14-MAY-14     
        BP Key: 70   Status: AVAILABLE  Compressed: NO  Tag: TAG20140514T010014
        Handle: al_77_1_847501214   Media: J03088

  List of Archived Logs in backup set 70
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  2    73      2788195815 13-MAY-14 2795106522 14-MAY-14


RMAN> run {
2> allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=mgm-db1,NB_ORA_SERV=nbu-master)';
3> allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=mgm-db2,NB_ORA_SERV=nbu-master)';
4> set archivelog destination to '/home/oracle';
5> restore archivelog from  logseq 70 until logseq 74  thread 2;
6> release channel ch00;
7> release channel ch01;
8> }

allocated channel: ch00
channel ch00: SID=63 instance=mgmdb1 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2013112320)

allocated channel: ch01
channel ch01: SID=13 instance=mgmdb1 device type=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.5 (2013112320)

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 14-MAY-14

channel ch00: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ch00: restoring archived log
archived log thread=2 sequence=73
channel ch00: reading from backup piece al_77_1_847501214
channel ch01: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ch01: restoring archived log
archived log thread=2 sequence=70
channel ch01: reading from backup piece al_74_1_847414815
channel ch00: ORA-19870: error while restoring backup piece al_77_1_847501214
ORA-19507: failed to retrieve sequential file, handle="al_77_1_847501214", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Failed to open backup file for restore.

channel ch00: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ch00: restoring archived log
archived log thread=2 sequence=74
channel ch00: reading from backup piece al_78_1_847501350
channel ch01: ORA-19870: error while restoring backup piece al_74_1_847414815
ORA-19507: failed to retrieve sequential file, handle="al_74_1_847414815", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Failed to open backup file for restore.

channel ch01: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ch01: restoring archived log
archived log thread=2 sequence=71
channel ch01: restoring archived log
archived log thread=2 sequence=72
channel ch01: reading from backup piece al_75_1_847414937
channel ch00: ORA-19870: error while restoring backup piece al_78_1_847501350
ORA-19507: failed to retrieve sequential file, handle="al_78_1_847501350", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Failed to open backup file for restore.

channel ch01: ORA-19870: error while restoring backup piece al_75_1_847414937
ORA-19507: failed to retrieve sequential file, handle="al_75_1_847414937", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Failed to open backup file for restore.

failover to previous backup

released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/14/2014 11:02:26
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of archived log for thread 2 with sequence 74 and starting SCN of 2795106522 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 73 and starting SCN of 2788195815 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 72 and starting SCN of 2788146915 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 71 and starting SCN of 2788143828 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 70 and starting SCN of 2780540605 found to restore


RMAN> run {
2> allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=ltewrtdb1,NB_ORA_SERV=nbu-master)';
3> allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=ltewrtdb2,NB_ORA_SERV=nbu-master)';
4> set archivelog destination to '/home/oracle';
5> restore archivelog from  logseq 70 until logseq 74  thread 2;
6> release channel ch00;
7> release channel ch01;
8> }

allocated channel: ch00
channel ch00: SID=121 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2013112320)

allocated channel: ch01
channel ch01: SID=125 device type=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.5 (2013112320)

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 14-MAY-14

archived log for thread 2 with sequence 70 is already on disk as file /data01/mgmdb/arch/2_70_839452241.dbf
archived log for thread 2 with sequence 71 is already on disk as file /data01/mgmdb/arch/2_71_839452241.dbf
archived log for thread 2 with sequence 72 is already on disk as file /data01/mgmdb/arch/2_72_839452241.dbf
restore not done; all files read only, offline, or already restored
Finished restore at 14-MAY-14

released channel: ch00

released channel: ch01

================================================================================================
restore archivelog:
***********************************************************************************************
1 restore 70~74:
run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=ltewrtdb1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=ltewrtdb2,NB_ORA_SERV=nbu-master)';
set archivelog destination to '/home/oracle';
restore archivelog from  logseq 70 until logseq 74  thread 2;
release channel ch00;
release channel ch01;
}

run
{
allocate channel ch01 type 'SBT_TAPE';
send 'NB_ORA_CLIENT=MGM-DB1,NB_ORA_SERV=nbu-master';
set archivelog destination to '/home/oracle';
restore archivelog from logseq 181 until logseq 182 thread 1;
release channel ch01;
}

2 restore  one arch:
run
{
allocate channel ch01 type 'SBT_TAPE';
send 'NB_ORA_CLIENT=MGM-DB1,NB_ORA_SERV=nbu-master';
restore archivelog sequence 180 thread 1;
release channel ch01;
}

3 restore from tag:
run {
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB1,NB_ORA_SERV=nbu-master)';
set archivelog destination to '/home/oracle';
restore archivelog sequence 73 from tag ‘TAG20140514T010014’;--?
release channel ch01;
}

run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB2,NB_ORA_SERV=nbu-master)';
set archivelog destination to '/home/oracle';
restore archivelog sequence 73 from tag TAG20140514T010014;
release channel ch00;
release channel ch01;
}


run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=mgm-db1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=mgm-db2,NB_ORA_SERV=nbu-master)';
set archivelog destination to '/home/oracle';
restore archivelog from  logseq 70 until logseq 74  thread 2;
release channel ch00;
release channel ch01;
}

4 restore archivelog between:
run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB2,NB_ORA_SERV=nbu-master)';
set archivelog destination to '/home/oracle';
restore archivelog sequence sequence between 1 and 3 thread1;
release channel ch00;
release channel ch01;
}

5 restore archivelog until:
run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB2,NB_ORA_SERV=nbu-master)';
set archivelog destination to '/home/oracle';
restore archivelog  until logseq 74  thread 2;
release channel ch00;
release channel ch01;
}

6 restore archivelog from:

run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB2,NB_ORA_SERV=nbu-master)';
set archivelog destination to '/home/oracle';
restore archivelog from  logseq 74  thread 2;
release channel ch00;
release channel ch01;
}

7 restore archivelog from sysdate:
run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB2,NB_ORA_SERV=nbu-master)';
set archivelog destination to '/home/oracle';
restore archivelog from time 'sysdate-7';
release channel ch00;
release channel ch01;
}

8 restore archivelog from one:
run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB2,NB_ORA_SERV=nbu-master)';
set archivelog destination to '/home/oracle';
restore archivelog low logseq 80;
release channel ch00;
release channel ch01;
}

9 restore archivelog to one:
run {
allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=MGM-DB2,NB_ORA_SERV=nbu-master)';
set archivelog destination to '/home/oracle';
restore archivelog high  logseq 80;
release channel ch00;
release channel ch01;
}
http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta008.htm
***********************************************************************************
check archivelog
****************************************************************************************
 run {
2> allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=mgm-db1,NB_ORA_SERV=nbu-master)';
allocate channel ch01 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=mgm-db2,NB_ORA_SERV=nbu-master)';
crosscheck archivelog sequence 73 thread 2;
3> 4> 5> release channel ch00;
6> release channel ch01;
7> }

released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=3059 instance=mgmdb1 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2013112320)

allocated channel: ch01
channel ch01: SID=4541 instance=mgmdb1 device type=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.5 (2013112320)

specification does not match any archived log in the repository

released channel: ch00

released channel: ch01

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13750068/viewspace-1161063/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-1161063/

Windows 11 安装 JDK 11:下载、安装、配置环境变量、验证 本文详细介绍了在 Windows 11 系统中安装 JDK 11 的完整流程,包括从 Oracle 官网下载压缩包、解压到自定义目录、配置 JAVA_HOME 与 Path 环境变量,并验证安装是否成功。文章还包含一个专为 JDK 11 新特性设计的测试程序,涵盖 Lambda 表达式 var 语法、HTTP 客户端 API、字符串增强方法等,帮助读者确认安装版本正确无误,适合初学者和需要多版本 JDK 共存的开发者参考。 阅读详情

相关推荐

【实践指南】Wasserstein距离在电力系统鲁棒优化中的核心应用

本文深入探讨了Wasserstein距离在电力系统分布鲁棒优化中的核心应用。针对风电、光伏出力的不确定性,文章阐述了如何利用Wasserstein距离构建模糊集,将复杂的分布鲁棒优化问题转化为可求解的确定性模型,并提供了从理论到代码实现的完整实践指南,有效平衡了系统运行的经济性与鲁棒性。

weixin_29229261的博客 308

oracle 还原归档,ORACLE RMAN 还原归档日志

一.备份所有归档日志文件RMAN>backuparchivelogalldeleteinput;二:restorearchivelog的各种选项1.恢复全部归档日志文件RMAN>restorearchivelogall;2.只恢复5到8这四个归档日志文件RMAN>restorearchivelogfromlogseq5untillogseq8...

weixin_28813803的博客 1958

极具性价比的步进电机驱动芯片-TMC2226/TMC2209使用小结

TMC2226/2209相对于TMC2660C、TMC5160来说,价格低了很多,同时功能并没有太多阉割。对比TMC5160,少了内部加减速曲线,电流足够(Ipeak = 2.8A),相对5160而言功能也很足够,所以毫无疑问TMC2226是极具性价比的步进驱动芯片。

Trinamic_TMC的博客 7029

rman 还原归档日志(restore archivelog)

听说过还原(restore)数据库,表空间及数据库文件,使用归档日志恢复(recover)数据库,表空间,数据库文件。咦,还有还原归档日志这一说法呢?没错,可能我们忽略了还原归档日志这一个过程,原因是还原归档日志通常情况下是oracle在recover时自动完成的。大多数情况下我们是先还原数据库,恢复数据库,打开数据库。实际上在恢复数据库之前有一个动作,那就是还原归档日志,也就是将日志文件还原到缺

乐沙弥的世界 4万+

Vivado ILA调试全攻略:从HDL实例化到Block Design的5个实战技巧

本文全面解析了Vivado集成逻辑分析仪(ILA)的五种核心调试方法,涵盖从HDL代码实例化到Block Design集成的实战技巧。详细对比了不同方法的优缺点与适用场景,并重点介绍了如何利用Debug Hub高效管理多时钟域复杂调试,旨在帮助FPGA开发者精准定位问题,显著提升板级调试效率。

weixin_29214199的博客 379

智能网联汽车电子电气架构(下)

从资产的表现形式, 可以分为数据、 软件、 硬件、 服务等, 而从需要保护的业务过程和活动、 所关注信息的角度, 资产类型可包括基于 ECU 的控制功能、 与特定车辆相关的信息、 车辆状态信息、 用户信息、 配置信息、 特定的软件、 内容等。面向新一代 EEA 的安全需求, 基于芯片提供的 OTP, 或SHE\HSM 的安全存储能力, 实现系统关键数据(身份、 密钥等关键信息) 的安全存储, 保证系统的关键数据不被盗取、 破坏、 改写。结合攻击者的动机与识别出的系统用例, 分析对汽车电子系统可能的攻击。

m0_58838529的博客 1474

【转】恢复archivelog介绍

恢复archivelog介绍(即restore archivelog介绍) 恢复archivelog介绍(即restore archivelog介绍) 作者:George...

ckykdwr884269的博客 704

.NET 8 组件之IOC容器组件

NET 8中的IOC容器组件继承了前几代的优良传统,并在性能、扩展性、灵活性等方面进行了诸多优化,使得它在现代应用开发中依然保持领先地位。通过合理使用IOC容器,开发者可以更高效地管理依赖关系,编写更加模块化、可维护的代码。随着.NET生态的不断发展,IOC容器将继续扮演关键角色,为开发者提供强大的依赖管理功能。

hy_4377的博客 1531

从备份集恢复归档日志的测试与说明

当数据库出现问题,但不需要restore只需recover时,发现要用到的archivelog已经备份并删除了,因为我们备份archivelog一般是采用delete input的,这时先需要restore archivelog...

cqcq2013的博客 257

Windows 10 下 Nacos 3.0.2 单机版保姆级安装教程(含JDK 17配置与MySQL 8.0连接避坑)

本文提供Windows 10下Nacos 3.0.2单机版的详细安装教程,涵盖JDK 17配置、MySQL 8.0连接优化及生产级安全设置。通过步骤详解和常见问题解决方案,帮助开发者快速完成Nacos的安装与配置,确保服务发现与配置管理的高效运行。

weixin_29237635的博客 322

使用 MATLAB/Simulink + Simscape Electrical + SimPowerSystems + Stateflow,构建一个多能互补微电网系统的动态响应仿真模型

本文详细介绍了使用MATLAB/Simulink构建多能互补微电网动态响应仿真模型的方法。文章从系统架构设计入手,包含光伏、风电、柴油发电机、锂电池储能等多种组件,重点讲解了建模过程、控制策略(下垂控制、PLL、SOC管理)和模式切换逻辑(Stateflow)。通过四种典型场景(负荷突增、光伏出力骤降、并网/孤岛切换、电动机启动)的仿真分析,验证了微电网在动态响应中的关键性能指标,并提出了高可靠性设计建议。该模型为微电网的稳定性分析和优化设计提供了有效工具,特别强调了储能系统在快速功率支撑中的重要作用。

amy_mhd的博客 161

RMAN环境下restore归档文件常用命令

摘要:Oracle数据库使用RMAN备份的时候,会把归档日志压成备份集(backup set),备份在disk或者tape上。本文讲述RMAN环境下restore归档文件常用命令。 Oracle数据库使用RMAN备份的时候,会把归档日志压成备份集(backup set),备份在disk或者tape上。 一种场景: 大家都熟悉一种架构RAC+ADG。在该架构下,源库的归档文件清理机制为数据库备份完成后进行清除(参考语句:backup filesperset 20 format ‘al_t%t_s%s_p

db_murphy的博客 1146

基于STM32L4XX 、HAL库的STSPIN32G4三相无刷直流电机(BLDC)驱动应用C语言程序设计

/ 设置PWM模式为6步换相。│PA5-7 ├── SPI ────►│SCK/MISO│ │ 三相桥 │。– 2路电机控制高级定时器(16位,支持6路 PWM 通道)// 60度电气周期对应转速 = 60/(极对数 * 6 * 周期)// 电气角度(0-3599)

PP_Cottage的博客 148

crosscheck restore uncatalog archivelog 检查 恢复 归档日志

How to verify if the archivelogs are on disk or RMAN backup?1. Issue the following RMAN command to check if the archivelogs are on disk: RMAN> crosscheck archivelog from logseq 7057 until logseq 7060 thread 1; If they are not on disk, then you will get

jnrjian的博客 263

文档:亲测可用解决vnc灰屏,黑屏,鼠标大黑叉情况

主要解决vnc-viewer灰屏,黑屏,鼠标大黑叉等现象,详细见文档。

IEM模型,地表粗糙度模拟

利用微波反演土壤水分时候,利用IEM模型可以实现对随机地表的模拟

restore archivelog RAC thread from sequence logseq

crosscheck archivelog from logseq 7057 until logseq 7060 restore archivelog from sequence x1 until sequence x2 thread 1;All UsersWhen there is a gap between the primary and the physical standby databases, and the archive log files are on ASM on both the

jnrjian的博客 542

精雕软件(JDpaint) 5.5 绿色版

精雕软件(JDpaint) 5.5 绿色版精雕软件(JDpaint) 5.5 绿色版精雕软件(JDpaint) 5.5 绿色版

restore archivelog的各种用法

restore archivelog的各种用法 1.备份所有归档日志文件 RMAN> backup archivelog all delete input; Starting backup at 02-JUN-08 current log archived using channel ORA_DISK_1 skipping archive log file D:\ARCHPAU

老代——Oracle不仅是工作,更是兴趣 3153

Statistics and Machine Learning Toolbox

Statistics and Machine Learning Toolbox(带书签),MATLAB统计学习工具

restore archivelog 的用法

restore archivelog 的用法      restore archivelog all;   还原全部归档日志文件      restore archivelog from logseq 27 ;  还原log sequence为27之后的所有归档日志      restore archivelog from logseq 27 until logseq 29; 还

Perry 2699

mysql 归档日志恢复_rman 还原归档日志(restore archivelog)

听说过还原(restore)数据库,表空间及数据库文件,使用归档日志恢复(recover)数据库,表空间,数据库文件。咦,还有还原归档日志这一说法呢?没错,可能我们忽略了还原归档日志这一个过程,原因是还原归档日志通常情况下是oracle在recover时自动完成的。大多数情况下我们是先还原数据库,恢复数据库,打开数据库。实际上在恢复数据库之前有一个动作,那就是还原归档日志,也就是将日志文件还原到缺...

weixin_42524610的博客 1259

rman restore preview 和validate ,preview可以查找到archivelog的范围

Option 2 :runpreview;runvalidate;RMAN> run---.........---Behaviour3。

jnrjian的博客 462

restore archivelog 常用用法

restorearchivelogall;还原全部归档日志文件 restorearchivelogfromlogseq2213;还原logsequence为2213之后的所有归档日志 restorearchivelogfromlogseq2213untillogseq2222;还原logsequ...

weixin_34417200的博客 690

restore archivelog

restore archivelog[@more@]RMAN> run{2> allocate channel c1 type 'sbt_tape';3> set archivelog destination ...

congzhen6220的博客 182

RMAN分批restore/apply archivelog恢复数据库

recoverOptionListSpecifies various recovery options.DELETE ARCHIVELOG [MAXSIZE integer [K|M|G]]Deletes archived lo...

cuantiaowei3015的博客 224

采用RESTORE ARCHIVELOG恢复归档

### BEGIN LOG - DATE: 120723, TIME: 101037 ### ============================================================================================= 1、想“瞎猫碰耗子”,采用from to 和between and均不成功 ==...

weixin_34071713的博客 92

restore archivelog 的一些用法

1.备份所有归档日志文件RMAN> backup archivelog all delete input;第二: restore archivelog 的各种选项1.restore archivelog all 恢复全...

cl5127的博客 411

restore archivelog 的各种用法

1.备份所有归档日志文件 RMAN> backup archivelog all delete input; Starting backup at 02-JUN-08current log archivedusing ...

cucanqi9387的博客 263
上一篇: Bug 5483067: UNSHIPPED LOGS DELETED DELETION POLICY TO APPLIED
下一篇: NEEDS MORE RECOVERY TO BE CONSISTENT ORA-1194 ORA-1547 ORA-1110
cppg67031
博客等级 码龄12年 2粉丝 0原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符  | 博主筛选后可见
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明:

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

余额充值