Are you over 18 and want to see adult content?
More Annotations
A complete backup of rocciadisalvezza.it
Are you over 18 and want to see adult content?
A complete backup of english-geo-active.com
Are you over 18 and want to see adult content?
A complete backup of antiochconway.com
Are you over 18 and want to see adult content?
A complete backup of rogueoctopus.com
Are you over 18 and want to see adult content?
A complete backup of psd-nuernberg.de
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of airporttaxiairport.com
Are you over 18 and want to see adult content?
A complete backup of comoespiargratis.com
Are you over 18 and want to see adult content?
A complete backup of shiftutechnology.com
Are you over 18 and want to see adult content?
A complete backup of morereward.co.uk
Are you over 18 and want to see adult content?
A complete backup of littlefamilyadventure.com
Are you over 18 and want to see adult content?
Text
these
SATYA'S DBA BLOG: MYSQL MYSQLDBIMPORT COMMANDS mysqldbimport import metadata and data from files Usage: mysqldbimport --server=user:pass@host:port:socket db1.csv db2.sql db3.grid mysqldbimport utility, in MySQL, imports metadata (object definitions) and/or data, from one or more files, for one or more databases with or without GITDs enabled. mysqldbimport --version SATYA'S DBA BLOG: DATABASE OF LIFE Make your life as deep as a database Be always as unique as a primary key Be productive as an index Take others good habits as a forei SATYA'S DBA BLOG: SNAPSHOT STANDBY DATABASES IN ORACLE The use of snapshot standby database is in the situation where if we want to clone a production database for testing something, we can convert existing physical standby database to snapshot standby database which is as close as to the production database w.r.t data, do required testing on the snapshot standby database and convert it back to physical standby database. SATYA'S DBA BLOG: EMCLI ENTERPRISE MANAGER COMMAND LINE emcli -- Enterprise Manager Command Line Interface, in Oracle emcli login -username="sysman" emcli modify_target -name="pdb2" - SATYA'S DBA BLOG: ORACLE RMAN INCREMENTAL BACKUPS Each data block in a datafile contains a system change number (SCN), which is the SCN at which the most recent change was made to the block. During an incremental backup, RMAN reads the SCN of each data block in the input file and compares it to SATYA'S DBA BLOG: ORACLE FLASH/FAST RECOVERY AREA The flash recovery area is the most powerful tool available from Oracle 10g, that plays a vital role in performing database backup & recovery operations.From Oracle 11g release2, flash recovery area is called as fast recovery area. Flash Recovery Area can be defined as a single, centralized, unified storage area that keep all the database backup & recovery related files and performs those SATYA'S DBA BLOG: EMCTL COMMANDS EMCTL: -- Enterprise Manager Control, in Oracle EMCTL @ normal (Oracle Management) Agent emctl start agent ./emctl start SATYA'S DBA BLOG: UNDO TABLESPACE/UNDO MANAGEMENT IN ORACLE Until Oracle 8i, Oracle uses rollback segments to manage the undo data. Oracle9i introduced automatic undo management, which allows the dba to exert more control on how long undo information is retained, simplifies undo space management and also eliminates the complexity of managing rollback segments. Oracle strongly recommends that you use undo tablespace to manage SATYA'S DBA BLOG: PASSWORD FILE (ORAPWD UTILITY) IN ORACLE The Oracle orapwd utility assists the DBA while granting SYSDBA, SYSOPER, SYSASM, SYSKM, SYSDG or SYSBACKUP privileges to other users. By default, SYS is the only user that has SYSDBA and SYSOPER privileges. Creating a password file, via orapwd, enables remote users to connect with administrative privileges. SATYA'S DBA BLOG: TEMPORARY TABLESPACE IN ORACLE Temporary tablespaces are used to manage space for database sort and joining operations and for storing global temporary tables. For joining two large tables or sorting a bigger result set, Oracle cannot do in memory by using SORT_AREA_SIZE in PGA (Programmable Global Area). Space will be allocated in a temporary tablespace for doingthese
SATYA'S DBA BLOG: MYSQL MYSQLDBIMPORT COMMANDS mysqldbimport import metadata and data from files Usage: mysqldbimport --server=user:pass@host:port:socket db1.csv db2.sql db3.grid mysqldbimport utility, in MySQL, imports metadata (object definitions) and/or data, from one or more files, for one or more databases with or without GITDs enabled. mysqldbimport --version SATYA'S DBA BLOG: DATABASE OF LIFE Make your life as deep as a database Be always as unique as a primary key Be productive as an index Take others good habits as a forei SATYA'S DBA BLOG: SNAPSHOT STANDBY DATABASES IN ORACLE The use of snapshot standby database is in the situation where if we want to clone a production database for testing something, we can convert existing physical standby database to snapshot standby database which is as close as to the production database w.r.t data, do required testing on the snapshot standby database and convert it back to physical standby database. SATYA'S DBA BLOG: EMCLI ENTERPRISE MANAGER COMMAND LINE emcli -- Enterprise Manager Command Line Interface, in Oracle emcli login -username="sysman" emcli modify_target -name="pdb2" - SATYA'S DBA BLOG: AUDITING OF ORACLE DATABASE The auditing mechanism for Oracle is extremely flexible. Oracle stores information that is relevant to auditing in its data dictionary. Every time a user attempts anything in the database where audit is enabled the Oracle kernel checks to see if an audit record should be created or updated (in the case or a session record) and generates the record in a table owned by the SYS user called AUD$. SATYA'S DBA BLOG: ORACLE EXPORT IMPORT (EXP & IMP) Export and Import are the Oracle utilities that allow us to make exports & imports of the data objects, and transfer the data across databases that reside on different hardware platforms on different Oracle versions. Export (exp) and import (imp) utilities are used to perform logical database backup and recovery. SATYA'S DBA BLOG: DATA PUMP EXPORT & IMPORT UTILITIES IN The following commands are valid while in interactive mode. Note: abbreviations are allowed Data Pump Export interactive mode While exporting is going on, press Control-C to go to interactive mode, it will stop the displaying of the messages on the SATYA'S DBA BLOG: ORACLE RMAN BASIC/ADVANCED INTERVIEW Hi Satya, You're posts are really very help full to me i need a help from you. Could you please post some more real time interview questions for RMAN,ASM and RAC. SATYA'S DBA BLOG: ORACLE Oracle - Automatic Storage Management (ASM) to provide a platform for file sharing in RAC and Grid computing. Automatic Storage Management (ASM) is a new type of file system. ASM provided a foundation for highly efficient storage management with kernelized asynchronous I/O, direct I/O, redundancy, striping, and an easy way to manage storage. SATYA'S DBA BLOG: TRANSPORTABLE TABLESPACES (TTS) IN ORACLE Oracle Database 10g Release 1 introduced cross platform transportable tablespaces (XTTS), which allows data files to be moved between platforms of different endian format. XTTS is an enhancement to the transportable tablespace (TTS). If ENDIAN formats are different we have to use RMAN (e.g. Windows to Solaris, Tru64 to AIX). SATYA'S DBA BLOG: ORACLE RMAN INCREMENTAL BACKUPS Each data block in a datafile contains a system change number (SCN), which is the SCN at which the most recent change was made to the block. During an incremental backup, RMAN reads the SCN of each data block in the input file and compares it to SATYA'S DBA BLOG: ORACLE DBA INTERVIEW QUESTIONS / FAQS Oracle DBA Interview Questions/FAQs Part1 1. What is an instance? Memory/SGA + background processes . 2. What is SGA? System/Sha SATYA'S DBA BLOG: EMCTL COMMANDS EMCTL: -- Enterprise Manager Control, in Oracle EMCTL @ normal (Oracle Management) Agent emctl start agent ./emctl start SATYA'S DBA BLOG: PASSWORD FILE (ORAPWD UTILITY) IN ORACLE The Oracle orapwd utility assists the DBA while granting SYSDBA, SYSOPER, SYSASM, SYSKM, SYSDG or SYSBACKUP privileges to other users. By default, SYS is the only user that has SYSDBA and SYSOPER privileges. Creating a password file, via orapwd, enables remote users to connect with administrative privileges. SATYA'S DBA BLOG: NEW FEATURES IN ORACLE DATABASE 18C Oracle Database 18c (18.1.0, 18.2.0, 18.3.0) new features General Starting with Oracle 18c, we can configure ORACLE_HOME in read-only SATYA'S DBA BLOG: UNDO TABLESPACE/UNDO MANAGEMENT IN ORACLE Until Oracle 8i, Oracle uses rollback segments to manage the undo data. Oracle9i introduced automatic undo management, which allows the dba to exert more control on how long undo information is retained, simplifies undo space management and also eliminates the complexity of managing rollback segments. Oracle strongly recommends that you use undo tablespace to manage SATYA'S DBA BLOG: DATABASE OF LIFE Make your life as deep as a database Be always as unique as a primary key Be productive as an index Take others good habits as a forei SATYA'S DBA BLOG: MYSQL MYSQLDBIMPORT COMMANDS mysqldbimport import metadata and data from files Usage: mysqldbimport --server=user:pass@host:port:socket db1.csv db2.sql db3.grid mysqldbimport utility, in MySQL, imports metadata (object definitions) and/or data, from one or more files, for one or more databases with or without GITDs enabled. mysqldbimport --version SATYA'S DBA BLOG: EMCLI ENTERPRISE MANAGER COMMAND LINE emcli -- Enterprise Manager Command Line Interface, in Oracle emcli login -username="sysman" emcli modify_target -name="pdb2" - SATYA'S DBA BLOG: SNAPSHOT STANDBY DATABASES IN ORACLE The use of snapshot standby database is in the situation where if we want to clone a production database for testing something, we can convert existing physical standby database to snapshot standby database which is as close as to the production database w.r.t data, do required testing on the snapshot standby database and convert it back to physical standby database. SATYA'S DBA BLOG: ORACLE RMAN INCREMENTAL BACKUPS Each data block in a datafile contains a system change number (SCN), which is the SCN at which the most recent change was made to the block. During an incremental backup, RMAN reads the SCN of each data block in the input file and compares it to SATYA'S DBA BLOG: ORACLE DBA INTERVIEW QUESTIONS / FAQS Oracle DBA Interview Questions/FAQs Part1 1. What is an instance? Memory/SGA + background processes . 2. What is SGA? System/Sha SATYA'S DBA BLOG: EMCTL COMMANDS EMCTL: -- Enterprise Manager Control, in Oracle EMCTL @ normal (Oracle Management) Agent emctl start agent ./emctl start SATYA'S DBA BLOG: PASSWORD FILE (ORAPWD UTILITY) IN ORACLE The Oracle orapwd utility assists the DBA while granting SYSDBA, SYSOPER, SYSASM, SYSKM, SYSDG or SYSBACKUP privileges to other users. By default, SYS is the only user that has SYSDBA and SYSOPER privileges. Creating a password file, via orapwd, enables remote users to connect with administrative privileges. SATYA'S DBA BLOG: NEW FEATURES IN ORACLE DATABASE 18C Oracle Database 18c (18.1.0, 18.2.0, 18.3.0) new features General Starting with Oracle 18c, we can configure ORACLE_HOME in read-only SATYA'S DBA BLOG: UNDO TABLESPACE/UNDO MANAGEMENT IN ORACLE Until Oracle 8i, Oracle uses rollback segments to manage the undo data. Oracle9i introduced automatic undo management, which allows the dba to exert more control on how long undo information is retained, simplifies undo space management and also eliminates the complexity of managing rollback segments. Oracle strongly recommends that you use undo tablespace to manage SATYA'S DBA BLOG: DATABASE OF LIFE Make your life as deep as a database Be always as unique as a primary key Be productive as an index Take others good habits as a forei SATYA'S DBA BLOG: MYSQL MYSQLDBIMPORT COMMANDS mysqldbimport import metadata and data from files Usage: mysqldbimport --server=user:pass@host:port:socket db1.csv db2.sql db3.grid mysqldbimport utility, in MySQL, imports metadata (object definitions) and/or data, from one or more files, for one or more databases with or without GITDs enabled. mysqldbimport --version SATYA'S DBA BLOG: EMCLI ENTERPRISE MANAGER COMMAND LINE emcli -- Enterprise Manager Command Line Interface, in Oracle emcli login -username="sysman" emcli modify_target -name="pdb2" - SATYA'S DBA BLOG: SNAPSHOT STANDBY DATABASES IN ORACLE The use of snapshot standby database is in the situation where if we want to clone a production database for testing something, we can convert existing physical standby database to snapshot standby database which is as close as to the production database w.r.t data, do required testing on the snapshot standby database and convert it back to physical standby database. SATYA'S DBA BLOG: PROFILES IN ORACLE Profiles were introduced in Oracle 8. Profiles are, set of resource limits, used to limit system resources a user can use. It allows us to regulate the amount of resources used by each database user by creating and assigning profiles to them. Whenever you create a database, one default profile will be created and assigned to all theusers you
SATYA'S DBA BLOG: AUDITING OF ORACLE DATABASE The auditing mechanism for Oracle is extremely flexible. Oracle stores information that is relevant to auditing in its data dictionary. Every time a user attempts anything in the database where audit is enabled the Oracle kernel checks to see if an audit record should be created or updated (in the case or a session record) and generates the record in a table owned by the SYS user called AUD$. SATYA'S DBA BLOG: ORACLE DATA GUARD BROKER UTILITY $ dgmgrl -logfile observer.log / "stop observer" $ dgmgrl -silent sys/test@dgprimary "show configuration verbose" SATYA'S DBA BLOG: TRANSPORTABLE TABLESPACES (TTS) IN ORACLE Oracle Database 10g Release 1 introduced cross platform transportable tablespaces (XTTS), which allows data files to be moved between platforms of different endian format. XTTS is an enhancement to the transportable tablespace (TTS). If ENDIAN formats are different we have to use RMAN (e.g. Windows to Solaris, Tru64 to AIX). SATYA'S DBA BLOG: ORACLE Oracle - Automatic Storage Management (ASM) to provide a platform for file sharing in RAC and Grid computing. Automatic Storage Management (ASM) is a new type of file system. ASM provided a foundation for highly efficient storage management with kernelized asynchronous I/O, direct I/O, redundancy, striping, and an easy way to manage storage. SATYA'S DBA BLOG: ORACLE DATA GUARD INTERVIEW QUESTIONS 1. How to setup Data Guard? 2. What are the advantages in using Oracle Data Guard? 3. What are different types of protection modes in Data Guard and which is default? Answer : Maximum performance: This is the default protection mode. SATYA'S DBA BLOG: ORACLE RMAN BASIC/ADVANCED INTERVIEW Hi Satya, You're posts are really very help full to me i need a help from you. Could you please post some more real time interview questions for RMAN,ASM and RAC. SATYA'S DBA BLOG: ORACLE RMAN INCREMENTAL BACKUPS Each data block in a datafile contains a system change number (SCN), which is the SCN at which the most recent change was made to the block. During an incremental backup, RMAN reads the SCN of each data block in the input file and compares it to SATYA'S DBA BLOG: ORACLE DBA INTERVIEW QUESTIONS / FAQS Oracle DBA Interview Questions/FAQs Part1 1. What is an instance? Memory/SGA + background processes . 2. What is SGA? System/Sha SATYA'S DBA BLOG: ORACLE FLASH/FAST RECOVERY AREA The flash recovery area is the most powerful tool available from Oracle 10g, that plays a vital role in performing database backup & recovery operations.From Oracle 11g release2, flash recovery area is called as fast recovery area. Flash Recovery Area can be defined as a single, centralized, unified storage area that keep all the database backup & recovery related files and performs those SATYA'S DBA BLOG: EMCTL COMMANDS EMCTL: -- Enterprise Manager Control, in Oracle EMCTL @ normal (Oracle Management) Agent emctl start agent ./emctl start SATYA'S DBA BLOG: UNDO TABLESPACE/UNDO MANAGEMENT IN ORACLE Until Oracle 8i, Oracle uses rollback segments to manage the undo data. Oracle9i introduced automatic undo management, which allows the dba to exert more control on how long undo information is retained, simplifies undo space management and also eliminates the complexity of managing rollback segments. Oracle strongly recommends that you use undo tablespace to manage SATYA'S DBA BLOG: DATABASE OF LIFE Make your life as deep as a database Be always as unique as a primary key Be productive as an index Take others good habits as a forei SATYA'S DBA BLOG: MYSQL MYSQLDBIMPORT COMMANDS mysqldbimport import metadata and data from files Usage: mysqldbimport --server=user:pass@host:port:socket db1.csv db2.sql db3.grid mysqldbimport utility, in MySQL, imports metadata (object definitions) and/or data, from one or more files, for one or more databases with or without GITDs enabled. mysqldbimport --version SATYA'S DBA BLOG: NEW FEATURES IN ORACLE DATABASE 18C Oracle Database 18c (18.1.0, 18.2.0, 18.3.0) new features General Starting with Oracle 18c, we can configure ORACLE_HOME in read-only SATYA'S DBA BLOG: SNAPSHOT STANDBY DATABASES IN ORACLE The use of snapshot standby database is in the situation where if we want to clone a production database for testing something, we can convert existing physical standby database to snapshot standby database which is as close as to the production database w.r.t data, do required testing on the snapshot standby database and convert it back to physical standby database. SATYA'S DBA BLOG: EMCLI ENTERPRISE MANAGER COMMAND LINE emcli -- Enterprise Manager Command Line Interface, in Oracle emcli login -username="sysman" emcli modify_target -name="pdb2" - SATYA'S DBA BLOG: ORACLE RMAN INCREMENTAL BACKUPS Each data block in a datafile contains a system change number (SCN), which is the SCN at which the most recent change was made to the block. During an incremental backup, RMAN reads the SCN of each data block in the input file and compares it to SATYA'S DBA BLOG: ORACLE DBA INTERVIEW QUESTIONS / FAQS Oracle DBA Interview Questions/FAQs Part1 1. What is an instance? Memory/SGA + background processes . 2. What is SGA? System/Sha SATYA'S DBA BLOG: ORACLE FLASH/FAST RECOVERY AREA The flash recovery area is the most powerful tool available from Oracle 10g, that plays a vital role in performing database backup & recovery operations.From Oracle 11g release2, flash recovery area is called as fast recovery area. Flash Recovery Area can be defined as a single, centralized, unified storage area that keep all the database backup & recovery related files and performs those SATYA'S DBA BLOG: EMCTL COMMANDS EMCTL: -- Enterprise Manager Control, in Oracle EMCTL @ normal (Oracle Management) Agent emctl start agent ./emctl start SATYA'S DBA BLOG: UNDO TABLESPACE/UNDO MANAGEMENT IN ORACLE Until Oracle 8i, Oracle uses rollback segments to manage the undo data. Oracle9i introduced automatic undo management, which allows the dba to exert more control on how long undo information is retained, simplifies undo space management and also eliminates the complexity of managing rollback segments. Oracle strongly recommends that you use undo tablespace to manage SATYA'S DBA BLOG: DATABASE OF LIFE Make your life as deep as a database Be always as unique as a primary key Be productive as an index Take others good habits as a forei SATYA'S DBA BLOG: MYSQL MYSQLDBIMPORT COMMANDS mysqldbimport import metadata and data from files Usage: mysqldbimport --server=user:pass@host:port:socket db1.csv db2.sql db3.grid mysqldbimport utility, in MySQL, imports metadata (object definitions) and/or data, from one or more files, for one or more databases with or without GITDs enabled. mysqldbimport --version SATYA'S DBA BLOG: NEW FEATURES IN ORACLE DATABASE 18C Oracle Database 18c (18.1.0, 18.2.0, 18.3.0) new features General Starting with Oracle 18c, we can configure ORACLE_HOME in read-only SATYA'S DBA BLOG: SNAPSHOT STANDBY DATABASES IN ORACLE The use of snapshot standby database is in the situation where if we want to clone a production database for testing something, we can convert existing physical standby database to snapshot standby database which is as close as to the production database w.r.t data, do required testing on the snapshot standby database and convert it back to physical standby database. SATYA'S DBA BLOG: EMCLI ENTERPRISE MANAGER COMMAND LINE emcli -- Enterprise Manager Command Line Interface, in Oracle emcli login -username="sysman" emcli modify_target -name="pdb2" - SATYA'S DBA BLOG: PROFILES IN ORACLE Profiles were introduced in Oracle 8. Profiles are, set of resource limits, used to limit system resources a user can use. It allows us to regulate the amount of resources used by each database user by creating and assigning profiles to them. Whenever you create a database, one default profile will be created and assigned to all theusers you
SATYA'S DBA BLOG: AUDITING OF ORACLE DATABASE The auditing mechanism for Oracle is extremely flexible. Oracle stores information that is relevant to auditing in its data dictionary. Every time a user attempts anything in the database where audit is enabled the Oracle kernel checks to see if an audit record should be created or updated (in the case or a session record) and generates the record in a table owned by the SYS user called AUD$. SATYA'S DBA BLOG: ORACLE EXPORT IMPORT (EXP & IMP) Export and Import are the Oracle utilities that allow us to make exports & imports of the data objects, and transfer the data across databases that reside on different hardware platforms on different Oracle versions. Export (exp) and import (imp) utilities are used to perform logical database backup and recovery. SATYA'S DBA BLOG: DATA PUMP EXPORT & IMPORT UTILITIES IN The following commands are valid while in interactive mode. Note: abbreviations are allowed Data Pump Export interactive mode While exporting is going on, press Control-C to go to interactive mode, it will stop the displaying of the messages on the SATYA'S DBA BLOG: ORACLE RMAN BASIC/ADVANCED INTERVIEW Hi Satya, You're posts are really very help full to me i need a help from you. Could you please post some more real time interview questions for RMAN,ASM and RAC. SATYA'S DBA BLOG: ORACLE Oracle - Automatic Storage Management (ASM) to provide a platform for file sharing in RAC and Grid computing. Automatic Storage Management (ASM) is a new type of file system. ASM provided a foundation for highly efficient storage management with kernelized asynchronous I/O, direct I/O, redundancy, striping, and an easy way to manage storage. SATYA'S DBA BLOG: TRANSPORTABLE TABLESPACES (TTS) IN ORACLE Oracle Database 10g Release 1 introduced cross platform transportable tablespaces (XTTS), which allows data files to be moved between platforms of different endian format. XTTS is an enhancement to the transportable tablespace (TTS). If ENDIAN formats are different we have to use RMAN (e.g. Windows to Solaris, Tru64 to AIX). SATYA'S DBA BLOG: ORACLE RMAN INCREMENTAL BACKUPS Each data block in a datafile contains a system change number (SCN), which is the SCN at which the most recent change was made to the block. During an incremental backup, RMAN reads the SCN of each data block in the input file and compares it to SATYA'S DBA BLOG: ORACLE DBA INTERVIEW QUESTIONS / FAQS Oracle DBA Interview Questions/FAQs Part1 1. What is an instance? Memory/SGA + background processes . 2. What is SGA? System/Sha SATYA'S DBA BLOG: ORACLE FLASH/FAST RECOVERY AREAORACLE FLASH RECOVERY AREAFLASHBACK RECOVERY ORACLEMEDIA RECOVERY ORACLEORACLE DATABASE RECOVERY SCENARIOSORACLE RECOVERORACLE RECOVERY MANAGER The flash recovery area is the most powerful tool available from Oracle 10g, that plays a vital role in performing database backup & recovery operations.From Oracle 11g release2, flash recovery area is called as fast recovery area. Flash Recovery Area can be defined as a single, centralized, unified storage area that keep all the database backup & recovery related files and performs those SATYA'S DBA BLOG: EMCTL COMMANDS EMCTL: -- Enterprise Manager Control, in Oracle EMCTL @ normal (Oracle Management) Agent emctl start agent ./emctl start SATYA'S DBA BLOG: UNDO TABLESPACE/UNDO MANAGEMENT IN ORACLE Until Oracle 8i, Oracle uses rollback segments to manage the undo data. Oracle9i introduced automatic undo management, which allows the dba to exert more control on how long undo information is retained, simplifies undo space management and also eliminates the complexity of managing rollback segments. Oracle strongly recommends that you use undo tablespace to manage SATYA'S DBA BLOG: DATABASE OF LIFE Make your life as deep as a database Be always as unique as a primary key Be productive as an index Take others good habits as a forei SATYA'S DBA BLOG: MYSQL MYSQLDBIMPORT COMMANDS mysqldbimport import metadata and data from files Usage: mysqldbimport --server=user:pass@host:port:socket db1.csv db2.sql db3.grid mysqldbimport utility, in MySQL, imports metadata (object definitions) and/or data, from one or more files, for one or more databases with or without GITDs enabled. mysqldbimport --version SATYA'S DBA BLOG: NEW FEATURES IN ORACLE DATABASE 18C Oracle Database 18c (18.1.0, 18.2.0, 18.3.0) new features General Starting with Oracle 18c, we can configure ORACLE_HOME in read-only SATYA'S DBA BLOG: SNAPSHOT STANDBY DATABASES IN ORACLE The use of snapshot standby database is in the situation where if we want to clone a production database for testing something, we can convert existing physical standby database to snapshot standby database which is as close as to the production database w.r.t data, do required testing on the snapshot standby database and convert it back to physical standby database. SATYA'S DBA BLOG: EMCLI ENTERPRISE MANAGER COMMAND LINE emcli -- Enterprise Manager Command Line Interface, in Oracle emcli login -username="sysman" emcli modify_target -name="pdb2" - SATYA'S DBA BLOG: ORACLE RMAN INCREMENTAL BACKUPS Each data block in a datafile contains a system change number (SCN), which is the SCN at which the most recent change was made to the block. During an incremental backup, RMAN reads the SCN of each data block in the input file and compares it to SATYA'S DBA BLOG: ORACLE DBA INTERVIEW QUESTIONS / FAQS Oracle DBA Interview Questions/FAQs Part1 1. What is an instance? Memory/SGA + background processes . 2. What is SGA? System/Sha SATYA'S DBA BLOG: ORACLE FLASH/FAST RECOVERY AREAORACLE FLASH RECOVERY AREAFLASHBACK RECOVERY ORACLEMEDIA RECOVERY ORACLEORACLE DATABASE RECOVERY SCENARIOSORACLE RECOVERORACLE RECOVERY MANAGER The flash recovery area is the most powerful tool available from Oracle 10g, that plays a vital role in performing database backup & recovery operations.From Oracle 11g release2, flash recovery area is called as fast recovery area. Flash Recovery Area can be defined as a single, centralized, unified storage area that keep all the database backup & recovery related files and performs those SATYA'S DBA BLOG: EMCTL COMMANDS EMCTL: -- Enterprise Manager Control, in Oracle EMCTL @ normal (Oracle Management) Agent emctl start agent ./emctl start SATYA'S DBA BLOG: UNDO TABLESPACE/UNDO MANAGEMENT IN ORACLE Until Oracle 8i, Oracle uses rollback segments to manage the undo data. Oracle9i introduced automatic undo management, which allows the dba to exert more control on how long undo information is retained, simplifies undo space management and also eliminates the complexity of managing rollback segments. Oracle strongly recommends that you use undo tablespace to manage SATYA'S DBA BLOG: DATABASE OF LIFE Make your life as deep as a database Be always as unique as a primary key Be productive as an index Take others good habits as a forei SATYA'S DBA BLOG: MYSQL MYSQLDBIMPORT COMMANDS mysqldbimport import metadata and data from files Usage: mysqldbimport --server=user:pass@host:port:socket db1.csv db2.sql db3.grid mysqldbimport utility, in MySQL, imports metadata (object definitions) and/or data, from one or more files, for one or more databases with or without GITDs enabled. mysqldbimport --version SATYA'S DBA BLOG: NEW FEATURES IN ORACLE DATABASE 18C Oracle Database 18c (18.1.0, 18.2.0, 18.3.0) new features General Starting with Oracle 18c, we can configure ORACLE_HOME in read-only SATYA'S DBA BLOG: SNAPSHOT STANDBY DATABASES IN ORACLE The use of snapshot standby database is in the situation where if we want to clone a production database for testing something, we can convert existing physical standby database to snapshot standby database which is as close as to the production database w.r.t data, do required testing on the snapshot standby database and convert it back to physical standby database. SATYA'S DBA BLOG: EMCLI ENTERPRISE MANAGER COMMAND LINE emcli -- Enterprise Manager Command Line Interface, in Oracle emcli login -username="sysman" emcli modify_target -name="pdb2" - SATYA'S DBA BLOG: PROFILES IN ORACLE Profiles were introduced in Oracle 8. Profiles are, set of resource limits, used to limit system resources a user can use. It allows us to regulate the amount of resources used by each database user by creating and assigning profiles to them. Whenever you create a database, one default profile will be created and assigned to all theusers you
SATYA'S DBA BLOG: AUDITING OF ORACLE DATABASE The auditing mechanism for Oracle is extremely flexible. Oracle stores information that is relevant to auditing in its data dictionary. Every time a user attempts anything in the database where audit is enabled the Oracle kernel checks to see if an audit record should be created or updated (in the case or a session record) and generates the record in a table owned by the SYS user called AUD$. SATYA'S DBA BLOG: ORACLE EXPORT IMPORT (EXP & IMP) Export and Import are the Oracle utilities that allow us to make exports & imports of the data objects, and transfer the data across databases that reside on different hardware platforms on different Oracle versions. Export (exp) and import (imp) utilities are used to perform logical database backup and recovery. SATYA'S DBA BLOG: DATA PUMP EXPORT & IMPORT UTILITIES IN The following commands are valid while in interactive mode. Note: abbreviations are allowed Data Pump Export interactive mode While exporting is going on, press Control-C to go to interactive mode, it will stop the displaying of the messages on the SATYA'S DBA BLOG: ORACLE RMAN BASIC/ADVANCED INTERVIEW Hi Satya, You're posts are really very help full to me i need a help from you. Could you please post some more real time interview questions for RMAN,ASM and RAC. SATYA'S DBA BLOG: ORACLE Oracle - Automatic Storage Management (ASM) to provide a platform for file sharing in RAC and Grid computing. Automatic Storage Management (ASM) is a new type of file system. ASM provided a foundation for highly efficient storage management with kernelized asynchronous I/O, direct I/O, redundancy, striping, and an easy way to manage storage. SATYA'S DBA BLOG: TRANSPORTABLE TABLESPACES (TTS) IN ORACLE Oracle Database 10g Release 1 introduced cross platform transportable tablespaces (XTTS), which allows data files to be moved between platforms of different endian format. XTTS is an enhancement to the transportable tablespace (TTS). If ENDIAN formats are different we have to use RMAN (e.g. Windows to Solaris, Tru64 to AIX). SATYA'S DBA BLOG: ORACLE RMAN INCREMENTAL BACKUPS Each data block in a datafile contains a system change number (SCN), which is the SCN at which the most recent change was made to the block. During an incremental backup, RMAN reads the SCN of each data block in the input file and compares it to SATYA'S DBA BLOG: ORACLE DBA INTERVIEW QUESTIONS / FAQS Oracle DBA Interview Questions/FAQs Part1 1. What is an instance? Memory/SGA + background processes . 2. What is SGA? System/Sha SATYA'S DBA BLOG: ORACLE FLASH/FAST RECOVERY AREAORACLE FLASH RECOVERY AREAFLASHBACK RECOVERY ORACLEMEDIA RECOVERY ORACLEORACLE DATABASE RECOVERY SCENARIOSORACLE RECOVERORACLE RECOVERY MANAGER The flash recovery area is the most powerful tool available from Oracle 10g, that plays a vital role in performing database backup & recovery operations.From Oracle 11g release2, flash recovery area is called as fast recovery area. Flash Recovery Area can be defined as a single, centralized, unified storage area that keep all the database backup & recovery related files and performs those SATYA'S DBA BLOG: EMCTL COMMANDS EMCTL: -- Enterprise Manager Control, in Oracle EMCTL @ normal (Oracle Management) Agent emctl start agent ./emctl start SATYA'S DBA BLOG: UNDO TABLESPACE/UNDO MANAGEMENT IN ORACLE Until Oracle 8i, Oracle uses rollback segments to manage the undo data. Oracle9i introduced automatic undo management, which allows the dba to exert more control on how long undo information is retained, simplifies undo space management and also eliminates the complexity of managing rollback segments. Oracle strongly recommends that you use undo tablespace to manage SATYA'S DBA BLOG: DATABASE OF LIFE Make your life as deep as a database Be always as unique as a primary key Be productive as an index Take others good habits as a forei SATYA'S DBA BLOG: MYSQL MYSQLDBIMPORT COMMANDS mysqldbimport import metadata and data from files Usage: mysqldbimport --server=user:pass@host:port:socket db1.csv db2.sql db3.grid mysqldbimport utility, in MySQL, imports metadata (object definitions) and/or data, from one or more files, for one or more databases with or without GITDs enabled. mysqldbimport --version SATYA'S DBA BLOG: NEW FEATURES IN ORACLE DATABASE 18C Oracle Database 18c (18.1.0, 18.2.0, 18.3.0) new features General Starting with Oracle 18c, we can configure ORACLE_HOME in read-only SATYA'S DBA BLOG: SNAPSHOT STANDBY DATABASES IN ORACLE The use of snapshot standby database is in the situation where if we want to clone a production database for testing something, we can convert existing physical standby database to snapshot standby database which is as close as to the production database w.r.t data, do required testing on the snapshot standby database and convert it back to physical standby database. SATYA'S DBA BLOG: EMCLI ENTERPRISE MANAGER COMMAND LINE emcli -- Enterprise Manager Command Line Interface, in Oracle emcli login -username="sysman" emcli modify_target -name="pdb2" - SATYA'S DBA BLOG: ORACLE RMAN INCREMENTAL BACKUPS Each data block in a datafile contains a system change number (SCN), which is the SCN at which the most recent change was made to the block. During an incremental backup, RMAN reads the SCN of each data block in the input file and compares it to SATYA'S DBA BLOG: ORACLE DBA INTERVIEW QUESTIONS / FAQS Oracle DBA Interview Questions/FAQs Part1 1. What is an instance? Memory/SGA + background processes . 2. What is SGA? System/Sha SATYA'S DBA BLOG: ORACLE FLASH/FAST RECOVERY AREAORACLE FLASH RECOVERY AREAFLASHBACK RECOVERY ORACLEMEDIA RECOVERY ORACLEORACLE DATABASE RECOVERY SCENARIOSORACLE RECOVERORACLE RECOVERY MANAGER The flash recovery area is the most powerful tool available from Oracle 10g, that plays a vital role in performing database backup & recovery operations.From Oracle 11g release2, flash recovery area is called as fast recovery area. Flash Recovery Area can be defined as a single, centralized, unified storage area that keep all the database backup & recovery related files and performs those SATYA'S DBA BLOG: EMCTL COMMANDS EMCTL: -- Enterprise Manager Control, in Oracle EMCTL @ normal (Oracle Management) Agent emctl start agent ./emctl start SATYA'S DBA BLOG: UNDO TABLESPACE/UNDO MANAGEMENT IN ORACLE Until Oracle 8i, Oracle uses rollback segments to manage the undo data. Oracle9i introduced automatic undo management, which allows the dba to exert more control on how long undo information is retained, simplifies undo space management and also eliminates the complexity of managing rollback segments. Oracle strongly recommends that you use undo tablespace to manage SATYA'S DBA BLOG: DATABASE OF LIFE Make your life as deep as a database Be always as unique as a primary key Be productive as an index Take others good habits as a forei SATYA'S DBA BLOG: MYSQL MYSQLDBIMPORT COMMANDS mysqldbimport import metadata and data from files Usage: mysqldbimport --server=user:pass@host:port:socket db1.csv db2.sql db3.grid mysqldbimport utility, in MySQL, imports metadata (object definitions) and/or data, from one or more files, for one or more databases with or without GITDs enabled. mysqldbimport --version SATYA'S DBA BLOG: NEW FEATURES IN ORACLE DATABASE 18C Oracle Database 18c (18.1.0, 18.2.0, 18.3.0) new features General Starting with Oracle 18c, we can configure ORACLE_HOME in read-only SATYA'S DBA BLOG: SNAPSHOT STANDBY DATABASES IN ORACLE The use of snapshot standby database is in the situation where if we want to clone a production database for testing something, we can convert existing physical standby database to snapshot standby database which is as close as to the production database w.r.t data, do required testing on the snapshot standby database and convert it back to physical standby database. SATYA'S DBA BLOG: EMCLI ENTERPRISE MANAGER COMMAND LINE emcli -- Enterprise Manager Command Line Interface, in Oracle emcli login -username="sysman" emcli modify_target -name="pdb2" - SATYA'S DBA BLOG: PROFILES IN ORACLE Profiles were introduced in Oracle 8. Profiles are, set of resource limits, used to limit system resources a user can use. It allows us to regulate the amount of resources used by each database user by creating and assigning profiles to them. Whenever you create a database, one default profile will be created and assigned to all theusers you
SATYA'S DBA BLOG: AUDITING OF ORACLE DATABASE The auditing mechanism for Oracle is extremely flexible. Oracle stores information that is relevant to auditing in its data dictionary. Every time a user attempts anything in the database where audit is enabled the Oracle kernel checks to see if an audit record should be created or updated (in the case or a session record) and generates the record in a table owned by the SYS user called AUD$. SATYA'S DBA BLOG: ORACLE EXPORT IMPORT (EXP & IMP) Export and Import are the Oracle utilities that allow us to make exports & imports of the data objects, and transfer the data across databases that reside on different hardware platforms on different Oracle versions. Export (exp) and import (imp) utilities are used to perform logical database backup and recovery. SATYA'S DBA BLOG: DATA PUMP EXPORT & IMPORT UTILITIES IN The following commands are valid while in interactive mode. Note: abbreviations are allowed Data Pump Export interactive mode While exporting is going on, press Control-C to go to interactive mode, it will stop the displaying of the messages on the SATYA'S DBA BLOG: ORACLE RMAN BASIC/ADVANCED INTERVIEW Hi Satya, You're posts are really very help full to me i need a help from you. Could you please post some more real time interview questions for RMAN,ASM and RAC. SATYA'S DBA BLOG: ORACLE Oracle - Automatic Storage Management (ASM) to provide a platform for file sharing in RAC and Grid computing. Automatic Storage Management (ASM) is a new type of file system. ASM provided a foundation for highly efficient storage management with kernelized asynchronous I/O, direct I/O, redundancy, striping, and an easy way to manage storage. SATYA'S DBA BLOG: TRANSPORTABLE TABLESPACES (TTS) IN ORACLE Oracle Database 10g Release 1 introduced cross platform transportable tablespaces (XTTS), which allows data files to be moved between platforms of different endian format. XTTS is an enhancement to the transportable tablespace (TTS). If ENDIAN formats are different we have to use RMAN (e.g. Windows to Solaris, Tru64 to AIX).Find us on Google+
Google+
SATYA'S DBA BLOG
AUGUST 11, 2019
MYSQL UTILITY MYSQLBINLOGPURGE USAGE EXAMPLES CHEATSHEET OF MYSQLBINLOGPURGE - MYSQL UTILITY * Interview question and answer* Answers
* Groups
* Job description administrative assistant-vv
mysqlbinlogpurge --master=mydba --slaves=root:root@localhost:3311,root:root@localhost:3312,root:root@localhost:3313 --binlog=mysql-bin.000033 -v mysqlbinlogpurge --server=root:root@localhost:3310 --dry-runOptions:
--version show program's version number and exit --help display a help message and exit --license display program's license and exit --server=SERVER connection information for the server in the form: user@host or login-path or config- path. --ssl-ca=SSL_CA path to a file that contains a list of trusted SSL CAs. --ssl-cert=SSL_CERT name of the SSL certificate file to use for establishing a secure connection. --ssl-key=SSL_KEY name of the SSL key file to use for establishing a secure connection. --ssl=SSL specifies if the server connection requires use of SSL. If an encrypted connection cannot be established, the connection attempt fails. By default 0 (SSL not required). -d, --dry-run run the utility without purge any binary log, instead it will print the unused binary log files. --binlog=BINLOG Binlog file name to keep (not to purge). All the binary log files prior to the specified file will be removed. --discover-slaves-login=DISCOVER at startup, query master for all registered slaves and use the user name and password specified to connect. Supply the user and password in the form user or login-path. For example, --discover-slaves-login=joe:secret will use 'joe' as the user and 'secret' as the password for each discoveredslave.
--master=MASTER connection information for master server in the form: user@host or login-path or config- path. --slaves=SLAVES connection information for slave servers in the form: user@host or login-path or config- path. List multiple slaves in comma- separated list. -v, --verbose control how much information is displayed. e.g., -v = verbose, -vv = more verbose, -vvv = debugIntroduction
------------
The mysqlbinlogpurge utility was designed to purge binary log files in a replication scenario operating in a safe manner by prohibiting deletion of binary log files that are open or which are required by a slave (have not been read by the slave). The utility verifies the latest binary log file that has been read by all the slave servers to determine the binary log files that can be deleted. Note: In order to determine the latest binary log file that has been replicated by all the slaves, they must be connected to the master at the time the utility is executed. The following are examples of use: # Purge all the binary log files prior to a specified file for astandalone
# server.
$ mysqlbinlogpurge --server=root:pass@host1:3306 --binlog=bin-log.001302 # Display the latest binary log that has been replicated by allspecified
# slaves in a replication scenario. $ mysqlbinlogpurge --master=root:pass@host2:3306 --slaves=root:pass@host3:3308,root:pass@host3:3309 --dry-run Related MySQL Articles:1 comments
Links to this post
Email This
BlogThis!
Share
to Twitter
Share
to Facebook
Share
to Pinterest
Reactions:
Older Posts
Home
Subscribe to: Posts (Atom) MYSQL ARTICLES/UTILITIES CHEATSHEETS (FOR DBAS) * Cheatsheet of MySQL utility - mysqlfrm * Cheatsheet of mysqlbinlog utility * MySQL Database Administrator Online Quiz * MySQL mysqldbexport cheatsheet * MySQL mysqldumpslow utility commands * MySQL mysqlreplicate cheatsheet * MySQL mysqlrplsync utility * MySQL mysqluserclone utility cheatsheet * MySQL utility - mysqlauditadmin * MySQL utility - mysqlauditgrep cheatsheet * MySQL utility - mysqlmetagrep * MySQL utility mysqlprocgrep cheatsheet * mysql utility/commands * mysql_config_editor commands * mysql_install_db utility commands in MySQL * mysqladmin commands * mysqlcheck utility commands * mysqld_multi utility examples * mysqldbcompare utility * mysqldbcopy commands cheatsheet * mysqldbimport utility in MariaDB/MySQL/Aurora * mysqldiff utility in MySQL * mysqldiskusage utility * mysqldump commands * mysqlfailover commands in MySQL * mysqlimport commands * mysqlindexcheck utility commands in MySQL * mysqlrpladmin utility commands * mysqlrplcheck replication check utility * mysqlrplms utility in MySQL * mysqlrplshow utility commands in MySQL * mysqlserverclone utility commands * mysqlserverinfo commands list * mysqlshow utility commands * mysqlslap in Aurora/MySQL/MariaDB ORACLE DBA INTERVIEW QUESTIONS AND ANSWERS * OGG (Oracle GoldenGate) Interview Questions Part2 * Oracle AppsDBA (E-Business Suite) Interview Questions/FAQs * Oracle ASM Interview Questions/FAQs * Oracle Data Base Administrator Interview Questions/FAQs – Part3 * Oracle Data Guard Interview Questions/FAQs * Oracle Database Admin Interview Questions/FAQs – Part1 * Oracle DataBase Administrator Interview Questions/FAQs – Part2 * Oracle DBA interview questions - Part 5 * Oracle DBA interview questions answers * Oracle DBA Interview Questions/FAQs – Part4 * Oracle DBA Online Quiz Questions/Answers * Oracle Exadata Interview Questions/FAQs * Oracle Export/Import - Data Pump Interview Questions/FAQs * Oracle GoldenGate (OGG) Interview Questions/FAQs Part1 * Oracle Performance related interview Questions/FAQs * Oracle PL/SQL Interview Questions/FAQs * Oracle RAC Interview Questions/FAQs * Oracle RMAN Interview Questions/FAQs * UNIX Interview Questions/FAQs for Oracle DBAsTRANSLATOR
Select Language▼MY ARTICLES
* * Bits n Bytes
* * Database of Life * * Databases in the world * * First day in Job (at IDRBT) * ADRCI Commands in Oracle* ASM
* asmcmd in Oracle 11g * asmcmd in oracle 12c * Auditing in Oracle * Background Processes in Oracle * Block Change Tracking file * Data Dictionary Views * Data Pump Export Import * Data Pump in Oracle * DataDictionary views Vs V$ views* dgmgrl utility
* emca commands
* emcli commands
* emctl commands (OEM) * Export and Import (exp & imp) * Flash/Fast Recovery Area (FRA)* Flashback
* Flashback Query
* ggsci - Oracle GoldenGate * Golden Gate LogDump Utility Commands * Indexes on Oracle Partitions * Logical Standby Databases* lsnrctl commands
* Managing Oracle Partitions * Materialized View Logs * Materialized View Types * Materialized Views * Materialized Views Refresh Groups * NID Utility (DBNEWID Utility)* omsca utility
* opatchauto Tool
* orachk utility
* Oracle 12C
* Oracle Certifications (for DBAs)* Oracle Solaris 11
* oracleasm
* ORADEBUG tool
* Partitioning in Oracle * Password file (orapwd utility) * Physical Standby Databases * Profiles in Oracle * Recycle bin in Oracle * Remote Diagnostic Agent (RDA) * RMAN (Recovery Manager)* RMAN Commands
* RMAN Incremental Backups* Rollback Segments
* Setting SQL prompt * Snapshot Standby Databases* SQL*Loader
* Startup/Shutdown Options * Statistics in Oracle * Statspack in Oracle * Temporary Tablespace * Temporary Tablespace Group * Test Your Oracle DBA Skills * Transportable Tablespaces (TTS) * Undo Tablespace/Management * Wait events in Oracle Database * What's New in Oracle 10g Release 1/2 * What's New in Oracle 11g Release 1 * What's New in Oracle 11g Release 2 * What's New in Oracle 12c Release 1 * What's New in Oracle 12c Release 2 * What's New in Oracle 18c Release 1 * What's New in Oracle 19c Release 1 * What's New in Oracle 9i Release 1/2POPULAR POSTS
* Password file (orapwd utility) in Oracle * Temporary Tablespace in Oracle* Oracle Statistics
* Oracle Export Import (exp & imp) * Auditing of Oracle Database * Oracle - Automatic Storage Management (ASM)FOLLOWERS
FOLLOW BY EMAIL
VISITOR COUNT (SINCE JAN 2019)LABELS
* Database of Life * (1) * Databases in the world *(1) 12.1.0 (1)
12.2.0 (1) ADRCI
Commands in Oracle
(1) ASM (5) asmcmd
(2) Auditing in
Oracle
(1) Background Processes(1) Bits n Bytes
(1)
Block Change Tracking file (1) Data Dictionary Views (1) Data Pump expdp impdp (1) Data Pump Export Import (1) Database Administrator (3) DataDictionary views Vs V$ views (1) DBA Interview Questions (Part2) (1) DBA Interview Questions (Part3) (1) DBMS_STATS - Statistics(1) dgmgrl utility
(1)
emca commands
(1)
emcli commands
(1)
emctl commands
(1) exp
& imp in Oracle
(1) Export and Import (1) Export/Import - Data Pump Interview Questions (1) Flash Recovery Area (FRA)(1) Flashback
(1) Flashback Query
(1)
ggsci (1) Indexes
on Partitions
(1) Logical Standby Databases (1) Managing Oracle partitions (1) Materialized View Log (1) Materialized View Types (1) Materialized Views(1)
Materialized Views Refresh Groups(1) MySQL (9)
mysql commands
(1)
MySQL DBA Interview Questions And Answers (1) MySQL DBA Mock Test (1) MySQL DBA Online Quiz (1) MySQL Quiz Questions and answers(1) MySQL Tools
(10) MySQL
utilities
(7)
MySQL utility
(10)
mysql_config_editor commands (1) mysql_install_db utility usage (1) mysqladmin commands (1) mysqlauditadmin Utility cheatsheet (1) mysqlauditgrep commands (1) mysqlbinlog commands (1) mysqlbinlogpurge commands (1) mysqlcheck commands (1) mysqld_multi utility commands (1) mysqldbcompare commands (1) mysqldbcopy utility cheatsheet (1) mysqldbexport commands cheatsheet (1) mysqldbimport usage (1) mysqldiff commands(1)
mysqldiskusage utility (1) mysqldump commands(1)
mysqldumpslow utility commands (1) mysqlfailover utility commands (1) mysqlfrm utility examples (1) mysqlimport commands (1) mysqlindexcheck utility in MySQL (1) mysqlmetagrep utility (1) mysqlprocgrep utility (1) mysqlreplicate commands (1) mysqlrpladmin utility commands (1) mysqlrplcheck utility (1) mysqlrplms utility in MySQL (1) mysqlrplshow utility commands (1) mysqlrplsync utility (1) mysqlserverclone utility (1) mysqlserverinfo utility (1) mysqlshow commands(1)
mysqlslap utility
(1)
mysqluserclone example commands (1) New features in Oracle Database 18c (1) NID Utility (DBNEWID Utility)(1) omsca commands
(1)
opatchauto
(1) orachk utility in Oracle(1) Oracle 12c
(2) Oracle
ASM library (ASMLib) (1) Oracle Automatic Storage Management (1) Oracle Certifications (for DBAs) (1) Oracle Data Guard Interview Questions (1) Oracle Data Guard Manager Utility (1) Oracle Database 19c new features (1) Oracle Database Administrator (1) Oracle Database Adminstrator (1) Oracle Database Auditing(1) Oracle DBA
(3) Oracle
DBA ASM Interview Questions (1) Oracle DBA Interview Questions (4) Oracle DBA Interview Questions (Part1) (1) Oracle DBA Interview Questions And Answers (2) Oracle DBA Mock Test (1) Oracle DBA Online Quiz (1) Oracle DBA Quiz answers (1) Oracle DBA Quiz Questions (1) Oracle Golden Gate (OGG) (4) Oracle GoldenGate Interview Questions (1) Oracle GoldenGate LogDump Utility (1) Oracle lsnrctl commands (1) Oracle Password file orapwd utility (1) Oracle RMAN (Recovery Manager) (1) Oracle Snapshot Standby Databases (1) Oracle Solaris 11 (1) Oracle SQL*Loader(1)
oracleasm (1)
ORADEBUG Utility
(1)
Partitioning
(1)
Password file (orapwd) (1) Performance related interview Questions (1) Physical Standby Databases (1) PL/SQL Interview Questions(1) Profiles
(1) Recycle bin
(1)
Release 1
(1) Release 2
(1) Remote
Diagnostic Agent (RDA) (1) RMAN (Recovery Manager)(4) RMAN Commands
(1) RMAN
Incremental Backups
(1) RMAN Interview Questions (1) Rollback Segments(1)
Setting SQL prompt
(1) Solaris Interview Questions (1) Startup/Shutdown Options(1) Statspack
(1) Temp file
(1)
Temporary Tablespace (1) Temporary Tablespace Group (1) Test Your MySQL DBA Skills (1) Test Your Oracle DBA Skills (1) Transportable Tablespaces (TTS) (1) Undo Tablespace/Management (1) UNIX Interview Questions for Oracle DBAs (1) wait events in Oracle (1) What's New in 10g Release 1/2 (1) What's New in 11g Release 1 (1) What's New in 11g Release 2 (1) What's New in 9i Release 1/2 (1) What's New in Oracle 12c (2) What's new in Oracle 18c(1)
Simple theme. Powered by Blogger .ORIGINAL TEXT
Contribute a better translation ------------------------- Up to 30% off Ballard Designs Furniture stores and home decor. It’s Ballard!Button (3)
ballarddesigns.com
Infolinks Embraces Emerging Publishers Provides advertising income to emerging websitesButton (3)
www.adotas.com
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0