Restore Archivelog

最新推荐文章于 2022-05-31 11:13:51 发布
最新推荐文章于 2022-05-31 11:13:51 发布
阅读量198 收藏
点赞数
文章标签： 数据库


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/

cppg67031
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
windows下基于be的oracle restore
01-04
- **开启Archivelog模式**：如果数据库运行在Noarchivelog模式，必须先切换到Archivelog模式，才能进行有效的恢复。 - **应用redo log**：在某些情况下，可能需要手动应用redo log以完成恢复。 总的来说，基于BE的...
rman 还原归档日志(restore archivelog)
热门推荐
乐沙弥的世界
07-29 3万+
听说过还原(restore)数据库，表空间及数据库文件，使用归档日志恢复(recover)数据库，表空间，数据库文件。咦，还有还原归档日志这一说法呢？没错，可能我们忽略了还原归档日志这一个过程，原因是还原归档日志通常情况下是oracle在recover时自动完成的。大多数情况下我们是先还原数据库，恢复数据库，打开数据库。实际上在恢复数据库之前有一个动作，那就是还原归档日志，也就是将日志文件还原到缺
因incarnation导致恢复时出现RMAN-06026错误
还不算晕的专栏
06-12 4881
正常恢复控制文件并MOUNT数据库 环境： 生产环境进行备份数据库、控制文件 测试环境在之前执行过异机恢复任务，并进行过RESETLOGS操作，并遗留下每次RESETLOGS后的归档日志。 在使用生产环境的备份进行恢复时，报错： RMAN-06026: some targets not found - aborting restore RMAN-06100: no channel
oracle恢复操作命令详解,学习笔记:Oracle RMAN备份入门 DBA使用rman中关于archivelog操作命令汇总...
weixin_34405261的博客
04-04 602
天萃荷净rman中关于archivelog操作，汇总运维DBA在日常工作中常用于archivelog归档文件的操作命令，含：查看归档，删除归档，备份恢复归档等命令RMAN> list backup of archivelog all;列出所有archive log 备份RMAN> list backup of archivelog from logseq 100 until logse...
nbu还原oracle,NBU异机恢复ORACLE成功版本
weixin_39895977的博客
04-03 402
经过《NBU异机恢复ORACLE(遇到的问题) 》，成功版本如下源端：oracle10grac1 oracle10grac2 RAC+ASM目标端：ora10master server:nbuserver1、在nbuserver的/usr/openv/netbackup/db/altnames目录下创建文件 No.Restrictions2、准备好脚本db_bak.sh，重点注意这里一定要加上归档...
从带库归档备份文件恢复归档日志
Ahern_的博客
05-31 308
从磁带库恢复归档
Oracle 数据库备份与恢复的基本步骤和方法
最新发布
03-29
- **还原redo日志**：`restore archivelog all;` - **切换到RESTORE状态**：`recover database until cancel;`或指定时间点`recover database until timestamp 'YYYY-MM-DD HH24:MI:SS';` - **OPEN数据库**：完成...
ORACLE备份和恢复方案[文].pdf
10-11
restore archivelog all; recover database; sql "alter database open"; release channel c1; } ``` ##### 2. 重做日志文件丢失 - **场景**：某个重做日志文件丢失。 - **步骤**： - 启动数据库并挂载。 -...
VeritasNetBackupOracle的备份和恢复分享.pdf
02-02
RESTORE ARCHIVELOG ALL命令用于恢复所有缺失的归档日志。 7. **数据库恢复**： - 使用RECOVER DATABASE命令，RMAN将应用所有可用的归档日志，使数据库恢复到故障前的状态。 8. **以resetlog打开数据库**： - 在...
Oracle 数据库备份与恢复总结.pdf
10-30
- **归档重做日志的还原**: 使用`restore archivelog;`命令。 - **数据文件副本还原**: 使用`restore datafile;`命令。 - **还原检查与恢复测试**: 使用`report need backup;`命令。 - **从指定的tag恢复**: ...
Oracle RMAN的备份与恢复命令详解
徐彬的进行曲
09-21 225
4.3 Copy 镜像拷贝与恢复     Copy镜像拷贝命令可以创建数据库数据文件、归档重做日志或者控制文件的精确副本。 RMAN 副本与这些文件的区别仅在于名称和（或）位置的区别。功能相当于用户管理的备份恢复中的热备份。备份副本的好处是恢复比较快，恢复时可以不用拷贝，指定新位置即可。     Copy镜像拷贝至少要在mount 状态下运行。     Copy镜像拷贝可作为增量备份的 Le...
oracle指定tag恢复,Oracle RMAN的备份与恢复命令详解
weixin_39813200的博客
04-02 1108
4.3 Copy 镜像拷贝与恢复Copy镜像拷贝命令可以创建数据库数据文件、归档重做日志或者控制文件的精确副本。 RMAN 副本与这些文件的区别仅在于名称和(或)位置的区别。功能相当于用户管理的备份恢复中的热备份。备份副本的好处是恢复比较快，恢复时可以不用拷贝，指定新位置即可。Copy镜像拷贝至少要在mount 状态下运行。Copy镜像拷贝可作为增量备份的 Level 0Oracle10g开始，允...
NBU异机恢复ORACLE出现ORA-19507、ORA-27029和ORA-19511错误
DBA_JohnHuang
10-28 6079
近日在使用NBU对ORACLE数据库进行异机恢复参数文件时出现ORA-19511错误，进行各种原因排查和方法尝试后，终于找到错误原因。在此进行记录，为大家在遇到相同问题时可以更快的得到解决。
rman备份恢复归档日志
liuzhilong的博客
06-04 2047
数据库的恢复需要利用数据库的备份并使用归档日志去追回scn和在备份点以后点更改数据。如果归档日志发生丢失，数据库可以恢复，但还是会发生备份点后的数据丢失的情况，所以备份归档日志也是很重要的。 展示归档 RMAN> list archivelog all; List of Archived Log Copies for database with db_unique_name TEST ===========================================================
RAC 恢复到单实例 ASM 和文件系统方法
jnrjian的博客
04-15 1164
ASM到ASM简单一点 ASM到RPM安装下的oracle，三点要改 datafile rename，arch改变，redo改动 改动太多，后期恢复完 recover完后重建控制文件。 1.set archivelog destination to ''/opt/oracle/arch'; 2.set newname for datafile 3.alter database rename file '+DATA/RAC/ONLINELOG/group_6.311.1102011695' t...
nbu备份软件异机恢复需要注意问题
cucanqi9387的博客
06-20 549
vertais netbackup备份软件在异机恢复oracle数据库时,有以下三个问题,需要注意： (否则会导致恢复不成功) 1.允许客户端恢复,设置如下(nbu软件服务器上操作master server): ...
rman恢复基础操作
Cindy（Berry）的专栏
09-27 699
《三思笔记》--读书笔记
NBU7.0 RMAN 异机恢复 not found in NetBackup catalog
Lixora's DB Home
11-02 4246
问题描述： RMAN>  run { 2>  allocate channel t1 type 'sbt_tape'; 3>  send 'NB_ORA_SERV=netbackup,NB_ORA_CLIENT=hz1'; 4>  restore controlfile to '/oracle11/oradata/control01.ctl' from '/c-3201563006-201
legato ORA-19870 ORA-19507 ORA-27029 ORA-19511
congnen9588的博客
04-12 2120
Legato异机恢复oracle报错，rman没有任何错误日志：ORA-19870: error reading backup piece full_open_IEBDPR01_h7k7ccrn_1575ORA-19507:...
rman restore archive log到新的路径
05-27
RESTORE ARCHIVELOG ALL; ``` 3. 接下来，使用SET命令设置新的恢复路径： ``` SET ARCHIVELOG DESTINATION '<new_path>'; ``` 4. 最后，使用SWITCH命令将归档日志文件切换到新的恢复路径： ``` SWITCH ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值