☰
  • Home
  • About Us
  • Contact Us
  • Privacy Policy

DBAtricksWorld.com

Sharing Knowledge is ultimate key to Gaining knowledge…

  • Home
  • About Us
  • Contact Us
  • Privacy Policy

MySQL

Change MySQL Data directory location in Windows

Change MySQL Data directory location in Windows

Backup & Restore MySQL database with compression option

Backup & Restore MySQL database with compression option

How to backup your MySQL Database[s]

How to backup your MySQL Database[s]

Installation of MySQL on CentOS plain

Installation of MySQL on CentOS plain

Search Post

Recent Posts

  • ORA-01580: error creating control backup file xxx, ORA-27040: file create error, unable to create file
  • RMAN failed to connect target database with ORA-00020: maximum number of processes (150) exceeded
  • DBVisit Physical Standby Synchronization Stopped due to partial archivelog transferred to Disaster Recover site
  • SMON: Restarting fast_start parallel rollback
  • Restore Oracle hot backup

Categories

  • DBVisit Standby
  • Linux
  • MongoDB v3
  • MySQL Backup & Restore
  • MySQL Installation & Configuration
  • Oracle
  • Oracle 10g
  • Oracle 11g
  • Oracle 12c
  • Oracle Backup & Restore
  • Oracle Database Management
  • Oracle Errors & Warnings
  • Oracle Installation & Configuration
  • Oracle Replication
  • Oracle Scripts
  • Other
  • PostgreSQL Performance Tuning
  • SQL Server Backup & Restore
  • SQL Server Errors & Warnings
  • SQL Server Installation & Configuration
  • Sybase Installation & Configuration
  • Uncategorized

Tags

ANALYZE ASM Data-Pump Data Guard Data Redaction DBV DBVisit Standby Enterprise Manager Export-Import Linux Manual Data Guard MongoDB v3 MySQL Offline Backup Online Backup ORA-600 ORA-XXXXX Oracle Oracle-Linux Oracle 10g Oracle 11g Oracle 12c Oracle How to's Oracle Scripts Oracle VM Manager Other PostgreSQL RAC RedHat rman SQL Server SQL Server-Error Sybase - SAP ASE TNS-XXXXX Vaccum

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 868 other subscribers

More Blogs

Heal your health with YOGA

