database 如何使用sql developer备份和恢复数据库（oracle 9i）
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4363782/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
how to backup and restore database(oracle 9i ) using sql developer
提问by Savitha
Could you please let me know is there any way to backup and restore Oracle 9i database through Sql Developer.
请问有没有办法通过Sql Developer备份和恢复Oracle 9i数据库。
I've been asked to do it though I am a developer and don't have DBA rights.
尽管我是一名开发人员并且没有 DBA 权限，但我被要求这样做。
Thanks in advance, Savitha
提前致谢，萨维莎
回答by Matthew Watson
No. Not really. You should use RMAN to do backup and recovery.
不，不是。您应该使用 RMAN 进行备份和恢复。
Check out the Backup and Recovery roadmapfor where you should learn about 9i backup.
查看备份和恢复路线图，了解您应该在哪里了解 9i 备份。
回答by stevek
In Oracles SQL Developer click in the menue bar on Extras-> Database Copy.Worked for me.
在 Oracles SQL Developer 中，单击“Extras-> Database Copy.对我来说有效”菜单栏。
回答by victorvartan
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.
如果您只需要保留数据的副本，您可以使用“工具”菜单项中的“导出表”和“导入表”操作作为备份和恢复的替代方法。
回答by Rob van Laarhoven
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
用于备份和恢复的 GUI 是 Oracle Enterprise Manager Grid 或 Database 控制台。要检查 OEM 运行的位置，请登录到数据库服务器。将您的环境设置为数据库并运行
#> emctl status dbconsole
回答by Chandra Bhushan
It is not possible to do backup & recovery thru sql developer. You should use RMAN.
无法通过 sql 开发人员进行备份和恢复。您应该使用 RMAN。
