如何利用RMAN將Database Backup到其他電腦的硬碟上

因生產資料庫比較大,硬碟空間所剩不多,如果用RMAN備份,無法將資料存放在本機電腦,故需將資料備份到網路上另一台電腦的硬碟上(目錄資料庫的硬碟),做法如下.

環境: 生產資料庫 SID : ORA
      目錄資料庫 SID : Backup
      存放備份資料的路徑 : \\backup\backup
1.將兩台電腦administrator的密碼都改成admin
2.將目標資料庫的資料庫Service及listener的service啟動使用者由local system account改為administrator
3.Shutdown目標資料庫
4.重新啟動目標資料庫的Service及listener的service
5.Startup 目標資料庫

以下是簡單的測試過程
C:\>rman target sys/oracle@ora
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Feb 14 14:21:11 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ora (DBID=1200029802)
RMAN> connect catalog rman/rman@backup;
connected to recovery catalog database
RMAN> run{
2> allocate channel c1 type disk;
3> backup datafile 5 format='\\backup\backup\test\%n_%f_%s.dbf';
4> }

allocated channel: c1
channel c1: sid=1645 devtype=DISK

Starting backup at 14-FEB-07
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00005 name=E:\TOOLS\TOOLS01.DBF
channel c1: starting piece 1 at 14-FEB-07
channel c1: finished piece 1 at 14-FEB-07
piece handle=\\backup\BACKUP\TEST\LCZHISXX_5_2.DBF tag=TAG20070214T142155 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 14-FEB-07
released channel: c1

測試完畢!