A long-distance backup (oracle in machine room, backup machine in the company) with the following script
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */
@ echo off

: : backup database file to the local (file path to create good beforehand,)

Exp abc123/abc123 @ * *. Abc.com/orcl owner=abc123 file=d: \ backup \ oracle % date: date: ~ 0, 4 % % % % ~ 5, 2 date: ~ 8, 2 %. The DMP log=d: \ backup \ oracle % date: date: ~ 0, 4 % % % % ~ 5, 2 date: ~ 8, 2 %. The log

: : delete the last modified date under the directory the file before 10 days of days (d - 10 can modify)

Stored forfiles/p "d: \ " - 2 "CMD/c/c/d echo deleting @ the file... & & Del/f @ path
"/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */

In the local use EXPDP backup is probably less than 40 g (local backup for almost 2 hours), with exp backups for more than 20 hours haven't finished, the file size is about 34 g
Remote backup machine (virtual machine), oracle was open, and a test environment of ERP open, below is the hardware configuration


How can quickly to different backup, the backup of the old and slow, all the whole day, haven't finish backup,
The script can be optimized? Or have a better script? The other way?
Thank you very much!

CodePudding user response:

Backed up using rman ah, of course

CodePudding user response:

Too slow, 40 g in 2 hours, said "no" in the past, estimation is your storage performance is poor,

CodePudding user response:

refer to the second floor selling fruit net reply:

is too slow, 40 g in 2 hours, said "no" in the past, estimation is your storage performance is poor,

Remember wrong, it is 1 hour,
Generally how much time 40 g backup storage performance is better?
Hardware aspects don't know whether there is any promotion? In order to improve performance,

A long-distance backup how can I improve? Thank you moderator!

CodePudding user response:

Use expdp ready to come out, or just have a NFS for above is not faster

CodePudding user response:

reference freesp reply: 3/f

Quote: refer to the second floor selling fruit net reply:

Too slow, 40 g in 2 hours, said "no" in the past, estimation is your storage performance is poor,

Remember wrong, it is 1 hour,
Generally how much time 40 g backup storage performance is better?
Hardware aspects don't know whether there is any promotion? In order to improve performance,

A long-distance backup how can I improve? Thank you moderator!

If the local backup, then an hour at least 1 t barely pass, the situation is complicated, the remote to see your network, the bandwidth, whether monopoly, etc.,

CodePudding user response:

Look at your local use exp backup also need two hours is a bit slow, if allow local export, can change to use expdp, if only a remote, try to open direct=y, can speed up, to a certain extent

CodePudding user response:

Backup and security a truth. Easy to use, poor safety, simple EXP backup, recovery is troublesome, can consider to DG

CodePudding user response:

Compression using RMAN backup will be much smaller, copy is hurry in the past