因生产数据库比较大,硬盘空间所剩不多,如果用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
测试完毕!