CharlesSHill
asked on
Difference between RMAN and EXP
On one of our systems a script is run each day which contains an EXP with
grants=y
full=y
rows=y
Some time later a RMAN is scheduled with
connect target xxx/xxx@xxx
configure retention policy to redundancy 1;
configure controlfile autobackup on;
configure device type disk parallelism 1;
run {
backup database
format 'D:\oracle\backup\xxx\DB_% s_%p.bck';
backup
(archivelog all format 'D:\oracle\backup\xxx\ARC_ %s_%p.bck' delete input);
delete obsolete;
}
sql 'alter system switch logfile';
sql 'alter system switch logfile';
sql 'alter system switch logfile';
sql 'alter database backup controlfile to trace';
sql "alter database backup controlfile to ''D:\oracle\backup\xxx\Con trol.ctl'' reuse";
The above are done for database backup/recovery purposes.
The EXP runs at 18:00 and the RMAN at 01:00, the resulting DMP file from EXP
is orders smaller than the disk space that RMAN consumes with its backups.
What I want to know is:
1. what the differences are between EXP and RMAN?
2. Why would I choose one over the other?
3. Does it make sense to do both?
4. Is there some URL where I can get a short description of both EXP and RMAN
grants=y
full=y
rows=y
Some time later a RMAN is scheduled with
connect target xxx/xxx@xxx
configure retention policy to redundancy 1;
configure controlfile autobackup on;
configure device type disk parallelism 1;
run {
backup database
format 'D:\oracle\backup\xxx\DB_%
backup
(archivelog all format 'D:\oracle\backup\xxx\ARC_
delete obsolete;
}
sql 'alter system switch logfile';
sql 'alter system switch logfile';
sql 'alter system switch logfile';
sql 'alter database backup controlfile to trace';
sql "alter database backup controlfile to ''D:\oracle\backup\xxx\Con
The above are done for database backup/recovery purposes.
The EXP runs at 18:00 and the RMAN at 01:00, the resulting DMP file from EXP
is orders smaller than the disk space that RMAN consumes with its backups.
What I want to know is:
1. what the differences are between EXP and RMAN?
2. Why would I choose one over the other?
3. Does it make sense to do both?
4. Is there some URL where I can get a short description of both EXP and RMAN
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
u can use RMAN for recovery to the sertan point of time
2. Why would I choose one over the other?
if user drop table and calls you to get it back you can use IMP (import to get this table back from EXP snapshot), but it will not have any transactions that happen after that snapshot was taken. RMAN can help you with this problem too, but hole database will need to be restored on the diferent server to the time before table drop happen.
3. Does it make sense to do both?
export is an additional seafty mesure and you need to make a choice if you want it or not.
4. Is there some URL where I can get a short description of both EXP and RMAN
http://oraclesvca2.oracle.com/docs/cd/B14117_01/server.101/b10739/dba.htm#i1007021
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10742/backrest.htm#i1004902