DBAtricksWorld.com

Sharing Knowledge is ultimate key to Gaining knowledge…

Home
About Us
Contact Us
Privacy Policy

Other

How to Flush DNS

How to open firewall ports on Windows Server 2008 R2

Search Post

Search for:

Subscribe to Blog via Email

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

Email Address

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