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

This article is about how to migrate the file system from the database to ASM, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Today, you need to migrate the data files on the file system to ASM.

Data files on the file system: / dev/sda / database/oradata archive: / dev/sda / arch

New ASM storage: / dev/sdb1, / dev/sdc1, / dev/sdd1 correspond to + DG1 of asm to store data files

+ DG2 of / dev/sde1 corresponding to asm stores archive logs / dev/sdf1 corresponds to + DG3 flashback area of asm.

1 first create an ASM disk VOL1-VOL5 correspondence / dev/sdb1-/ dev/sdf1

2 create a pfile file on ASM

3 create ASM instance password file

4 create disk group DG1 corresponding to VOL1-VOL3; DG2 corresponding to VOL4; DG3 corresponding to VOL5

5 backup

RMAN > run {

2 > backup as copy database format'+ DG1'

3 >}

At this point, all the data files on the file system are backed up to the ASM disk group DG1, and the files are automatically allocated on the ASM disk.

6 modify flashback, and data file parameters, specify the location of flashback, data file, log file on ASM

Alter system set db_create_online_log_dest_1='+DG1' scope=both

Alter system set db_create_online_log_dest_2='+DG2' scope=both

After later migration, the same log file will be placed on two ASM disk groups

SQL > select member from v$logfile

15. MEMBER

16.-

17. + DG1/orcl/onlinelog/group_1.263.929801375

18. + DG2/orcl/onlinelog/group_1.256.929801375

19. + DG1/orcl/onlinelog/group_2.264.929801379

20. + DG2/orcl/onlinelog/group_2.257.929801379

21. + DG1/orcl/onlinelog/group_3.265.929801383

twenty-two。 + DG2/orcl/onlinelog/group_3.258.929801383

7 migrate redolog as long as you rebuild the log group on ASM, you can create a new redolog on the specified ASM disk.

8 to migrate temporary tablespaces is to add data files to create existing temporary tablespaces, and then delete the data files of the original file system.

9 migrate data files and control files

Set control file location parameters and restart db restore controlfile from'/ database/oradata/orcl/control01.ctl'

Restore the control file, and then restore the data file

Alter database mount

Switch database to copy

Recover database and open the database

The above is how to migrate the file system from the database to ASM. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

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.