20161026__Oracle10g_DataGuard

2023-08-07 11:25:04

1、

orcl.__db_cache_size=180355072

orcl.__java_pool_size=4194304

orcl.__large_pool_size=4194304

orcl.__shared_pool_size=96468992

orcl.__streams_pool_size=0

*.audit_file_dest='D:\oracle\product\10.2.0/admin/orcl/adump'

*.background_dump_dest='D:\oracle\product\10.2.0/admin/orcl/bdump'

*.compatible='10.2.0.1.0'

*.control_files='D:\oracle\product\10.2.0\oradata\orcl\control01.ctl','D:\oracle\product\10.2.0\oradata\orcl\control02.ctl','D:\oracle\product\10.2.0\oradata\orcl\control03.ctl'

*.core_dump_dest='D:\oracle\product\10.2.0/admin/orcl/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='orcl'

*.db_recovery_file_dest='D:\oracle\product\10.2.0/flash_recovery_area'

*.db_recovery_file_dest_size=2147483648

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.job_queue_processes=10

###################modified log_archive_dest_1 add "VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary"###############

*.log_archive_dest_1='location=D:\oracle\product\10.2.0\db_1\database\archive\ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary'

*.open_cursors=300

*.pga_aggregate_target=95420416

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=287309824

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='D:\oracle\product\10.2.0/admin/orcl/udump'

######################new parameters#####################

DB_UNIQUE_NAME=primary

LOG_ARCHIVE_CONFIG='DG_CONFIG=(primary,standby)'

LOG_ARCHIVE_DEST_2='SERVICE=standby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby'

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

LOG_ARCHIVE_MAX_PROCESSES=4

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

FAL_CLIENT = primary

FAL_SERVER = standby

DB_FILE_NAME_CONVERT='standby','primary'

STANDBY_FILE_MANAGEMENT =AUTO

log_file_name_convert='D:\oracle\product\10.2.0\oradata\ZHEJIANG','D:\oracle\product\10.2.0\oradata\ZHEJIANG'

2、

　　2.1、

SQL> create spfile='D:\oracle\product\10.2.0\db_1\dbs\SPFILEORCL.ORA' from pfile='D:\oracle\product\10.2.0\admin\orcl\pfile\init.ora.071205';

改成 (实际情况[tw的机子])

SQL> create spfile='D:\oracle\product\10.2.0\db_1\dbs\SPFILEZHEJIANG.ORA' from pfile='D:\oracle\product\10.2.0\admin\ZHEJIANG\pfile\init.ora.3152016131013';

　　2.2、

rman nocatalog target 'sys/admin@orcl as sysdba'

实际输入的命令为：

C:\Users\Administrator>rman nocatalog target 'sys/dongruisoft.com@ZHEJIANG as sysdba'

　　2.3、

run{

allocate channel c1 type disk;

backup format 'd:\db_bakup\full%u_%s_%p' database include current controlfile;

sql 'alter system archive log current';

backup filesperset 10 archivelog all format='d:\db_bakup\log%u_%s.bak';

release channel c1;

}

　　2.4、报错“PLS-00302: 必须声明 'GETRANGEALBACKUP' 组件”，实际是需要“升级相关包”

　　　　http://f.dataguru.cn/thread-112227-1-1.html

RMAN>  upgrade catalog;

　　2.5、

3、我操作rman的步骤：

　　CMD中“rman catalog "sys/dongruisoft.com as sysdba"”

　　“rman target /” --> “connect catalog "sys/dongruisoft.com as sysdba"”

　　都有报错...

4、

“rman target sys/dongruisoft.com@ZJ”

“backup full database format 'D:\db_bakup\backup_%T_%s_%p.bak';” --> 成功

“backup archive log all format='D:\db_bakup\arch_%T_%s_%p.bak';” --> 失败

　　ZC: 貌似之前是我的 “D:\oracle\product\10.2.0\db_1\network\ADMIN\tnsnames.ora”没有正确的配置造成的(没有指向本机的Oracle...指向的是 201的Oracle)

5、

6、步骤10

zhejiang.__db_cache_size=390070272

zhejiang.__java_pool_size=16777216

zhejiang.__large_pool_size=4194304

zhejiang.__shared_pool_size=192937984

zhejiang.__streams_pool_size=0

*.audit_file_dest='D:\oracle\product\10.2.0\admin\ZHEJIANG\adump'

*.background_dump_dest='D:\oracle\product\10.2.0\admin\ZHEJIANG\bdump'

*.compatible='10.2.0.3.0'

*.control_files='D:\oracle\product\10.2.0\oradata\ZHEJIANG\control01.ctl','D:\oracle\product\10.2.0\oradata\ZHEJIANG\control02.ctl','D:\oracle\product\10.2.0\oradata\ZHEJIANG\control03.ctl'

