Wednesday, December 17, 2014

Recovering Table in Non-Container Database and Pluggable Database (PDB) in Container Database (CDB)


Article Name : Recovering Table in Non-Container Database and Pluggable Database (PDB) in Container Database (CDB)

Article URL : http://www.toadworld.com/platforms/oracle/w/wiki/11065.recovering-table-in-non-container-database-and-pluggable-database-pdb-in-container-database-cdb.aspx

Thanks to TOADWORLD...


Container Database (CDB) with Pluggable Databases (PDBs) in Oracle 12c RAC


Article Name : Container Database (CDB) with Pluggable Databases (PDBs) in Oracle 12c RAC

Article URL : http://www.toadworld.com/platforms/oracle/w/wiki/11059.container-database-cdb-with-pluggable-databases-pdbs-in-oracle-12c-rac.aspx

Thanks to TOAD WORLD..



Wednesday, November 26, 2014

Rolling RECO data disk group resize activity for Oracle Exadata Database Machine


Article Name : Rolling RECO data disk group resize activity for Oracle Exadata Database Machine

Article URL : http://www.toadworld.com/platforms/oracle/w/wiki/11021.rolling-reco-data-disk-group-resize-activity-for-oracle-exadata-database-machine.aspx

Thanks to Toad World !!!!!!


Thursday, October 9, 2014

Monday, June 30, 2014

Published Oracle Technical Article in World Famous Site "Oracle Technology Network (OTN)"


Article No 24 : Published Oracle Technical Article in World Famous Site "Oracle Technology Network (OTN)"

Article Title : Oracle Standby Database, un "amigo" para 1000 casos

Article URL : http://www.oracle.com/technetwork/es/articles/database-performance/oracle-standby-database-2232804-esa.html

Saturday, June 28, 2014

Published Oracle Technical Article in World Famous Site "Oracle Technology Network (OTN)"


Article No 23 : Published Oracle Technical Article in World Famous Site "Oracle Technology Network (OTN)"

Article Title : RMAN: Como hacer para Restaurar y/o Recuperar solo los "Tablespaces" esenciales

Article URL : http://www.oracle.com/technetwork/es/articles/database-performance/restaurar-recuperar-tablespaces-2228109-esa.html

Wednesday, June 25, 2014

Published Oracle Technical Article in World Famous Site "Oracle Technology Network (OTN)" By OraWorld Team


Article No 22 : Published Oracle Technical Article in World Famous Site "Oracle Technology Network (OTN)"

Article Title : Oracle Database 12c: Data Redaction

Article URL : http://www.oracle.com/technetwork/es/articles/idm/oracle-data-redaction-12c-esp-2226725-esa.html.

Thanks to My OraWorld Team.


Wednesday, June 18, 2014

ORAchk Health Checks For The Oracle Stack - ORAchk 2.2.5


ORAchk replaces the popular RACcheck tool, extending the coverage based on prioritization of top issues reported by users, to proactively scan for known problems within the area of:

1. Oracle Database
2. Enterprise Manager Cloud Control
3. E-Business Suite
4. Oracle Sun Systems

ORAchk features:
=============
1. Proactively scans for the most impactful problems across the various layers of your stack
2. Simplifies and streamlines how to investigate and analyze which known issues present a risk to you
3. Lightweight tool that runs within your environment without requiring config data to be sent to Oracle
4. High level reports show your system health risks with the ability to drill down into specific problems and understand their resolutions
5. Can be configured to send email notifications when it detects problems
6. Collection Manager, a companion Application Express web app, provides a single dashboard view of collections across your entire enterprise


login as: oracle
oracle@192.168.0.111's password:
Last login: Fri Feb  1 15:34:36 2013 from oel6-112-rac2.localdomain
 

[oracle@oel6-112-rac1 ~]$ cd /home/oracle/
-rw-r--r--   1 oracle oinstall 5.6M Jun 18 15:11 orachk.zip
 

[oracle@oel6-112-rac1 ~]$ cksum orachk.zip
3306312142 5770368 orachk.zip
 

[oracle@oel6-112-rac1 ~]$ unzip orachk.zip
Archive:  orachk.zip
  inflating: UserGuide.txt
  inflating: rules.dat
  inflating: orachk
   creating: .cgrep/
  inflating: .cgrep/hiacgrep
  inflating: .cgrep/lcgrep5
  inflating: .cgrep/auto_upgrade.pl
  inflating: .cgrep/check_reblance_free_space.sql
  inflating: .cgrep/psqlplus
  inflating: .cgrep/scgrepx86
  inflating: .cgrep/init.tmpl
  inflating: .cgrep/utluppkg.sql
  inflating: .cgrep/scgrep
  inflating: .cgrep/versions.dat
  inflating: .cgrep/raw_data_browser.pl
  inflating: .cgrep/lcgrep6
  inflating: .cgrep/profiles.dat
  inflating: .cgrep/auto_upgrade_check.pl
  inflating: .cgrep/CollectionManager_App.sql
  inflating: .cgrep/utlu112i.sql
  inflating: .cgrep/ggdiscovery.sh
  inflating: .cgrep/lcgreps9
  inflating: .cgrep/checkDiskFGMapping.sh
  inflating: .cgrep/lcgreps10
  inflating: .cgrep/pxhcdr.sql
  inflating: .cgrep/diff_collections.pl
  inflating: .cgrep/rack_comparison.py
  inflating: .cgrep/exalogic_zfs_checks.aksh
  inflating: .cgrep/lcgrep4
  inflating: .cgrep/merge_collections.pl
  inflating: .cgrep/acgrep
  inflating: .cgrep/show_file_in_html.pl
  inflating: .cgrep/scnhealthcheck.sql
  inflating: .cgrep/lcgreps11
  inflating: .cgrep/reset_crshome.pl
  inflating: .cgrep/ogghc_12101.sql
   creating: .cgrep/profiles/
  inflating: .cgrep/profiles/DF65D0F7FB6F1014E04312C0E50A7808.prf
  inflating: .cgrep/profiles/DFE9C207A8F2428CE04313C0E50A6B0A.prf
  inflating: .cgrep/profiles/D49C4F9F48735396E0431EC0E50A9A0B.prf
  inflating: .cgrep/profiles/D49C0AB26A6D45A8E0431EC0E50ADE06.prf
  inflating: .cgrep/profiles/D49BDC2EC9E624AEE0431EC0E50A3E12.prf
  inflating: .cgrep/profiles/F9ED0179CCD8256BE04312C0E50A5399.prf
  inflating: .cgrep/profiles/F6AFECA37F177C3FE04313C0E50A56BF.prf
  inflating: .cgrep/profiles/D49B218473787400E0431EC0E50A0BB9.prf
  inflating: .cgrep/profiles/E2E972DDE1E14493E04312C0E50A1AB1.prf
  inflating: .cgrep/profiles/F32F44CE0BCD662FE04312C0E50AB058.prf
  inflating: .cgrep/profiles/D49AD88F8EE75CD8E0431EC0E50A0BC3.prf
  inflating: .cgrep/profiles/E8DF76E07DD82E0DE04313C0E50AA55D.prf
  inflating: .cgrep/profiles/EA5EE324E7E05128E04313C0E50A4B2A.prf
  inflating: .cgrep/profiles/D462A6F7E9C340FDE0431EC0E50ABE12.prf
  inflating: .cgrep/profiles/E1BF012E8F210839E04313C0E50A7B68.prf
  inflating: .cgrep/profiles/DF65D6117CB41054E04312C0E50A69D1.prf
  inflating: .cgrep/profiles/D8367AD6754763FEE04312C0E50A6FCB.prf
  inflating: .cgrep/profiles/D49C0FBF8FBF4B1AE0431EC0E50A0F24.prf
  inflating: .cgrep/profiles/DA94919CD0DE0913E04312C0E50A7996.prf
  inflating: .cgrep/profiles/EF6C016813C51366E04313C0E50AE11F.prf
 extracting: .cgrep/profiles/F13E11974A282AB3E04312C0E50ABCBF.prf
  inflating: .cgrep/utlusts.sql
  inflating: .cgrep/asrexacheck
  inflating: .cgrep/create_version.pl
  inflating: .cgrep/oracle-upstarttmpl.conf
  inflating: .cgrep/preupgrd.sql
  inflating: .cgrep/ogghc_11203.sql
  inflating: .cgrep/ogghc_11204.sql
  inflating: CollectionManager_App.sql
  inflating: raccheck
  inflating: readme.txt
  inflating: collections.dat
 

