rman备份恢复命令之switch

最新推荐文章于 2023-12-10 15:08:28 发布
最新推荐文章于 2023-12-10 15:08:28 发布
阅读量1.9k 收藏 6
点赞数 1
分类专栏： Oracle & RMAN 文章标签： oracle 数据库
原文链接：https://blog.51cto.com/jiujian/1140329
版权

文章目录

一、 switch 命令

1. switch命令用途

更新数据文件名为rman下镜像拷贝时指定的数据文件名
更新数据文件名为 set newname 命令指定的名字。

2. switch 命令使用前提条件

rman 必须连接到目标数据库
当switch tablespaces、datafiles、tempfiles时，这些文件必须离线
当switch 整个数据库时，数据库不能open

3. 注意事项

switch…to copy 命令用于rman命令提示符下
switch没有to copy的命令用于run语句块中

4. 语法

第一组

switch dtabase to copy;
switch datafile number|name to copy;
switch tablespace name to copy;

第二组

switch datafile all;
switch datafile number|name;
switch tempfile all;

二、 举例

例一：用switch datafile number to copy 更新数据文件位置和名字

RMAN> backup as copy datafile 8 format '/oracle/CRM/test.dbf';

Starting backup at 2013-02-22 10:06:21
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=/backup/test.dbf
output file name=/oracle/CRM/test.dbf tag=TAG20130222T100621 RECID=14 STAMP=808049181
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2013-02-22 10:06:22

Starting Control File and SPFILE Autobackup at 2013-02-22 10:06:22
piece handle=/backup/c-3599153036-20130222-01 comment=NONE
Finished Control File and SPFILE Autobackup at 2013-02-22 10:06:25

RMAN> sql 'alter tablespace test offline';

sql statement: alter tablespace test offline

RMAN> switch datafile 8 to copy;

datafile 8 switched to datafile copy “/oracle/CRM/test.dbf”

RMAN> report schema;

Report of database schema for database with db_unique_name CRM

List of Permanent Datafiles

File Size(MB) Tablespace RB segs Datafile Name

1 750 SYSTEM *** /oracle/CRM/system01.dbf
2 540 SYSAUX *** /oracle/CRM/sysaux01.dbf
3 100 UNDOTBS3 *** /oracle/CRM/undotbs3.dbf
4 1742 USERS *** /backup/users01.dbf
5 500 POS *** /oracle/CRM/pos.dbf
6 100 ERP *** /oracle/CRM/erp.dbf
7 5 USER01 *** /oracle/CRM/user01.dbf
8 0 TEST *** /oracle/CRM/test.dbf

List of Temporary Files
File Size(MB) Tablespace Maxsize(MB) Tempfile Name

1 218 TEMP 32767 /oracle/CRM/temp01.dbf
2 3072 MYNEWTEMP 40960 /oracle/CRM/newtemp.dbf

例二：用switch tablespace name to copy更新表空间所有数据文件位置和名字

RMAN> backup as copy tablespace pos format '/oracle/%N%f.dbf';
（%N为表空间名、%f为数据文件绝对文件号）

Starting backup at 2013-02-22 10:55:49
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/oracle/CRM/pos.dbf
channel ORA_DISK_2: starting datafile copy
input datafile file number=00009 name=/oracle/CRM/pos2.dbf
output file name=/oracle/POS9.dbf tag=TAG20130222T105549 RECID=18 STAMP=808052153
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:07
output file name=/oracle/POS5.dbf tag=TAG20130222T105549 RECID=19 STAMP=808052179
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:36
Finished backup at 2013-02-22 10:56:25

Starting Control File and SPFILE Autobackup at 2013-02-22 10:56:25
piece handle=/backup/c-3599153036-20130222-03 comment=NONE
Finished Control File and SPFILE Autobackup at 2013-02-22 10:56:28

RMAN> sql 'alter tablespace pos offline';

sql statement: alter tablespace pos offline

RMAN> switch tablespace pos to copy;

datafile 5 switched to datafile copy “/oracle/POS5.dbf”
datafile 9 switched to datafile copy “/oracle/POS9.dbf”

RMAN> report schema;

Report of database schema for database with db_unique_name CRM

List of Permanent Datafiles

