Oracle Offline Backup
来源:互联网 发布:数据库应用系统开发 编辑:程序博客网 时间:2024/05/12 22:48
offline backup
The main files:
1.Control file: the core file that controls the database instance and it's service. It's path can be got by "v$controlfile";
2.Redo Loger file:It's path can be got by "v$logfile";
3.Data file:the file that represents the tables' spaces. It's patht can be got by "v$datafile" and "v$tablespace";
4.Core configuration file:It's path can be got by "SHOW PARAMETER pfile";
The first 3 files are the files of the database instance. But the 4th file,"pfile.ORA" is the starting configuration file of the ORACLE database software.
In the real enterprise's environment, in order to get the better speed, DAB will save the DB file to different disks. We will need to check the DB files path by those previous COMMAND.
Steps:
1.Use the super administrator to login: COMM sys/change_on_install as SYSDBA;
2.Search all the pathes of the control files(.CTL) : select * from v$controlfile;
3.Search all the pathes of the REDO LOG files(.LOG) : select * from v$logfile;
4.Search all the pathes of the TABLES' SPACES files(.DBF) : select * from v$tablespace; select * from v$datafile;
5.Search all the pathes of the "pfile" files(.ORA) : SHOW PARAMETER PFILE;
6.TURN OFF the database's instance : SHUTDOWN IMMEDIAT
7.COPY or Backup all the previous files;
8.Start the database instance to be ready to use: START UP;
- Oracle Offline Backup
- db2 offline backup shell
- Offline Backup/Restore the TDS
- oracle backup
- Oracle backup
- backup oracle
- Oracle中的offline mode
- TDS学习文档——Offline Backup/Restore the TDS
- oracle backup script
- 【【Oracle posted -- Backup 大全】】
- Oracle backup and recover
- oracle backup encryption
- Oracle---备份(backup)
- Oracle offline 表空间详解
- oracle里tablespace offline和datafile offline的区别
- offline
- Oracle Database backup: exp command
- oracle auto backup shell script
- Python基础:Python的变量和对象
- debug : CoInitialize执行的时机
- 春秋战国已阅
- 对于已有的【寄存】代码,【式样】变更,【参照】其他代码修正时的注意事项!
- IRC(xchat)---学习和使用笔记
- Oracle Offline Backup
- 有题
- itoa函数
- 万年历
- php中可变变量名
- JS 在前台判断文件大小
- 第三个工作日!
- C++悄悄做的那些事
- 转:java一些常用代码的分享!