[oracle@oel6-112-rac1 ~]$ ls
CollectionManager_App.sql  Desktop  Documents  grid.rsp  node.ccf  orachk.zip      Pictures  raccheck    rpm        shiphomes   Templates      Videos
collections.dat            disk.sh  Downloads  Music     orachk    oradiag_oracle  Public    readme.txt  rules.dat  swingbench  UserGuide.txt
[oracle@oel6-112-rac1 ~]$ ./orachk -v

ORACHK  VERSION: 2.2.5_20140530
[oracle@oel6-112-rac1 ~]$ pwd
/home/oracle
[oracle@oel6-112-rac1 ~]$ chmod 755 orachk
[oracle@oel6-112-rac1 ~]$ ./orachk

CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /u01/app/12.1.0/grid?[y/n][y]y

Checking ssh user equivalency settings on all nodes in cluster
Node oel6-112-rac2 is configured for ssh user equivalency for oracle user
Searching for running databases . . . . .
. .
List of running databases registered in OCR
1. orcl
2. None of above

Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1].1
. .

Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
-------------------------------------------------------------------------------------------------------
                                                 Oracle Stack Status
-------------------------------------------------------------------------------------------------------
Host Name  CRS Installed  ASM HOME       RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name
-------------------------------------------------------------------------------------------------------
oel6-112-rac1 Yes             N/A             Yes             Yes        Yes      Yes      orcl1
oel6-112-rac2 Yes             N/A             Yes             Yes        Yes      Yes      orcl2
-------------------------------------------------------------------------------------------------------
Copying plug-ins
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . .

16 of the included audit checks require root privileged data collection . If sudo is not configured or the root password is not available, audit checks which  require root privileged data collection can be skipped.

1. Enter 1 if you will enter root password for each  host when prompted
2. Enter 2 if you have sudo configured for oracle user to execute root_orachk.sh script
3. Enter 3 to skip the root privileged collections
4. Enter 4 to exit and work with the SA to configure sudo  or to arrange for root access and run the tool later.

Please indicate your selection from one of the above options for root access[1-4][1]:- 1
 

*** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***

Collections and audit checks log file is
/home/oracle/orachk_oel6-112-rac1_orcl_061814_153147/log/orachk.log

Running orachk in serial mode because expect(/usr/bin/expect) is not available to supply root passwords on remote nodes

NOTICE:  Installing the expect utility (/usr/bin/expect) will allow orachk to gather root passwords at the beginning of the process and execute orachk on all nodes in parallel speeding up the entire process. For more info - http://www.nist.gov/el/msid/expect.cfm.  Expect is available for all major platforms.  See User Guide for more details.

Checking for prompts in /home/oracle/.bash_profile on oel6-112-rac1 for oracle user...

Checking for prompts in /home/oracle/.bash_profile on oel6-112-rac2 for oracle user...
 

=============================================================
                    Node name - oel6-112-rac1
=============================================================
Collecting - ASM DIsk I/O stats
Collecting - ASM Disk Groups
Collecting - ASM Diskgroup Attributes
Collecting - ASM disk partnership imbalance
Collecting - ASM diskgroup attributes
Collecting - ASM initialization parameters
Collecting - Active sessions load balance for orcl database
Collecting - Archived Destination Status for orcl database
Collecting - Cluster Interconnect Config for orcl database
Collecting - Database Archive Destinations for orcl database
Collecting - Database Files for orcl database
Collecting - Database Instance Settings for orcl database
Collecting - Database Parameters for orcl database
Collecting - Database Parameters for orcl database
Collecting - Database Properties for orcl database
Collecting - Database Registry for orcl database
Collecting - Database Sequences for orcl database
Collecting - Database Undocumented Parameters for orcl database
Collecting - Database Undocumented Parameters for orcl database
Collecting - Database Workload Services for orcl database
Collecting - Dataguard Status for orcl database
Collecting - Files not opened by ASM
Collecting - Log Sequence Numbers for orcl database
Collecting - Percentage of asm disk  Imbalance
Collecting - Process for shipping Redo to standby for orcl database
Collecting - RDBMS Feature Usage for orcl database
Collecting - Redo Log information for orcl database
Collecting - Standby redo log creation status before switchover for orcl database
Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - CSS Reboot time
Collecting - CSS disktimout
Collecting - Cluster interconnect (clusterware)
Collecting - Clusterware OCR healthcheck
Collecting - Clusterware Resource Status
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Huge pages configuration
Collecting - Interconnect network card speed
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - Network Service Switch
Collecting - OS Packages
Collecting - OS version
Collecting - Operating system release information and kernel version
Collecting - Oracle Executable Attributes
Collecting - Patches for Grid Infrastructure
Collecting - Patches for RDBMS Home
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - Voting disks (clusterware)
Collecting - number of semaphore operations per semop system call
Preparing to run root privileged commands  oel6-112-rac1.  Please enter root password when prompted.
root@oel6-112-rac1's password:

Data collections completed. Checking best practices on oel6-112-rac1.
--------------------------------------------------------------------------------------
 WARNING => SYS.AUDSES$ sequence cache size < 10,000 for orcl
 WARNING => Without ARCHIVELOG mode the database cannot be recovered from an online backup and Data Guard cannot be used. for orcl
 WARNING => OCR is NOT being backed up daily
 INFO =>    $CRS_HOME/log/hostname/client directory has too many older log files.
 INFO =>    user_dump_dest has trace files older than 30 days for orcl
 INFO =>    ORA-07445 errors found in alert log for orcl
 INFO =>    background_dump_dest has files older than 30 days for orcl
 INFO =>    Some tablespaces do not have allocation type as SYSTEM for orcl
 INFO =>    At some times checkpoints are not being completed for orcl
 INFO =>    audit_file_dest has audit files older than 30 days for orcl
 WARNING => Controlfile is NOT multiplexed for orcl
 WARNING => One or more redo log groups are NOT multiplexed for orcl
 WARNING => /tmp is NOT on a dedicated filesystem
 WARNING => Shell limit soft nproc for DB is NOT configured according to recommendation
 FAIL =>    Operating system hugepages count does not satisfy total SGA requirements
 WARNING => NIC bonding is not configured for interconnect
 WARNING => NIC bonding is NOT configured for public network (VIP)
 WARNING => OSWatcher is not running as is recommended.
 INFO =>    Jumbo frames (MTU >= 8192) are not configured for interconnect
 FAIL =>    Database parameter DB_LOST_WRITE_PROTECT is NOT set to recommended value on orcl1 instance
 WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for orcl
 FAIL =>    Flashback on PRIMARY is not configured for orcl
 INFO =>    Operational Best Practices
 INFO =>    Database Consolidation Best Practices
 INFO =>    Computer failure prevention best practices
 INFO =>    Data corruption prevention best practices
 INFO =>    Logical corruption prevention best practices
 INFO =>    Database/Cluster/Site failure prevention best practices
 INFO =>    Client failover operational best practices
 FAIL =>    Some bigfile tablespaces do not have non-default maxbytes values set for orcl
 WARNING => fast_start_mttr_target should be greater than or equal to 300. on orcl1 instance
 INFO =>    Information about hanganalyze and systemstate dump
 WARNING => Package unixODBC-2.2.14-11.el6-i686 is recommended but NOT installed
 WARNING => Package unixODBC-devel-2.2.14-11.el6-i686 is recommended but NOT installed
 FAIL =>    Table AUD$[FGA_LOG$] should use Automatic Segment Space Management for orcl
 INFO =>    Database failure prevention best practices
 WARNING => Database Archivelog Mode should be set to ARCHIVELOG for orcl
 FAIL =>    Primary database is NOT protected with Data Guard (standby database) for real-time data protection and availability for orcl
 WARNING => Redo log write time is more than 500 milliseconds for orcl
 WARNING => TFA Collector is either not installed or not running
 WARNING => Package unixODBC-devel-2.2.14-11.el6-x86_64 is recommended but NOT installed
 WARNING => Linux transparent huge pages are enabled
 WARNING => vm.min_free_kbytes should be set as recommended.
 INFO =>    Oracle recovery manager(rman) best practices
 WARNING => RMAN controlfile autobackup should be set to ON for orcl
 WARNING => Linux Disk I/O Scheduler should be configured to [Deadline]
 INFO =>    Consider increasing the COREDUMPSIZE size
 INFO =>    Consider investigating the frequency of SGA resize operations and take corrective action for orcl
 WARNING => Shell limit soft stack for DB is not configured according to recommendation

