INSTANCE_NAME VERSION DATABASE_STATUS HOST_NAME SQL> select INSTANCE_NAME,VERSION,DATABASE_STATUS,HOST_NAME from v$instance u01/app/oracle/fast_recovery_area/DEMTEST/onlinelog/o1_mf_1_ftgqw771_.logģ.Let’s check Instance Name and Version of Grid Infrastructure. u01/app/oracle/oradata/DEMTEST/onlinelog/o1_mf_1_ftgqw68q_.log u01/app/oracle/fast_recovery_area/DEMTEST/onlinelog/o1_mf_2_ftgqwbss_.log u01/app/oracle/oradata/DEMTEST/onlinelog/o1_mf_2_ftgqwb52_.log u01/app/oracle/fast_recovery_area/DEMTEST/onlinelog/o1_mf_3_ftgqwgnj_.log u01/app/oracle/oradata/DEMTEST/onlinelog/o1_mf_3_ftgqwfrs_.log u01/app/oracle/oradata/DEMTEST/datafile/o1_mf_temp_ftgqxgmk_.tmp u01/app/oracle/oradata/DEMTEST/datafile/o1_mf_sysaux_ftgqoro6_.dbf u01/app/oracle/oradata/DEMTEST/datafile/o1_mf_system_ftgqqt14_.dbf u01/app/oracle/oradata/DEMTEST/datafile/o1_mf_undotbs1_ftgqtjo8_.dbf u01/app/oracle/oradata/DEMTEST/datafile/o1_mf_users_ftgqthfw_.dbf SQL> select FILE_NAME from DBA_DATA_FILES u01/app/oracle/fast_recovery_area/DEMTEST/controlfile/o1_mf_ftgqw321_.ctl Spfile string /u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfileDEMTEST.oraĬontrol_files string /u01/app/oracle/oradata/DEMTEST/controlfile/o1_mf_ftgqw2ry_.ctl, Let’s check location of Parameter file, Control file, Datafile, Tempfile and Redo Logfile of the database DEMTEST. SQL> select NAME,VERSION,DATABASE_STATUS, HOST_NAME from v$database,v$instance ĭEMTEST 12.1.0.2.0 ACTIVE Ģ. Let’s check the Name and Version of the database. If you haven’t created ASM instance yet, you can check this article.ġ. Here I’m assuming you already have up and running ASM instance with +DATA and +FRA ASM diskgroups. In this demonstration Oracle RDBMS version is 12.1.0.2 and Grid Infrastructure is also 12.1.0.2. ‘ RMAN backup as copy’ is one of the methods of migrating database from File System to ASM. There are many ways which can be used to migrate Oracle Database from File System to ASM. Migrating Oracle Database 12cR1 from File System to ASM using RMAN.
0 kommentar(er)
