工程日志數(shù)據(jù)庫(kù)遷移到asm-全文預(yù)覽
【正文】 1 /u01/app/oracle/oradata/prod/15:05:10 SYS prodalter database tempfile 39。/u01/app/oracle/oradata/prod/39。6 recover database。查詢數(shù)據(jù)文件的位置NAME+DG1/prod/datafile/+DG1/prod/datafile/+DG1/prod/datafile/+DG1/prod/datafile/+DG1/prod/datafile/ 恢復(fù)數(shù)據(jù)庫(kù)RMAN run{2 allocate channel c1 device type disk。Starting restore at 27MAR14using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=155 devtype=DISKchannel ORA_DISK_1: restoring control filechannel ORA_DISK_1: restore plete, elapsed time: 00:00:35output filename=+DG1/prod/controlfile/output filename=+DG1/prod/controlfile/output filename=+DG1/prod/controlfile/Finished restore at 27MAR1414:40:08 SYS prodalter database mount。prod39。+DG139。prod39。+DG1/39。9} using target database control file instead of recovery catalogdatabase dismountedOracle instance shut downconnected to target database (not started)Oracle instance starteddatabase mountedTotal System Global Area 612368384 bytesFixed Size 2022800 bytesVariable Size 134218352 bytesDatabase Buffers 469762048 bytesRedo Buffers 6365184 bytesallocated channel: c1channel c1: sid=157 devtype=DISKallocated channel: c2channel c2: sid=154 devtype=DISKallocated channel: c3channel c3: sid=153 devtype=DISKallocated channel: c4channel c4: sid=152 devtype=DISKStarting backup at 27MAR14channel c1: starting datafile copyinput datafile fno=00004 name=/disk1/oradata/prod/channel c2: starting datafile copyinput datafile fno=00002 name=/u01/app/oracle/oradata/prod/channel c3: starting datafile copyinput datafile fno=00001 name=/u01/app/oracle/oradata/prod/channel c4: starting datafile copyinput datafile fno=00003 name=/u01/app/oracle/oradata/prod/output filename=+DG1/prod/datafile/ tag=ORA_ASM_MIGRATION recid=24 stamp=843314663channel c4: datafile copy plete, elapsed time: 00:04:25channel c4: starting datafile copyinput datafile fno=00005 name=/u01/app/oracle/oradata/prod/output filename=+DG1/prod/datafile/ tag=ORA_ASM_MIGRATION recid=25 stamp=843314867channel c4: datafile copy plete, elapsed time: 00:03:25output filename=+DG1/prod/datafile/ tag=ORA_ASM_MIGRATION recid=26 stamp=843314905channel c2: datafile copy plete, elapsed time: 00:08:28output filename=+DG1/prod/datafile/ tag=ORA_ASM_MIGRATION recid=27 stamp=843314908channel c3: datafile copy plete, elapsed time: 00:08:27output filename=+DG1/prod/datafile/ tag=ORA_ASM_MIGRATION recid=28 stamp=843315048channel c1: datafile copy plete, elapsed time: 00:10:54Finished backup at 27MAR14Starting Control File and SPFILE Autobackup at 27MAR14piece handle=/local_backup/backup/control/c2543085702014032700 ment=NONEFinished Control File and SPFILE Autobackup at 27MAR14released channel: c1released channel: c2released channel: c3released channel: c4RMAN backup as backupset spfile。8 backup as copy incremental level 0 database format 39。4 allocate channel c1 type disk。INSTANCE_NAME STATUS +ASM STARTED如果陣列已經(jīng)有RAID保護(hù)，就用external redundancy（外部冗余,磁盤數(shù)最好為偶數(shù)），就可不需再做normal redundancy（雙向冗余），以免增加IO。/dev/rlv_asm239。/as sysdba39。root39。*.asm_diskstring=39。*.large_pool_size=12M*.remote_login_passwordfile=39。*.core_dump_dest=39。 t 39。 t 39。 t 39。lv_asm139。lv_asm239。lv_asm339。/u01/app/oracle/admin/+ASM/bdump39。asm39。/u01/app/oracle/admin/+ASM/udump39。s Password:[tuh W]$bash[13:33:27rootaix207 dbs]cd $ORACLE_HOME/bin[13:33:37rootaix207 bin]./localconfig delete/etc/oracle does not exist. Creating it now.No such file or directory/etc/[519]: /etc/oracle/scls_scr/aix207/root/cssrun: cannot createtouch: /etc/oracle/scls_scr/aix207/root/nooprocd cannot createtouch: /etc/oracle/scls_scr/aix207/root/noclsmon cannot createFailure 33 in main OCR context initialization: PROC33: Oracle Cluster Registry is not configured Operating System error [No such file or directory] [2]Shutdown has begun. The daemons should exit soon.[13:33:48rootaix207 bin]./localconfig addSuccessfully accumulated necessary OCR keys.Creating OCR keys for user 39。..Operation successful.Configuration for local CSS has been initializedAdding to inittabStartup will be queued to init within 30 seconds.Checking the status of new Oracle init process...Expecting the CRS daemons to be up within 600 seconds.CSS is active on these nodes. aix207CSS is active on all nodes.Oracle CSS service is installed and running under init(1M)[13:36:30oracleaix207 ~]$export ORACLE_SID=+ASM[13:36:33oracleaix207 ~]$sqlplus 39。13:40:25 3 failgroup FG2 disk 39。Diskgroup created.13:47:19 SYS +ASMselect instance_name,status from v$instance。3 startup mount。7 allocate channel c4 type disk。ORA_ASM_MIGRATION39。Starting restore at 27MAR14using ch
語(yǔ)文相關(guān)推薦
鄂ICP備17016276號(hào)-1