Best Practice checking completed.Checking recommended patches on oel6-112-rac1.
---------------------------------------------------------------------------------
Collecting patch inventory on  CRS HOME /u01/app/12.1.0/grid
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/12.1.0/db_1
---------------------------------------------------------------------------------
1 Recommended CRS patches for 121010 from /u01/app/12.1.0/grid on oel6-112-rac1
---------------------------------------------------------------------------------
Patch#   CRS  ASM    RDBMS RDBMS_HOME                              Patch-Description
---------------------------------------------------------------------------------
18139660  no          no  /u01/app/oracle/product/12.1.0/db_1GRID INFRASTRUCTURE SYSTEM PATCH 12.1.0.1.3
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 121010 from /u01/app/oracle/product/12.1.0/db_1 on oel6-112-rac1
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
18139660  no             merge               GRID INFRASTRUCTURE SYSTEM PATCH 12.1.0.1.3
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              Clusterware patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on CRS Applied on RDBMS Applied on ASM
---------------------------------------------------------------------------------
1              0              0                0
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              RDBMS homes patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
 1              0              0                /u01/app/oracle/product/12.1.0/db_1
---------------------------------------------------------------------------------

=============================================================
                    Node name - oel6-112-rac2
=============================================================

Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - Cluster interconnect (clusterware)
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Huge pages configuration
Collecting - Interconnect network card speed
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - Network Service Switch
Collecting - OS Packages
Collecting - OS version
Collecting - Operating system release information and kernel version
Collecting - Oracle Executable Attributes
Collecting - Patches for Grid Infrastructure
Collecting - Patches for RDBMS Home
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call
Preparing to run root privileged commands  oel6-112-rac2.  Please enter root password when prompted.
root@oel6-112-rac2's password:
Collecting - Broadcast Requirements for Networks
Collecting - CRS user time zone check
Collecting - Disk Information
Collecting - Grid Infastructure user shell limits configuration
Collecting - Interconnect interface config
Collecting - Network interface stats
Collecting - Number of RDBMS LMS running in real time
Collecting - OLR Integrity
Collecting - Root user limits
Collecting - Verify no database server kernel out of memory errors
Collecting - root time zone check
Collecting - slabinfo

Data collections completed. Checking best practices on oel6-112-rac2.
-------------------------------------------------------------------------------------
 INFO =>    $CRS_HOME/log/hostname/client directory has too many older log files.
 INFO =>    user_dump_dest has trace files older than 30 days for orcl
 INFO =>    background_dump_dest has files older than 30 days for orcl
 INFO =>    audit_file_dest has audit files older than 30 days for orcl
 WARNING => /tmp is NOT on a dedicated filesystem
 WARNING => Shell limit soft nproc for DB is NOT configured according to recommendation
 FAIL =>    Operating system hugepages count does not satisfy total SGA requirements
 WARNING => NIC bonding is not configured for interconnect
 WARNING => NIC bonding is NOT configured for public network (VIP)
 WARNING => OSWatcher is not running as is recommended.
 INFO =>    Jumbo frames (MTU >= 8192) are not configured for interconnect
 FAIL =>    Database parameter DB_LOST_WRITE_PROTECT is NOT set to recommended value on orcl2 instance
 WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for orcl
 WARNING => fast_start_mttr_target should be greater than or equal to 300. on orcl2 instance
 WARNING => Package unixODBC-2.2.14-11.el6-i686 is recommended but NOT installed
 WARNING => Package unixODBC-devel-2.2.14-11.el6-i686 is recommended but NOT installed
 WARNING => Redo log write time is more than 500 milliseconds for orcl
 WARNING => TFA Collector is either not installed or not running
 WARNING => Package unixODBC-devel-2.2.14-11.el6-x86_64 is recommended but NOT installed
 WARNING => Linux transparent huge pages are enabled
 WARNING => vm.min_free_kbytes should be set as recommended.
 WARNING => Linux Disk I/O Scheduler should be configured to [Deadline]
 INFO =>    Consider increasing the COREDUMPSIZE size
 WARNING => Shell limit hard nproc for root is NOT configured according to recommendation
 WARNING => Shell limit soft stack for DB is not configured according to recommendation

Best Practice checking completed.Checking recommended patches on oel6-112-rac2.
---------------------------------------------------------------------------------
Collecting patch inventory on  CRS HOME /u01/app/12.1.0/grid
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/12.1.0/db_1
---------------------------------------------------------------------------------
1 Recommended CRS patches for 121010 from /u01/app/12.1.0/grid on oel6-112-rac2
---------------------------------------------------------------------------------
Patch#   CRS  ASM    RDBMS RDBMS_HOME                              Patch-Description
---------------------------------------------------------------------------------
18139660  no          no  /u01/app/oracle/product/12.1.0/db_1GRID INFRASTRUCTURE SYSTEM PATCH 12.1.0.1.3
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 121010 from /u01/app/oracle/product/12.1.0/db_1 on oel6-112-rac2
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
18139660  no             merge               GRID INFRASTRUCTURE SYSTEM PATCH 12.1.0.1.3
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              Clusterware patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on CRS Applied on RDBMS Applied on ASM
---------------------------------------------------------------------------------
1              0              0                0
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              RDBMS homes patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
 1              0              0                /u01/app/oracle/product/12.1.0/db_1
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
                      CLUSTERWIDE CHECKS
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

Detailed report (html) - /home/oracle/orachk_oel6-112-rac1_orcl_061814_153147/orachk_oel6-112-rac1_orcl_061814_153147.html

UPLOAD(if required) - /home/oracle/orachk_oel6-112-rac1_orcl_061814_153147.zip

[oracle@oel6-112-rac1 ~]$

Tuesday, May 27, 2014

Published Oracle Technical Article in World Famous Site "Oracle Technology Network (OTN)"


Article No 21 : Published Oracle Technical Article in World Famous Site "Oracle Technology Network (OTN)"

Article Title : Oracle Exadata Database Machine: "Exachk"

Article URL : http://www.oracle.com/technetwork/pt/articles/servers-storage-admin/oracle-exadata-exachk-2209072-ptb.html


Saturday, May 17, 2014

Speaker @AIOUG (All India Oracle User Group) - Oracle ExaDataSIG’s first Webcast on May 28th 2014

Speaker @AIOUG Oracle ES SIG’s first Webcast on May 28th 2014.
=====================================================

Agenda
======
3.45 PM – 4 PM – Introduction to Oracle ES SIG

4 PM – 5 PM IST– Oracle Engineered Systems Overview & Introduction to Oracle Database Appliance (ODA).

5 PM – 6 PM IST– Oracle Exadata Database Machine Evolution by Y.V Ravi Kumar

Oracle ES SIG » Register oracle-es-sig.org

Wednesday, May 7, 2014

SwitchOver and SwitchBack Operations In Oracle Database (SE) using 'dbvisit' Software


SwitchOver Operation:

[oracle@dbvisit2 standby]$ ./dbv_oraStartStop switchover proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 13892)
dbv_oraStartStop started on dbvisit2: Wed May  7 12:45:44 2014 ()
=============================================================
=============================================================
Graceful Switchover starting on Primary Database proda with standby database proda.
Timestamp: 201405071245.

