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

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?


Thanks,
Michael.

Report message to a moderator

Re: Logical backups [message #333929 is a reply to message #333928] Mon, 14 July 2008 22:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
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
sunil_v_mishra
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

Report message to a moderator

Previous Topic: ORA-00312: online log 1 thread
Next Topic: Clone Database Using RMAN without Recover Catalog
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 12:26:39 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.