Primary Database:
[oracle@dbvisit1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Tue May 6 18:27:22 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> connect sys/oracle as sysdba
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 1870647296 bytes
Fixed Size 2229424 bytes
Variable Size 469764944 bytes
Database Buffers 1392508928 bytes
Redo Buffers 6144000 bytes
Database mounted.
Database opened.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 11
Next log sequence to archive 13
Current log sequence 13
SQL> connect scott/oracle
Connected.
SQL> create table sample (no number);
Table created.
SQL> connect sys/oracle as sysdba
Connected.
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
Transferring Archive Log Files from Primary Database to Physical Standby Database:
[oracle@dbvisit1 standby]$ ./dbvisit proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.9151) (pid 4187)
dbvisit started on dbvisit1: Tue May 6 18:47:54 2014 ()
=============================================================
Obtaining information from standby database (RUN_INSPECT=Y)...
Checking Dbvisit Standby configurational differences between dbvisit1 and dbvisi t2...
No Dbvisit Standby configurational differences found between dbvisit1 and dbvisi t2.
Log file(s) for proda will be transferred from dbvisit1 to dbvisit2...
Transferring o1_mf_1_13_9pkr4coo_.arc.gz to host dbvisit2:o1_mf_1_13_9pkr4coo_.arc.gz
Transferring o1_mf_1_14_9pkr4n3j_.arc.gz to host dbvisit2:o1_mf_1_14_9pkr4n3j_.arc.gz
Transferring o1_mf_1_15_9pkr4x53_.arc.gz to host dbvisit2:o1_mf_1_15_9pkr4x53_.arc.gz
Transferring o1_mf_1_16_9pkr57jp_.arc.gz to host dbvisit2:o1_mf_1_16_9pkr57jp_.arc.gz
Transferring o1_mf_1_17_9pkr58hd_.arc.gz to host dbvisit2:o1_mf_1_17_9pkr58hd_.arc.gz
Transferring o1_mf_1_18_9pkr59fm_.arc.gz to host dbvisit2:o1_mf_1_18_9pkr59fm_.arc.gz
Transferring o1_mf_1_19_9pkr5b9y_.arc.gz to host dbvisit2:o1_mf_1_19_9pkr5b9y_.arc.gz
Transferring o1_mf_1_20_9pkr5c3c_.arc.gz to host dbvisit2:o1_mf_1_20_9pkr5c3c_.arc.gz
Transferring o1_mf_1_21_9pkr6ntl_.arc.gz to host dbvisit2:o1_mf_1_21_9pkr6ntl_.arc.gz
Transferring o1_mf_1_22_9pkr6oms_.arc.gz to host dbvisit2:o1_mf_1_22_9pkr6oms_.arc.gz
Transferring o1_mf_1_23_9pkr6sh4_.arc.gz to host dbvisit2:o1_mf_1_23_9pkr6sh4_.arc.gz
Transferring o1_mf_1_24_9pkr6shr_.arc.gz to host dbvisit2:o1_mf_1_24_9pkr6shr_.arc.gz
Transferring o1_mf_1_25_9pkr6xr7_.arc.gz to host dbvisit2:o1_mf_1_25_9pkr6xr7_.arc.gz
201405061847 - 13 Log transfers to dbvisit2 for proda completed.
Last sequence was 25.
Dbvisit Archive Management Module (AMM)
(Number to keep: 0) (Days to keep: 7) (Archive backup count: 0) (Diskspace full threshold: 80%)
Current Disk percent full (/u01/app/oracle/fast_recovery_area) : 32%
=============================================================
dbvisit ended on dbvisit1: Tue May 6 18:48:26 2014
=============================================================
Physical Standby Database:
[oracle@dbvisit2 standby]$ ./dbvisit proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.9151) (pid 5293)
dbvisit started on dbvisit2: Tue May 6 18:53:29 2014 ()
=============================================================
Log file(s) for proda from dbvisit1 will be applied to dbvisit2...
201405061853 - Log seq 9 thread 1 applied to standby database proda.
201405061853 - Log seq 10 thread 1 applied to standby database proda.
201405061853 - Log seq 11 thread 1 applied to standby database proda.
201405061853 - Log seq 12 thread 1 applied to standby database proda.
201405061853 - Log seq 13 thread 1 applied to standby database proda.
201405061853 - Log seq 14 thread 1 applied to standby database proda.
201405061853 - Log seq 15 thread 1 applied to standby database proda.
201405061853 - Log seq 16 thread 1 applied to standby database proda.
201405061853 - Log seq 17 thread 1 applied to standby database proda.
201405061853 - Log seq 18 thread 1 applied to standby database proda.
201405061853 - Log seq 19 thread 1 applied to standby database proda.
201405061853 - Log seq 20 thread 1 applied to standby database proda.
201405061853 - Log seq 21 thread 1 applied to standby database proda.
201405061853 - Log seq 22 thread 1 applied to standby database proda.
201405061853 - Log seq 23 thread 1 applied to standby database proda.
201405061853 - Log seq 24 thread 1 applied to standby database proda.
201405061853 - Log seq 25 thread 1 applied to standby database proda.
201405061853 - Log seq 26 thread 1 applied to standby database proda.
Dbvisit Archive Management Module (AMM)
(Number to keep: 0) (Days to keep: 7) (Diskspace full threshold: 80%)
Processing /oracle/oraarch/proda...
Archive log dir: /oracle/oraarch/proda
Total number of archive files : 23
Number of files deleted : 0
Current Disk percent full : 31%
=============================================================
dbvisit ended on dbvisit2: Tue May 6 18:54:55 2014
=============================================================
You have new mail in /var/spool/mail/oracle
[oracle@dbvisit2 standby]$ ./dbv_oraStartStop open proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 6095)
dbv_oraStartStop started on dbvisit2: Tue May 6 18:55:14 2014 ()
=============================================================
Open Standby Database proda in READ ONLY mode...
Standby Database proda opened in READ ONLY mode.
Log files cannot be applied to Database while in READ ONLY mode.
Database tempfile(s) may need to be added to this database.
=============================================================
dbv_oraStartStop ended on dbvisit2: Tue May 6 18:55:22 2014
=============================================================
[oracle@dbvisit2 standby]$ exit
Check the Table in Physical Standby Database:
[oracle@dbvisit2 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Tue May 6 18:55:57 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> connect scott/oracle
Connected.
SQL> select * from sample;
no rows selected
No comments:
Post a Comment