oracle 备份
1.首先以 sysdba的身份登录数据库SQL> conn sys/oracle as sysdba
SQL> colname for a50
SQL> select* from v$controlfile; 找到控制文件所在目录
STATUS
-------
NAME
---------------------------------------
F:\ORACLE\ORADATA\AFIS40\CONTROL01.CTL
F:\ORACLE\ORADATA\AFIS40\CONTROL02.CTL
F:\ORACLE\ORADATA\AFIS40\CONTROL03.CTL
SQL> shutdown immediate
SQL> host copy F:\ORACLE\ORADATA\AFIS40\*.*E:\backup
SQL>host copy F:\ORACLE\ORA92\database\*.*E:\backup\database
SQL> startup
完成！
上面的 backupdatabase是事先建好的存放备份的路径
页:
[1]