Home » RDBMS Server » Backup & Recovery » Logical backups (Oracle10g,Linux)
Logical backups [message #333928] Mon, 14 July 2008 22:14 Go to next message
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member

I need to export the whole databases and import into other database.
The source database has many schema. I have exported dumps based on the schema wise and import into target databases using logical backup.I think,it is time lengthly process.

What is the easiest way to do the backup and restore?

Re: Logical backups [message #333929 is a reply to message #333928] Mon, 14 July 2008 22:18 Go to previous messageGo to next message
Messages: 25581
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow Posting Guideline as stated above

Too few details in post & too many options depending unstated requirements

>What is the easiest way to do the backup and restore?
RMAN full backup & restore

[Updated on: Mon, 14 July 2008 22:18] by Moderator

Report message to a moderator

Re: Logical backups [message #337722 is a reply to message #333929] Thu, 31 July 2008 19:07 Go to previous message
Messages: 506
Registered: March 2005
Senior Member
cloning through RMAN is the easy way to make test DB

check the attachment for this purpose ... enjoy Laughing

I Always Admire the Stones that come in my way because they later become my Milestones
Previous Topic: Creating Clone database manually
Next Topic: Recovery catalog maintenance
Goto Forum:

Current Time: Thu Aug 24 00:09:15 CDT 2017

Total time taken to generate the page: 0.05230 seconds