Could you please let me know is there any way to backup and restore Oracle 9i database through Sql Developer.
I've been asked to do it though I am a developer and don't have DBA rights.
Thanks in advance, Savitha
2
-
This question on dba.stackexchange answers your question:Sachin Sharma– Sachin Sharma2013-05-28 09:14:06 +00:00Commented May 28, 2013 at 9:14
-
Oracle backup is painful compared to SQL Server. Oracle permissions can be set up in such a way as you don't have the rights to backup and restore the full database. So you think you have a backup until you try to restore it and then find out you can't restore part of it. As SQL Server gains more market share Oracle will eventually have to make a proper backup.Paul McCarthy– Paul McCarthy2017-09-13 15:24:14 +00:00Commented Sep 13, 2017 at 15:24
Add a comment
|
5 Answers
No. Not really. You should use RMAN to do backup and recovery.
Check out the Backup and Recovery roadmap for where you should learn about 9i backup.
Comments
In Oracles SQL Developer click in the menue bar on Extras-> Database Copy. Worked for me.
answered Jun 24, 2011 at 9:31
Cloudscape Germany
15.9k15 gold badges96 silver badges158 bronze badges
Comments
The GUI to use for backup and recovery is Oracle Enterprise Manager Grid- or Datbase console. To check where OEM is running log on to the database server. Set your environment to the database and run
#> emctl status dbconsole
Comments
It is not possible to do backup & recovery thru sql developer. You should use RMAN.
Comments
You can use the Export Tables and Import Tables actions from the Tools menu item as an alternative to backup and restore, if all you need is to keep a copy of just the data.
