【RMAN】使用duplicate本地复制数据库-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

【RMAN】使用duplicate本地复制数据库

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:50 PM

同一台主机使用RMAN的duplicate复制数据库，linux操作系统中有一套正在运行的数据库enmoedu 复制后的数据库aux

任务：同一台主机使用RMAN的duplicate复制数据库，linux操作系统中有一套正在运行的数据库enmoedu 复制后的数据库aux

实验步骤：

1. 主库RMAN备份

[Oracle@test ~]$ export ORACLE_SID=enmoedu

[oracle@test ~]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jun 6 00:43:13 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: ENMOEDU (DBID=108163061)

RMAN> backup database plus archivelog;

Starting backup at 06-JUN-14

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=61 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/11g/app/oracle/oradata/enmoedu/system01.dbf

input datafile file number=00002 name=/11g/app/oracle/oradata/enmoedu/sysaux01.dbf

input datafile file number=00005 name=/11g/app/oracle/oradata/enmoedu/example01.dbf

input datafile file number=00003 name=/11g/app/oracle/oradata/enmoedu/undotbs01.dbf

input datafile file number=00006 name=/11g/app/oracle/oradata/enmoedu/pitr.dbf

input datafile file number=00007 name=/11g/app/oracle/oradata/enmoedu/pitr_ind.dbf

input datafile file number=00008 name=/11g/app/oracle/oradata/enmoedu/index01.dbf

input datafile file number=00010 name=/11g/app/oracle/oradata/enmoedu/ts_users_1.dbf

input datafile file number=00004 name=/11g/app/oracle/oradata/enmoedu/users01.dbf

input datafile file number=00009 name=/11g/app/oracle/oradata/enmoedu/ts_users.dbf

input datafile file number=00011 name=/11g/app/oracle/oradata/enmoedu/ts_users1.dbf

channel ORA_DISK_1: starting piece 1 at 06-JUN-14

channel ORA_DISK_1: finished piece 1 at 06-JUN-14

piece handle=/11g/app/backup/db_53pa49ha_1_1.bak tag=TAG20140606T004322 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

including current SPFILE in backup set

channel ORA_DISK_1: starting piece 1 at 06-JUN-14

channel ORA_DISK_1: finished piece 1 at 06-JUN-14

piece handle=/11g/app/backup/db_54pa49i3_1_1.bak tag=TAG20140606T004322 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 06-JUN-14

RMAN>quit

--------------------------------------------------------------------------------

RMAN 配置归档日志删除策略

Oracle基础教程之通过RMAN复制数据库

RMAN备份策略制定参考内容

RMAN备份学习笔记

Oracle数据库备份加密 RMAN加密

Linux-6-64下安装Oracle 12C笔记

在CentOS 6.4下安装Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虚拟机中安装步骤

Debian 下安装 Oracle 11g XE R2

--------------------------------------------------------------------------------

2. 配置监听文件及tnsnames.ora

--监听改静态 listener.ora 因为复制的aux库是nomount状态，pmon是mount的时候去动态注册，所以需要加静态注册。

Listener.ora文件修改后：

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = enmoedu)

(ORACLE_HOME = /11g/app/oracle/product/11.2.0/dbhome)

(SID_NAME = enmoedu)

)

(SID_DESC =

(GLOBAL_DBNAME = aux)

(ORACLE_HOME = /11g/app/oracle/product/11.2.0/dbhome)

(SID_NAME = aux)

)

)

Tnsnames.ora文件中添加：

aux =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.8)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = aux)

)

)

3. 通过enmoedu库的SPFILE生成PFILE，复制PFILE文件，，将SID名字更改为aux，并且将文件中参数进行修改。

[oracle@test ~]$ sqlplus / as sysdba

SQLPlus Release 11.2.0.3.0 Production on Thu Jun 5 235614 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL select instance_name,status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

enmoedu OPEN

SQL create pfile from spfile;

File created.

SQLexit

[oracle@test ~]$ cd $ORACLE_HOMEdbs

[oracle@test dbs]$ cp initenmoedu.ora initaux.ora

修改前initaux.ora

enmoedu.__db_cache_size=201326592

enmoedu.__java_pool_size=4194304

enmoedu.__large_pool_size=4194304

enmoedu.__oracle_base='/11g/app/oracle'#ORACLE_BASE set from environment

enmoedu.__pga_aggregate_target=293601280

enmoedu.__sga_target=545259520

enmoedu.__shared_io_pool_size=0

enmoedu.__shared_pool_size=318767104

enmoedu.__streams_pool_size=8388608

*._shared_io_pool_size=0

*.audit_file_dest='/11g/app/oracle/admin/enmoedu/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/11g/app/oracle/oradata/enmoedu/control01.ctl','/11g/app/oracle/oradata/enmoedu/control02.ctl'

*.db_block_size=8192

*.db_cache_size=201326592

*.db_create_file_dest=''

*.db_domain=''

*.db_flashback_retention_target=2880

*.db_name='enmoedu'

*.db_recovery_file_dest_size=2147483648

*.db_recovery_file_dest='/11g/app/backup'

*.db_writer_processes=2

*.diagnostic_dest='/11g/app/oracle'

*.java_pool_size=4194304

*.large_pool_size=4194304

*.log_archive_format='%t_%s_%r.arc'

*.memory_target=0

