oracledba365.wordpress.com
ORACLE DBA POOL | YogendraYogendra
http://oracledba365.wordpress.com/
Yogendra
http://oracledba365.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Sunday
LOAD TIME
0.5 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
11
SSL
EXTERNAL LINKS
0
SITE IP
192.0.78.13
LOAD TIME
0.5 sec
SCORE
6.2
ORACLE DBA POOL | Yogendra | oracledba365.wordpress.com Reviews
https://oracledba365.wordpress.com
Yogendra
oracledba365.wordpress.com
Interview FAQ1 | ORACLE DBA POOL
https://oracledba365.wordpress.com/interview-faq1
Oracle DBA interview questions. Oracle Concepts and Architecture Database Structures. 1 What are the components of physical database structure of Oracle database? The physical layer of the database consists of three types of files:. One or more Datafiles. Two or more redo log files. One or more control files. Datafiles (.dbf files):. Redo Log Files (.rdo and .arc):. Control Files (.ctl):. 2 What are the components of logical database structure of Oracle database? The advantage of separating the logical a...
Linux Regular Commands | ORACLE DBA POOL
https://oracledba365.wordpress.com/2010/04/28/linux-regular-commands
Directory Commands – mkdir. To create a new directory below current directory:. To create multiple versions of directory:. Creates dir1 first. Creates dir2 under dir1. Creates dir3 under dir2. To create a directory with given permissions:. Mkdir -m 754 new-dir. New-dir will be created with 754 permissions. Directory Commands – rmdir. To remove a directory:. Rmdir can remove only empty directories. To remove directory along parent directory:. Deletes all the directories. Directory Commands – cd. Picks up ...
Controlfile Recover | ORACLE DBA POOL
https://oracledba365.wordpress.com/2010/04/28/controlfile-recover
SCENARIO LOSS OF ALL CONTROLFILES (NO CATALOG). SQL insert into myobjects select * from myobjects;. SQL select count(*) from myobjects;. 8212;——-. Need to check this record count after recovery. SQL archive log list. Database log mode Archive Mode. Archive destination USE DB RECOVERY FILE DEST. Oldest online log sequence 5. Next log sequence to archive 7. Current log sequence 7. Note – current log sequence is 7 – not archived but contains the last committed changes that we made. ERROR at line 1:. Channel...
RMAN Enhancements | ORACLE DBA POOL
https://oracledba365.wordpress.com/2010/04/28/rman-enhancements
In this section, we will discuss the new features of Recovery Manager (RMAN) in Oracle 10g. Automated Channel Failover for Backup and Restore. And in the output to the terminal or log file when it encounters such problems. Automated File Creation During Recovery. This feature enhances RMAN recovery by automatically creating and recovering datafiles that have never been backed up. Automated File Creation During Recovery. Simplified Backups to Disk. Which is a proprietary format recognized by RMAN only....
Backup & Recovery Scenarios | ORACLE DBA POOL
https://oracledba365.wordpress.com/2010/04/28/backup-recovery-scenarios
Backup and Recovery Scenarios. User Managed Recovery Scenarios And Configuration. 1 Complete Closed Database Recovery. System tablespace is missing. 2 Complete Open Database Recovery. Non system tablespace is missing. 3 Complete Open Database Recovery (when the database is initially closed). Non system tablespace is missing. 4 Recovery of a Missing Datafile that has no backups. 5 Restore and Recovery of a Datafile to a different location. 6 Control File Recovery. RMAN Recovery Scenarios And Configuration.
TOTAL PAGES IN THIS WEBSITE
11
OracleDBA.ru
About OracleDBA.ru / про OracleDBA.ru. Notes, tricks, programs about/for Oracle and in particular, for its administration. Access to My Oracle Support site is not required but sometimes is desirable because of appearance of links to http:/ supporthtml.oracle.com. Below the same in Russian ]. Заметки, трики, программы, касающиеся Oracle и, в частности, его администрирования. Сайта можно смотреть в его блоге.
ORACLE_DBA
Oracle DBA
Oracle Database Administration Oracle Database Tuning Oracle Dataguard Admininstration Oracle Rac Administration Oracle DR DRILL. Thursday, 19 February 2015. How to make DR site as PR Site and vice versa in Oracle. Labels: Oracle Dataguard Drill down. Wednesday, 26 March 2014. Oracle Rac Node Removal. STEP BY STEP ORACLE 11G R2 NODE REMOVAL. Hayat Mohammad Khan (DBA) hayathk@hotmail.com. Maroof Ud Din (DBA) maroofuddinkhan@yahoo.com. Saturday, March 01, 2014. Oracle 11.2.0.4 two nodes cluster. Disabling ...
Site Title
October 16, 2016. October 16, 2016. This is the excerpt for your very first post. This is a text widget, which allows you to add text or HTML to your sidebar. You can use them to display text, links, images, HTML, or a combination of these. Edit them in the Widget section of the Customizer. Blog at WordPress.com. Blog at WordPress.com.
Account has been suspended!
This account has been suspended. Pls contact below link for removing suspension. or Call 8801977CREASH or Email: info@creash.com.bd.
ORACLE DBA POOL | Yogendra
April 28, 2010. Database cloning is a procedure by which you can create an exact copy of an Oracle database without doing a full export/import. This method is used frequently by DBAs to update test or development environments from production. 1 Relocating an Oracle database to another machine. 2 Moving Oracle database to new Storage media. 3 Renaming Oracle database. Clone an Oracle Database using Cold Physical Backup. Source Database side: (Troy database). Select name from v$datafile;. 1Create the appro...
| Musings of an oracle dba
Musings of an oracle dba. June 24, 2011. Welcome to WordPress.com. After you read this, you should delete and write your own post, with a new title above. Or hit Add New. On the left (of the admin dashboard. To start a fresh post. Are some suggestions for your first post. You can find new ideas for what to blog about by reading the Daily Post. To your browser. It creates a new blog post for you about any interesting page you read on the web. Make some changes to this page. June 23, 2011. Note: checkpoint...
Oracle DBA experience
Friday, June 5, 2015. Move object or schema from one replicate group to another replicate group. Move object or schema from one replicate group to another replicate group. We are moving one schema from the Replicat(R0000050) to Replicat(R0000018). Schema name CG DATA. Take the backup of all the param which are planned to modify during the change. 1 Add table on the new extract and Pump process. Add the below line in the param file(Extract and Pump). TABLE CG DATA.*;. Stop the replicat process. Oracle Gol...
index.htm
This site is under construction and will be available soon. For further information, please email chris@beebe.net.
Welcome oracledbachennai.com