File Size(MB) Tablespace RB segs Datafile Name

1 750 SYSTEM *** /oracle/CRM/system01.dbf
2 540 SYSAUX *** /oracle/CRM/sysaux01.dbf
3 100 UNDOTBS3 *** /oracle/CRM/undotbs3.dbf
4 1742 USERS *** /backup/users01.dbf
5 0 POS *** /oracle/POS5.dbf
6 100 ERP *** /oracle/CRM/erp.dbf
7 5 USER01 *** /oracle/CRM/user01.dbf
8 0 TEST *** /oracle/CRM/test.dbf
9 0 POS *** /oracle/POS9.dbf

List of Temporary Files

File Size(MB) Tablespace Maxsize(MB) Tempfile Name

1 218 TEMP 32767 /oracle/CRM/temp01.dbf
2 3072 MYNEWTEMP 40960 /oracle/CRM/newtemp.dbf

例三：用switch dtabase to copy更新数据库所有数据文件位置和名字

RMAN> backup as copy database format '/oracle/CRM/test/%N%f.dbf';

Starting backup at 2013-02-22 11:26:52
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=129 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=192 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/backup/users01.dbf
channel ORA_DISK_2: starting datafile copy
input datafile file number=00001 name=/oracle/CRM/system01.dbf
output file name=/oracle/CRM/test/SYSTEM1.dbf tag=TAG20130222T112653 RECID=52 STAMP=808054107
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:01:41
channel ORA_DISK_2: starting datafile copy
input datafile file number=00002 name=/oracle/CRM/sysaux01.dbf
output file name=/oracle/CRM/test/USERS4.dbf tag=TAG20130222T112653 RECID=53 STAMP=808054182
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:54
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/oracle/POS5.dbf
output file name=/oracle/CRM/test/SYSAUX2.dbf tag=TAG20130222T112653 RECID=54 STAMP=808054193
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:01:11
channel ORA_DISK_2: starting datafile copy
input datafile file number=00003 name=/oracle/CRM/undotbs3.dbf
output file name=/oracle/CRM/test/UNDOTBS33.dbf tag=TAG20130222T112653 RECID=55 STAMP=808054203
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:16
channel ORA_DISK_2: starting datafile copy
input datafile file number=00006 name=/oracle/CRM/erp.dbf
output file name=/oracle/CRM/test/ERP6.dbf tag=TAG20130222T112653 RECID=56 STAMP=808054230
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_2: starting datafile copy
input datafile file number=00009 name=/oracle/POS9.dbf
output file name=/oracle/CRM/test/POS5.dbf tag=TAG20130222T112653 RECID=57 STAMP=808054247
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:58
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/oracle/CRM/user01.dbf
output file name=/oracle/CRM/test/POS9.dbf tag=TAG20130222T112653 RECID=58 STAMP=808054247
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:08
channel ORA_DISK_2: starting datafile copy
input datafile file number=00008 name=/oracle/CRM/test.dbf
output file name=/oracle/CRM/test/USER017.dbf tag=TAG20130222T112653 RECID=59 STAMP=808054250
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:00
output file name=/oracle/CRM/test/TEST8.dbf tag=TAG20130222T112653 RECID=60 STAMP=808054250
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2013-02-22 11:30:51

Starting Control File and SPFILE Autobackup at 2013-02-22 11:30:51
piece handle=/backup/c-3599153036-20130222-06 comment=NONE
Finished Control File and SPFILE Autobackup at 2013-02-22 11:30:59

RMAN> switch database to copy;

datafile 1 switched to datafile copy “/oracle/CRM/test/SYSTEM1.dbf”
datafile 2 switched to datafile copy “/oracle/CRM/test/SYSAUX2.dbf”
datafile 3 switched to datafile copy “/oracle/CRM/test/UNDOTBS33.dbf”
datafile 4 switched to datafile copy “/oracle/CRM/test/USERS4.dbf”
datafile 5 switched to datafile copy “/oracle/CRM/test/POS5.dbf”
datafile 6 switched to datafile copy “/oracle/CRM/test/ERP6.dbf”
datafile 7 switched to datafile copy “/oracle/CRM/test/USER017.dbf”
datafile 8 switched to datafile copy “/oracle/CRM/test/TEST8.dbf”
datafile 9 switched to datafile copy “/oracle/CRM/test/POS9.dbf”

