01.dbf tag=TAG20151019T173607 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 Finished backup at 19-OCT-15 sql statement: alter system archive log current contents of Memory Script: { switch clone datafile all; } executing Memory Script datafile 1 switched to datafile copy input datafile copy RECID=3 STAMP=893526478 file name=/home/oradata/powerdes/system01.dbf datafile 2 switched to datafile copy input datafile copy RECID=4 STAMP=893526478 file name=/home/oradata/powerdes/sysaux01.dbf datafile 3 switched to datafile copy input datafile copy RECID=5 STAMP=893526479 file name=/home/oradata/powerdes/undotbs01.dbf datafile 4 switched to datafile copy input datafile copy RECID=6 STAMP=893526479 file name=/home/oradata/powerdes/users01.dbf datafile 5 switched to datafile copy input datafile copy RECID=7 STAMP=893526479 file name=/home/oradata/powerdes/powerdesk01.dbf datafile 6 switched to datafile copy input datafile copy RECID=8 STAMP=893526479 file name=/home/oradata/powerdes/plas01.dbf datafile 7 switched to datafile copy input datafile copy RECID=9 STAMP=893526479 file name=/home/oradata/powerdes/pl01.dbf datafile 8 switched to datafile copy input datafile copy RECID=10 STAMP=893526479 file name=/home/oradata/powerdes/help01.dbf datafile 9 switched to datafile copy input datafile copy RECID=11 STAMP=893526479 file name=/home/oradata/powerdes/adobelc01.dbf datafile 10 switched to datafile copy input datafile copy RECID=12 STAMP=893526479 file name=/home/oradata/powerdes/sms01.dbf datafile 11 switched to datafile copy input datafile copy RECID=13 STAMP=893526479 file name=/home/oradata/powerdes/plcrm01.dbf datafile 12 switched to datafile copy input datafile copy RECID=14 STAMP=893526479 file name=/home/oradata/powerdes/powerdesk02.dbf datafile 13 switched to datafile copy input datafile copy RECID=15 STAMP=893526479 file name=/home/oradata/powerdes/datagm01.dbf Finished Duplicate Db at 19-OCT-15 RMAN>
4.6，去standby从库启动open
SQL> alter database open; Database altered. SQL>
4.7 去standby从库开始应用日志
SQL> alter database recover managed standby database disconnect from session; Database altered. SQL>
4.8 check 主备一致性
从库standby 上check
SQL> select sequence#,applied from v$archived_log order by sequence# asc; SEQUENCE# APPLIED ---------- --------- 38268 YES 38269 YES 38270 YES 38271 YES SQL>
主库primary上check
SQL> select sequence#,applied from v$archived_log order by sequence# asc; SEQUENCE# APPLIED ---------- --------- 38265 NO 38265 YES 38266 NO 38267 NO 38268 YES 38268 NO 38269 NO 38269 YES 38270 NO 38270 YES 38271 YES SEQUENCE# APPLIED ---------- --------- 38271 NO 5600 rows selected. SQL>
4.9 check
主库上primary上操作
SQL> create table z_z_test(id number); Table created. SQL> insert into z_z_test values(1); 1 row created. SQL> commit; Commit complete. SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /oracle/app/oracle/flash_recovery_area/archivelog Oldest online log sequence 38270 Next log sequence to archive 38272 Current log sequence 38272 SQL> SQL> SQL> alter system switch logfile; System altered. SQL>
从库standby上查询数据：
SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /data/oracle/oradgdata/standby_archive Oldest online log sequence 38271 Next log sequence to archive 0 Current log sequence 38272 SQL> archive l