|
station1-2014-09-15.txt:
- nnected to an idle instance.
- SQL> startup
- ORACLE instance started.
- Total System Global Area 1073741824 bytes
- Fixed Size 1264968 bytes
- Variable Size 276824760 bytes
- Database Buffers 788529152 bytes
- Redo Buffers 7122944 bytes
- Database mounted.
- Database opened.
- SQL> exit
- Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
- With the Partitioning, OLAP and Data Mining options
- [oracle@station1 ~]$ lsnrctl services
- LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 14-SEP-2014 19:18:33
- Copyright (c) 1991, 2005, Oracle. All rights reserved.
- Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.1)(PORT=1521)))
- Services Summary...
- Service "PROD" has 2 instance(s).
- Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:0 refused:0
- LOCAL SERVER
- Instance "PROD", status READY, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:9 refused:0 state:ready
- LOCAL SERVER
- Service "PROD_DGB" has 1 instance(s).
- Instance "PROD", status READY, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:9 refused:0 state:ready
- LOCAL SERVER
- Service "PROD_XPT" has 1 instance(s).
- Instance "PROD", status READY, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:9 refused:0 state:ready
- LOCAL SERVER
- The command completed successfully
- [oracle@station1 ~]$ sqlplus /nolog
- SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 14 19:29:29 2014
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> archive log list
- Database log mode Archive Mode
- Automatic archival Enabled
- Archive destination USE_DB_RECOVERY_FILE_DEST
- Oldest online log sequence 5
- Next log sequence to archive 7
- Current log sequence 7
- SQL> exit
- Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
- With the Partitioning, OLAP and Data Mining options
- [oracle@station1 ~]$ cd /u01/app/
- [oracle@station1 app]$ ls
- oracle oraInventory
- [oracle@station1 app]$ cd oracle
- [oracle@station1 oracle]$ ls
- admin agent10g flash_recovery_area oradata oraInventory product
- [oracle@station1 oracle]$ cd flash_recovery_area/
- [oracle@station1 flash_recovery_area]$ ls
- PROD
- [oracle@station1 flash_recovery_area]$ cd PROD/
- [oracle@station1 PROD]$ ls
- archivelog autobackup flashback onlinelog
- [oracle@station1 PROD]$ cd archivelog
- [oracle@station1 archivelog]$ ls
- 2014_08_31 2014_09_04 2014_09_10 2014_09_12 2014_09_14
- [oracle@station1 archivelog]$ cd 2014_09_14
- [oracle@station1 2014_09_14]$ ls
- o1_mf_1_10_b1bn8dcx_.arc o1_mf_1_23_b1brk0hn_.arc o1_mf_1_57_b19vqs3f_.arc o1_mf_1_6_b1bl5jz2_.arc o1_mf_1_82_b1b4vlyx_.arc
- o1_mf_1_11_b1bn8xo3_.arc o1_mf_1_24_b1bsdhcb_.arc o1_mf_1_58_b19vrnjy_.arc o1_mf_1_6_b1by8fn1_.arc o1_mf_1_83_b1b4vm7t_.arc
- o1_mf_1_12_b1bn91gy_.arc o1_mf_1_25_b1bsdhj2_.arc o1_mf_1_59_b19vsfvj_.arc o1_mf_1_70_b1b03wmf_.arc o1_mf_1_84_b1b4vs79_.arc
- o1_mf_1_13_b1bn9415_.arc o1_mf_1_26_b1bsdtf7_.arc o1_mf_1_5_b1bl40n3_.arc o1_mf_1_71_b1b03x1c_.arc o1_mf_1_85_b1b4vso0_.arc
- o1_mf_1_14_b1bnf07z_.arc o1_mf_1_28_b1bsf0gg_.arc o1_mf_1_5_b1by5zkd_.arc o1_mf_1_72_b1b0nvow_.arc o1_mf_1_86_b1bh5pjh_.arc
- o1_mf_1_15_b1bnf0tz_.arc o1_mf_1_29_b1bsf0kh_.arc o1_mf_1_60_b19w3c4k_.arc o1_mf_1_73_b1b46jgo_.arc o1_mf_1_87_b1bhcwkh_.arc
- o1_mf_1_16_b1bnf3jz_.arc o1_mf_1_2_b1bhzrrb_.arc o1_mf_1_61_b19w5p1v_.arc o1_mf_1_74_b1b46jrk_.arc o1_mf_1_88_b1bhcwm5_.arc
- o1_mf_1_17_b1bnfdlw_.arc o1_mf_1_2_b1btd2rm_.arc o1_mf_1_62_b19wh1l5_.arc o1_mf_1_75_b1b46vw1_.arc o1_mf_1_89_b1bhd6sx_.arc
- o1_mf_1_18_b1bnlzpv_.arc o1_mf_1_30_b1bsr5pd_.arc o1_mf_1_63_b19whr28_.arc o1_mf_1_76_b1b46w3t_.arc o1_mf_1_8_b1bmft1y_.arc
- o1_mf_1_19_b1bnmls3_.arc o1_mf_1_3_b1bksmyd_.arc o1_mf_1_64_b19wj5br_.arc o1_mf_1_77_b1b471ch_.arc o1_mf_1_91_b1bhddss_.arc
- o1_mf_1_1_b1bhtf6n_.arc o1_mf_1_3_b1by5hrn_.arc o1_mf_1_65_b19wpdyt_.arc o1_mf_1_78_b1b471wx_.arc o1_mf_1_92_b1bhdf5b_.arc
- o1_mf_1_1_b1bsrcmt_.arc o1_mf_1_4_b1bl0nqm_.arc o1_mf_1_66_b1b03k7l_.arc o1_mf_1_79_b1b4ovf2_.arc o1_mf_1_93_b1bhsz37_.arc
- o1_mf_1_20_b1bno1xk_.arc o1_mf_1_4_b1by5zft_.arc o1_mf_1_67_b1b03kjs_.arc o1_mf_1_7_b1bmfghf_.arc o1_mf_1_9_b1bmg92r_.arc
- o1_mf_1_21_b1bqc6pd_.arc o1_mf_1_55_b19vqfm9_.arc o1_mf_1_68_b1b03pt6_.arc o1_mf_1_80_b1b4v8gt_.arc
- o1_mf_1_22_b1bqcbrh_.arc o1_mf_1_56_b19vqkrn_.arc o1_mf_1_69_b1b03q5r_.arc o1_mf_1_81_b1b4v8t3_.arc
- [oracle@station1 2014_09_14]$ ls -ltr o1_mf_1_1_*
- -rw-r----- 1 oracle oinstall 1024 Sep 14 15:10 o1_mf_1_1_b1bhtf6n_.arc
- -rw-r----- 1 oracle oinstall 1024 Sep 14 17:59 o1_mf_1_1_b1bsrcmt_.arc
- [oracle@station1 2014_09_14]$ md5sum o1_mf_1_12_b1bn91gy_.arc
- 37a6e8dbcb683aee59e50eb64f29e9e1 o1_mf_1_12_b1bn91gy_.arc
- [oracle@station1 2014_09_14]$ sqlplus /nolog
- SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 14 19:34:15 2014
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> show parameter log_Archive_format
- NAME TYPE VALUE
- ------------------------------------ ----------- ------------------------------
- log_archive_format string %t_%s_%r.dbf
- SQL> exit
- Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
- With the Partitioning, OLAP and Data Mining options
- [oracle@station1 2014_09_14]$ scp o1_mf_1_1_b1bsrcmt_.arc station2:/u01/app/oracle/stdbyarch/LOGSTDBY/
- oracle@station2's password:
- o1_mf_1_1_b1bsrcmt_.arc 100% 1024 1.0KB/s 00:00
- [oracle@station1 2014_09_14]$ sqlplus /nolog
- SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 14 19:42:36 2014
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> conn hr/hr
- Connected.
- SQL> select * from tab;
- TNAME TABTYPE CLUSTERID
- ------------------------------ ------- ----------
- T762 TABLE
- T1351 TABLE
- SQL> select * from T1351;
- A
- ----------
- 1
- SQL> update T1351 set a=2 ;
- 1 row updated.
- SQL> commit;
- Commit complete.
- SQL> select * from T1351;
- A
- ----------
- 2
- SQL> update T1351 set a=3;
- 1 row updated.
- SQL> commit;
- Commit complete.
- SQL>
复制代码
station2-2014-09-15.txt:
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> conn / as sysdba
- Connected to an idle instance.
- SQL> startup
- ORACLE instance started.
- Total System Global Area 1073741824 bytes
- Fixed Size 1264968 bytes
- Variable Size 260047544 bytes
- Database Buffers 805306368 bytes
- Redo Buffers 7122944 bytes
- Database mounted.
- Database opened.
- SQL> exit
- Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
- With the Partitioning, OLAP and Data Mining options
- [oracle@station2 ~]$ lsnrctl services
- LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 14-SEP-2014 19:18:59
- Copyright (c) 1991, 2005, Oracle. All rights reserved.
- Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.2)(PORT=1521)))
- Services Summary...
- Service "EMREP" has 1 instance(s).
- Instance "EMREP", status READY, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:17 refused:0 state:ready
- LOCAL SERVER
- Service "EMREP_XPT" has 1 instance(s).
- Instance "EMREP", status READY, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:17 refused:0 state:ready
- LOCAL SERVER
- Service "LOGSTDBY" has 1 instance(s).
- Instance "LOGSTDBY", status READY, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:9 refused:0 state:ready
- LOCAL SERVER
- Service "LOGSTDBY_DGB" has 1 instance(s).
- Instance "LOGSTDBY", status READY, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:9 refused:0 state:ready
- LOCAL SERVER
- Service "LOGSTDBY_DGMGRL" has 1 instance(s).
- Instance "LOGSTDBY", status UNKNOWN, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:8 refused:0
- LOCAL SERVER
- Service "LOGSTDBY_XPT" has 1 instance(s).
- Instance "LOGSTDBY", status READY, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:9 refused:0 state:ready
- LOCAL SERVER
- Service "STDBY_DGMGRL" has 1 instance(s).
- Instance "STDBY", status UNKNOWN, has 1 handler(s) for this service...
- Handler(s):
- "DEDICATED" established:0 refused:0
- LOCAL SERVER
- The command completed successfully
- [oracle@station2 ~]$ cd /u01/app/
- [oracle@station2 app]$ ls
- oracle oraInventory
- [oracle@station2 app]$ cd oracle/
- [oracle@station2 oracle]$ ls
- admin flash_recovery_area OracleHomes oradata oraInventory product stdbyarch
- [oracle@station2 oracle]$ cd stdbyarch
- [oracle@station2 stdbyarch]$ ls
- LOGSTDBY
- [oracle@station2 stdbyarch]$ cd LOGSTDBY/
- [oracle@station2 LOGSTDBY]$ ls
- 1_10_858265791.dbf 1_12_858265791.dbf 1_14_858265791.dbf 1_24_858265791.dbf 1_26_858265791.dbf 1_28_858265791.dbf 1_6_858275973.dbf
- 1_11_858265791.dbf 1_13_858265791.dbf 1_1_858275973.dbf 1_25_858265791.dbf 1_27_858265791.dbf 1_29_858265791.dbf dgarc
- [oracle@station2 LOGSTDBY]$ pwd
- /u01/app/oracle/stdbyarch/LOGSTDBY
- [oracle@station2 LOGSTDBY]$ md5sum 1_12_858265791.dbf
- 37a6e8dbcb683aee59e50eb64f29e9e1 1_12_858265791.dbf
- [oracle@station2 LOGSTDBY]$ ls
- 1_10_858265791.dbf 1_12_858265791.dbf 1_14_858265791.dbf 1_24_858265791.dbf 1_26_858265791.dbf 1_28_858265791.dbf 1_6_858275973.dbf
- 1_11_858265791.dbf 1_13_858265791.dbf 1_1_858275973.dbf 1_25_858265791.dbf 1_27_858265791.dbf 1_29_858265791.dbf dgarc
- [oracle@station2 LOGSTDBY]$ pwd
- /u01/app/oracle/stdbyarch/LOGSTDBY
- [oracle@station2 LOGSTDBY]$ ls
- 1_10_858265791.dbf 1_13_858265791.dbf 1_24_858265791.dbf 1_27_858265791.dbf 1_6_858275973.dbf
- 1_11_858265791.dbf 1_14_858265791.dbf 1_25_858265791.dbf 1_28_858265791.dbf dgarc
- 1_12_858265791.dbf 1_1_858275973.dbf 1_26_858265791.dbf 1_29_858265791.dbf o1_mf_1_1_b1bsrcmt_.arc
- [oracle@station2 LOGSTDBY]$ pwd
- /u01/app/oracle/stdbyarch/LOGSTDBY
- [oracle@station2 LOGSTDBY]$ . oraenv
- ORACLE_SID = [LOGSTDBY] ?
- [oracle@station2 LOGSTDBY]$ sqlplus /nolog
- SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 14 19:37:06 2014
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> alter database register logical logfile '/u01/app/oracle/stdbyarch/LOGSTDBY/o1_mf_1_1_b1bsrcmt_.arc';
- Database altered.
- SQL> alter database start logical apply immediate;
- alter database start logical apply immediate
- *
- ERROR at line 1:
- ORA-00905: missing keyword
- SQL> alter database start logical standby apply immediate;
- alter database start logical standby apply immediate
- *
- ERROR at line 1:
- ORA-16103: Logical Standby apply must be stopped to allow this operation
- SQL> alter database stop logical standby apply ;
- Database altered.
- SQL> alter database start logical standby apply immediate;
- Database altered.
- SQL> conn hr/hr
- Connected.
- SQL> select * from t1351;
- A
- ----------
- 1
- SQL> /
- A
- ----------
- 1
- SQL> /
- A
- ----------
- 1
- SQL> /
- A
- ----------
- 2
- SQL> /
- A
- ----------
- 2
- SQL> /
- A
- ----------
- 2
- SQL> /
- A
- ----------
- 2
- SQL> /
- A
- ----------
- 3
- SQL>
复制代码
2014-09-15.sql:
- select * from dba_logstdby_events order by event_time desc;
- select * from v$logstdby_process;
- select * from dba_logstdby_log;
- select * from v$logstdby_state;
- select * from v$logstdby_progress;
- select * from dba_logstdby_parameters;
- begin
- dbms_logstdby.apply_set('LOG_AUTO_DELETE','FALSE');
- end;
复制代码
2014-09-15.txt:
- select * from dba_logstdby_events order by event_time desc;
- select * from v$logstdby_process;
- select * from dba_logstdby_log;
- select * from v$logstdby_state;
- select * from v$logstdby_progress;
复制代码
|
|