RMAN> sql 'alter database open';

sql statement: alter database open

SQL> select file#,name,status from v$datafile;

FILE# NAME STATUS

 1 /oracle/CRM/test/SYSTEM1.dbf       SYSTEM
 2 /oracle/CRM/test/SYSAUX2.dbf       ONLINE
 3 /oracle/CRM/test/UNDOTBS33.dbf      ONLINE
 4 /oracle/CRM/test/USERS4.dbf       ONLINE
 5 /oracle/CRM/test/POS5.dbf        ONLINE
 6 /oracle/CRM/test/ERP6.dbf        ONLINE
 7 /oracle/CRM/test/USER017.dbf       ONLINE
 8 /oracle/CRM/test/TEST8.dbf        ONLINE
 9 /oracle/CRM/test/POS9.dbf        ONLINE

例四：用switch tempfile all更新所有临时数据文件位置和名字

SQL> select file#,name,status from v$tempfile;

FILE# NAME STATUS

1 /oracle/CRM/temp01.dbf ONLINE
2 /oracle/CRM/newtemp.dbf ONLINE

语句如下：

startup force mount
run{
set newname for tempfile 1 to '/oracle/CRM/test/temp01.dbf';
set newname for tempfile 2 to '/oracle/CRM/test/temp02.dbf';
switch tempfile all;
alter database open;
}

执行过程如下：

RMAN> startup force mount

run{
set newname for tempfile 1 to '/oracle/CRM/test/temp01.dbf';
set newname for tempfile 2 to '/oracle/CRM/test/temp02.dbf';
switch tempfile all;
alter database open;
}

Oracle instance started
database mounted

Total System Global Area 1252663296 bytes

Fixed Size 2226072 bytes
Variable Size 1006635112 bytes
Database Buffers 234881024 bytes
Redo Buffers 8921088 bytes

RMAN> 2> 3> 4> 5> 6>

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /oracle/CRM/test/temp01.dbf in control file
renamed tempfile 2 to /oracle/CRM/test/temp02.dbf in control file

database opened

RMAN> report schema;

Report of database schema for database with db_unique_name CRM

List of Permanent Datafiles

File Size(MB) Tablespace RB segs Datafile Name

1 750 SYSTEM *** /oracle/CRM/test/SYSTEM1.dbf
2 540 SYSAUX *** /oracle/CRM/test/SYSAUX2.dbf
3 100 UNDOTBS3 *** /oracle/CRM/test/UNDOTBS33.dbf
4 1742 USERS *** /oracle/CRM/test/USERS4.dbf
5 500 POS *** /oracle/CRM/test/POS5.dbf
6 100 ERP *** /oracle/CRM/test/ERP6.dbf
7 5 USER01 *** /oracle/CRM/test/USER017.dbf
8 1 TEST *** /oracle/CRM/test/TEST8.dbf
9 10 POS *** /oracle/CRM/test/POS9.dbf

List of Temporary Files

File Size(MB) Tablespace Maxsize(MB) Tempfile Name

1 218 TEMP 32767 /oracle/CRM/test/temp01.dbf
2 3072 MYNEWTEMP 40960 /oracle/CRM/test/temp02.dbf

例五：用switch datafile all更新表空间所有数据位置和名字

语句：

run{
sql 'alter tablespace pos offline immediate';
set newname for datafile '/oracle/CRM/test/POS5.dbf' to '/oracle/CRM/pos1.dbf';
set newname for datafile '/oracle/CRM/test/POS9.dbf' to '/oracle/CRM/pos2.dbf';
restore tablespace pos;
switch datafile all;
recover tablespace pos;
sql 'alter tablespace pos online';
}

执行过程如下：

RMAN> run{
2> sql 'alter tablespace pos offline immediate';
3> set newname for datafile '/oracle/CRM/test/POS5.dbf' to '/oracle/CRM/pos1.dbf';
4> set newname for datafile '/oracle/CRM/test/POS9.dbf' to '/oracle/CRM/pos2.dbf';
5> restore tablespace pos;
6> switch datafile all;
7> recover tablespace pos;
8> sql 'alter tablespace pos online';
9> }

