今天忙中偷闲,进行了一次oracle数据库的duplicate的测试:
测试环境:
两台redhate操作系统,数据库oracle10g 10.2.0.1;
主库运行正常,备机仅安装oracle10g 软件,未建立库!
测试的步骤,按照oracle官方文档提供的操作步骤
Perform. these tasks before performing RMAN duplication:
Preparing the Auxiliary Instance for Duplication: Basic Steps
- Task 1: Create an Oracle Password File for the Auxiliary Instance
- Task 2: Ensure Oracle Net Connectivity to the Auxiliary Instance
- Task 3: Create an Initialization Parameter File for the Auxiliary Instance
- Task 4: Start the Auxiliary Instance
- Task 5: Mount or Open the Target Database
- Task 6: Make Sure You Have the Necessary Backups and Archived Redo Logs
- Task 7: Allocate Auxiliary Channels if Automatic Channels Are Not Configured
1,创建一个口令文件:
$orapwd file=/database/oracle/product/10.2/dbs/orapworcldb password=123qwe entries=10
2,配置tnsname,listener 使在备机上能够连接到主库上面;
3,在主库上面创建一个pfile
SQL>create pfile='/home/oracle/pfileorcldb.ora' from spfile;
把生成的pfile拷贝到备机上的oracle目录下,可以是随意的位置,这里可以假定是/home/oracle, 并且修改控制文件,alter log,dump file 等文件的目录位置,
4,创建相应的数据库目录,启动备机上的数据库instance,以nomout的方式启动
$sqlplsu '/as sysdba'
SQL>startup pfile='/home/oracle/pfileorcldb.ora' nomount
5,使用rman 进行一次数据库的完全备份:
rman target /
RMAN>backup database
2> include current controlfile
3> format '/database/rmanbackup/fullbackup_%U'
4> plus archivelog format '/database/rmanbackup/fullbackup_arc_%U'
5> delete all input;
把备份集拷贝到备机的相应的目录位置处:
scp -r /database/rmanbackup/fullbackup* ip:/database/rmanbackup/
6,在备机上运行操作,见下面的rman脚本rmandup.sh
connect target sys/xxxxxx@pri
connect auxiliary /
run {
allocate auxiliary channel aux1 type disk;
set newname for datafile 1 to '/database/oracle/oradata/shltdb/system01.dbf';
set newname for datafile 2 to '/database/oracle/oradata/shltdb/undotbs01.dbf';
set newname for datafile 3 to '/database/oracle/oradata/shltdb/sysaux01.dbf';
set newname for datafile 4 to '/database/oracle/oradata/shltdb/users01.dbf';
set newname for datafile 5 to '/database/oracle/oradata/shlt_space01.dbf';
DUPLICATE TARGET DATABASE TO shltdb
pfile=/database/oracle/pfileshltdb.ora
LOGFILE
GROUP 1 ('/database/oracle/oradata/shltdb/REDO01.DBF') SIZE 100M,
GROUP 2 ('/database/oracle/oradata/shltdb/REDO02.DBF') SIZE 100M,
GROUP 3 ('/database/oracle/oradata/shltdb/REDO03.DBF') SIZE 100M
NOFILENAMECHECK;
执行完脚本后,如果没有抱错,显示操作成功!
进行测试,如果备机上的数据库的用户数据能够查询,则说明成功!
执行select * from dual;
然后再创建spfile
SQL>create spfile from pfile='/home/oracle/pfileorcldb.ora'
测试启,停!
SQL>shutdow immediate
SQL>startup
在操作的过程中注意事项:
1, 主备库上的oracle目录路径不同的时候,需要进行说明,使用set newname datafile 1 to ‘/newpath。。。
2,duplicate 操作时需要指定:pfile=/database/oracle/pfileshltdb.ora
否则在操作其间会有oracle的启动,因找不到参数文件而报错,导致数据库不能成功打开,我没指定pfile的时候遇到的错误:
使用rman 的duplicate 一个备库, 完成到最后,备库打开的时候报错:SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/database/oracle/oradata[/胜利]tdb/system01.dbf'
ORA-01206: file is not part of this database - wrong database id
所以加上pfile=。。。后,就会正常!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/241699/viewspace-588610/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/241699/viewspace-588610/