Hot Backup
1)usage
1@@@@hot mean online.
@@@the hot backup meaning you could copy your datafile to other directory
@@@for save. but one thing, if you want to recovery using these files.
@@@you must use cold recovery operation.
@@@Note: if outage when you are running the hot backup, you must end it first
@@@before you recover instance.
####begin####################################################
[oracle@station3 ~]$ cat hot_backup.sql
#!/bin/sh
sqlplus /nolog << !
conn /as sysdba
alter tablespace system begin backup;
quit
!
cp /u01/app/oracle/oradata/orcl/system01.dbf /home/oracle/system01.dbf
sqlplus /nolog << EOF
conn /as sysdba
alter tablespace system end backup;
quit
EOF
######end##################################################
Hot Backup
原创emperor_majesty 博主文章分类:B_Recovery ©著作权
©著作权归作者所有:来自51CTO博客作者emperor_majesty的原创作品,请联系作者获取转载授权,否则将追究法律责任
下一篇:Logfile Overview

提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
A hot tea
坚持
linux 新手 -
Inline the hot call
【代码】Inline the hot call。
rust inline html github