*.open_cursors=300

*.pga_aggregate_target=293601280

*.processes=300

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=0

*.shared_pool_size=318767104

*.streams_pool_size=8388608

*.undo_tablespace='UNDOTBS1'

修改后initaux.ora(具体参数可根据自己环境进行调整）标黄色部分为更改项，要建立更改后的路径目录

aux.__db_cache_size=201326592

aux.__java_pool_size=4194304

aux.__large_pool_size=4194304

aux.__oracle_base='/11g/app/oracle'#ORACLE_BASE set from environment

aux.__pga_aggregate_target=293601280

aux.__sga_target=545259520

aux.__shared_io_pool_size=0

aux.__shared_pool_size=318767104

aux.__streams_pool_size=8388608

*._shared_io_pool_size=0

*.audit_file_dest='/11g/app/oracle/admin/aux/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/11g/app/oracle/oradata/aux/control01.ctl','/11g/app/oracle/oradata/aux/control02.ctl'

*.db_block_size=8192

*.db_cache_size=201326592

*.db_create_file_dest=''

*.db_domain=''

*.db_flashback_retention_target=2880

*.db_name='aux'

*.db_recovery_file_dest_size=2147483648

*.db_recovery_file_dest='/11g/app/flashback_aux'

*.db_writer_processes=2

*.diagnostic_dest='/11g/app/oracle'

*.java_pool_size=4194304

*.large_pool_size=4194304

*.log_archive_format='%t_%s_%r.arc'

*.memory_target=0

*.open_cursors=300

*.pga_aggregate_target=293601280

*.processes=300

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=0

*.shared_pool_size=318767104

*.streams_pool_size=8388608

*.undo_tablespace='UNDOTBS1'

*.db_file_name_convert='/11g/app/oracle/oradata/enmoedu/','/11g/app/oracle/oradata/aux/'

*.log_file_name_convert='/11g/app/oracle/oradata/enmoedu/','/11g/app/oracle/oradata/aux/'

更多详情见请继续阅读下一页的精彩内容：

linux

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Explain the InnoDB Buffer Pool and its importance for performance.Apr 19, 2025 am 12:24 AM

InnoDBBufferPool reduces disk I/O by caching data and indexing pages, improving database performance. Its working principle includes: 1. Data reading: Read data from BufferPool; 2. Data writing: After modifying the data, write to BufferPool and refresh it to disk regularly; 3. Cache management: Use the LRU algorithm to manage cache pages; 4. Reading mechanism: Load adjacent data pages in advance. By sizing the BufferPool and using multiple instances, database performance can be optimized.

MySQL vs. Other Programming Languages: A ComparisonApr 19, 2025 am 12:22 AM

Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages have advantages in their respective fields such as data analytics, enterprise applications, and system programming.

Learning MySQL: A Step-by-Step Guide for New UsersApr 19, 2025 am 12:19 AM

MySQL is worth learning because it is a powerful open source database management system suitable for data storage, management and analysis. 1) MySQL is a relational database that uses SQL to operate data and is suitable for structured data management. 2) The SQL language is the key to interacting with MySQL and supports CRUD operations. 3) The working principle of MySQL includes client/server architecture, storage engine and query optimizer. 4) Basic usage includes creating databases and tables, and advanced usage involves joining tables using JOIN. 5) Common errors include syntax errors and permission issues, and debugging skills include checking syntax and using EXPLAIN commands. 6) Performance optimization involves the use of indexes, optimization of SQL statements and regular maintenance of databases.

MySQL: Essential Skills for Beginners to MasterApr 18, 2025 am 12:24 AM

MySQL is suitable for beginners to learn database skills. 1. Install MySQL server and client tools. 2. Understand basic SQL queries, such as SELECT. 3. Master data operations: create tables, insert, update, and delete data. 4. Learn advanced skills: subquery and window functions. 5. Debugging and optimization: Check syntax, use indexes, avoid SELECT*, and use LIMIT.

MySQL: Structured Data and Relational DatabasesApr 18, 2025 am 12:22 AM

MySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.

MySQL: Key Features and Capabilities ExplainedApr 18, 2025 am 12:17 AM

MySQL is an open source relational database management system that is widely used in Web development. Its key features include: 1. Supports multiple storage engines, such as InnoDB and MyISAM, suitable for different scenarios; 2. Provides master-slave replication functions to facilitate load balancing and data backup; 3. Improve query efficiency through query optimization and index use.

The Purpose of SQL: Interacting with MySQL DatabasesApr 18, 2025 am 12:12 AM

SQL is used to interact with MySQL database to realize data addition, deletion, modification, inspection and database design. 1) SQL performs data operations through SELECT, INSERT, UPDATE, DELETE statements; 2) Use CREATE, ALTER, DROP statements for database design and management; 3) Complex queries and data analysis are implemented through SQL to improve business decision-making efficiency.

MySQL for Beginners: Getting Started with Database ManagementApr 18, 2025 am 12:10 AM

The basic operations of MySQL include creating databases, tables, and using SQL to perform CRUD operations on data. 1. Create a database: CREATEDATABASEmy_first_db; 2. Create a table: CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY, titleVARCHAR(100)NOTNULL, authorVARCHAR(100)NOTNULL, published_yearINT); 3. Insert data: INSERTINTObooks(title, author, published_year)VA

See all articles