Oracle EBS Instance冷备份的方法(Cold Backup)
Oracle EBS Instance冷备份的方法(Cold Backup)
1. 关闭Oracle Application Server和 DB Server3. 创建备份目录
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
相关推荐
IT之家 2020-03-11
graseed 2020-10-28
zbkyumlei 2020-10-12
SXIAOYI 2020-09-16
jinhao 2020-09-07
impress 2020-08-26
liuqipao 2020-07-07
淡风wisdon大大 2020-06-06
yoohsummer 2020-06-01
chenjia00 2020-05-29
baike 2020-05-19
扭来不叫牛奶 2020-05-08
hxmilyy 2020-05-11
黎豆子 2020-05-07
xiongweiwei00 2020-04-29
Cypress 2020-04-25
冰蝶 2020-04-20