>>> Database proda will be shutdown and restarted <<<
Ensure Dbvisit is no longer scheduled.

>>> Gracefull Switchover will attempt to reset Oracle parameters db_file_name_convert and log_file_name_convert to default values (null strings) in the spfile <<<

Obtaining archive log gap....
Contacting Standby Database proda on dbvisit1...
Last standby sequence obtained (45) for thread 1.

Archive Log Gap for thread 1 is: 0. This is correct to continue.

Please enter unique key to begin graceful switchover for database proda.
The same key must be entered on both primary and standby server.

Please start command: dbv_oraStartStop switchover proda
on dbvisit1 if not already started.

Please enter unique key:
back
Key back entered.

Contacting dbvisit1 to ensure the same unique key is entered for proda.
Waiting for Key 1 on dbvisit1...
Checkpoint 1 completed. Key found on dbvisit1
Transferring X.dbvisit.back.proda.tempfile to host
dbvisit1:X.dbvisit.back.proda.tempfile
Transferring X.dbvisit.back.proda.force_logging to host
dbvisit1:X.dbvisit.back.proda.force_logging
Waiting for Checkpoint 2 on dbvisit1...
Checkpoint 2 completed. Key found on dbvisit1
Waiting for Checkpoint 3 on dbvisit1...
Checkpoint 3 completed. Key found on dbvisit1
Shutting down regular Database proda...
Regular Database proda shutdown successfully.
Starting Regular Database proda...
Regular Database proda started restrict.
Performing Oracle Checkpoint.
Waiting 3 seconds for log switch completion...
Creating standby controlfile controlfile...
Waiting for Checkpoint 4 on dbvisit1...
Checkpoint 4 completed. Key found on dbvisit1
Copying new archives for proda to dbvisit1...
Compressing  arch1_46_846414148.dbf...
Transferring arch1_46_846414148.dbf.gz to host
dbvisit1:arch1_46_846414148.dbf.gz
Compressing  arch1_47_846414148.dbf...
Transferring arch1_47_846414148.dbf.gz to host
dbvisit1:arch1_47_846414148.dbf.gz
Transferring X.dbvisit.back.proda.archives to host
dbvisit1:X.dbvisit.back.proda.archives
Completed.
Shutting down regular Database proda...
Regular Database proda shutdown successfully.
Copying redo logs ... this may take a while...
Compressing  X.dbvisit.back.proda.redo_1.log...
Transferring X.dbvisit.back.proda.redo_1.log.gz to host
dbvisit1:X.dbvisit.back.proda.redo_1.log.gz
Compressing  X.dbvisit.back.proda.redo_2.log...
Transferring X.dbvisit.back.proda.redo_2.log.gz to host
dbvisit1:X.dbvisit.back.proda.redo_2.log.gz
Compressing  X.dbvisit.back.proda.redo_3.log...
Transferring X.dbvisit.back.proda.redo_3.log.gz to host
dbvisit1:X.dbvisit.back.proda.redo_3.log.gz
Transferring X.dbvisit.back.proda.redo_matrix to host
dbvisit1:X.dbvisit.back.proda.redo_matrix
Waiting for Checkpoint 5 on dbvisit1...
Checkpoint 5 completed. Key found on dbvisit1
Backing up current controlfiles for proda dbvisit2...
Database proda on dbvisit2 is already down. No action taken.
Starting Regular Database proda...
Regular Database proda started nomount.
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Controlfile backed up as /usr/tmp/GS/proda/X.dbvisit.back.proda.controlfile.
Database proda on dbvisit2 is already down. No action taken.
Transferring X.dbvisit.back.proda.controlfile to host
dbvisit1:X.dbvisit.back.proda.controlfile
Waiting for Checkpoint 6 on dbvisit1...
Checkpoint 6 completed. Key found on dbvisit1
Waiting for Checkpoint 7 on dbvisit1...
Checkpoint 7 completed. Key found on dbvisit1
Waiting for Checkpoint 8 on dbvisit1...
Checkpoint 8 completed. Key found on dbvisit1
Waiting for Checkpoint 9 on dbvisit1...
Checkpoint 9 completed. Key found on dbvisit1
Waiting for Checkpoint 10 on dbvisit1...
Checkpoint 10 completed. Key found on dbvisit1
Waiting for Checkpoint 11 on dbvisit1...
Checkpoint 11 completed. Key found on dbvisit1
Waiting for Checkpoint 12 on dbvisit1...
Checkpoint 12 completed. Key found on dbvisit1
Database proda on dbvisit2 is already down. No action taken.
Starting Regular Database proda...
Regular Database proda started nomount.
STANDBY controlfile created.
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Starting Standby Database proda...
Standby Database proda started .
Waiting for Checkpoint 13 on dbvisit1...
Checkpoint 13 completed. Key found on dbvisit1
Waiting for Checkpoint 14 on dbvisit1...
Checkpoint 14 completed. Key found on dbvisit1
File dbv_proda.env copied to dbv_proda.env.201405071245.
Dbvisit Database configuration (DDC) file dbv_proda.env has been updated and
variables have been reversed between primary and standby server.

SOURCE=dbvisit1 DESTINATION=dbvisit2.

Waiting for Checkpoint 15 on dbvisit1...
Checkpoint 15 completed. Key found on dbvisit1
Waiting for Checkpoint 16 on dbvisit1...
Checkpoint 16 completed. Key found on dbvisit1
Waiting for Checkpoint 17 on dbvisit1...
Checkpoint 17 completed. Key found on dbvisit1
Tempfiles dropped.
Waiting for Checkpoint 18 on dbvisit1...
Checkpoint 18 completed. Key found on dbvisit1

Graceful switchover completed.

This database (proda) is now a standby database.

To keep this new standby database in synch,
reschedule Dbvisit as per normal:
        dbvisit proda
=============================================================
dbv_oraStartStop ended on dbvisit2: Wed May  7 12:51:49 2014
=============================================================

[oracle@dbvisit2 standby]$

[oracle@dbvisit1 standby]$ ./dbv_oraStartStop switchover proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 13791)
dbv_oraStartStop started on dbvisit1: Wed May  7 12:45:58 2014 ()
=============================================================

=============================================================
Graceful Switchover starting on Standby Database proda.
Timestamp: 201405071245.
Database proda will be shutdown and restarted!
Ensure Dbvisit is no longer scheduled.

Please enter unique key to begin graceful switchover for database proda.
The same key must be entered on both primary and standby server.

Please start command: dbv_oraStartStop switchover proda
on dbvisit2 if not already started.

Please enter unique key:
back
Key back entered.