Recent Posts

  • ORA-01580: error creating control backup file xxx, ORA-27040: file create error, unable to create file
  • RMAN failed to connect target database with ORA-00020: maximum number of processes (150) exceeded
  • DBVisit Physical Standby Synchronization Stopped due to partial archivelog transferred to Disaster Recover site
  • SMON: Restarting fast_start parallel rollback
  • Restore Oracle hot backup
  • ORA-01194: file 1 needs more recovery to be consistent
  • How to kill Oracle RMAN backup job
  • Database startup failed with ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim x bytes disk space from x limit
  • shutdown database not possible due to missing of one of the controlfile
  • How to multiplex Oracle control file?
  • ORA-00205: error in identifying control file, check alert log for more info
  • ORA-01555 Snapshot Too Old
  • ORA-19625: error identifying file – ORA-27037: unable to obtain file status
  • ORA-02062: distributed recovery received DBID %s, expected %s
  • ORA-19587: error occurred reading 512 bytes at block number 1 + ORA-27072: File I/O error
  • Datapump export job failed with ORA-01555: snapshot too old: rollback segment number x with name “_SYSSMU8$” too small
  • Alter database open failed with ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [160296], [591], [656]
  • Query to find out progress of transaction recovery by SMON
  • Generate AWR – Automatic Workload Repository (AWR) in oracle 11g
  • Change MySQL Data directory location in Windows
  • Restarting Dbvisit Standby components – Dbvnet and Dbvserver
  • DBVisit standby out of sync due network fluctuations & requested archive log file not in place.
  • RMAN-06183: datafile or datafile copy xyz.dbf larger than MAXSETSIZE
  • ORA-12542: TNS:address already in use – Oracle 10g 64 bit
  • ORA-08104: this index object xxxxx is being online built or rebuilt and ORA-00031: session marked for kill
  • MongoDB service not starting due Address already in use for socket: 127.0.0.1:27017
  • ORA-03113: end-of-file on communication channel while startup
  • How to drop database manually, without using Database Configuration Assistant(DBCA)
  • RMAN-06900 RMAN-06901 ORA-19921
  • rename/relocate SYSTEM, SYSAUX or User Tablespace datafiles
  • ORA-00600: internal error code, arguments:[4194] ORA-00603: ORACLE server session terminated by fatal error. PMON terminating the instance due to error 472
  • Oracle VM Manager 3.4.1 Installation on Oracle Linux 6 Update 5 (OL 6.5)
  • ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS and KUPW$WORKER.DISPATCH_WO ORA-01187: cannot read from file because it failed verification tests
  • TNS-12535: TNS:operation timed out AND TNS-00505: Operation timed out
  • Incremental backup from SCN – Oracle 11g Manual Data Guard Part-IV
  • Manual Physical Standby Failover – Activate Standby Database – Oracle 11g Manual Data Guard Part-V
  • How to open Manual Physical Standby Database in READ ONLY mode – Oracle 11g Manual Data Guard Part-III
  • Switch over and switch back – Oracle 11g Manual Data Guard Part-II
  • Steps to configure Manual Data Guard – Oracle 11g Manual Data Guard Part-I
  • How to configure oracle 11g database in archivelog mode
  • ORA-25153: “Temporary Tablespace is Empty” although temporary tablespace and tempfile is available
  • RMAN-06026: some targets not found – aborting restore, RMAN-06023: no backup or copy of datafile X found to restore
  • ORA-01031: insufficient privileges – “SQLPLUS / as sysdba” working, but “SQLPLUS sys/sys@YOUTH as sysdba” is not working.
  • How to uninstall SAP ASE – Sybase 16 from linux
  • TNS-01201: Listener cannot find executable string for SID string – Listener failed to start
  • ORA-01182: cannot create database file X – file is in use or recovery ORA-01111: name for data file X is unknown – rename to correct file
  • ORA-27047: unable to read the header block of file Linux-x86_64 Error: 25: Inappropriate ioctl for device ORA-27048: skgfifi: file header information is invalid ORA-27072: File I/O error
  • ORA-30013: undo tablespace ‘UNDOTBS1’ is currently in use
  • DBVisit standby configuration failed with ORA-19504, ORA-27040, RMAN-06026 and RMAN-06023
  • Oracle 11gR2 software and database installation on CentOS 6.x (64-bit)
  • ORA-03206: maximum file size of XXXX blocks in AUTOEXTEND clause is out of range
  • ORA-19502: write error on file “”, block number xxxxxxxx (block size=8192)
  • How to configure Enterprise Manager with Database Configuration Assistant
  • How to De-configure Enterprise Manager Database Control Manually with Enterprise Manager Configuration Assistant
  • Oracle Enterprise Manager failed to start, OC4J Configuration issue. Configure Enterprise Manager Database Control Manually with Enterprise Manager Configuration Assistant
  • ANALYZE – PostgreSQL Database Maintenance
  • VACUUM – PostgreSQL Database Maintenance
  • How to relocate/move oracle datafiles in Oracle 11g
  • Creating Partial Redaction Policy – Data Redaction Part-IV
  • Full Data Redaction Policy – Data Redaction Part-III
  • ORA-01045: user C##SCOTT lacks CREATE SESSION privilege; logon denied
  • ORA-01950: no privileges on tablespace ‘USERS’
  • Configuring Data Redaction Policies – Data Redaction part-II
  • Introduction to Data Redaction Oracle 12c feature – Data Redaction part-I
  • Oracle 12c R1 software and database installation on Oracle Linux 7 64-bit
  • System.Data.SqlClient.SqlError: The media loaded on X is formatted to support 1 media families, but 2 media families are expected according to the backup device specification
  • Oracle Linux 7: rpmdb open failed
  • ORA-01149:cannot shutdown-file 1 has online backup set OR ORA-10873:file 1 needs to be either taken out of backup mode or media recovered
  • Oracle 11g Manual Online Hot Backup
  • Oracle 11g manual offline cold backup in Linux operating system
  • Oracle 11g Physical standby data Guard Failover steps – Active Data Guard Part-V
  • Script to find out total number of oracle schema objects and its size
  • Script to find out datafiles with highest Input-Output activity
  • how to apply primary database redo information to standby database while standby database is in read only mode – Active Data guard feature – Active Data Guard Part-IV
  • How to open physical standby database in read only mode – Active Data Guard Part -III
  • Oracle 11g Data Guard Switchover and Switchback – Active Data Guard Part-II
  • ORA-16038-log 4 sequence# 10702 cannot be archived-ORA-19809: limit exceeded for recovery files-ORA-19804: cannot reclaim 52428800 bytes disk space from 107374182400 limit
  • Bash Code Injection Vulnerability CVE-2014-7169 Affecting Linux & OS X Systems
  • Steps to configure Oracle 11g Data Guard Physical Standby – Active Data Guard Part-I
  • RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
  • ORA-01105: mount is incompatible with mounts by other instances – ORA-19808: recovery destination parameter mismatch
  • How to configure default device type for RMAN backup – RMAN Part-6
  • HP Data Protector Backup Job failed with ORA-01157: cannot identify/lock data file 516 – see DBWR trace file
  • ORA-01113: file n needs media recovery- ORA-01110: data file n: ‘\SYSTEM01.data4′
  • How to show, change & clear RMAN persistent configuration – RMAN Part-5
  • How to configure server parameter file & controlfile autobackup in RMAN – RMAN Part-4
  • ORA-27369: job of type EXECUTABLE failed with exit code: Input/output error & ORA-06512
  • How to take oracle database incremental backup with RMAN backup utility – RMAN Part-3
  • How to backup database in Archivelog and NoArchivelog mode with RMAN backup utility – RMAN Part-2
  • Getting started with RMAN – Overview of RMAN, Starting and connecting to database – RMAN Part-1
  • Oracle 11gR2 software and database installation on Oracle Linux 6.5
  • ORA-00245: control file backup failed; target is likely on a local file system- RMAN-08132: WARNING: cannot update recovery area reclaimable file list
  • Oracle Backup and Recovery Solutions
  • Introduction to Oracle backup and recovery
  • How to Create TEMPORARY tablespace and drop existing temporary tablespace in oracle 11g
  • How to Backup Oracle RAC 11gR2 Database with RMAN Backup Utility with the help of DBMS_SCHEDULER – Part-IV – RMAN Delete Obsolete Backup
  • How to Backup Oracle RAC 11gR2 Database with RMAN Backup Utility with the help of DBMS_SCHEDULER – Part-III – RMAN Transactional log/Archive Database Backup
  • How to Backup Oracle RAC 11gR2 Database with RMAN Backup Utility with the help of DBMS_SCHEDULER – Part-II – RMAN Incremental Database Backup
  • How to Backup Oracle RAC 11gR2 Database with RMAN Backup Utility with the help of DBMS_SCHEDULER – Part-I – RMAN Full Database Backup
  • ORA-19573: cannot obtain exclusive enqueue for datafile 3

Top Posts & Pages

  • How to check RMAN backup status and timings
  • ORA-00205: error in identifying control file, check alert log for more info
  • ORA-01194: file 1 needs more recovery to be consistent
  • How to kill oracle datapump export job
  • Change MySQL Data directory location in Windows
  • How to kill Oracle RMAN backup job
  • ORA-15260: permission denied on ASM disk group
  • How to Create TEMPORARY tablespace and drop existing temporary tablespace in oracle 11g
  • ORA-19625: error identifying file - ORA-27037: unable to obtain file status
  • RMAN-06026: some targets not found - aborting restore, RMAN-06023: no backup or copy of datafile X found to restore
Sixteen Theme by InkHive