暂无图片
暂无图片
4
暂无图片
暂无图片
暂无图片
XTTS_生产环境_11G_19c迁移_1小时完成战斗.pdf
1687
48页
99次
2024-06-19
10墨值下载
45
1
root /etc/exports http://XXX.XXX.XXX ip
XXX.XXX.XXX.0/24 IP
2
#
3
vi /etc/exports
4
#
5
/11gto19c/ 192.168.**.0/24(rw,sync,no_root_squash)
6
7
root NFS
8
service nfs restart
9
10
44
11
yum install -y nfs-utils rpcbind
12
mkdir /11gto19c
13
mount -t nfs 192.168.**.45:/11gto19c /11gto19c
14
alter system set audit_trail=NONE scope=spfile sid='*';
1
ALTER SYSTEM SET undo_retention=259200 SCOPE=BOTH sid='*';
2
ALTER TABLESPACE temp ADD tempfile SIZE 30G;
3
ALTER TABLESPACE temp ADD tempfile SIZE 30G;
4
ALTER TABLESPACE temp ADD tempfile SIZE 30G;
5
alter system set deferred_segment_creation=false scope=spfile sid='*';
6
alter system set enable_ddl_logging=true scope=both sid='*';
7
ALTER DATABASE ADD LOGFILE GROUP 4 SIZE 200M;
8
ALTER DATABASE ADD LOGFILE GROUP 5 SIZE 200M;
9
ALTER DATABASE ADD LOGFILE GROUP 6 SIZE 200M;
10
ALTER DATABASE ADD LOGFILE GROUP 7 SIZE 200M;
11
ALTER DATABASE ADD LOGFILE GROUP 8 SIZE 200M;
12
ALTER DATABASE ADD LOGFILE GROUP 9 SIZE 200M;
13
ALTER DATABASE ADD LOGFILE GROUP 10 SIZE 200M;
14
alter system set "_undo_autotune"=false scope=spfile sid='*';
15
alter profile DEFAULT limit PASSWORD_GRACE_TIME UNLIMITED;
16
alter profile DEFAULT limit PASSWORD_LIFE_TIME UNLIMITED;
17
alter profile DEFAULT limit PASSWORD_LOCK_TIME UNLIMITED;
18
alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS UNLIMITED;
19
20
alter system set processes=10000 scope=spfile sid='*';
21
alter system set db_files=2000 scope=spfile sid='*';
22
alter system set control_file_record_keep_time=31 scope=spfile sid='*';
23
alter system set open_cursors=3000 scope=spfile sid='*';
24
alter system set session_cached_cursors=300 scope=spfile sid='*';
25
ALTER SYSTEM SET SGA_TARGET=80G SCOPE=SPFILE;
26
ALTER SYSTEM SET SGA_MAX_SIZE=80G SCOPE=SPFILE;
27
ALTER SYSTEM SET PGA_AGGREGATE_TARGET=15G SCOPE=SPFILE;
28
29
alter TABLESPACE undotbs1 add DATAFILE SIZE 30G;
30
alter TABLESPACE undotbs1 add DATAFILE SIZE 30G;
31
alter TABLESPACE undotbs1 add DATAFILE SIZE 30G;
32
of 48
10墨值下载
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