*.core_dump_dest='D:\oracle\product\10.2.0\admin\ZHEJIANG\cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='ZHEJIANG'

*.db_recovery_file_dest='D:\oracle\product\10.2.0\flash_recovery_area'

*.db_recovery_file_dest_size=2147483648

*.dispatchers='(PROTOCOL=TCP) (SERVICE=ZHEJIANGXDB)'

*.job_queue_processes=10

###*.local_listener='(address=(protocol=tcp)(host=192.168.1.77)(port=1623))'### 网页文章中没有这个，就注释掉了

###################modified log_archive_dest_1 add "VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary"###############

*.log_archive_dest_1='location=D:\oracle\product\10.2.0\db_1\database\archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary'

*.open_cursors=300

*.pga_aggregate_target=203423744

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=612368384

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='D:\oracle\product\10.2.0\admin\ZHEJIANG\udump'

######################new parameters#####################

DB_UNIQUE_NAME=standby

LOG_ARCHIVE_CONFIG='DG_CONFIG=(primary,standby)'

LOG_ARCHIVE_DEST_2='SERVICE=primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=primary'

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

LOG_ARCHIVE_MAX_PROCESSES=4

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

FAL_CLIENT = standby

FAL_SERVER = primary

DB_FILE_NAME_CONVERT='primary','standby'

STANDBY_FILE_MANAGEMENT =AUTO

log_file_name_convert='D:\oracle\product\10.2.0\oradata\ZHEJIANG','D:\oracle\product\10.2.0\oradata\ZHEJIANG'

　　6.1、∵ 我的 Oracle是安装在 F盘的，于是又改成这样：

zhejiang.__db_cache_size=390070272

zhejiang.__java_pool_size=16777216

zhejiang.__large_pool_size=4194304

zhejiang.__shared_pool_size=192937984

zhejiang.__streams_pool_size=0

*.audit_file_dest='F:\oracle\product\10.2.0\admin\ZHEJIANG\adump'

*.background_dump_dest='F:\oracle\product\10.2.0\admin\ZHEJIANG\bdump'

*.compatible='10.2.0.3.0'

*.control_files='F:\oracle\product\10.2.0\oradata\ZHEJIANG\control01.ctl','F:\oracle\product\10.2.0\oradata\ZHEJIANG\control02.ctl','F:\oracle\product\10.2.0\oradata\ZHEJIANG\control03.ctl'

*.core_dump_dest='F:\oracle\product\10.2.0\admin\ZHEJIANG\cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='ZHEJIANG'

*.db_recovery_file_dest='F:\oracle\product\10.2.0\flash_recovery_area'

*.db_recovery_file_dest_size=2147483648

*.dispatchers='(PROTOCOL=TCP) (SERVICE=ZHEJIANGXDB)'

*.job_queue_processes=10

###*.local_listener='(address=(protocol=tcp)(host=192.168.1.77)(port=1623))'### 网页文章中没有这个，就注释掉了

###################modified log_archive_dest_1 add "VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary"###############

*.log_archive_dest_1='location=F:\oracle\product\10.2.0\db_1\database\archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary'

*.open_cursors=300

*.pga_aggregate_target=203423744

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=612368384

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='F:\oracle\product\10.2.0\admin\ZHEJIANG\udump'

######################new parameters#####################

DB_UNIQUE_NAME=standby

LOG_ARCHIVE_CONFIG='DG_CONFIG=(primary,standby)'

LOG_ARCHIVE_DEST_2='SERVICE=primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=primary'

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

LOG_ARCHIVE_MAX_PROCESSES=4

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

FAL_CLIENT = standby

FAL_SERVER = primary

DB_FILE_NAME_CONVERT='primary','standby'

STANDBY_FILE_MANAGEMENT =AUTO

log_file_name_convert='F:\oracle\product\10.2.0\oradata\ZHEJIANG','F:\oracle\product\10.2.0\oradata\ZHEJIANG'

　　6.2、又根据我机子上面的文件，又配置了一份：

　　　　ZC: 本来是文件“F:\oracle\product\10.2.0\admin\orcl\pfile\init.ora.88201594715”，现在复制一份叫做“init_1.ora.88201594715”（注意，我的机子里面居然 Oracle实例名是叫“orcl”...居然不是“ZHEJIANG”...）

7、

8、

9、资料

upgrade catalog; --> http://f.dataguru.cn/thread-112227-1-1.html

oracle数据库版本升级后导致的catalog连接问题 --> http://www.ixdba.net/article/5d/1247.html

resync catalog; --> http://bbs.chinaunix.net/thread-793248-1-1.html

配置catalog --> http://www.itpub.net/thread-1020496-1-1.html

tnsnames.ora 中配置 catalog的连接 --> http://www.programgo.com/article/49583187097/;jsessionid=4FDD1AE3F2D9A3BF1A20294CCE137F37

10、

码农公寓

相关文章