Are you over 18 and want to see adult content?
More Annotations
A complete backup of https://autodesk.com
Are you over 18 and want to see adult content?
A complete backup of https://historiageneral.com
Are you over 18 and want to see adult content?
A complete backup of https://bogwv.biz
Are you over 18 and want to see adult content?
A complete backup of https://elkgroveparks.org
Are you over 18 and want to see adult content?
A complete backup of https://nashvilleclerk.com
Are you over 18 and want to see adult content?
A complete backup of https://yslhandbags.us
Are you over 18 and want to see adult content?
A complete backup of https://activistfacts.com
Are you over 18 and want to see adult content?
A complete backup of https://krusch.com
Are you over 18 and want to see adult content?
A complete backup of https://go2redstag.com
Are you over 18 and want to see adult content?
A complete backup of https://usaorderessayuk.com
Are you over 18 and want to see adult content?
A complete backup of https://casaviva.es
Are you over 18 and want to see adult content?
A complete backup of https://wishfulthinking.co.uk
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of photographypla.net
Are you over 18 and want to see adult content?
A complete backup of nuancecommunications.sharepoint.com
Are you over 18 and want to see adult content?
A complete backup of activetrainingworld.co.uk
Are you over 18 and want to see adult content?
A complete backup of toutsurlesfemmes.com
Are you over 18 and want to see adult content?
A complete backup of marialuciariccioli.wordpress.com
Are you over 18 and want to see adult content?
A complete backup of portalmadura.com
Are you over 18 and want to see adult content?
A complete backup of nutzfahrzeuge-aussenspiegel.de
Are you over 18 and want to see adult content?
Text
applied on Standby
PG_DUMP: QUERY WAS: LOCK TABLE Recover archive gaps in standby database - using 2 methodss. Gap Resolution in Dataguard. Convert Physical Standby to Snapshot Standby and Vice Versa. Re-create Redo-logs on Standby/ Primary. Pre-check for DataGuard switchover Process. ORA-19815: WARNING: db_recovery_file_dest_size. ORACLE DATA GUARD (STANDBY DB USING DUPLICATE COMMAND Datagurad, active standby, ORA-16139 ORA-01111 ORA-01110 ORA-16139 SWITCHOVER_STATUS database_role ORA-12514: TNS:listener does not currently know of service requested in connect descriptor , ORA-12154: TNS:could not resolve the connect identifier specified , (UR = A) ORA-12528: TNS:listener , !rman, RMAN , DBA , DUPLICATE command ,db_unique_name
TROUBLESHOOTING ISSUES WITH UNDO TABLESPACE Commonly seen problems with the undo tablespace are of the following nature: These errors can be caused by many different issues, such as incorrect sizing of the undo tablespace or poorly written SQL or PL/SQL code. • ORA-01555: snapshot too old. • ORA-30036: unable to extend segment by in undo tablespace 'UNDO1'.DATAPUMP SCENARIOS
FILESIZE parameter is used to limit the dumpfile size. For eg., if you want to limit your dumpfiles to 5gb, you can issue command as below. $ expdp / directory=dir1 dumpfile=test_%U.dmp logfile=test.log filesize=5120m full=y. where %U will assign numbers automatically from1 to 99.
20 ASM REALTIME
ASM interview DBA, Oracle DBA interiew questions 3+ Experience oracle DBA interview RAC interview questions DISKS OPERATIONS IN ASM ASM rebalance a disk group automatically, whenever we add or remove disks form disk group. · Disk groups can be rebalanced manually usingthe
DEADLOCK (PRACTICAL) * ERROR at line 1: ORA-00060: deadlock detected while waiting forresource
ORA-01565: ERROR IN IDENTIFYING FILE /DBS/SPFILE@.ORA ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 A LIFE LONG LEARNING EXPERIENCE First, there are memory (buffer) related parameters. There are two memory-related parameters. These parameters specify the size of the memory area that buffers the data, as it says "buffer related". Since the database handles a lot of disk I / O, it is very important for performance to use the buffer mechanism well. HOW TO FIND OUT , WHO / WHAT IS USING YOUR UNDO SPACE Recover archive gaps in standby database - using 2 methodss. Gap Resolution in Dataguard. Convert Physical Standby to Snapshot Standby and Vice Versa. Re-create Redo-logs on Standby/ Primary. Pre-check for DataGuard switchover Process. ORA-19815: WARNING: db_recovery_file_dest_size. How do you purge old archivelogs which areapplied on Standby
PG_DUMP: QUERY WAS: LOCK TABLE Recover archive gaps in standby database - using 2 methodss. Gap Resolution in Dataguard. Convert Physical Standby to Snapshot Standby and Vice Versa. Re-create Redo-logs on Standby/ Primary. Pre-check for DataGuard switchover Process. ORA-19815: WARNING: db_recovery_file_dest_size. ORACLE DATA GUARD (STANDBY DB USING DUPLICATE COMMAND Datagurad, active standby, ORA-16139 ORA-01111 ORA-01110 ORA-16139 SWITCHOVER_STATUS database_role ORA-12514: TNS:listener does not currently know of service requested in connect descriptor , ORA-12154: TNS:could not resolve the connect identifier specified , (UR = A) ORA-12528: TNS:listener , !rman, RMAN , DBA , DUPLICATE command ,db_unique_name
TROUBLESHOOTING ISSUES WITH UNDO TABLESPACE Commonly seen problems with the undo tablespace are of the following nature: These errors can be caused by many different issues, such as incorrect sizing of the undo tablespace or poorly written SQL or PL/SQL code. • ORA-01555: snapshot too old. • ORA-30036: unable to extend segment by in undo tablespace 'UNDO1'.DATAPUMP SCENARIOS
FILESIZE parameter is used to limit the dumpfile size. For eg., if you want to limit your dumpfiles to 5gb, you can issue command as below. $ expdp / directory=dir1 dumpfile=test_%U.dmp logfile=test.log filesize=5120m full=y. where %U will assign numbers automatically from1 to 99.
20 ASM REALTIME
ASM interview DBA, Oracle DBA interiew questions 3+ Experience oracle DBA interview RAC interview questions DISKS OPERATIONS IN ASM ASM rebalance a disk group automatically, whenever we add or remove disks form disk group. · Disk groups can be rebalanced manually usingthe
A LIFE LONG LEARNING EXPERIENCE First, there are memory (buffer) related parameters. There are two memory-related parameters. These parameters specify the size of the memory area that buffers the data, as it says "buffer related". Since the database handles a lot of disk I / O, it is very important for performance to use the buffer mechanism well. INITIALISE MULTIPLE POSTGRES INSTANCE ON SAME RHEL SERVER Initialise multiple postgres instance on same server RHEL server > WARNING: could not create listen socket for "localhost" > FATAL: could not create any TCP/IP sockets ORACLE BLOCK CHANGE TRACKING 3) To Reset the location of Block change tracking file. There are two options for this. 1. shutdown the database and set the new location. SQL> shutdown database. --Now Move BCT file to new location using OS command ‘mv’. SQL> startup mount. SQL> WHAT IS "BUFFER BUSY WAIT " Definition : When two or more session issue the same query/related query (that access the same database blocks), the few sessions will read the data from database buffer cache (based in inittrans and maxtrans in block level) while other sessions are in AWR - AUTOMATIC WORKLOAD REPOSITORY :: BEGINNERS GUIDE Automatic Workload Repository (AWR) serves as a repository where it collects , processes and maintains performance statistics for problem detection & self-tuning purposes. The AWR is used to collect performance statistics including: Wait events used to identify performance problems. REDUNDANCY AND RECOVERY WINDOW IN RMAN Redundancy and Recovery window in RMAN. There is two mutually exclusive options for setting a retention policy; redundancy and recovery window. To set Recovery Window of 3 days, RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS; Whenever retention policy is set to recovery window of 3 days then rman retains all information and backup PRE-CHECK FOR DATAGUARD SWITCHOVER PROCESS Pre-check for DataGuard switchover Process. Please perform these pre-requisite checks before undertaking a switchover to primary. Then do not proceed if this message is received in this case you are most probably on the primary site.. While functioning as a STANDBY, it is better to set log_archive_dest_state_2 to DEFER to avoid errors PRE-CHECK FOR SWITCHOVER USING DG BROKER Pre-check For SWITCHOVER using DG Broker, Swithchover, RMAN, DGMGRL, Standby database, Pre-check For SWITCHOVER using DG Broker DG broker, DBA, oracle, ASM , Pre-check For SWITCHOVER using DG Broker ORA-01274 : RENAME THE UNKNOW FILE IN THE STANDBY … ORA-01274 : RENAME THE UNKNOW FILE IN THE STANDBY DATABASE, ORA-01274 : ORA-01274 : ORA-01274 : ORA-01274 : ORA-01274 : ORA-01274 : ORA-01274 : ORA-01274 : ORA-01274 ORA-19815: WARNING: DB_RECOVERY_FILE_DEST_SIZE OF 11646 ORA-19815: WARNING: db_recovery_file_dest_size of 11646 bytes is 100.00% used, and has 0 remain PG_DUMP: QUERY WAS: LOCK TABLE Recover archive gaps in standby database - using 2 methodss. Gap Resolution in Dataguard. Convert Physical Standby to Snapshot Standby and Vice Versa. Re-create Redo-logs on Standby/ Primary. Pre-check for DataGuard switchover Process. ORA-19815: WARNING: db_recovery_file_dest_size.DATAPUMP SCENARIOS
FILESIZE parameter is used to limit the dumpfile size. For eg., if you want to limit your dumpfiles to 5gb, you can issue command as below. $ expdp / directory=dir1 dumpfile=test_%U.dmp logfile=test.log filesize=5120m full=y. where %U will assign numbers automatically from1 to 99.
TROUBLESHOOTING ISSUES WITH UNDO TABLESPACE Commonly seen problems with the undo tablespace are of the following nature: These errors can be caused by many different issues, such as incorrect sizing of the undo tablespace or poorly written SQL or PL/SQL code. • ORA-01555: snapshot too old. • ORA-30036: unable to extend segment by in undo tablespace 'UNDO1'. ORACLE DATA GUARD (STANDBY DB USING DUPLICATE COMMAND Datagurad, active standby, ORA-16139 ORA-01111 ORA-01110 ORA-16139 SWITCHOVER_STATUS database_role ORA-12514: TNS:listener does not currently know of service requested in connect descriptor , ORA-12154: TNS:could not resolve the connect identifier specified , (UR = A) ORA-12528: TNS:listener , !rman, RMAN , DBA , DUPLICATE command ,db_unique_name
FATAL: REQUESTED TIMELINE 3 IS NOT A CHILD OF THIS SERVER FATAL: requested timeline 3 is not a child of this server's history Latest checkpoint is at 0/6A000024 on timeline 2, but in the history of the requested timeline, the server forked off from that timeline at0/690000C0.
AWR - AUTOMATIC WORKLOAD REPOSITORY :: BEGINNERS GUIDE Automatic Workload Repository (AWR) serves as a repository where it collects , processes and maintains performance statistics for problem detection & self-tuning purposes. The AWR is used to collect performance statistics including: Wait events used to identify performance problems. ORACLE BLOCK CHANGE TRACKING 3) To Reset the location of Block change tracking file. There are two options for this. 1. shutdown the database and set the new location. SQL> shutdown database. --Now Move BCT file to new location using OS command ‘mv’. SQL> startup mount. SQL> WHAT IS "BUFFER BUSY WAIT " Definition : When two or more session issue the same query/related query (that access the same database blocks), the few sessions will read the data from database buffer cache (based in inittrans and maxtrans in block level) while other sessions are in ORA-01565: ERROR IN IDENTIFYING FILE /DBS/SPFILE@.ORA ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 REDUNDANCY AND RECOVERY WINDOW IN RMAN Redundancy and Recovery window in RMAN. There is two mutually exclusive options for setting a retention policy; redundancy and recovery window. To set Recovery Window of 3 days, RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS; Whenever retention policy is set to recovery window of 3 days then rman retains all information and backup PG_DUMP: QUERY WAS: LOCK TABLE Recover archive gaps in standby database - using 2 methodss. Gap Resolution in Dataguard. Convert Physical Standby to Snapshot Standby and Vice Versa. Re-create Redo-logs on Standby/ Primary. Pre-check for DataGuard switchover Process. ORA-19815: WARNING: db_recovery_file_dest_size.DATAPUMP SCENARIOS
FILESIZE parameter is used to limit the dumpfile size. For eg., if you want to limit your dumpfiles to 5gb, you can issue command as below. $ expdp / directory=dir1 dumpfile=test_%U.dmp logfile=test.log filesize=5120m full=y. where %U will assign numbers automatically from1 to 99.
TROUBLESHOOTING ISSUES WITH UNDO TABLESPACE Commonly seen problems with the undo tablespace are of the following nature: These errors can be caused by many different issues, such as incorrect sizing of the undo tablespace or poorly written SQL or PL/SQL code. • ORA-01555: snapshot too old. • ORA-30036: unable to extend segment by in undo tablespace 'UNDO1'. ORACLE DATA GUARD (STANDBY DB USING DUPLICATE COMMAND Datagurad, active standby, ORA-16139 ORA-01111 ORA-01110 ORA-16139 SWITCHOVER_STATUS database_role ORA-12514: TNS:listener does not currently know of service requested in connect descriptor , ORA-12154: TNS:could not resolve the connect identifier specified , (UR = A) ORA-12528: TNS:listener , !rman, RMAN , DBA , DUPLICATE command ,db_unique_name
FATAL: REQUESTED TIMELINE 3 IS NOT A CHILD OF THIS SERVER FATAL: requested timeline 3 is not a child of this server's history Latest checkpoint is at 0/6A000024 on timeline 2, but in the history of the requested timeline, the server forked off from that timeline at0/690000C0.
AWR - AUTOMATIC WORKLOAD REPOSITORY :: BEGINNERS GUIDE Automatic Workload Repository (AWR) serves as a repository where it collects , processes and maintains performance statistics for problem detection & self-tuning purposes. The AWR is used to collect performance statistics including: Wait events used to identify performance problems. ORACLE BLOCK CHANGE TRACKING 3) To Reset the location of Block change tracking file. There are two options for this. 1. shutdown the database and set the new location. SQL> shutdown database. --Now Move BCT file to new location using OS command ‘mv’. SQL> startup mount. SQL> WHAT IS "BUFFER BUSY WAIT " Definition : When two or more session issue the same query/related query (that access the same database blocks), the few sessions will read the data from database buffer cache (based in inittrans and maxtrans in block level) while other sessions are in ORA-01565: ERROR IN IDENTIFYING FILE /DBS/SPFILE@.ORA ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 REDUNDANCY AND RECOVERY WINDOW IN RMAN Redundancy and Recovery window in RMAN. There is two mutually exclusive options for setting a retention policy; redundancy and recovery window. To set Recovery Window of 3 days, RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS; Whenever retention policy is set to recovery window of 3 days then rman retains all information and backup A LIFE LONG LEARNING EXPERIENCE First, there are memory (buffer) related parameters. There are two memory-related parameters. These parameters specify the size of the memory area that buffers the data, as it says "buffer related". Since the database handles a lot of disk I / O, it is very important for performance to use the buffer mechanism well. DATABASE CREATION IN EASY 6 STEPS Wonted thingie.. A techie, from a reputed company, who keeps worrying about the tweaking the sqls and Optimizer parameters, weekend maintenances, upgrades, support, and what not a FATAL: REQUESTED TIMELINE 3 IS NOT A CHILD OF THIS SERVER FATAL: requested timeline 3 is not a child of this server's history Latest checkpoint is at 0/6A000024 on timeline 2, but in the history of the requested timeline, the server forked off from that timeline at0/690000C0.
20 ASM REALTIME
Wonted thingie.. A techie, from a reputed company, who keeps worrying about the tweaking the sqls and Optimizer parameters, weekend maintenances, upgrades, support, and what not a SERVER MAINTENANCE TASKS FOR A DBA Following steps mandatory just take backup of following three steps and store it in separate notepad. Once the server reboot activity completed.. then cross check once which was taken before server reboot. $ ps -ef|grep pmon. $ ps -ef|grep pmon|wc -l. $ ps -ef|grep inh (OR) ps -ef|grep tns. $ ps AWR - AUTOMATIC WORKLOAD REPOSITORY :: BEGINNERS GUIDE Automatic Workload Repository (AWR) serves as a repository where it collects , processes and maintains performance statistics for problem detection & self-tuning purposes. The AWR is used to collect performance statistics including: Wait events used to identify performance problems. PRE-CHECK FOR DATAGUARD SWITCHOVER PROCESS Pre-check for DataGuard switchover Process. Please perform these pre-requisite checks before undertaking a switchover to primary. Then do not proceed if this message is received in this case you are most probably on the primary site.. While functioning as a STANDBY, it is better to set log_archive_dest_state_2 to DEFER to avoid errors PRE-CHECK FOR SWITCHOVER USING DG BROKER Pre-check For SWITCHOVER using DG Broker, Swithchover, RMAN, DGMGRL, Standby database, Pre-check For SWITCHOVER using DG Broker DG broker, DBA, oracle, ASM , Pre-check For SWITCHOVER using DG Broker REDUNDANCY AND RECOVERY WINDOW IN RMAN Redundancy and Recovery window in RMAN. There is two mutually exclusive options for setting a retention policy; redundancy and recovery window. To set Recovery Window of 3 days, RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS; Whenever retention policy is set to recovery window of 3 days then rman retains all information and backup ORA-19815: WARNING: DB_RECOVERY_FILE_DEST_SIZE OF 11646 ORA-19815: WARNING: db_recovery_file_dest_size of 11646 bytes is 100.00% used, and has 0 remainDATAPUMP SCENARIOS
FILESIZE parameter is used to limit the dumpfile size. For eg., if you want to limit your dumpfiles to 5gb, you can issue command as below. $ expdp / directory=dir1 dumpfile=test_%U.dmp logfile=test.log filesize=5120m full=y. where %U will assign numbers automatically from1 to 99.
TROUBLESHOOTING ISSUES WITH UNDO TABLESPACE Commonly seen problems with the undo tablespace are of the following nature: These errors can be caused by many different issues, such as incorrect sizing of the undo tablespace or poorly written SQL or PL/SQL code. • ORA-01555: snapshot too old. • ORA-30036: unable to extend segment by in undo tablespace 'UNDO1'. ORACLE DATA GUARD (STANDBY DB USING DUPLICATE COMMAND Datagurad, active standby, ORA-16139 ORA-01111 ORA-01110 ORA-16139 SWITCHOVER_STATUS database_role ORA-12514: TNS:listener does not currently know of service requested in connect descriptor , ORA-12154: TNS:could not resolve the connect identifier specified , (UR = A) ORA-12528: TNS:listener , !rman, RMAN , DBA , DUPLICATE command ,db_unique_name
FATAL: REQUESTED TIMELINE 3 IS NOT A CHILD OF THIS SERVER FATAL: requested timeline 3 is not a child of this server's history Latest checkpoint is at 0/6A000024 on timeline 2, but in the history of the requested timeline, the server forked off from that timeline at0/690000C0.
AWR - AUTOMATIC WORKLOAD REPOSITORY :: BEGINNERS GUIDE Automatic Workload Repository (AWR) serves as a repository where it collects , processes and maintains performance statistics for problem detection & self-tuning purposes. The AWR is used to collect performance statistics including: Wait events used to identify performance problems. ORACLE BLOCK CHANGE TRACKING 3) To Reset the location of Block change tracking file. There are two options for this. 1. shutdown the database and set the new location. SQL> shutdown database. --Now Move BCT file to new location using OS command ‘mv’. SQL> startup mount. SQL> LINUX IMPORTANT FILES AND DESCRIPTION A place for Beginners and Experienced to Learn Oracle and Postgres DBA. A smarter way to learn Oracle and PostgreSQL DatabaseAdministration..
DEADLOCK (PRACTICAL) * ERROR at line 1: ORA-00060: deadlock detected while waiting forresource
WHAT IS "BUFFER BUSY WAIT " Definition : When two or more session issue the same query/related query (that access the same database blocks), the few sessions will read the data from database buffer cache (based in inittrans and maxtrans in block level) while other sessions are in ORA-01565: ERROR IN IDENTIFYING FILE /DBS/SPFILE@.ORA ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037DATAPUMP SCENARIOS
FILESIZE parameter is used to limit the dumpfile size. For eg., if you want to limit your dumpfiles to 5gb, you can issue command as below. $ expdp / directory=dir1 dumpfile=test_%U.dmp logfile=test.log filesize=5120m full=y. where %U will assign numbers automatically from1 to 99.
TROUBLESHOOTING ISSUES WITH UNDO TABLESPACE Commonly seen problems with the undo tablespace are of the following nature: These errors can be caused by many different issues, such as incorrect sizing of the undo tablespace or poorly written SQL or PL/SQL code. • ORA-01555: snapshot too old. • ORA-30036: unable to extend segment by in undo tablespace 'UNDO1'. ORACLE DATA GUARD (STANDBY DB USING DUPLICATE COMMAND Datagurad, active standby, ORA-16139 ORA-01111 ORA-01110 ORA-16139 SWITCHOVER_STATUS database_role ORA-12514: TNS:listener does not currently know of service requested in connect descriptor , ORA-12154: TNS:could not resolve the connect identifier specified , (UR = A) ORA-12528: TNS:listener , !rman, RMAN , DBA , DUPLICATE command ,db_unique_name
FATAL: REQUESTED TIMELINE 3 IS NOT A CHILD OF THIS SERVER FATAL: requested timeline 3 is not a child of this server's history Latest checkpoint is at 0/6A000024 on timeline 2, but in the history of the requested timeline, the server forked off from that timeline at0/690000C0.
AWR - AUTOMATIC WORKLOAD REPOSITORY :: BEGINNERS GUIDE Automatic Workload Repository (AWR) serves as a repository where it collects , processes and maintains performance statistics for problem detection & self-tuning purposes. The AWR is used to collect performance statistics including: Wait events used to identify performance problems. ORACLE BLOCK CHANGE TRACKING 3) To Reset the location of Block change tracking file. There are two options for this. 1. shutdown the database and set the new location. SQL> shutdown database. --Now Move BCT file to new location using OS command ‘mv’. SQL> startup mount. SQL> LINUX IMPORTANT FILES AND DESCRIPTION A place for Beginners and Experienced to Learn Oracle and Postgres DBA. A smarter way to learn Oracle and PostgreSQL DatabaseAdministration..
DEADLOCK (PRACTICAL) * ERROR at line 1: ORA-00060: deadlock detected while waiting forresource
WHAT IS "BUFFER BUSY WAIT " Definition : When two or more session issue the same query/related query (that access the same database blocks), the few sessions will read the data from database buffer cache (based in inittrans and maxtrans in block level) while other sessions are in ORA-01565: ERROR IN IDENTIFYING FILE /DBS/SPFILE@.ORA ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 , ORA-01565 , ORA-27037 A LIFE LONG LEARNING EXPERIENCE First, there are memory (buffer) related parameters. There are two memory-related parameters. These parameters specify the size of the memory area that buffers the data, as it says "buffer related". Since the database handles a lot of disk I / O, it is very important for performance to use the buffer mechanism well. DATABASE CREATION IN EASY 6 STEPS Wonted thingie.. A techie, from a reputed company, who keeps worrying about the tweaking the sqls and Optimizer parameters, weekend maintenances, upgrades, support, and what not a DISKS OPERATIONS IN ASM Wonted thingie.. A techie, from a reputed company, who keeps worrying about the tweaking the sqls and Optimizer parameters, weekend maintenances, upgrades, support, and what not a HOW TO RECOVER DATABASE IF SYSTEM DATAFILE LOST USING RMAN Wonted thingie.. A techie, from a reputed company, who keeps worrying about the tweaking the sqls and Optimizer parameters, weekend maintenances, upgrades, support, and what not a SERVER MAINTENANCE TASKS FOR A DBA Following steps mandatory just take backup of following three steps and store it in separate notepad. Once the server reboot activity completed.. then cross check once which was taken before server reboot. $ ps -ef|grep pmon. $ ps -ef|grep pmon|wc -l. $ ps -ef|grep inh (OR) ps -ef|grep tns. $ ps WHAT IS "BUFFER BUSY WAIT " Definition : When two or more session issue the same query/related query (that access the same database blocks), the few sessions will read the data from database buffer cache (based in inittrans and maxtrans in block level) while other sessions are in LEARN DBA : A LIFE LONG LEARNING EXPERIENCE: TUNING A place for Beginners and Experienced to Learn Oracle and Postgres DBA. A smarter way to learn Oracle and PostgreSQL DatabaseAdministration..
REDUNDANCY AND RECOVERY WINDOW IN RMAN Redundancy and Recovery window in RMAN. There is two mutually exclusive options for setting a retention policy; redundancy and recovery window. To set Recovery Window of 3 days, RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS; Whenever retention policy is set to recovery window of 3 days then rman retains all information and backup INTERVIEW QUSTIONS FOR 2+ YEAR EXPERIENCED CANDIDATES A place for Beginners and Experienced to Learn Oracle and Postgres DBA. A smarter way to learn Oracle and PostgreSQL DatabaseAdministration..
ORA-01274 : RENAME THE UNKNOW FILE IN THE STANDBY … ORA-01274 : RENAME THE UNKNOW FILE IN THE STANDBY DATABASE, ORA-01274 : ORA-01274 : ORA-01274 : ORA-01274 : ORA-01274 : ORA-01274 : ORA-01274 : ORA-01274 : ORA-01274 LEARN DBA : A LIFE LONG LEARNING EXPERIENCE Sharing knowledge is ultimate key to gaining knowledge… The only two things that stay with you for life are you & your knowledge...* ASM
* Core DBA
* DBA Interview
* DataGuard
* Frequently Asked
* How To..
* Logminer
* RMAN
* Tuning
* UNIX
* Upgradation
* About Me
* PostgreSql
WEDNESDAY, 25 MARCH 2020 PG_DUMP: ABORTING BECAUSE OF SERVER VERSION MISMATCH Initiating backup using pg_dump keeps on failing with error as below:
Read more »
Reactions:
No comments:
Labels: PostgreSQL
PG_DUMP: QUERY WAS: LOCK TABLE While performing backup using pg_dump with database user fails witherror as below :
Read more »
Reactions:
No comments:
Labels: PostgreSQL
PG_RESTORE WITH -C OPTION FAILS TO CREATE DATABASE. FATAL: DATABASE "NEXAPROD" DOES NOT EXIST When you use pg_restore you have various options available, forexample :
-c to drop database objects before recreating them, -C to create a database before restoring into it,Read more »
Reactions:
No comments:
Labels: PostgreSQL
THURSDAY, 19 MARCH 2020 INITIALISE MULTIPLE POSTGRES INSTANCE ON SAME RHEL SERVER It is pretty easy to install multiple instances of PostgreSQL servers on same server and have its benefits.Read more »
Reactions:
No comments:
Labels: PostgreSQL
WHO USES POSTGRESQL
A GOOD READ WHO USES POSTGRESQLReactions:
No comments:
Labels: PostgreSQL
MONDAY, 16 MARCH 2020 POSTGRES | QUERY TO IDENTIFY THE LAG AMONG THE PRIMARY AND REPLICARead more »
Reactions:
No comments:
Labels: PostgreSQL
TUESDAY, 10 MARCH 2020 HOW TO STOP STARTING OF CLUSTERS WHILE STARTING UP SERVICES Infra activities such as upgrade, OS patching or Sevrer maintaince activity may require disabling the auto startup of any specific cluster or if you want NOT auto start on a call such AS SUDO SERVICEPOSTGRESQL START
Read more »
Reactions:
No comments:
Labels: PostgreSQL
PGTUNE | INSTALLATION AND USAGE _PGTUNE _helps expands the database server to be as powerful as the hardware it's being deployed on , by taking an existing postgresql.conf file as an input, making changes to it based on the amount of RAM in your server and suggested workload, and output a new file.Read more »
Reactions:
No comments:
Labels: PostgreSQL
Older Posts
Home
Subscribe to: Posts (Atom)SEARCH THIS BLOG
REWARDED AMONG TOP 60 DATABASE BLOGSPAGEVIEWS TILL NOW
206568
ABOUT ME
Wonted thingie.. A techie, from a reputed company, who keeps worrying about the tweaking the sqls and Optimizer parameters, weekend maintenances, upgrades, support, and what not a DBA can do!! Yet trying to find some time to pen down the rushing thoughts as well as my technical experience, so that it could help others! At times me, people end up searching their own blogs :DPOSTGRESQL
STAY UPDATED. FOLLOW US ON FACEBOOK A Helping Hand for Beginners & ExperiencedBuy me a coffee
MY POSTS
* ▼ 2020 (10)
* ▼ March (10)
* pg_dump: aborting because of server version mismat... * pg_dump: query was: LOCK TABLE * pg_restore with -C option fails to create database... * initialise multiple postgres instance on same RHEL... * Who uses Postgresql * Postgres | Query to identify the lag among the Pri... * How to stop starting of clusters while starting up... * pgtune | installation and usage * pg_basebackup: could not connect to server: FATAL:... * pg_basebackup : could not connect to server: FATAL...* ► 2019 (3)
* ► October (1)* ► August (2)
* ► 2018 (13)
* ► October (2)* ► August (5)
* ► June (2)
* ► March (2)
* ► January (2)* ► 2017 (21)
* ► December (3)* ► September
(1)
* ► August (2)
* ► July (2)
* ► April (3)
* ► March (2)
* ► February (6) * ► January (2)* ► 2016 (146)
* ► September
(7)
* ► August (11)* ► July (11)
* ► June (19)
* ► May (21)
* ► April (30)
* ► March (47)
* ► 2015 (13)
* ► October (13)* ► 2014 (2)
* ► May (2)
:: MOST TRENDING TOPICS :: * DeadLock Scenario - Simulating Practical * Logminer in Oracle * Datapump Scenarios * Collection of VI Commands * AWR :: For Beginners * Tickiting Tool for DBA's * General Tips for Interview * Behind Upgradation Process * Pre-check for DG switchover * Quick Troubleshooting Steps for Daily ActivitiesRELATED LINKS
* DBA Code
POPULAR POSTS
*
20 ASM Realtime | Interview Questions | 3+ years*
Quick Troubleshooting Steps for Daily Activities How to detect locking issues in Database ? -During this,, you need to find Locking sessions and Kill 1Session among those ...*
How to Prepare for DBA Interview Preparation for DBA Interview Nobody can give us complete or most of questions about interview because it is like our school, coll...*
General Tips to Prepare for an Oracle DBA Job Interview FREE Sign-Up with Gmail and Receive Pdf's and Updates via Mail - Click Here Preparing for an interview beforehand is pref...*
AWR - Automatic Workload Repository :: Beginners Guide FREE Sign-Up with Gmail and Receive Pdf's and Updates via Mail -Click Here
*
What is nohup command ? How to Run Datapump Jobs in Background with ‘’nohup ‘’ mode. This is used to run Expdp / Impdp Jobs or any other long running jobs in Background. Step 1: Create a parameter file for export o...*
ORA-01565: error in identifying file /dbs/spfile@.ora ORA-01565 : error in identifying file /dbs/spfile@.ora When we’re going to create pfile from spfile while spfile running on ASM inst...*
Good DBA
Today my article is based on general thoughts about Oracle DBA with some technical details. In Oracle Technology we never fe...*
How to Crack DBA Interviews FREE Sign-Up with Gmail and Receive Pdf's and Updates via Mail - Click Here People always think that Preparing for Oracle Certif...*
Oracle Datapump Scenarios | Interview Questions Follow us on Facebook !! ASM Interview Questions | PDF Download 20 + ASM Interview Questions | Real-time Scenarios ASM Interview Qu...FIND US ON FACEBOOK
:: Click Here ::
FOLLOW US ON FACEBOOK* ASM (20)
* Auditing
(1)
* Core DBA
(79)
* DataGuard
(15)
* Frequently Asked
(33)
* Interview Questions(23)
* Logminer
(1)
* Must Read
(23)
* RMAN (30)
* Tuning
(12)
* UNIX (8)
* Upgradation
(1)
USEFUL LINKS
* Installing Grid Infrastructure to use ASM on LinuxHOT
* Tickiting Tool for DBA's * General Tips to Prepare for an Oracle DBA Job Interview * Understanding the Upgradation Process * Pre-check for DataGuard switchover Process * Quick Troubleshooting Steps for Daily ActivitiesARCHIVE
* March (10)
* October (1)
* August (2)
* October (2)
* August (5)
* June (2)
* March (2)
* January (2)
* December (3)
* September (1)
* August (2)
* July (2)
* April (3)
* March (2)
* February (6)
* January (2)
* September (7)
* August (11)
* July (11)
* June (19)
* May (21)
* April (30)
* March (47)
* October (13)
* May (2)
Nikhil . Simple theme. Powered by Blogger .Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0