sql statement: alter tablespace pos offline immediate

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 2013-02-22 15:18:37
using channel ORA_DISK_1
using channel ORA_DISK_2

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 00005 to /oracle/CRM/pos1.dbf
channel ORA_DISK_1: restoring datafile 00009 to /oracle/CRM/pos2.dbf
channel ORA_DISK_1: reading from backup piece /backup/20130222_hho2k7jn_1_1
channel ORA_DISK_1: piece handle=/backup/20130222_hho2k7jn_1_1 tag=TAG20130222T145756
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 2013-02-22 15:19:03

datafile 5 switched to datafile copy
input datafile copy RECID=72 STAMP=808067944 file name=/oracle/CRM/pos1.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=73 STAMP=808067944 file name=/oracle/CRM/pos2.dbf

Starting recover at 2013-02-22 15:19:04
using channel ORA_DISK_1
using channel ORA_DISK_2

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 2013-02-22 15:19:05

sql statement: alter tablespace pos online

RMAN> report schema;

Report of database schema for database with db_unique_name CRM

List of Permanent Datafiles

File Size(MB) Tablespace RB segs Datafile Name

1 750 SYSTEM *** /oracle/CRM/test/SYSTEM1.dbf
2 540 SYSAUX *** /oracle/CRM/test/SYSAUX2.dbf
3 100 UNDOTBS3 *** /oracle/CRM/test/UNDOTBS33.dbf
4 1742 USERS *** /oracle/CRM/test/USERS4.dbf
5 500 POS *** /oracle/CRM/pos1.dbf
6 100 ERP *** /oracle/CRM/test/ERP6.dbf
7 5 USER01 *** /oracle/CRM/test/USER017.dbf
8 1 TEST *** /oracle/CRM/test/TEST8.dbf
9 10 POS *** /oracle/CRM/pos2.dbf

