mohibalvi.wordpress.com
Backup Concepts | Mohib Alvi
https://mohibalvi.wordpress.com/2011/04/17/backup-concepts
Laquo; Oracle Database Architecture. Posted April 17, 2011 by mohibalvi in Backup and Recovery. Logical Backup Export Import. RMAN backup and recovery. User Managed Backup Recovery. A whole database backup. Includes all data files and at least one control file. Make a copy of every data block within the files being backed up that contains data. May include zero or more tablespaces, zero or more data files, and may or may not include a control file. Also known as hot. Or inconsistent backups) are taken wh...
chandu208.blogspot.com
Oracle: Basic Unix Commands
http://chandu208.blogspot.com/2011/04/basic-unix-commands.html
Wednesday, April 13, 2011. Creates a Perl script from an awk script. Prints statistics about users' connect time. Create a name for another command or long command string. Maintain portable archive or library. Display the architecture of the current host. Manipulate the system ARP cache. Awk script processing program. Deletes any specified prefix from a string. Editor for large files. Continues a program running in the background. Enable / disable incoming mail notifications. Cancels a print job. Tells y...
chandu208.blogspot.com
Oracle: Materialized View
http://chandu208.blogspot.com/2011/04/materialized-view.html
Thursday, April 28, 2011. There are 3 types of materialized views:. Cannot be updated and complex materialized views are supported. Can be updated even when disconnected from the master site, are refreshed on demand and consume fewer resources but requires advanced replication option. Are created with the for update. Clause, any changes are lost when the view is updated this also requires advanced replication option. Provides three different types of refresh operations:. DBMS MVIEW.REFRESH ALL MVIEWS.
chandu208.blogspot.com
Oracle: Data Guard Protection Modes
http://chandu208.blogspot.com/2011/08/normal-0-false-false-false-en-us-x-none.html
Thursday, August 11, 2011. Data Guard Protection Modes. Oracle Data Guard (known as Oracle Standby Database prior to Oracle9 i. Forms an extension to the Oracle RDBMS and provides organizations with high availability, data protection, and disaster recovery for enterprise databases. One of those new features in Oracle9 i. Release 2 is the ability for the DBA to place the database into one of the following. Data protection and availability. Log transport services will also coordinate with. On at least one ...
chandu208.blogspot.com
Oracle: Oracle Cluster Health Monitor (CHM) using large amount of space (crfclust.bdb)
http://chandu208.blogspot.com/2015/04/last-night-my-rac-2-node-server-went.html
Thursday, April 23, 2015. Oracle Cluster Health Monitor (CHM) using large amount of space (crfclust.bdb). Last night my rac 2 node server went down for OS patcing and rebooted but all CRS resources not coming up on both the node after node reboots:. Conn as root user and check all resources. Root@oradev11 bin]# ./crsctl stat res -t -init. NAME TARGET STATE SERVER STATE DETAILS. 1 ONLINE ONLINE oradev11. 1 ONLINE ONLINE oradev11. 1 ONLINE OFFLINE STARTING. CRS alert log says:. U01/app/11.2.0.4...U01/app/1...
practical-tech.blogspot.com
Yet another technology blog.: December 2012
http://practical-tech.blogspot.com/2012_12_01_archive.html
Yet another technology blog. Thursday, December 27, 2012. Different ways to get the DBID of Database. Method 1:Through SQL command prompt. SQL select dbid from v$database; DBID - - - - - 3764293269. Posted by Ajay Singh Chandi. Simulating Oracle Tape Backups. As per Oracle Note:312737.1. The Oracle DiskSbt API is designed for TESTING purposes ONLY and can NOT be used for any database backup. The Oracle.Disksbt can be used to simulate tape backups on disk using sbt tape channel. Posted by Ajay Singh Chandi.
practical-tech.blogspot.com
Yet another technology blog.: January 2013
http://practical-tech.blogspot.com/2013_01_01_archive.html
Yet another technology blog. Monday, January 21, 2013. How to Password Protect Listener in 11g? Log in to the listener control utility. Oracle@canada ]$ lsnrctl #Select listener name. LSNRCTL set current listener prod. Current Listener is prod. Change password(press enter for old password). LSNRCTL change password. Save the configuration. LSNRCTL save config. In listener.ora file insert the following line. Current Listener is prod. SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/d...To st...
practical-tech.blogspot.com
Yet another technology blog.: How To Find Views And What Information They Provide In Oracle Database ?
http://practical-tech.blogspot.com/2013/11/how-to-find-views-and-what-information.html
Yet another technology blog. Saturday, November 9, 2013. How To Find Views And What Information They Provide In Oracle Database? SQL desc dba views;. SQL select view name from dba views where view name like'%ROLE%';. SQL desc dict;. Type - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - TABLE NAME VARCHAR2(30) COMMENTS VARCHAR2(4000). SQL select * from dict where table name like '%ROLE%';. Posted by Ajay Singh Chandi. Subscribe to: Post Comments (Atom). View my complete profile.
practical-tech.blogspot.com
Yet another technology blog.: January 2014
http://practical-tech.blogspot.com/2014_01_01_archive.html
Yet another technology blog. Wednesday, January 22, 2014. Flashback Data Archive (Oracle Total Recall) 11g. GRANTEE PRIVILEGE ADM - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - SCOTT FLASHBACK ARCHIVE ADMINISTER NO SYS FLASHBACK ANY TABLE NO DBA FLASHBACK ANY TABLE YES SYS FLASHBACK ARCHIVE ADMINISTER NO DBA FLASHBACK ARCHIVE ADMINISTER YES MDSYS FLASHBACK ANY TABLE NO 6 rows selected. SQL grant flashback archive administer to scott;. SQL create table t1 2 (id int,name varchar2...
practical-tech.blogspot.com
Yet another technology blog.: November 2012
http://practical-tech.blogspot.com/2012_11_01_archive.html
Yet another technology blog. Wednesday, November 14, 2012. Oracle Goldengate 11g Initial Load Using Direct Load Method. This article focuses on initial synchronization of source and target databases by using Golden Gate initial direct load method for the purpose of zero downtime DML replication. Prerequisites:. Posted by Ajay Singh Chandi. Sunday, November 11, 2012. Delete or Remove Extract and Replicat Processes (Golden Gate 11g). Posted by Ajay Singh Chandi. Subscribe to: Posts (Atom).