1.冷备份
shutdown database
backup every datafile , control fiel ,redo log file ( maybe intialfile also)2. 热备份
用export 命令(backup and recovery is the biggest issue in oracle , I have to suggest to take
some oracle book ) .
shutdown database
backup every datafile , control fiel ,redo log file ( maybe intialfile also)2. 热备份
用export 命令(backup and recovery is the biggest issue in oracle , I have to suggest to take
some oracle book ) .
是将数据库中所有的表都备份下来了么?那恢复时,是否要先要将表结构建好,然后在倒入呢?
是将数据库中所有的表都备份下来了么?是,还有其他所有的数据库对象那恢复时,是否要先要将表结构建好,然后在倒入呢?不用
是导出整个数据库,不仅仅是表结构。
逻辑备份就是exp物理备份包括冷备份和联机备份(热备份),冷备份就是在数据库完全DOWN下来时把数据文件、控制文件、INIT文件及密码文件进行OS级的复制;联机备份是在数据库运行期间用命令:alter tablespace tablespacename begin backup;
OS级的复制
alter tableepace tablespacename end backup;