Because the production database is large, there is not much space left on the hard disk. If RMAN is used for backup, data cannot be stored on the local computer, therefore, you need to back up data to the hard disk of another computer on the network (the hard disk of the directory database) as follows.
Environment: production database Sid: ora
Directory database Sid: Backup
Path for storing backup data: \ backup
1. Change the administrator password of both computers to admin.
2. Change the starting user of the Database Service and listener service of the target database from local SYSTEM account to administrator.
3. shutdown the target database
4. Restart the service of the target database and the listener service.
5. startup target database
The following is a simple test process:
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,200 5, 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 \ 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 \ 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
Test complete!