Home » RDBMS Server » Backup & Recovery » Logical backup (oracle 9i, Linux , windows 2000 professional)
Logical backup [message #287912] Fri, 14 December 2007 00:57 Go to next message
Messages: 30
Registered: December 2007
Location: DELHI, INDIA

Dear all,
Can we take logical backup using RMAN ? If yes , then please give me tutorial. Is there any alternative option taking Logical backup , besides Export/Import.

Re: Logical backup [message #287915 is a reply to message #287912] Fri, 14 December 2007 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 65133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ No. RMAN is physical backup
2/ DataPump, SQL*Plus, Excel...

Re: Logical backup [message #289589 is a reply to message #287912] Mon, 24 December 2007 03:24 Go to previous message
Messages: 20
Registered: November 2007
Location: Australia
Junior Member
Do you actually want a logical backup or to be able to check that your database is logically consistent?

If you are checking for logical consistency you can do this via RMAN with
RMAN> backup database validate check logical;

also, if you use export, beware that a direct path export will not report logical corruptions. So you can potentially re-import logical corruptions back into your database with an export using direct=y.

Previous Topic: Corrupted Blocks
Next Topic: rman backup error???
Goto Forum:

Current Time: Wed Aug 16 08:30:24 CDT 2017

Total time taken to generate the page: 0.15092 seconds