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: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>