rman 注册归档(arch)的语句
One way of registering a logfile is via the following:
SQL> alter database register logfile<br /> '/var/arch/arch_1_101.arc';
So this is a straightforward way of registering a logfile giving the full path to the logfile. However, what if you have a very large number of logfiles to register, the above does not really scale all that well. Thankfully there is an rman command that enables you to register all logfiles within a directory:
rman> catalog start with '/var/arch';
This can save you a lot of time if you need to register a large number of files.
相关文章 | Related posts:
- Rolling a Standby Forward using an RMAN Incremental Backup Rolling a Standby Forward using an RMAN Incremental Bac […]...
- 【故障诊断】RMAN-06026与ABSOLUTE_FUZZY_CHANGE# 在物理备库上restore datafile时遇到RMAN-06026错误: 如果 […]...
- 了解rman catalog的兼容性 几天前被问到关于rman catalog兼容性的问题,catalog所在数据库版本与目标数据库版本不同会有影响 […]...
- Only ARCH Bgprocess may create archivelog? 我们在学习Oracle入门知识时都会介绍到ARCH归档进程,归档进程ARCH负责将在线重做日志归档,注意ARC […]...
- RMAN CURSOR_SHARING=EXACT脚本 RMAN CURSOR_SHARING=EXACT脚本 CREATE OR REP […]...
- Rman 备份检验功能 RMAN 中 “backup validate database” 语法可以用来扫描数据库中的物理错误,实际 […]...
- Does Rman Backup benefit from Large Pool? 我们在学习Oracle的过程中,或多或少会存在个人对概念的理解错误、误解或者根本是教材编写存在不严谨的地方,这 […]...
- rman hang on SQL*Net message from client 有这样一个问题,平台为HP-UX(B.11.31 U ia64),Oracle版本为10.2.0.4 sing […]...
- Oracle恢复目录的管理使用简要 I. 使用恢复目录存储RMAN备份记录 Oracle 官方建议把恢复目录建议于独立的数据库中。如果把恢复目录与 […]...
- Oracle备份恢复:Rman Backup缓慢问题一例 近日客户报多套10g的数据库在使用NBU磁带备份时出现RMAN FULL BACKUP十分缓慢的问题,这些数据 […]...