Shulou(Shulou.com)05/31 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.