Get the App
SLTechnology News&Howtos  ›  Database  › 

How to migrate database bare device data files to other bare devices

Shulou Source: shulou.com Published: 2022-05-31 15:41:06 11月17日 Update

This article mainly explains "how to migrate database bare device data files to other bare devices". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to migrate database bare device data files to other bare devices".

1. Create a bare device

Create a bare device on hp and authorize

Mklv-y lvname-t jfs2-T-O-S 128k vgname 256 hdisk1 hdisk2

Chown oracle:oinstall / dev/rlvname

2. Offline the corresponding data file

Alter database datafile'/ dev/rxdb001' offline

3. Copy by using rman copy

Rman target /

Copy datafile'/ dev/rxdb001' to'/ dev/rlvname'

4. Rename the database offline data file

Alter database rename file'/ dev/rxdb001' to'/ dev/rlvname'

5. Try to online the offline data file

Alter database datafile'/ dev/rlvname' online

Note: in general, you will be prompted to restore the file. Execute the following command:

Recover datafile'/ dev/rlvname'

Perform online operation of data file again

Alter database datafile'/ dev/rlvname' online

At this point, I believe you have a deeper understanding of "how to migrate database bare device data files to other bare devices". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Tags: Data files devices databases content learning practical deeper interest again commands practicality reality situation simple operation way method more friends website Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Huawei Linux Docker macOS OPPO Reno