Oracle EBS Instance冷备份的方法(Cold Backup)
1. 关闭Oracle Application Server和 DB Server
2. 用oracle用户(数据库管理用户)SSH到Server上
3. 创建备份目录
4. 拷贝所有DATA_TOP目录下的文件(/u01/oracle/instance/db/apps_st/data) 到备份目录下$cp -r /u01/oracle/instance/db/apps_st/data/* /backup_dir
怎样查看EBS Instance的数据文件,日志文件,数据库控制文件以及表空间文件
- SELECT name FROM v$datafile;
- /u01/oracle/instance/db/apps_st/data/xxx.dbf
-
- SELECT member FROM v$logfile;
- /u01/oracle/instance/db/apps_st/data/logx.dbf
-
- SELECT name FROM v$controlfile;
- /u01/oracle/instance/db/apps_st/data/cntrl0x.dbf
-
- SELECT t.NAME "Tablespace", f.NAME "Datafile"
- FROM V$TABLESPACE t,V$DATAFILE f
- WHERE t.TS# = f.TS#
- ORDER BY t.NAME;
- /u01/oracle/mc3yd213/db/apps_st/data/xxx