Stand-alone ASM replaces storage and hosts

Oracle ASM replaces storage and hosts:

1. In the new host when installing a stand-alone grid, and the database software, you can copy from the source host, and then clone the operation

2. Hang the new storage on the old host, set up a new disk group, back up the database to the new disk group with backup copy, and

The new storage is unmapped from the old host,

3. Export the old OCR and import the new host,

./OCRCONFIG-EXPORT/TMP/033_ASM.OCR

./OCRCONFIG-EXPORT/TMP/053_ASM.OCR


./ocrconfig-import/tmp/ocr.bak

4. Restart CRS and you can see that the disk group is already mounted on the new host.

5. Modify the control file and data file path:

SQL>  ALTER SYSTEM  SET DB_CREATE_FILE_DEST= ‘+DATA‘ SID= ‘*‘ ; System altered. SQL>  ALTER SYSTEM  SET DB_RECOVERY_FILE_DEST_SIZE=100G SID= ‘*‘ ; System altered. SQL>  ALTER SYSTEM  SET DB_RECOVERY_FILE_DEST= ‘+FRA‘ SID= ‘*‘ ;

SQL>   ALTER SYSTEM  SET CONTROL_FILES= ‘+DATA‘ , ‘+FRA‘ SCOPE=SPFILE SID= ‘*‘ ; System altered.

Copy the control file from the source host and restore it to the target host

ALTER DATABASE Mount;

SWITCH DATABASETOCOPY;

Recover database

；；

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE, STACK follows ===============
RMAN-00571: ===========================================================
Rman-03002:failure of recover command at 06/22/2016 20:35:05
Rman-06053:unable to perform media recovery because of missing log
Rman-06025:no Backup of archived log for thread 1 with sequence 2274 and starting SCN of 64377780446 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2273 and starting SCN of 64375042569 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2272 and starting SCN of 64371781040 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2271 and starting SCN of 64369148011 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2270 and starting SCN of 64367907974 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2269 and starting SCN of 64366653696 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2268 and starting SCN of 64363294087 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2267 and starting SCN of 64358391536 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2266 and starting SCN of 64352846715 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2265 and starting SCN of 64352844045 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2264 and starting SCN of 64352832699 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2263 and starting SCN of 64352555519 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2262 and starting SCN of 64349448092 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2261 and starting SCN of 64348058197 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2260 and starting SCN of 64346601983 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2259 and starting SCN of 64344758678 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2258 and starting SCN of 64343087188 found to restore
Rman-06025:no Backup of archived log for thread 1 with Sequence 2257 and starting SCN of 64340524960 found to restore
Rman-06025:no Backup of archived log for thread 1 with sequence 2256 and starting SCN of 64340493278 found to Restor

Back up these logs on the source host

Backup as copy archivelog sequence between 2248 and 2274 thread 1 format '/app/bak0622_arch/archivelog_%u.%t ';

Copy to target machine;

Then catalog start with

rman> catalog start with '/app/oracle/bak_arch/';

Searching for all files that match the pattern/app/oracle/bak_arch/

List of Files Unknown to the Database
=====================================
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2256_t-1_a-909648652_2gr8qaih.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2257_t-1_a-909648652_2hr8qaj0.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2258_t-1_a-909648652_2ir8qajf.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2259_t-1_a-909648652_2jr8qaju.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2260_t-1_a-909648652_2kr8qakd.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2261_t-1_a-909648652_2lr8qaks.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2262_t-1_a-909648652_2mr8qall.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2263_t-1_a-909648652_2nr8qam4.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2264_t-1_a-909648652_2or8qamt.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2265_t-1_a-909648652_2pr8qanm.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2266_t-1_a-909648652_2qr8qaof.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2267_t-1_a-909648652_2rr8qap8.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2268_t-1_a-909648652_2sr8qaq1.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2269_t-1_a-909648652_2tr8qaqh.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2270_t-1_a-909648652_2ur8qara.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2271_t-1_a-909648652_2vr8qas3.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2272_t-1_a-909648652_30r8qasi.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2273_t-1_a-909648652_31r8qat1.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2274_t-1_a-909648652_32r8qatg.20160622

Really want to catalog the above files (enter YES or NO)? YES
Cataloging files ...
Cataloging done

List of cataloged Files
=======================
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2256_t-1_a-909648652_2gr8qaih.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2257_t-1_a-909648652_2hr8qaj0.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2258_t-1_a-909648652_2ir8qajf.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2259_t-1_a-909648652_2jr8qaju.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2260_t-1_a-909648652_2kr8qakd.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2261_t-1_a-909648652_2lr8qaks.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2262_t-1_a-909648652_2mr8qall.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2263_t-1_a-909648652_2nr8qam4.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2264_t-1_a-909648652_2or8qamt.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2265_t-1_a-909648652_2pr8qanm.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2266_t-1_a-909648652_2qr8qaof.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2267_t-1_a-909648652_2rr8qap8.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2268_t-1_a-909648652_2sr8qaq1.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2269_t-1_a-909648652_2tr8qaqh.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2270_t-1_a-909648652_2ur8qara.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2271_t-1_a-909648652_2vr8qas3.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2272_t-1_a-909648652_30r8qasi.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2273_t-1_a-909648652_31r8qat1.20160622
File Name:/app/oracle/bak_arch/archivelog_arch_d-test_id-2207710614_s-2274_t-1_a-909648652_32r8qatg.20160622

then recover database;

Working with temporary tablespace and log files

Stand-alone ASM replaces storage and hosts