关于RMAN恢复中的switch database …
来源:互联网 发布:尔雅网络课程怎么快进 编辑:程序博客网 时间:2024/06/05 19:04
After the RESTORE command but before the RECOVER command in yourRUN
block, use a SWITCH command to update the control file with thenew
filenames of the datafiles. The SWITCH command is equivalent tothe
SQL statement ALTER DATABASE RENAME FILE. SWITCH DATAFILE ALLupdates
the control file to reflect the new names for alldatafiles for
which a SET NEWNAME has been issued in the RUNblock.
RUN
{
SQL 'ALTER TABLESPACE users OFFLINEIMMEDIATE';
SQL 'ALTER TABLESPACE tools OFFLINEIMMEDIATE';
# specify the new location for eachdatafile
SET NEWNAME FOR DATAFILE '/olddisk/users01.dbf'TO
'/newdisk/users01.dbf';
SET NEWNAME FOR DATAFILE '/olddisk/tools01.dbf'TO
'/newdisk/tools01.dbf';
# to restore to an ASM disk group named dgroup,use:
# SET NEWNAME FOR DATAFILE'/olddisk/trgt/tools01.dbf'
# TO '+dgroup';
RESTORE TABLESPACE users, tools;
SWITCH DATAFILE ALL; # update control file withnew filenames
RECOVER TABLESPACE users, tools;
}
block, use a SWITCH command to update the control file with thenew
filenames of the datafiles. The SWITCH command is equivalent tothe
SQL statement ALTER DATABASE RENAME FILE. SWITCH DATAFILE ALLupdates
RUN
{
}
0 0
- 关于RMAN恢复中的switch database …
- 关于alter system switch lo…
- RMAN-20004: target database name…
- RMAN 完全恢复
- 实验1 :关于FLASHBACK DATABASE …
- RMAN 恢复实际操作(模拟数据文件…
- 转帖:完整的ORACLE RMAN 备份恢复…
- 关于alter database open resetlog…
- RMAN - 备份异机恢复
- Rman运行recover database&nb…
- ORACLE 10G R2 RMAN学习笔记3(恢复…
- Oracle Database …
- rman 基于时间的不完全恢复
- 10g RAC库用rman 的方式备份并恢复…
- RMAN - "丢失控制文件的恢复"
- Manage Database Projects With Vi…
- Microsoft JET Database Engine 错…
- 关于PL/SQL与Oracle Database 12c …
- 数据库服务端的字符集
- 66. Plus One
- Linux 解压cpio文件
- 实现Fragment->ViewPager->Fragment嵌套,并保存内层Fragment view 状态
- SMON: Restarting fast_start para…
- 关于RMAN恢复中的switch database …
- HTTP error 500 Internal server e…
- ORA-16146: STANDBY DESTINATION C…
- sqlldr加载 数据文件的字段超出最…
- 恢复删除的view
- 淘宝、天猫用的Android框架V-Layout,赶紧收藏
- Linux Shell——流程控制
- ASM转文件系统方法四种方法
- CoordinatorLayout高级用法-自定义Behavior