Oracle 10g RAC Rman Backup heterogeneous Single Instance recovery

This article makes it possible to discover some of the problems of backup during the recovery process by using a complete backup of Oracle 10g RAC Rman for a different machine recovery process. such as the redundancy of the Regulation log, control the use of automatic backup of files and parameter files, and so on, this example takes an Rman backup set for backup, so there was a problem during the last startup of the database, prompting for problems such as old file control, so the backup needs to be designed in detail and highly available, To mitigate risk during the recovery process.

Oracle 11g R2 RAC on OEL5.8 x64 installation notes

http://koumm.blog.51cto.com/703525/1282368

I. Environmental description

Operating system version: Oracle Enterprise Linux 5.8 x64

1. Source database Server

Oracle version: Oracle 10g RAC 10.2.0.5 64-bit

Oracle_sid:orcl

2. Target database server

Oracle version: Oracle 10g 10.2.0.5 64-bit

Oracle_sid:orcl

Only Oracle software installed, listening, no DBCA operation

Second, the source DB server

1. Source Server Environment Description

The source server performs a RAC Rman backup. You need to perform a different machine recovery operation.

2. Package or copy Rman backup directory

$ cd/u01

$ tar czvf rman_bak.tar.gz rman_bak/

Third, the purpose of the server to do rman recovery preparation

1. Copy the data from the Rman backup

# cd/u01/rman_bak/data/

# LL

-RW-R-----1 Oracle oinstall 1080751616 07-18 16:58 archlog. orcl.level.0.0rof2j8q_1_1_20130718

-RW-R-----1 Oracle oinstall 1018279424 07-18 16:58 archlog. orcl.level.0.0sof2j8n_1_1_20130718

-RW-R-----1 Oracle oinstall 58086912 07-18 16:58 archlog. orcl.level.0.0tof2j9l_1_1_20130718

-RW-R-----1 Oracle Oinstall 493084672 07-18 16:58 data. orcl.level.0.0vof2j9v_1_1_20130718

-RW-R-----1 Oracle Oinstall 409280512 07-18 16:58 data. orcl.level.0.10of2j9s_1_1_20130718

-RW-R-----1 Oracle Oinstall 15466496 07-18 16:58 data. orcl.level.0.11of2jae_1_1_20130718

-RW-R-----1 Oracle oinstall 98304 07-18 16:58 spfile_12of2jah_1_1_20130718

#

2. Create the Regulatory log directory

Su-oracle

Mkdir-p/u01/archivelog

3. Create DATABASE Base directory

Note: Because the information of Rman backup is recorded in Controlfile, the directory structure should be consistent with the original database.

Mkdir-p/u01/app/oracle/admin/orcl/{adump,bdump,cdump,ddump,udump}

Mkdir-p/U01/APP/ORACLE/ORADATA/ORCL

Mkdir-p/U01/APP/ORACLE/FLASH_RECOVERY_AREA/ORCL

Third, recover data on the target server

Description: Creates the directory defined in the parameter file on the target server, which is created on the target server.

1. Boot to Nomount State

# su-oracle

$ Echo ' DB_NAME=ORCL ' > $ORACLE _home/dbs/initorcl.ora

$ Export ORACLE_SID=ORCL

$ Rman Target/

rman> startup Nomount;

2. Recover pfile files by recovering spfile files

rman> restore SPFile to Pfile '/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora ' from '/u01/rman_bak/data/ spfile_12of2jah_1_1_20130718 ';

Starting restore at 19-7? -13

Using target database control file instead of recovery catalog

Allocated Channel:ora_disk_1

Channel ora_disk_1:sid=36 Devtype=disk

Channel Ora_disk_1:autobackup found:/u01/rman_bak/data/spfile_12of2jah_1_1_20130718

Channel Ora_disk_1:spfile Restore from Autobackup complete

Finished restore at 19-7? -13

Rman> quit

3. Edit Pfile File

# Modify Pfile used for single instance file system database

$ vi/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora

#注释掉RAC集群的配置参数, and modify the partial single-instance parameters.

#orcl2. __db_cache_size=822083584

#orcl1. __db_cache_size=771751936

#orcl2. __java_pool_size=16777216

#orcl1. __java_pool_size=16777216

#orcl2. __large_pool_size=16777216

#orcl1. __large_pool_size=16777216

#orcl2. __shared_pool_size=352321536

#orcl1. __shared_pool_size=402653184

#orcl2. __streams_pool_size=0

#orcl1. __streams_pool_size=0

*.audit_file_dest= '/u01/app/oracle/admin/orcl/adump '

*.background_dump_dest= '/u01/app/oracle/admin/orcl/bdump '

#*.cluster_database_instances=2

#*.cluster_database=true

*.compatible= ' 10.2.0.5.0 '

*.control_file_record_keep_time=40

*.control_files= '/u01/app/oracle/oradata/orcl/control01.ctl ', '/u01/app/oracle/oradata/orcl/control02.ctl ', '/ U01/app/oracle/oradata/orcl/control03.ctl '

*.core_dump_dest= '/u01/app/oracle/admin/orcl/cdump '

*.db_block_size=8192

#*.db_create_file_dest= ' +data '

*.db_domain= '

*.db_file_multiblock_read_count=16

*.db_name= ' ORCL '

*.db_recovery_file_dest= '/u01/app/oracle/flash_recovery_area '

*.db_recovery_file_dest_size=21474836480

*.dispatchers= ' (protocol=tcp) (SERVICE=ORCLXDB) '

#orcl2. instance_number=2

#orcl1. instance_number=1

*.job_queue_processes=10

#*.log_archive_dest_1= ' Location=+recovery '

*.log_archive_dest_1= ' Location=/u01/archivelog '

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

*.open_cursors=300

*.pga_aggregate_target=402653184

*.processes=200

#*.remote_listener= ' LISTENERS_ORCL '

*.remote_login_passwordfile= ' Exclusive '

*.sessions=225

*.sga_target=1210056704

#orcl2. thread=2

#orcl1. thread=1

*.undo_management= ' AUTO '

#orcl2. undo_tablespace= ' UNDOTBS2 '

#orcl1. undo_tablespace= ' UNDOTBS1 '

*.undo_tablespace= ' UNDOTBS1 '

*.user_dump_dest= '/u01/app/oracle/admin/orcl/udump '

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/