How to back up a database to a hard disk of another computer using RMAN

Source: Internet
Author: User

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!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.