ORACLE 11G 单机冷备数据库

1.1 查看文件路径

代码语言：javascript复制

SYS@orcl>select name from v$datafile;
SYS@orcl>select name from v$controlfile;
SYS@orcl>select member from v$logfile;

1.2 一致性关闭数据库

代码语言：javascript复制

SYS@orcl>shutdown immeidate;

1.3 拷贝参数文件

代码语言：javascript复制

[oracle@orcl ~]$ cd /u01/app/oracle/oradata/orcl
[oracle@orc1 orcl]$ cp $ORACLE_HOME/dbs/spfileorcl.ora ./
[oracle@orc1 orcl]$ ll

1.4 tar 打包备份

代码语言：javascript复制

创建备份目录
[oracle@orcl ~]$ mkdir /home/oracle/files
[oracle@orcl orcl]$ tar -zcvf /home/oracle/files/orcl.tar.gz *

oracle

0 人点赞