怎么备份客户端数据库那位高手教教我啊 谢谢了
解决方案 »
- 求教:一个关于isql的问题,恳请各位指教,谢谢了
- PL/SQL触发器的疑问,急!!!!!
- bde连接oracle
- 没看懂这个 rollup 的结果是怎么出来的,求助大虾!
- oracle 8 for Win2K????求
- 为什么我把数据库从一个机器导到另一个机器的时候,会有有的表的记录不能完全插入,有的外键也丢失了,请大家指点一下
- Oracle 如何储存rmvb格式文件呢?
- 动态行转列的代码 编译不过,大家帮帮我啊,着急!
- oracle--视图
- 那位兄弟知道Oracle9i的复制管理员用户名和密码是什么?
- oracle10g在连网和不连网的启动问题
- 如何将oracle 中的 表空间 从 A机 中的oracle10g 移植到 B机的oracle10g 上用
rem script:coldbak.sql
rem date:11.09.2008
rem desc:offline full backup database --connect database
--connect system/manager;
connect admin/admin as sysdba;
--shutdown database
shutdown immediate;
--Copy Data file
host xcopy F:\oracle\oradata\oradb\*.dbf F:bak/H/R;
--Copy Control file
host xcopy F:\oracle\oradata\oradb\*.ctl F:bak/H/R;
--Copy Log file
host xcopy F:\oracle\oradata\oradb\*.log F:bak/H/R;
--startup database
startup;
热备份参考:
rem script:hotbak.sql
rem date:11.09.2008
rem desc:backup all database datafile in archive--connect database
--connect internal/password;
connect / as sysdba;--archive
alter system archive log current;
--startalter tablespace system begin backup;
host xcopy F:\oracle\oradata\oradb\system01.dbf f:\bak2/H/R;
alter tablespace system end backup;alter tablespace cwmlite begin backup;
host xcopy F:\oracle\oradata\oradb\cwmlite01.dbf f:\bak2/H/R;
alter tablespace cwmlite end backup;alter tablespace users begin backup;
host xcopy F:\oracle\oradata\oradb\users01.dbf f:\bak2/H/R;
alter tablespace users end backup;alter tablespace tools begin backup;
host xcopy F:\oracle\oradata\oradb\tools01.dbf f:\bak2/H/R;
alter tablespace tools end backup;alter tablespace indx begin backup;
host xcopy F:\oracle\oradata\oradb\indx01.dbf f:\bak2/H/R;
alter tablespace indx end backup;--alter tablespace drsys begin backup;
--host xcopy F:\oracle\oradata\oradb\drsys01.dbf f:\bak2/H/R;
--alter tablespace drsys end backup;alter tablespace example begin backup;
host xcopy F:\oracle\oradata\oradb\example01.dbf f:\bak2/H/R;
alter tablespace example end backup;--alter tablespace undotbs begin backup;
--host xcopy F:\oracle\oradata\oradb\undotbs01.dbf f:\bak2/H/R;
--alter tablespace undotbs end backup;alter tablespace ts_test begin backup;
host xcopy F:\oracle\oradata\oradb\test01.dbf f:\bak2/H/R;
alter tablespace ts_test end backup;
--end--bak control file
--binary
alter database backup controlfile to 'f:\bak2\controlbinbak.000';
--ascii
alter database backup controlfile to trace;alter system archive log current;