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
Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA
Member

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.

Thanks
Vivek
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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1/ No. RMAN is physical backup
2/ DataPump, SQL*Plus, Excel...

Regards
Michel
Re: Logical backup [message #289589 is a reply to message #287912] Mon, 24 December 2007 03:24 Go to previous message
halfydba
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: Tue Dec 24 11:25:29 CST 2024