nocatelog模式本地完整复制目标数据库orcl到副本数据库db
1.创建副本数据库的密码文件
- [Oracle@linux dbs]$ pwd
- /u01/app/oracle/product/10.2.0/db_1/dbs
- [oracle@linux dbs]$ orapwd file='/u01/app/oracle/product/10.2.0/db_1/dbs/orapwdb' password=oracle entries=10
- [oracle@linux dbs]$ ll orapwdb
- -rw-r----- 1 oracle oinstall 2560 10-07 08:37 orapwdb
2.手动创建副本数据库所需目录
- [oracle@linux admin]$ pwd
- /u01/app/oracle/admin
- [oracle@linux admin]$ mkdir db
- [oracle@linux admin]$ cd db/
- [oracle@linux db]$ mkdir adump bdump cdump udump pfile
- [oracle@linux db]$ mkdir -p /u01/app/oracle/archive/db
- [oracle@linux db]$ mkdir -p /u01/app/oracle/oradata/db
3.配置副本数据库初始化参数文件
- [oracle@linux dbs]$ pwd
- /u01/app/oracle/product/10.2.0/db_1/dbs
- [oracle@linux dbs]$ cat initdb.ora
- db.__db_cache_size=100663296
- db.__java_pool_size=4194304
- db.__large_pool_size=4194304
- db.__shared_pool_size=54525952
- db.__streams_pool_size=0
- *.audit_file_dest='/u01/app/oracle/admin/db/adump'
- *.background_dump_dest='/u01/app/oracle/admin/db/bdump'
- *.compatible='10.2.0.3.0'
- *.control_files='/u01/app/oracle/oradata/db/control01.ctl','/u01/app/oracle/oradata/db/control02.ctl','/u01/app/oracle/oradata/db/control03.ctl'
- *.core_dump_dest='/u01/app/oracle/admin/db/cdump'
- *.db_block_size=8192
- *.db_domain=''
- *.db_file_multiblock_read_count=16
- *.db_name='db'
- *.db_recovery_file_dest_size=2147483648
- *.db_recovery_file_dest=''
- *.dispatchers='(PROTOCOL=TCP) (SERVICE=dbXDB)'
- *.job_queue_processes=10
- *.log_archive_dest_1='location=/u01/app/oracle/archive/db'
- *.log_archive_format='%t_%s_%r.dbf'
- *.nls_language='SIMPLIFIED CHINESE'
- *.nls_territory='CHINA'
- *.open_cursors=300
- *.pga_aggregate_target=16777216
- *.processes=150
- *.remote_login_passwordfile='EXCLUSIVE'
- *.sga_target=167772160
- *.undo_management='AUTO'
- *.undo_tablespace='UNDOTBS1'
- *.user_dump_dest='/u01/app/oracle/admin/db/udump'
- *.db_file_name_convert=('/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/db')
- *.log_file_name_convert=('/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/db')
4.启动副本数据库实例到nomount状态
- [oracle@linux dbs]$ export ORACLE_SID=db
- [oracle@linux dbs]$ echo $ORACLE_SID
- db
- [oracle@linux dbs]$ sqlplus /nolog
- SQL*Plus: Release 10.2.0.4.0 - Production on 星期五 10月 7 08:50:32 2011
- Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
- SQL> conn /as sysdba
- 已连接到空闲例程。
- SQL> create spfile from pfile;
- 文件已创建。
- SQL> startup nomount
- ORACLE 例程已经启动。
- Total System Global Area 167772160 bytes
- Fixed Size 1266392 bytes
- Variable Size 62917928 bytes
- Database Buffers 100663296 bytes
- Redo Buffers 2924544 bytes
- [oracle@linux admin]$ pwd
- /u01/app/oracle/product/10.2.0/db_1/network/admin
- [oracle@linux admin]$ cat listener.ora
- # listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
- # Generated by Oracle configuration tools.
- SID_LIST_LISTENER =
- (SID_LIST =
- (SID_DESC =
- (GLOBAL_DBNAME = orcl)
- (SID_NAME = orcl)
- (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
- )
- (SID_DESC =
- (GLOBAL_DBNAME = db)
- (SID_NAME = db)
- (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
- )
- )
- LISTENER =
- (DESCRIPTION_LIST =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = linux)(PORT = 1521))
- (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
- )
- )
- [oracle@linux admin]$ pwd
- /u01/app/oracle/product/10.2.0/db_1/network/admin
- [oracle@linux admin]$ cat tnsnames.ora
- # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
- # Generated by Oracle configuration tools.
- orcl =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = linux)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SID = orcl)
- (SERVER = DEDICATED)
- )
- )
- db =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = linux)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SID = db)
- (SERVER = DEDICATED)
- )
- )
- EXTPROC_CONNECTION_DATA =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
- )
- (CONNECT_DATA =
- (SID = PLSExtProc)
- (PRESENTATION = RO)
- )
- )
- [oracle@linux admin]$ lsnrctl stop
- LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 07-10月-2011 08:56:28
- Copyright (c) 1991, 2007, Oracle. All rights reserved.
- 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux)(PORT=1521)))
- 命令执行成功
- [oracle@linux admin]$ lsnrctl start
- LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 07-10月-2011 08:56:44
- Copyright (c) 1991, 2007, Oracle. All rights reserved.
- 启动/u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: 请稍候...
- TNSLSNR for Linux: Version 10.2.0.4.0 - Production
- 系统参数文件为/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
- 写入/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log的日志信息
- 监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux)(PORT=1521)))
- 监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
- 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux)(PORT=1521)))
- LISTENER 的 STATUS
- ------------------------
- 别名 LISTENER
- 版本 TNSLSNR for Linux: Version 10.2.0.4.0 - Production
- 启动日期 07-10月-2011 08:56:44
- 正常运行时间 0 天 0 小时 0 分 0 秒
- 跟踪级别 off
- 安全性 ON: Local OS Authentication
- SNMP OFF
- 监听程序参数文件 /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
- 监听程序日志文件 /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
- 监听端点概要...
- (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux)(PORT=1521)))
- (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
- 服务摘要..
- 服务 "db" 包含 1 个例程。
- 例程 "db", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
- 服务 "orcl" 包含 1 个例程。
- 例程 "orcl", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
- 命令执行成功
- [oracle@linux ~]$ echo $ORACLE_SID
- orcl
- [oracle@linux ~]$ sqlplus /nolog
- SQL*Plus: Release 10.2.0.4.0 - Production on 星期五 10月 7 08:58:02 2011
- Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
- SQL> conn /as sysdba
- 已连接到空闲例程。
- SQL> startup
- ORACLE 例程已经启动。
- Total System Global Area 167772160 bytes
- Fixed Size 1266392 bytes
- Variable Size 117443880 bytes
- Database Buffers 46137344 bytes
- Redo Buffers 2924544 bytes
- 数据库装载完毕。
- 数据库已经打开。