当前位置：首页 -> AI编程基础 -> 数据库编程

rman备份恢复命令之switch(一)

2014-11-24 16:56:14 · 作者: · 浏览: 5
标签: rman 备份 恢复 命令 switch
rman备份恢复命令之switch
一 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: