Comparison of the measured data of Rman transfer data and Exp/imp transfer

Compare | data
As the project needs to regularly export the customer's site data to the company's development environment, as the customer site data volume continues to increase, the original

The export import method that you use takes more and more time, so test the efficiency of Rman and verify that you can use recovery Rman

method to replace the previous Exp/imp method. I thought about using the method of transferring table space, but since we usually create a database

A large data file is created for the table space used by the business, so the steps to transfer the copy data file in the table space will cost

For a long time, so I decided to test the Rman.

Test Purpose:
Implement data transfer for JHJKREC users.

Test on the 10.101.48.71 machine.
Test environment:
p42.8g single cpu,1g memory, 80G single hard drive, Windows server,oracle817

The total size of the data file associated with the JHJK user is: 21.4G
Where the total size of the Jhjkrec user's object is: 2.1G

1. Rman for full backup, spents 20 minutes, generate file size 5.47G
Exp as Jhjkrec user data export, spents 2 minutes 20 seconds, generate file size 546M

2. Rman for data recovery, spents 23 minutes (including restore data files, recover database)
IMP for JHJKREC user data import, spents 55 minutes

3. Rman backup needs to shut down the database and start the database to mount State in non-archive mode
EXP does not need to shut down the database in non-archive mode, but the datasheet itself is inconsistent

Conclusion:
The time that the Rman backup is significantly longer than exp, and the files backed up are much larger than the exp files
But the time to recover is less than the time required by IMP.

With Rman recovery, you also need to back up the control files, and because of the sqlplus mode, you also need to check the maximum SCN that is currently recoverable, then recover the database until change SCN in the file, and then alter DATABASE open Resetlogs, the entire operation than Exp/imp cumbersome, for the field business staff may be more difficult, so use Rman or use export import for data transfer, or a matter of opinion.

The following are the commands that are used in Rman and export imports in the test, and are basically not optimized.

Backup script for Rman:
@ @connect. Rcv
# Backup Up database at the full level
#
Shutdown immediate;
startup Mount;
run{
Allocate channel D1 type disk;
Set limit channel D1 Kbytes 2097150;
Backup full Database
Format ' E:\rman_bak\dbfull_%d_%s_%p_%t '
tag= ' Dbfull ';
Release channel D1;
}
ALTER DATABASE open;
Exit

Rman's recovery script:
@ @connect. Rcv
Shutdown immediate;
startup Mount;
Run {
SQL "alter session set Nls_date_language=american";
SQL "alter session set nls_date_format= ' Yyyy-mm-dd hh24:mi:ss '";
Set until time ' 2004-9-7 15:30:00 ';
Allocate channel CH1 type disk;
Restore database;
Release channel CH1;
}
Exit

Exp Script:
Userid=jhjkrec/jhjkrec
File=e:\rman_bak\jhjkrec.dmp
Owner=jhjkrec
Direct=n
Compress=n
feedback=1000

Imp's script:
Userid=jhjkrec/jhjkrec
File=e:\rman_bak\jhjkrec.dmp
Ignore=y
Fromuser=jhjkrec
Touser=jhjkrec
feedback=1000