Dataguard online standby database Reconstruction

Environment: OS: centos 6.5x64 dB: Oracle 10.2.0.5 fault: the master and slave logs are synchronized due to the active master write of the slave database due to an error, and the slave database is rebuilt. close the slave database, delete the data file and control file, and redo file Rm-RF *. log Rm-RF *. CTL Rm-RF *. dbf2. primary database backup database channel ora_disk_1: Starting piece 1 at 13-sep-14rman-00571: ========================================================== ============================== RMAN-00569: ================ error message stack follows ============================ RMAN-00571: ========================================================== ============================== RMAN-03002: failure of backup plus archivelog command at 09/13/2014 17: 32: 18ora-19809: limit exceeded for recovery filesORA-19804: cannot reclaim 2380478464 bytes disk space from 2147483648 limit this error occurs when backing up, this is because the backup archive log exceeds the default backup space capacity of the database (flash_recovery_area ). SQL> show parameters db_recovery_file_destname type value ------------------------------------ ----------- ------------------------------ db_recove Ry_file_dest string/u01/APP/Oracle/flash_recovery _ too big integer 2G expands db_recovery_file_dest_size of the master database to 4 gsql> alter system set db_recovery_file_dest_size = 4G scope = both; system altered.3. recreate the backup Database Control File RMAN> Backup full database format = '/u01/backup/% d _ % S. dbf' plus archivelog Delete input; starting backup at 13-sep-14current log archivedusing channel ora_disk_1channel ora_disk_1: Starting archive log backupsetchannel ora_disk_1: specifying archive log (s) in backup setinput archive log thread = 1 sequence = 3 recid = 1 Stamp = 857934488 input archive log thread = 1 sequence = 4 recid = 3 stamp = 858007446 input archive log thread = 1 sequence = 5 recid = 5 Stamp = 858008785 input archive log thread = 1 sequence = 6 recid = 7 stamp = 858009084 input archive log thread = 1 sequence = 7 recid = 9 stamp = 858009195 Input Archive log thread = 1 sequence = 8 recid = 11 stamp = 858009210 input archive log thread = 1 sequence = 9 recid = 13 stamp = 858009668 input archive log thread = 1 sequence = 10 recid = 15 stamp = 858009683 input archive log thread = 1 sequence = 11 recid = 17 stamp = 858009702 input archive log thread = 1 sequence = 12 recid = 19 stamp = 858009732 input archive log thread = 1 sequence = 13 recid = 20 stamp = 858009737 input archive log thread = 1 seq Uence = 14 recid = 21 stamp = 858009750 input archive log thread = 1 sequence = 15 recid = 23 stamp = 858009765 input archive log thread = 1 sequence = 16 recid = 24 stamp = 858009776 Input archive log thread = 1 sequence = 17 recid = 25 stamp = 858009794 input archive log thread = 1 sequence = 18 recid = 28 stamp = 858009817 input archive log thread = 1 sequence = 19 recid = 30 stamp = 858009846 input archive log thread = 1 sequence = 20 recid = 32 stam P = 858009866 input archive log thread = 1 sequence = 21 recid = 35 stamp = 858009908 input archive log thread = 1 sequence = 22 recid = 39 stamp = 858010410 input archive log thread = 1 sequence = 23 recid = 41 stamp = 858011048 input archive log thread = 1 sequence = 24 recid = 43 stamp = 858011098 input archive log thread = 1 sequence = 25 recid = 45 stamp = 858011962 input Archive log thread = 1 sequence = 26 recid = 47 stamp = 858012039 input Archi Ve log thread = 1 sequence = 27 recid = 49 stamp = 858012458 input archive log thread = 1 sequence = 28 recid = 50 stamp = 858012493 input archive log thread = 1 sequence = 29 recid = 52 stamp = 858012545 input archive log thread = 1 sequence = 30 recid = 55 stamp = 858012614 input archive log thread = 1 sequence = 31 recid = 57 stamp = 858012692 input archive log thread = 1 sequence = 32 recid = 58 stamp = 858012748 input archive log thread = 1 sequen Ce = 33 recid = 60 stamp = 858012806 input archive log thread = 1 sequence = 34 recid = 63 stamp = 858012901 input archive log thread = 1 sequence = 35 recid = 65 stamp = 858012986 Input archive log thread = 1 sequence = 36 recid = 67 stamp = 858013083 input archive log thread = 1 sequence = 37 recid = 68 stamp = 858013186 input archive log thread = 1 sequence = 38 recid = 70 stamp = 858013254 input archive log thread = 1 sequence = 39 recid = 73 stamp = 8 58013356 input archive log thread = 1 sequence = 40 recid = 75 stamp = 858013449 input archive log thread = 1 sequence = 41 recid = 77 stamp = 858013577 input archive log thread = 1 sequence = 42 recid = 79 stamp = 858018255 input archive log thread = 1 sequence = 43 recid = 81 stamp = 858019538 input archive log thread = 1 sequence = 44 recid = 82 stamp = 858019747 input archive log thread = 1 sequence = 45 recid = 85 stamp = 858020928 input Archive Log thread = 1 sequence = 46 recid = 87 stamp = 858020930 input archive log thread = 1 sequence = 47 recid = 89 stamp = 858021699 input archive log thread = 1 sequence = 48 recid = 90 stamp = 858021700 input archive log thread = 1 sequence = 49 recid = 93 stamp = 858076987 input archive log thread = 1 sequence = 50 recid = 95 stamp = 858158029 input archive log thread = 1 sequence = 51 recid = 97 stamp = 858161261 input archive log thread = 1 sequence = 52 recid = 99 stamp = 858165545 input archive log thread = 1 sequence = 53 recid = 101 stamp = 858176150 input archive log thread = 1 sequence = 54 recid = 102 stamp = 858176234 input archive log thread = 1 sequence = 55 recid = 103 stamp = 858183498 input archive log thread = 1 sequence = 56 recid = 104 stamp = 858185684 input archive log thread = 1 sequence = 57 recid = 105 stamp = 858186930 input archive log thread = 1 sequence = 58 recid = 106 stam P = 858187380 input archive log thread = 1 sequence = 59 recid = 107 stamp = 858187931 input archive log thread = 1 sequence = 60 recid = 108 stamp = 858188097 channel ora_disk_1: starting piece 1 at 13-sep-14channel ora_disk_1: finished piece 1 at 13-sep-14piece handle =/u01/APP/Oracle/flash_recovery_area/netdata_pd/backupset/2014_09_13/pai _. bkp tag = tag20140913t173457 comment = nonech Annel ora_disk_1: Backup set complete, elapsed time: 00: 02: 27 channel ora_disk_1: deleting archive log (s) archive log filename =/u01/APP/Oracle/archive/netdata/1_3_857898543.arc recid = 1 Stamp = 857934488 archive log filename =/u01/APP/Oracle/archive/netdata/1_4_857898543.arc recid = 3 stamp = 858007446 archive log filename =/u01/APP/Oracle/archive/netdata/4155_857898543.arc recid = 5 Stamp = 858008785 archive log fi Lename =/u01/APP/Oracle/archive/netdata/ipv6_857898543.arc recid = 7 stamp = 858009084 archive log filename =/u01/APP/Oracle/archive/netdata/volume recid = 9 stamp = 858009195 archive log filename =/u01/APP/Oracle/archive/netdata/ipv8_857898543.arc recid = 11 stamp = 858009210 archive log filename =/u01/APP/Oracle/archive/netdata/ipv9_857898543.arc recid = 13 stamp = 858009668 archive log filename =/u01/APP/Oracle /Archive/netdata/logs recid = 15 stamp = 858009683 archive log filename =/u01/APP/Oracle/archive/netdata/201711_857898543.arc recid = 17 stamp = 858009702 archive log filename =/u01 /APP/Oracle/archive/netdata/ipv12_857898543.arc recid = 19 stamp = 858009732 archive log filename =/u01/APP/Oracle/archive/netdata/ipv13_857898543.arc recid = 20 stamp = 858009737 archive log filename =/u01/APP/Oracle/archive/netdata /Export 14_857898543.arc recid = 21 stamp = 858009750 archive log filename =/u01/APP/Oracle/archive/netdata/export 15_857898543.arc recid = 23 stamp = 858009765 archive log filename =/u01/APP//archive/netdata/logs recid = 24 stamp = 858009776 archive log filename =/u01/APP/Oracle/archive/netdata/41517_857898543.arc recid = 25 stamp = 858009794 archive log filename =/u01 /APP/Oracle/archive/netdata/ipv18_857898543. Arc recid = 28 stamp = 858009817 archive log filename =/u01/APP/Oracle/archive/netdata/201719_857898543.arc recid = 30 stamp = 858009846 archive log filename =/u01/APP/Oracle/ archive/netdata/ipv20_857898543.arc recid = 32 stamp = 858009866 archive log filename =/u01/APP/Oracle/archive/netdata/1_21_857898543.arc recid = 35 stamp = 858009908 archive log filename =/u01/ APP/Oracle/archive/netdata/ipv22_857898543.arc recid = 39 sta MP = 858010410 archive log filename =/u01/APP/Oracle/archive/netdata/41523_857898543.arc recid = 41 stamp = 858011048 archive log filename =/u01/APP/Oracle/archive/netdata/ 201724_857898543.arc recid = 43 stamp = 858011098 archive log filename =/u01/APP/Oracle/archive/netdata/255.25_857898543.arc recid = 45 stamp = 858011962 archive log filename =/u01/APP/Oracle/ archive/netdata/ipv26_857898543.arc recid = 47 stamp = 858012039 Arch Ive log filename =/u01/APP/Oracle/archive/netdata/41527_857898543.arc recid = 49 stamp = 858012458 archive log filename =/u01/APP/Oracle/archive/netdata/41528_857898543.arc recid 50 stamp = 858012493 archive log filename =/u01/APP/Oracle/archive/netdata/41529_857898543.arc recid = 52 stamp = 858012545 archive log filename =/u01/APP/Oracle/archive/netdata /Optional 30_857898543.arc recid = 55 stamp = 858012614 archive log filename =/U01/APP/Oracle/archive/netdata/ipv31_857898543.arc recid = 57 stamp = 858012692 archive log filename =/u01/APP/Oracle/archive/netdata/ipv32_857898543.arc recid = 58 stamp 858012748 archive log filename =/u01/APP/Oracle/archive/netdata/41533_857898543.arc recid = 60 stamp = 858012806 archive log filename =/u01/APP/Oracle/archive/netdata/latest recid = 63 stamp = 858012901 archive log filename =/u01/APP/Oracle /Archive/netdata/logs recid = 65 stamp = 858012986 archive log filename =/u01/APP/Oracle/archive/netdata/logs 36_857898543.arc recid = 67 stamp = 858013083 archive log filename =/u01 /APP/Oracle/archive/netdata/export 37_857898543.arc recid = 68 stamp = 858013186 archive log filename =/u01/APP/Oracle/archive/netdata/export 38_857898543.arc recid = 70 stamp = 858013254 archive log filename =/u01/APP/Oracle/archive/netdata /Optional 39_857898543.arc recid = 73 stamp = 858013356 archive log filename =/u01/APP/Oracle/archive/netdata/41540_857898543.arc recid = 75 stamp = 858013449 archive log filename =/u01/APP//archive/netdata/logs recid = 77 stamp = 858013577 archive log filename =/u01/APP/Oracle/archive/netdata/10942_857898543.arc recid = 79 stamp = 858018255 archive log filename =/u01 /APP/Oracle/archive/netdata/ipv43_857898543. Arc recid = 81 stamp = 858019538 archive log filename =/u01/APP/Oracle/archive/netdata/201744_857898543.arc recid = 82 stamp = 858019747 archive log filename =/u01/APP/Oracle/ archive/netdata/export 45_857898543.arc recid = 85 stamp = 858020928 archive log filename =/u01/APP/Oracle/archive/netdata/export recid = 87 stamp = 858020930 archive log filename =/u01/ APP/Oracle/archive/netdata/ipv47_857898543.arc recid = 89 sta MP = 858021699 archive log filename =/u01/APP/Oracle/archive/netdata/41548_857898543.arc recid = 90 stamp = 858021700 archive log filename =/u01/APP/Oracle/archive/netdata/ export 49_857898543.arc recid = 93 stamp = 858076987 archive log filename =/u01/APP/Oracle/archive/netdata/export 50_857898543.arc recid = 95 stamp = 858158029 archive log filename =/u01/APP/Oracle/ archive/netdata/logs 51_857898543.arc recid = 97 stamp = 858161261 RMAN -08137: Warning: archive log not deleted as it is still neededarchive log filename =/u01/APP/Oracle/archive/netdata/10952_857898543.arc thread = 1 sequence = 52rman-08133: Warning: archive log not deleted as it is still neededarchive log filename =/u01/APP/Oracle/archive/netdata/41553_857898543.arc thread = 1 sequence = 53rman-08133: Warning: archive log not deleted as it is still neededarchive log filename =/ U01/APP/Oracle/archive/netdata/ipv54_857898543.arc thread = 1 sequence = 54rman-08133: Warning: archive log not deleted as it is still neededarchive log filename =/u01/APP/Oracle/archive/netdata/41555_857898543.arc thread = 1 sequence = 55rman-08133: Warning: archive log not deleted as it is still neededarchive log filename =/u01/APP/Oracle/archive/netdata/10956_857898543.arc thread = 1 sequence = 56rman-08133: wa Rning: archive log not deleted as it is still neededarchive log filename =/u01/APP/Oracle/archive/netdata/FIG: Warning: archive log not deleted as it is still neededarchive log filename =/u01/APP/Oracle/archive/netdata/10958_857898543.arc thread = 1 sequence = 58rman-08133: Warning: archive log not deleted as it is still neededarchive log filename =/u01/APP/or ACLE/archive/netdata/logs 59_857898543.arc thread = 1 sequence = 59rman-08133: Warning: archive log not deleted as it is still your log filename =/u01/APP/Oracle/archive/netdata/login thread = 1 sequence = 60 finished backup at 13-sep-14starting backup at 13-sep-14using channel ora_disk_1channel ora_disk_1: starting full datafile backupsetchannel ora_disk_1: specifying datafile (s) in back Upsetinput datafile fno = 00001 name =/u01/APP/Oracle/oradata/netdata/system01.dbfinput datafile fno = 00003 name =/u01/APP/Oracle/oradata/netdata/sysaux01.dbfinput datafile fno = 00005 name =/u01/APP/Oracle/oradata/netdata/example01.dbfinput datafile fno = 00006 name =/u01/APP/Oracle/oradata/netdata/htsdk_01.dbfinput datafile fno = 00007 name =/ u01/APP/Oracle/oradata/netdata/htsdk_index_01.dbfinput datafile fno = 00002 name =/u01/APP/Oracle/oradata/netdata/undotbs01.dbfinput datafile fno = 00004 name =/u01/APP/Oracle/oradata/netdata/users01.dbfchannel ora_disk_1: starting piece 1 at 13-sep-14channel ora_disk_1: finished piece 1 at 13-sep-14piece handle =/u01/backup/snapshot tag = partition comment = nonechannel ora_disk_1: Backup set complete, elapsed time: 00: 02: 06 channel ora_disk_1: Starting full d Atafile backupsetchannel ora_disk_1: specifying datafile (s) in backupsetincluding current control file in current spfile in backupsetchannel ora_disk_1: Starting piece 1 at 13-sep-14channel ora_disk_1: finished piece 1 at 13-sep-14piece handle =/u01/backup/netdata_8.dbf tag = tag20140913t173725 comment = nonechannel ora_disk_1: Backup set complete, elapsed time: 00: 00: 02 finished back Up at 13-sep-14starting backup at 13-sep-14current log archivedusing channel ora_disk_1channel ora_disk_1: Starting archive log backupsetchannel ora_disk_1: specifying archive log (s) in backup setinput archive log thread = 1 sequence = 61 recid = 109 stamp = 858188374 channel ora_disk_1: Starting piece 1 at 13-sep-14channel ora_disk_1: finished piece 1 at 13-sep-14piece handle =/u01/APP/Oracle/flash_recover Y_area/netdata_pd/backupset/2014_09_13/o1_mf_annnn_tag20140913t173934_b1846q4v _. bkp tag = tag20140913t173934 comment = nonechannel ora_disk_1: Backup set complete, elapsed time: 00: 00: 02rman-08133: Warning: archive log not deleted as it is still neededarchive log filename =/u01/APP/Oracle/archive/netdata/10961_857898543.arc thread = 1 sequence = 61 finished backup at 13-sep-14rman> quitrecovery Manager Ete. backup completed 4. re-create the control file SQL for the slave database> alter database create standby controlfile as '/u01/control01.ctl '; database altered.5. Copy the backup file and control file to the same Backup Directory of the slave database [[email protected] backup] $ SCP/u01/backup /*. DBF [email protected]:/u01/backup [email protected]'s password: netdata_7.dbf 100% 1926 MB 6.2 Mb/s 05:11 netdata_8.dbf 100% 7200kb 7.0 Mb/s 00:01 [[email protected] backup] $ SCP/u01/control01.ctl [email protected]:/u01/backup [Email protected]'s password: control01.ctl 100% 7120kb 7.0 Mb/s [[email protected] backup] $ copy three control file files to the specified control file directory CP stcontrol01.ctl/u01/APP/Oracle/oradata/netdata/control01.ctlcp stcontrol01.ctl /u01/APP/Oracle/oradata/netdata/control02.ctlcp stcontrol01.ctl/u01/APP/Oracle/oradata/netdata/control03.ctl6. recover the standby database [[email protected] ~] $ RMAN target/recovery Manager: Release 10.2.0.5.0-production on Sat Sep 13 18:25:57 2014 copyright (c) 1982,200 7, Oracle. all rights reserved. connected to target database: netdata (dbid = 351758316, not open) RMAN> Restore database; do not recover the database here; 7. the slave database starts to receive application logs [[email protected] ~] $ Sqlplus/As sysdbasql * Plus: Release 10.2.0.5.0-production on Sat Sep 13 18:26:25 2014 copyright (c) 1982,201 0, Oracle. all rights reserved. connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit productionwith the partitioning, OLAP, data mining and real application testing optionssql> alter database recover managed standby database disconnect from session; 8. verify that the standby database is synchronized: archive log list; database Log mode archive modeautomatic archival enabledarchive destination/u01/APP/Oracle/archive/netdataoldest online log sequence 63 next log sequence to archive 0 current log sequence 67col name format A50; col dest_name format a40col error format a20set line 200; Select name, sequence #, applied from V $ archived_log A where. sequence # = (select max (sequence #) from V $ archived_log ); name sequence # app route ---------- ---/u01/APP/Oracle/archive/netdata/route 66_857898543.arc 66 yescol dest_name format a40sql> select dest_name, status, error from V $ archive_dest where rownum <3; dest_name status error ---------------------------------------- -------------------------- log_archive_dest_1 validlog_archive_dest_2 valid primary database: archive log list; database Log mode archive modeautomatic archival enabledarchive destination/u01/APP/Oracle/archive/netdataoldest online log sequence 65 next log sequence to archive 67 current log sequence 67col name format A50; SQL> Col dest_name format a40col error format a20set line 200; Select name, sequence #, applied from V $ archived_log A where. sequence # = (select max (sequence #) from V $ archived_log); SQL> Col dest_name format a40select dest_name, status, error from V $ archive_dest where rownum <3; name sequence # app route ---------- ---/u01/APP/Oracle/archive/netdata/route 66 nonetdata_sd 66 yessql> SQL> dest_name status error cause --------- -------------------- log_archive_dest_1 invalid valid

 

Dataguard online standby database Reconstruction