叼辣条闯天涯
关注
  • 1
    点赞
  • 踩
  • 6
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
使用RMAN在线移动数据文件
cqszpx的博客
06-17 163
查看数据库的数据文件路径存在异常，全都放在了空间很小的目录下这时在暂时不能停机的情况下要移动数据文件，可以通过RMAN来实现数据文件的offline和online 1.首先备份目标数据文件： RMAN> backup as copy datafile 10 format ' /data/orcl/oradata/foruse01.dbf'; Starting backup at 11-JUN-21 using channel ORA_DISK_1 channel ORA_DISK_1: startin
rman备份恢复实例
04-24
根据提供的文件内容，本文将详细解释RMAN（Recovery Manager）在Oracle数据库...以上就是RMAN备份与恢复的核心流程和技术要点。通过这些步骤，可以有效地管理Oracle数据库的备份与恢复过程，确保数据的安全性和可靠性。
rman 异地恢复，备份路径不一样时数据库恢复
10-26
rman 异地恢复，备份路径不一样时数据库恢复
RMAN switch 命令 及使用back as copy 和switch datafile迁移存储数据
viviliving的专栏
07-04 2773
SWITCH命令详解 Purpose：目的，即使用switch命令能做什么 1.将数据库，表空间或数据文件的文件名更新为指定文件可用的最新映像副本 2.在run块中发出set netname后在控制文件中更新指定的文件名信息 A SWITCH is equivalent to the SQL statement ALTER DATABASE RENAME FILE: ...
关于RMAN恢复中的switch database …
babymouse1212的博客
05-02 594
After the RESTORE command but before the RECOVER command in your RUN  block, use a SWITCH command to update the control file with the new  filenames of the datafiles. The SWITCH command is equivalent
rman备份还原亲测成功
11-20
- 恢复操作，可能涉及`switch`、`recover`等命令。 在实际应用中，遇到问题可参照提供的压缩包文件进行操作，或者直接联系提供者寻求帮助。RMAN的学习和实践是Oracle DBA必备技能之一，通过不断实践和学习，可以更...
Oracel之联机备份和恢复.pdf
07-11
完成备份后，若需恢复，可以利用这些备份文件，根据具体情况执行相应的恢复操作，例如使用RMAN（恢复管理器）或直接替换备份文件。在恢复过程中，可能需要使用RESTORE和RECOVER命令，具体步骤会根据实际的备份策略和...
LINUX-下ORACLE利用rman备份迁移数据库.doc
10-12
1. **RMAN备份**： - RMAN可以通过命令行运行，用于创建数据库的完整备份、增量备份或差异备份。 - 在示例中，`run`块被用来分配通道（channel），如`channel c1 device type disk`，这指定了一个名为c1的通道，并...
Oracle（2-13） RMAN Complete Recove
最新发布
不会编程的猫星人
12-10 409
RMAN Complete Recove RMAN完全恢复
RMAN备份恢复数据文件找不到
sinat_36757755的博客
04-03 1541
最近在隔离环境进行数据库RMAN备份恢复的时候，遇到了恢复数据文件找不到导致恢复异常终止的情况，整理了当时的问题分析情况以及修复方法。 问题复现: 执行rman份恢复，恢复到时间点2022-04-02 17:06:00 run{ allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; allocate channel ...
重庆思庄oracle技术分享-使用RMAN在线移动数据文件
duanweifang的博客
02-25 89
查看数据库的数据文件路径存在异常，全都放在了空间很小的目录下这时在暂时不能停机的情况下要移动数据文件，可以通过RMAN来实现数据文件的offline和online 1.首先备份目标数据文件： RMAN> backup as copy datafile 10 format ‘/data/orcl/oradata/foruse01.dbf’; Starting backup at 11-JUN-21 using channel ORA_DISK_1 channel ORA_DISK_1: startin
oracle配置并发备份,Oracle RMAN 备份详解（三）
weixin_32260467的博客
04-15 527
三、备份的其它特性1.并发：主要用于提高备份的速度，可以分为手动并发或自动并发手动并发：通过分配多个通道并将文件指定到特定的通道RMAN> run {2> allocate channel ch1 device type disk;3> allocate channel ch2 device type disk;4> allocate channel ch3 devi...
rman set newname switch 用法
cucanqi9387的博客
12-20 325
前提是已经有个backup tablespace tools 备份了 set newname 的作用是恢复到一个新的路径 switch 做切换把新路径文件写到控制文件中 恢复到一个新的路径 C:\Documents an...
oracle 恢复中的switch datafile all是什么意思
weixin_30339969的博客
03-24 1656
使用rman进行恢复时，如果使用了set name修改文件路径，那么恢复后，控制文件里面的信息是没有修改该的，如果要同步控制文件的信息那么就需要使用 switch datafile allall这个可以写文件号的，all表示所有使用set name的都一起保存https://docs.oracle.com/cd/B19306_01/backup.102/b14192/recov004.htm#st...
使用switch database to copy快速复制数据库
w1346561235的博客
03-06 4165
1,  源库switch logfile，checkpoint，shutdown； 2,  源库startup restrict;shutdown immediate;startup mount; 3,  rman target / ;backup as copy database; 4,  新库restore spfile,  controlfile,   catalog 备份片,  st
Oracle 11g R2 rac通过rman 恢复到单实例数据库
weiwang的专栏
01-23 7848
生产环境是2个节点的rac + dataguard（物理备库也是两个节点的rac），通过rman每天进行备份，现在需要定期对生产库进行恢复操作 恢复步骤如下： 1.      把生产库的备份拷贝到目标端 建立存放备份的目录修改目录属主属组 mkdir /oracle/backup chown oracle:oinstall /oracle/backup 2.      拷贝备份到目标端
单机rman异机恢复
打工人的博客
11-03 277
因项目需要，要将测试库恢复到另一台服务器上 测试库备份 RMAN> backup format '/u01/app/backup/epmdss/FULLBAK_%d_%T_%s_%p' tag db_full_bak database include current controlfile; RMAN> backup format '/u01/app/backup/epmdss/init_%d_%T_%s_%p' tag initpara_bak spfile; 1.恢复参数文件、控
Oracle数据库备份与恢复实战指南
在数据库发生故障时，用户管理的备份和RMAN备份能快速恢复到不同时间点的数据。根据SCN或备份集进行恢复操作，RMAN提供了详细的恢复步骤和选项，以便在灾难发生后尽快恢复服务。 总结来说，Oracle备份与恢复基础...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值