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

This article mainly introduces how Oracle uses RMAN to convert ordinary data files into ASM. The article is very detailed and has a certain reference value. Interested friends must read it!

1. Database Boot to mount

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > startup mount

2. RMAN backup data files

RMAN > backup as copy database format'+ data'

Starting backup at 27-MAR-18

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=6 device type=DISK

Channel ORA_DISK_1: starting datafile copy

Input datafile file number=00001 name=/u01/app/oracle/oradata/test/system01.dbf

3. Switch datafile

RMAN > switch database to copy

Datafile 1 switched to datafile copy "+ DATA/test/datafile/system.276.971869559"

Datafile 2 switched to datafile copy "+ DATA/test/datafile/sysaux.277.971869589"

Datafile 3 switched to datafile copy "+ DATA/test/datafile/undotbs1.278.971869615"

Datafile 4 switched to datafile copy "+ DATA/test/datafile/users.280.971869621"

4. Alter database open

SQL > alter database open

Database altered.

5. Verification

SQL > select file_name from dba_data_files

FILE_NAME

+ DATA/test/datafile/users.280.971869621

+ DATA/test/datafile/undotbs1.278.971869615

+ DATA/test/datafile/sysaux.277.971869589

+ DATA/test/datafile/system.276.971869559

The above is all the contents of the article "how Oracle uses RMAN to convert ordinary data files into ASM". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to 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.