Step1:搭建oracle dataguard-21克的思念

上帝大脸

　　[oracle@dg1 backupbk]$ rman target /

　　Recovery Manager:>　　Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
　　connected to target database: DG (DBID=1735397445)
　　RMAN> backup format ‘/u01/backupbk/full_%U’ database plus archivelog delete input;
　　Starting backup at 30-JUL-13
　　current log archived
　　using channel ORA_DISK_1
　　channel ORA_DISK_1: starting archived log backup set
　　channel ORA_DISK_1: specifying archived log(s) in backup set
　　input archived log thread=1 sequence=40 RECID=46 STAMP=822097135
　　input archived log thread=1 sequence=41 RECID=47 STAMP=822097177
　　input archived log thread=1 sequence=42 RECID=49 STAMP=822097337
　　input archived log thread=1 sequence=43 RECID=51 STAMP=822097500
　　channel ORA_DISK_1: starting piece 1 at 30-JUL-13
　　channel ORA_DISK_1: finished piece 1 at 30-JUL-13
　　piece handle=/u01/backupbk/full_1cog0dis_1_1 tag=TAG20130730T002500 comment=NONE
　　channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
　　channel ORA_DISK_1: deleting archived log(s)
　　RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
　　archived log file name=/u01/app/oracle/arch/1_40_822066437.arc thread=1 sequence=40
　　RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
　　archived log file name=/u01/app/oracle/arch/1_41_822066437.arc thread=1 sequence=41
　　RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
　　archived log file name=/u01/app/oracle/arch/1_42_822066437.arc thread=1 sequence=42
　　RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
　　archived log file name=/u01/app/oracle/arch/1_43_822066437.arc thread=1 sequence=43
　　Finished backup at 30-JUL-13
　　Starting backup at 30-JUL-13
　　using channel ORA_DISK_1
　　channel ORA_DISK_1: starting full datafile backup set
　　channel ORA_DISK_1: specifying datafile(s) in backup set
　　input datafile file number=00001 name=/u01/app/oradata/system.dbf
　　input datafile file number=00003 name=/u01/app/oradata/undotbs1.dbf
　　input datafile file number=00002 name=/u01/app/oradata/sysaux.dbf
　　channel ORA_DISK_1: starting piece 1 at 30-JUL-13
　　channel ORA_DISK_1: finished piece 1 at 30-JUL-13
　　piece handle=/u01/backupbk/full_1dog0diu_1_1 tag=TAG20130730T002501 comment=NONE
　　channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
　　channel ORA_DISK_1: starting full datafile backup set
　　channel ORA_DISK_1: specifying datafile(s) in backup set
　　including current control file in backup set
　　channel ORA_DISK_1: starting piece 1 at 30-JUL-13
　　channel ORA_DISK_1: finished piece 1 at 30-JUL-13
　　piece handle=/u01/backupbk/full_1eog0dk1_1_1 tag=TAG20130730T002501 comment=NONE
　　channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
　　Finished backup at 30-JUL-13
　　Starting backup at 30-JUL-13
　　current log archived
　　using channel ORA_DISK_1
　　channel ORA_DISK_1: starting archived log backup set
　　channel ORA_DISK_1: specifying archived log(s) in backup set
　　input archived log thread=1 sequence=44 RECID=52 STAMP=822097540
　　channel ORA_DISK_1: starting piece 1 at 30-JUL-13
　　channel ORA_DISK_1: finished piece 1 at 30-JUL-13
　　piece handle=/u01/backupbk/full_1fog0dk4_1_1 tag=TAG20130730T002540 comment=NONE
　　channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
　　channel ORA_DISK_1: deleting archived log(s)
　　RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
　　archived log file name=/u01/app/oracle/arch/1_44_822066437.arc thread=1 sequence=44
　　Finished backup at 30-JUL-13
　　[oracle@dg1 backupbk]$ ls
　　full_1cog0dis_1_1  full_1dog0diu_1_1  full_1eog0dk1_1_1  full_1fog0dk4_1_1  standby.ctl
　　[oracle@dg1 backupbk]$ scp * dg2:/u01/backupbk
　　oracle@dg2′s password:
　　full_1cog0dis_1_1                                                                                 100%  763KB 762.5KB/s   00:00
　　full_1dog0diu_1_1                                                                                 100%  326MB   5.8MB/s   00:56
　　full_1eog0dk1_1_1                                                                                 100% 9856KB   9.6MB/s   00:01
　　full_1fog0dk4_1_1                                                                                 100%   26KB  26.0KB/s   00:00
　　standby.ctl                                                                                       100% 9808KB   4.8MB/s   00:02
　　4.startup mount using standby controlfile(standby)
　　5.restore datafile(standby database)
　　RMAN> restore database;
　　Starting restore at 30-JUL-13
　　allocated channel: ORA_DISK_1
　　channel ORA_DISK_1: SID=28 device type=DISK
　　channel ORA_DISK_1: starting datafile backup set restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oradata/system.dbf
　　channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oradata/sysaux.dbf
　　channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oradata/undotbs1.dbf
　　channel ORA_DISK_1: reading from backup piece /u01/backupbk/full_1dog0diu_1_1
　　channel ORA_DISK_1: piece handle=/u01/backupbk/full_1dog0diu_1_1 tag=TAG20130730T002501
　　channel ORA_DISK_1: restored backup piece 1
　　channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
　　[root@dg2 oradata]# ls
　　con.ctl  sysaux.dbf  system.dbf  temp01.dbf  undotbs1.dbf