Stand-alone ASM replaces storage and host 02/24 Update SLTechnology News&Howtos

Stand-alone ASM replaces storage and host

2025-02-24 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Shulou(Shulou.com)06/01 Report--

Oracle ASM replaces storage and hosts:

1. When installing stand-alone GRID and database software on a new host, you can copy it from the source host and then clone the operation

two。 Hang the new storage on the old host, create a new disk group, back up the database to the new disk group with back as copy, and then

New storage is unmapped from the old host

3. Export the old OCR and import it to 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 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 DATABASE TO COPY

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 the target

And 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

Do you really want to catalog the above files (enter YES or NO)? YES

Cataloging files...

Cataloging done

List of Cataloged Files