Contacting dbvisit2 to ensure the same unique key is entered for proda.
Waiting for Key 1 on dbvisit2...
Checkpoint 1 completed. Key found on dbvisit2
Waiting for Checkpoint 2 on dbvisit2...
Checkpoint 2 completed. Key found on dbvisit2
Waiting for Checkpoint 3 on dbvisit2...
Checkpoint 3 completed. Key found on dbvisit2
Waiting for Checkpoint 4 on dbvisit2...
Checkpoint 4 completed. Key found on dbvisit2
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Waiting for Checkpoint 5 on dbvisit2...
Checkpoint 5 completed. Key found on dbvisit2
Uncompressing arch1_46_846414148.dbf.gz...
Uncompressing arch1_47_846414148.dbf.gz...
Uncompressing X.dbvisit.back.proda.redo_1.log.gz...
Uncompressing X.dbvisit.back.proda.redo_2.log.gz...
Uncompressing X.dbvisit.back.proda.redo_3.log.gz...
Waiting for Checkpoint 6 on dbvisit2...
Checkpoint 6 completed. Key found on dbvisit2
Waiting for Checkpoint 7 on dbvisit2...
Checkpoint 7 completed. Key found on dbvisit2
Backing up current controlfiles for proda dbvisit1...
Database proda on dbvisit1 is already down. No action taken.
Starting Standby Database proda...
Standby Database proda started nomount.
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Controlfile backed up as /usr/tmp/GS/proda/X.dbvisit.back.proda.stdby_ctl_bck.
Database proda on dbvisit1 is already down. No action taken.
Waiting for Checkpoint 8 on dbvisit2...
Checkpoint 8 completed. Key found on dbvisit2
Starting Standby Database proda...
Standby Database proda started nomount.
Database proda on dbvisit1 is already started. No action taken.
PRIMARY controlfile created.
Mount Database proda...
Database proda mounted.
Copying redo log /usr/tmp/GS/proda/X.dbvisit.back.proda.redo_1.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_1.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.back.proda.redo_1.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_2.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.back.proda.redo_2.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_1.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.back.proda.redo_2.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_2.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.back.proda.redo_3.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_1.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.back.proda.redo_3.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_2.log
Waiting for Checkpoint 9 on dbvisit2...
Checkpoint 9 completed. Key found on dbvisit2
Recovering new primary database...
Completed.
Waiting for Checkpoint 10 on dbvisit2...
Checkpoint 10 completed. Key found on dbvisit2
Archive log all for Database proda...
Completed.
Tempfiles dropped.
Waiting for Checkpoint 11 on dbvisit2...
Checkpoint 11 completed. Key found on dbvisit2
Open Database proda...
Database proda opened.
Waiting for Checkpoint 12 on dbvisit2...
Checkpoint 12 completed. Key found on dbvisit2
Waiting for Checkpoint 13 on dbvisit2...
Checkpoint 13 completed. Key found on dbvisit2
Waiting for Checkpoint 14 on dbvisit2...
Checkpoint 14 completed. Key found on dbvisit2
File dbv_proda.env copied to dbv_proda.env.201405071245.
Dbvisit Database configuration (DDC) file dbv_proda.env has been updated and
variables have been reversed between primary and standby server.

SOURCE=dbvisit1 DESTINATION=dbvisit2.

Waiting for Checkpoint 15 on dbvisit2...
Checkpoint 15 completed. Key found on dbvisit2
Tempfiles created.
Waiting for Checkpoint 16 on dbvisit2...
Checkpoint 16 completed. Key found on dbvisit2
Compressing  arch1_46_846414148.dbf...
Compressing  arch1_47_846414148.dbf...
Waiting for Checkpoint 17 on dbvisit2...
Checkpoint 17 completed. Key found on dbvisit2

FORCE LOGGING is left turned off in the primary database proda on dbvisit1.
Waiting for Checkpoint 18 on dbvisit2...
Checkpoint 18 completed. Key found on dbvisit2

Graceful switchover completed.

This database (proda) is now the primary database.

You may consider re-creating a password file to make sure all sysdba passwords are preserved.
To keep the standby database on dbvisit2 in synch with this primary database,
reschedule Dbvisit as per normal:
        dbvisit proda
=============================================================
dbv_oraStartStop ended on dbvisit1: Wed May  7 12:51:50 2014
=============================================================

You have new mail in /var/spool/mail/oracle
[oracle@dbvisit1 standby]$

SwitchBack Operation:
[oracle@dbvisit1 standby]$ ./dbv_oraStartStop switchover proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 21725)
dbv_oraStartStop started on dbvisit1: Wed May  7 13:23:59 2014 ()
=============================================================

=============================================================
Graceful Switchover starting on Primary Database proda with standby database
proda.
Timestamp: 201405071323.

>>> Database proda will be shutdown and restarted <<<
Ensure Dbvisit is no longer scheduled.

>>> Gracefull Switchover will attempt to reset Oracle parameters db_file_name_convert and log_file_name_convert to default values (null strings) in the spfile <<<

Obtaining archive log gap....
Contacting Standby Database proda on dbvisit2...
Last standby sequence obtained (55) for thread 1.

Archive Log Gap for thread 1 is: 0. This is correct to continue.

Please enter unique key to begin graceful switchover for database proda.
The same key must be entered on both primary and standby server.

Please start command: dbv_oraStartStop switchover proda
on dbvisit2 if not already started.

Please enter unique key:
dbvisit
Key dbvisit entered.

Contacting dbvisit2 to ensure the same unique key is entered for proda.
Waiting for Key 1 on dbvisit2...
Checkpoint 1 completed. Key found on dbvisit2
Transferring X.dbvisit.dbvisit.proda.tempfile to host
dbvisit2:X.dbvisit.dbvisit.proda.tempfile
Transferring X.dbvisit.dbvisit.proda.force_logging to host
dbvisit2:X.dbvisit.dbvisit.proda.force_logging
Waiting for Checkpoint 2 on dbvisit2...
Checkpoint 2 completed. Key found on dbvisit2
Waiting for Checkpoint 3 on dbvisit2...
Checkpoint 3 completed. Key found on dbvisit2
Shutting down regular Database proda...
Regular Database proda shutdown successfully.
Starting Regular Database proda...
Regular Database proda started restrict.
Performing Oracle Checkpoint.
Waiting 3 seconds for log switch completion...
Creating standby controlfile controlfile...
Waiting for Checkpoint 4 on dbvisit2...
Checkpoint 4 completed. Key found on dbvisit2
Copying new archives for proda to dbvisit2...
Compressing  o1_mf_1_56_9pmsq68o_.arc...
Transferring o1_mf_1_56_9pmsq68o_.arc.gz to host
dbvisit2:o1_mf_1_56_9pmsq68o_.arc.gz
Compressing  o1_mf_1_57_9pmsrlwo_.arc...
Transferring o1_mf_1_57_9pmsrlwo_.arc.gz to host
dbvisit2:o1_mf_1_57_9pmsrlwo_.arc.gz
Transferring X.dbvisit.dbvisit.proda.archives to host
dbvisit2:X.dbvisit.dbvisit.proda.archives
Completed.
Shutting down regular Database proda...
Regular Database proda shutdown successfully.
Copying redo logs ... this may take a while...
Compressing  X.dbvisit.dbvisit.proda.redo_1.log...
Transferring X.dbvisit.dbvisit.proda.redo_1.log.gz to host
dbvisit2:X.dbvisit.dbvisit.proda.redo_1.log.gz
Compressing  X.dbvisit.dbvisit.proda.redo_2.log...
Transferring X.dbvisit.dbvisit.proda.redo_2.log.gz to host
dbvisit2:X.dbvisit.dbvisit.proda.redo_2.log.gz
Compressing  X.dbvisit.dbvisit.proda.redo_3.log...
Transferring X.dbvisit.dbvisit.proda.redo_3.log.gz to host
dbvisit2:X.dbvisit.dbvisit.proda.redo_3.log.gz
Transferring X.dbvisit.dbvisit.proda.redo_matrix to host
dbvisit2:X.dbvisit.dbvisit.proda.redo_matrix
Waiting for Checkpoint 5 on dbvisit2...
Checkpoint 5 completed. Key found on dbvisit2
Backing up current controlfiles for proda dbvisit1...
Database proda on dbvisit1 is already down. No action taken.
Starting Regular Database proda...
Regular Database proda started nomount.
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Controlfile backed up as /usr/tmp/GS/proda/X.dbvisit.dbvisit.proda.controlfile.
Database proda on dbvisit1 is already down. No action taken.
Transferring X.dbvisit.dbvisit.proda.controlfile to host
dbvisit2:X.dbvisit.dbvisit.proda.controlfile
Waiting for Checkpoint 6 on dbvisit2...
Checkpoint 6 completed. Key found on dbvisit2
Waiting for Checkpoint 7 on dbvisit2...
Checkpoint 7 completed. Key found on dbvisit2
Waiting for Checkpoint 8 on dbvisit2...
Checkpoint 8 completed. Key found on dbvisit2
Waiting for Checkpoint 9 on dbvisit2...
Checkpoint 9 completed. Key found on dbvisit2
Waiting for Checkpoint 10 on dbvisit2...
Checkpoint 10 completed. Key found on dbvisit2
Waiting for Checkpoint 11 on dbvisit2...
Checkpoint 11 completed. Key found on dbvisit2
Waiting for Checkpoint 12 on dbvisit2...
Checkpoint 12 completed. Key found on dbvisit2
Database proda on dbvisit1 is already down. No action taken.
Starting Regular Database proda...
Regular Database proda started nomount.
STANDBY controlfile created.
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Starting Standby Database proda...
Standby Database proda started .
Waiting for Checkpoint 13 on dbvisit2...
Checkpoint 13 completed. Key found on dbvisit2
Waiting for Checkpoint 14 on dbvisit2...
Checkpoint 14 completed. Key found on dbvisit2
File dbv_proda.env copied to dbv_proda.env.201405071323.
Dbvisit Database configuration (DDC) file dbv_proda.env has been updated and
variables have been reversed between primary and standby server.

SOURCE=dbvisit2 DESTINATION=dbvisit1.

Waiting for Checkpoint 15 on dbvisit2...
Checkpoint 15 completed. Key found on dbvisit2
Waiting for Checkpoint 16 on dbvisit2...
Checkpoint 16 completed. Key found on dbvisit2
Waiting for Checkpoint 17 on dbvisit2...
Checkpoint 17 completed. Key found on dbvisit2
Tempfiles dropped.
Waiting for Checkpoint 18 on dbvisit2...
Checkpoint 18 completed. Key found on dbvisit2

Graceful switchover completed.

This database (proda) is now a standby database.

To keep this new standby database in synch,
reschedule Dbvisit as per normal:
        dbvisit proda
=============================================================
dbv_oraStartStop ended on dbvisit1: Wed May  7 13:30:32 2014
=============================================================

You have new mail in /var/spool/mail/oracle
[oracle@dbvisit1 standby]$

[oracle@dbvisit2 standby]$ ./dbv_oraStartStop switchover proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 23049)
dbv_oraStartStop started on dbvisit2: Wed May  7 13:24:13 2014 ()
=============================================================

=============================================================
Graceful Switchover starting on Standby Database proda.
Timestamp: 201405071324.
Database proda will be shutdown and restarted!
Ensure Dbvisit is no longer scheduled.

Please enter unique key to begin graceful switchover for database proda.
The same key must be entered on both primary and standby server.

Please start command: dbv_oraStartStop switchover proda
on dbvisit1 if not already started.

Please enter unique key:
dbvisit
Key dbvisit entered.

Contacting dbvisit1 to ensure the same unique key is entered for proda.
Waiting for Key 1 on dbvisit1...
Checkpoint 1 completed. Key found on dbvisit1
Waiting for Checkpoint 2 on dbvisit1...
Checkpoint 2 completed. Key found on dbvisit1
Waiting for Checkpoint 3 on dbvisit1...
Checkpoint 3 completed. Key found on dbvisit1
Waiting for Checkpoint 4 on dbvisit1...
Checkpoint 4 completed. Key found on dbvisit1
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Waiting for Checkpoint 5 on dbvisit1...
Checkpoint 5 completed. Key found on dbvisit1
Uncompressing o1_mf_1_56_9pmsq68o_.arc.gz...
Uncompressing o1_mf_1_57_9pmsrlwo_.arc.gz...
Uncompressing X.dbvisit.dbvisit.proda.redo_1.log.gz...
Uncompressing X.dbvisit.dbvisit.proda.redo_2.log.gz...
Uncompressing X.dbvisit.dbvisit.proda.redo_3.log.gz...
Waiting for Checkpoint 6 on dbvisit1...
Checkpoint 6 completed. Key found on dbvisit1
Waiting for Checkpoint 7 on dbvisit1...
Checkpoint 7 completed. Key found on dbvisit1
Backing up current controlfiles for proda dbvisit2...
Database proda on dbvisit2 is already down. No action taken.
Starting Standby Database proda...
Standby Database proda started nomount.
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Controlfile backed up as /usr/tmp/GS/proda/X.dbvisit.dbvisit.proda.stdby_ctl_bck.
Database proda on dbvisit2 is already down. No action taken.
Waiting for Checkpoint 8 on dbvisit1...
Checkpoint 8 completed. Key found on dbvisit1
Starting Standby Database proda...
Standby Database proda started nomount.
Database proda on dbvisit2 is already started. No action taken.
PRIMARY controlfile created.
Mount Database proda...
Database proda mounted.
Copying redo log /usr/tmp/GS/proda/X.dbvisit.dbvisit.proda.redo_1.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_1.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.dbvisit.proda.redo_1.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_2.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.dbvisit.proda.redo_2.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_1.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.dbvisit.proda.redo_2.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_2.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.dbvisit.proda.redo_3.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_1.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.dbvisit.proda.redo_3.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_2.log
Waiting for Checkpoint 9 on dbvisit1...
Checkpoint 9 completed. Key found on dbvisit1
Recovering new primary database...
Completed.
Waiting for Checkpoint 10 on dbvisit1...
Checkpoint 10 completed. Key found on dbvisit1
Archive log all for Database proda...
Completed.
Tempfiles dropped.
Waiting for Checkpoint 11 on dbvisit1...
Checkpoint 11 completed. Key found on dbvisit1
Open Database proda...
Database proda opened.
Waiting for Checkpoint 12 on dbvisit1...
Checkpoint 12 completed. Key found on dbvisit1
Waiting for Checkpoint 13 on dbvisit1...
Checkpoint 13 completed. Key found on dbvisit1
Waiting for Checkpoint 14 on dbvisit1...
Checkpoint 14 completed. Key found on dbvisit1
File dbv_proda.env copied to dbv_proda.env.201405071324.
Dbvisit Database configuration (DDC) file dbv_proda.env has been updated and
variables have been reversed between primary and standby server.

SOURCE=dbvisit2 DESTINATION=dbvisit1.

Waiting for Checkpoint 15 on dbvisit1...
Checkpoint 15 completed. Key found on dbvisit1
Tempfiles created.
Waiting for Checkpoint 16 on dbvisit1...
Checkpoint 16 completed. Key found on dbvisit1
Compressing  o1_mf_1_56_9pmsq68o_.arc...
Compressing  o1_mf_1_57_9pmsrlwo_.arc...
Waiting for Checkpoint 17 on dbvisit1...
Checkpoint 17 completed. Key found on dbvisit1

FORCE LOGGING is left turned off in the primary database proda on dbvisit2.
Waiting for Checkpoint 18 on dbvisit1...
Checkpoint 18 completed. Key found on dbvisit1

Graceful switchover completed.

This database (proda) is now the primary database.

You may consider re-creating a password file to make sure all sysdba passwords are preserved.
To keep the standby database on dbvisit1 in synch with this primary database,
reschedule Dbvisit as per normal:
        dbvisit proda
=============================================================
dbv_oraStartStop ended on dbvisit2: Wed May  7 13:30:27 2014
=============================================================

[oracle@dbvisit2 standby]$


Tuesday, May 6, 2014

Oracle Database (Standard Edition) - Disaster Recovery Testing Using 'dbvisit' Software


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
 

Thursday, May 1, 2014

Oracle Database Switchover using 'dbvisit' for Oracle Database (Standard Edition)


Primary Database:

Step1: Transfer all the archive log files

[oracle@dbvisit1 standby]$ ./dbvisit proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.9151) (pid 11969)
dbvisit started on dbvisit1: Fri May  2 12:02:55 2014 ()
=============================================================
Obtaining information from standby database (RUN_INSPECT=Y)...
Checking Dbvisit Standby configurational differences between dbvisit1 and dbvisit2...
No Dbvisit Standby configurational differences found between dbvisit1 and dbvisit2.

Log file(s) for proda will be transferred from dbvisit1 to dbvisit2...
Transferring o1_mf_1_30_9p6gcgcx_.arc.gz to host dbvisit2:o1_mf_1_30_9p6gcgcx_.arc.gz
Transferring o1_mf_1_31_9p6ghhks_.arc.gz to host dbvisit2:o1_mf_1_31_9p6ghhks_.arc.gz
201405021202 - 2 Log transfers to dbvisit2 for proda completed.
         Last sequence was 31.
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: Fri May  2 12:03:08 2014
=============================================================

Step2: Starting switchover from Primary Database

[oracle@dbvisit1 standby]$ ./dbv_oraStartStop switchover proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 12348)
dbv_oraStartStop started on dbvisit1: Fri May  2 12:04:51 2014 ()
=============================================================

=============================================================
Graceful Switchover starting on Primary Database proda with standby database proda.
Timestamp: 201405021204.

>>> Database proda will be shutdown and restarted <<<
Ensure Dbvisit is no longer scheduled.

>>> Gracefull Switchover will attempt to reset Oracle parameters db_file_name_convert and log_file_name_convert to default values (null strings) in the spfile <<<

Obtaining archive log gap....
Contacting Standby Database proda on dbvisit2...
Last standby sequence obtained (31) for thread 1.

Archive Log Gap for thread 1 is: 0. This is correct to continue.

Please enter unique key to begin graceful switchover for database proda.
The same key must be entered on both primary and standby server.

Please start command: dbv_oraStartStop switchover proda
on dbvisit2 if not already started.

Please enter unique key:
switch
Key switch entered.

Contacting dbvisit2 to ensure the same unique key is entered for proda.
Waiting for Key 1 on dbvisit2...
switchCheckpoint 1 completed. Key found on dbvisit2
Transferring X.dbvisit.switch.proda.tempfile to host dbvisit2:X.dbvisit.switch.p
Transferring X.dbvisit.switch.proda.force_logging to host dbvisit2:X.dbvisit.swi
Waiting for Checkpoint 2 on dbvisit2...
Checkpoint 2 completed. Key found on dbvisit2
Waiting for Checkpoint 3 on dbvisit2...
Checkpoint 3 completed. Key found on dbvisit2
Shutting down regular Database proda...
Regular Database proda shutdown successfully.
Starting Regular Database proda...
Regular Database proda started restrict.
Performing Oracle Checkpoint.
Waiting 3 seconds for log switch completion...
Creating standby controlfile controlfile...
Waiting for Checkpoint 4 on dbvisit2...
Checkpoint 4 completed. Key found on dbvisit2
Copying new archives for proda to dbvisit2...
Compressing  o1_mf_1_32_9p6h5ssl_.arc...
Transferring o1_mf_1_32_9p6h5ssl_.arc.gz to host dbvisit2:o1_mf_1_32_9p6h5ssl_.arc.gz
Compressing  o1_mf_1_33_9p6h747n_.arc...
Transferring o1_mf_1_33_9p6h747n_.arc.gz to host dbvisit2:o1_mf_1_33_9p6h747n_.arc.gz
Transferring X.dbvisit.switch.proda.archives to host dbvisit2:X.dbvisit.switch.proda.archives
Completed.
Shutting down regular Database proda...
Regular Database proda shutdown successfully.
Copying redo logs ... this may take a while...
Compressing  X.dbvisit.switch.proda.redo_1.log...
Transferring X.dbvisit.switch.proda.redo_1.log.gz to host dbvisit2:X.dbvisit.switch.proda.redo_1.log.gz
Compressing  X.dbvisit.switch.proda.redo_2.log...
Transferring X.dbvisit.switch.proda.redo_2.log.gz to host dbvisit2:X.dbvisit.switch.proda.redo_2.log.gz
Compressing  X.dbvisit.switch.proda.redo_3.log...
Transferring X.dbvisit.switch.proda.redo_3.log.gz to host dbvisit2:X.dbvisit.switch.proda.redo_3.log.gz
Transferring X.dbvisit.switch.proda.redo_matrix to host dbvisit2:X.dbvisit.switch.proda.redo_matrix
Waiting for Checkpoint 5 on dbvisit2...
Checkpoint 5 completed. Key found on dbvisit2
Backing up current controlfiles for proda dbvisit1...
Database proda on dbvisit1 is already down. No action taken.
Starting Regular Database proda...
Regular Database proda started nomount.
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Controlfile backed up as /usr/tmp/GS/proda/X.dbvisit.switch.proda.controlfile.
Database proda on dbvisit1 is already down. No action taken.
Transferring X.dbvisit.switch.proda.controlfile to host dbvisit2:X.dbvisit.switch.proda.controlfile
Waiting for Checkpoint 6 on dbvisit2...
Checkpoint 6 completed. Key found on dbvisit2
Waiting for Checkpoint 7 on dbvisit2...
Checkpoint 7 completed. Key found on dbvisit2
Waiting for Checkpoint 8 on dbvisit2...
Checkpoint 8 completed. Key found on dbvisit2
Waiting for Checkpoint 9 on dbvisit2...
Checkpoint 9 completed. Key found on dbvisit2
Waiting for Checkpoint 10 on dbvisit2...
Checkpoint 10 completed. Key found on dbvisit2
Waiting for Checkpoint 11 on dbvisit2...
Checkpoint 11 completed. Key found on dbvisit2
Waiting for Checkpoint 12 on dbvisit2...
Checkpoint 12 completed. Key found on dbvisit2
Database proda on dbvisit1 is already down. No action taken.
Starting Regular Database proda...
Regular Database proda started nomount.
STANDBY controlfile created.
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Starting Standby Database proda...
Standby Database proda started .
Waiting for Checkpoint 13 on dbvisit2...
Checkpoint 13 completed. Key found on dbvisit2
Waiting for Checkpoint 14 on dbvisit2...
Checkpoint 14 completed. Key found on dbvisit2
File dbv_proda.env copied to dbv_proda.env.201405021204.
Dbvisit Database configuration (DDC) file dbv_proda.env has been updated and variables have been reversed between primary and standby server.

SOURCE=dbvisit2 DESTINATION=dbvisit1.

Waiting for Checkpoint 15 on dbvisit2...
Checkpoint 15 completed. Key found on dbvisit2
Waiting for Checkpoint 16 on dbvisit2...
Checkpoint 16 completed. Key found on dbvisit2
Waiting for Checkpoint 17 on dbvisit2...
Checkpoint 17 completed. Key found on dbvisit2
Tempfiles dropped.
Waiting for Checkpoint 18 on dbvisit2...
201405021204 - Cancelling graceful switchover, because processing has stopped on dbvisit2
Status: Database proda has been converted to standby database.

No further roll forward action required on dbvisit1.

                Dbvisit Standby terminated.
Return code = 960

(Tracefile required if contacting Dbvisit Standby support: /usr/tmp/12348_dbv_oraStartStop_switchover_proda_201405021204.trc (server:dbvisit1))
You have new mail in /var/spool/mail/oracle
[oracle@dbvisit1 standby]$

Step3: Synchronization on Physical Standby Database

[oracle@dbvisit2 standby]$ ./dbvisit proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.9151) (pid 9636)
dbvisit started on dbvisit2: Fri May  2 12:03:17 2014 ()
=============================================================
Log file(s) for proda from dbvisit1 will be applied to dbvisit2...
201405021203 - Log seq 23 thread 1 applied to standby database proda.
201405021203 - Log seq 24 thread 1 applied to standby database proda.
201405021203 - Log seq 25 thread 1 applied to standby database proda.
201405021203 - Log seq 26 thread 1 applied to standby database proda.
201405021203 - Log seq 27 thread 1 applied to standby database proda.
201405021203 - Log seq 28 thread 1 applied to standby database proda.
201405021203 - Log seq 29 thread 1 applied to standby database proda.
201405021203 - Log seq 30 thread 1 applied to standby database proda.
201405021203 - Log seq 31 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   : 28
Number of files deleted         : 0
Current Disk percent full       : 31%
=============================================================
dbvisit ended on dbvisit2: Fri May  2 12:04:31 2014
=============================================================

Step4: Converting Physical Standby Database to Primary Database

[oracle@dbvisit2 standby]$ ./dbv_oraStartStop switchover proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 10084)
dbv_oraStartStop started on dbvisit2: Fri May  2 12:04:38 2014 ()
=============================================================
=============================================================
Graceful Switchover starting on Standby Database proda.
Timestamp: 201405021204.
Database proda will be shutdown and restarted!
Ensure Dbvisit is no longer scheduled.

Please enter unique key to begin graceful switchover for database proda.
The same key must be entered on both primary and standby server.

Please start command: dbv_oraStartStop switchover proda
on dbvisit1 if not already started.

Please enter unique key:
switch
Key switch entered.

Contacting dbvisit1 to ensure the same unique key is entered for proda.
Waiting for Key 1 on dbvisit1...
Checkpoint 1 completed. Key found on dbvisit1
Waiting for Checkpoint 2 on dbvisit1...
Checkpoint 2 completed. Key found on dbvisit1
Waiting for Checkpoint 3 on dbvisit1...
Checkpoint 3 completed. Key found on dbvisit1
Waiting for Checkpoint 4 on dbvisit1...
Checkpoint 4 completed. Key found on dbvisit1
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Waiting for Checkpoint 5 on dbvisit1...
Checkpoint 5 completed. Key found on dbvisit1
Uncompressing o1_mf_1_32_9p6h5ssl_.arc.gz...
Uncompressing o1_mf_1_33_9p6h747n_.arc.gz...
Uncompressing X.dbvisit.switch.proda.redo_1.log.gz...
Uncompressing X.dbvisit.switch.proda.redo_2.log.gz...
Uncompressing X.dbvisit.switch.proda.redo_3.log.gz...
Waiting for Checkpoint 6 on dbvisit1...
Checkpoint 6 completed. Key found on dbvisit1
Waiting for Checkpoint 7 on dbvisit1...
Checkpoint 7 completed. Key found on dbvisit1
Backing up current controlfiles for proda dbvisit2...
Database proda on dbvisit2 is already down. No action taken.
Starting Standby Database proda...
Standby Database proda started nomount.
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Controlfile backed up as /usr/tmp/GS/proda/X.dbvisit.switch.proda.stdby_ctl_bck.
Database proda on dbvisit2 is already down. No action taken.
Waiting for Checkpoint 8 on dbvisit1...
Checkpoint 8 completed. Key found on dbvisit1
Starting Standby Database proda...
Standby Database proda started nomount.
Database proda on dbvisit2 is already started. No action taken.
PRIMARY controlfile created.
Mount Database proda...
Database proda mounted.
Copying redo log /usr/tmp/GS/proda/X.dbvisit.switch.proda.redo_1.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_1.log
File /u01/app/oracle/fast_recovery_area/PRODA/onlinelog/o1_mf_1_9p3q3gs3_.log renamed to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_1.log.

Copying redo log /usr/tmp/GS/proda/X.dbvisit.switch.proda.redo_1.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_2.log
File /u01/app/oracle/oradata/PRODA/onlinelog/o1_mf_1_9p3q3d9m_.log renamed to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_2.log.

Copying redo log /usr/tmp/GS/proda/X.dbvisit.switch.proda.redo_2.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_1.log
File /u01/app/oracle/fast_recovery_area/PRODA/onlinelog/o1_mf_2_9p3q3ljx_.log renamed to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_1.log.

Copying redo log /usr/tmp/GS/proda/X.dbvisit.switch.proda.redo_2.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_2.log
File /u01/app/oracle/oradata/PRODA/onlinelog/o1_mf_2_9p3q3l6o_.log renamed to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_2.log.

Copying redo log /usr/tmp/GS/proda/X.dbvisit.switch.proda.redo_3.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_1.log
File /u01/app/oracle/fast_recovery_area/PRODA/onlinelog/o1_mf_3_9p3q3t8n_.log renamed to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_1.log.

Copying redo log /usr/tmp/GS/proda/X.dbvisit.switch.proda.redo_3.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_2.log
File /u01/app/oracle/oradata/PRODA/onlinelog/o1_mf_3_9p3q3qvn_.log renamed to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_2.log.

Waiting for Checkpoint 9 on dbvisit1...
Checkpoint 9 completed. Key found on dbvisit1
Recovering new primary database...
Completed.
Waiting for Checkpoint 10 on dbvisit1...
Checkpoint 10 completed. Key found on dbvisit1
Archive log all for Database proda...
Completed.
Tempfiles dropped.
Waiting for Checkpoint 11 on dbvisit1...
Checkpoint 11 completed. Key found on dbvisit1
Open Database proda...
Database proda opened.
Waiting for Checkpoint 12 on dbvisit1...
Checkpoint 12 completed. Key found on dbvisit1
Waiting for Checkpoint 13 on dbvisit1...
Checkpoint 13 completed. Key found on dbvisit1
Waiting for Checkpoint 14 on dbvisit1...
Checkpoint 14 completed. Key found on dbvisit1
File dbv_proda.env copied to dbv_proda.env.201405021204.
Dbvisit Database configuration (DDC) file dbv_proda.env has been updated and variables have been reversed between primary and standby server.

SOURCE=dbvisit2 DESTINATION=dbvisit1.

Waiting for Checkpoint 15 on dbvisit1...
Checkpoint 15 completed. Key found on dbvisit1
Tempfiles created.
Waiting for Checkpoint 16 on dbvisit1...
Checkpoint 16 completed. Key found on dbvisit1
Compressing  o1_mf_1_32_9p6h5ssl_.arc...
Compressing  o1_mf_1_33_9p6h747n_.arc...
Waiting for Checkpoint 17 on dbvisit1...
Checkpoint 17 completed. Key found on dbvisit1
201405021204 - Problem with obtaining the last sequence from standby database on dbvisit1.
201405021210 - Directory ARCHDEST "/oracle/oraarch/proda" does not exists and cannot be created. Please check permissions or create directory on dbvisit1.             Dbvisit
Standby terminated.Return code = 853(Tracefile required if contacting Dbvisit Standby support: /usr/tmp/17418_dbv_functions_proda_201405021210.trc (server:dbvisit1))
Please check Standby Database is up and runnning on dbvisit2, else please contact Dbvisit support.
Status: Database proda has been converted to the Primary Database.

No further roll forward action required on dbvisit2.
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover.
To enable FRA run the following command:
SQL>alter system set db_recovery_file_dest = '/u01/app/oracle/fast_recovery_area' scope=both;
                Dbvisit Standby terminated.
Return code = 85

(Tracefile required if contacting Dbvisit Standby support: /usr/tmp/10084_dbv_oraStartStop_switchover_proda_201405021204.trc (server:dbvisit2))
[oracle@dbvisit2 standby]$



Monday, April 21, 2014

Published Two Oracle Technical Articles in World Famous Site "OracleTechnology Network (OTN)"


Published Two Oracle Technical Articles in World Famous Site "OracleTechnology Network (OTN)"

Article-19 : Oracle Database 12c: Una introducción a los conceptos de Respaldo, Recuperación y Recuperación a un punto en el tiempo (PITR) de PDBs
http://www.oracle.com/technetwork/es/articles/database-performance/pdbs-backup-recovery-dbpitr-2192211-esa.html


Article-20 : Migración a la versión 12c de la base de datos Oracle sin interrupción de servicio usando Oracle Golden Gate 12c
http://www.oracle.com/technetwork/es/articles/datawarehouse/oracle-golden-gate-2192209-esa.html

These articles are in Spanish, so please do use translator to read it in English by Chrome (or) Google-itools.

 

Thursday, April 17, 2014

Published Oracle Technical Article in World Famous Site "Oracle Technology Network (OTN)"


Article No 18 : Published Oracle Technical Article in World Famous Site "Oracle Technology Network (OTN)"

Article Title : Todo lo que tienes que saber sobre COMMON y LOCAL en Oracle Database 12c

Article URL : http://www.oracle.com/technetwork/es/articles/idm/common-local-12c-2190666-esa.html


Wednesday, April 9, 2014

Revolution in Voting Disk (VD) & Oracle Cluster Registry (OCR) in RAC (10g RAC, 11g RAC & 12c RAC)


Revolution in Voting Disk (VD) & Oracle Cluster Registry (OCR) in RAC (10g RAC, 11g RAC & 12c RAC)

10g RAC: Voting Disk : 20 MB (3 locations) & OCR : 100 MB (2 locations)in raw devices
11g RAC: Voting Disk & Oracle Cluster Registry : 2 GB (3 locations) in ASM disk groups
12c RAC: Voting Disk & Oracle Cluster Registry : 4 GB (3 locations) in ASM disk groups
                 (Check the choices in 12c RAC Implementation Screenshot)