• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Oracle 10g

How to Identify Different File types and space used in Flash Recovery Area

By admin

Question: How to find out the existence of different types of files and backups available with the usage of space in the Flash Recovery Area? Starting with Oracle 10G Release 2, a new view has been made available: V$FLASH_RECOVERY_AREA_USAGE. V$FLASH_RECOVERY_AREA_USAGE shows the percentage of the total disk quota used by different types of files, and how much space for each type of file can be reclaimed by deleting files that are obsolete, redundant, or already backed up to tape. SQL> … [Read more...] about How to Identify Different File types and space used in Flash Recovery Area

Filed Under: oracle, Oracle 10g, Oracle 11g, oracle 12c

Database Crashed With ORA-19815, ORA-19809, ORA-16038

By admin

The Problem Instance terminated due to error 16038 as its not able to archive the log in FRA: ORA-19815: WARNING: db_recovery_file_dest_size of 99614720000 bytes is 100.00% used, and has 0 remaining bytes available. Sat Mar 8 00:57:07 2008 ************************************************************************ You have following choices to free up space from flash recovery area: 1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, then consider changing RMAN … [Read more...] about Database Crashed With ORA-19815, ORA-19809, ORA-16038

Filed Under: oracle, Oracle 10g, Oracle 11g, oracle 12c

Rman Backups Failing with RMAN-20004

By admin

The Problem Recovery catalog has been configured. Production Database has been cloned and a connection has been made from the clone to Catalog database using rman. DBID of the clone instance has not been changed, (so is identical with source DBID). Rman backup fails with: RMAN-00571: RMAN-00569: RMAN-00571: RMAN-03002: failure of resync command at 01/5/2009 08:10:05 RMAN-06004: ORACLE error from recovery catalog database RMAN-20004: target database name does not match name in … [Read more...] about Rman Backups Failing with RMAN-20004

Filed Under: oracle, Oracle 10g, Oracle 11g

Oracle Database – How to Rename a Datafile with Special Characters Created by Mistake

By admin

Question: We have mistakenly create a datafile with special charatcers. Also we get error ORA-01516 when we try to rename it using the normal method: sql> alter database rename file 'old_file_name' to 'new_file_name'; The Solution 1. Bring the Tablespace offline. sql> alter tablespace [tablespace name] offline; 2. Copy/Move the File at the OS level specifying the correct file name. 3. If there is no special character then the solution is: sql> alter database rename file … [Read more...] about Oracle Database – How to Rename a Datafile with Special Characters Created by Mistake

Filed Under: oracle, Oracle 10g, Oracle 11g, oracle 12c

How to Rename or Move Datafiles and Logfiles in Oracle Database

By admin

How to Rename or Move Datafiles and Logfiles In many situations, a datafile or logfile must be renamed inside Oracle. Whereas the contents of the file remain valid, you need to define a new physical name or location for it. For example: You want to move a database file to a different disk for performance or maintenance reasons. You have restored a datafile from backup, but the disk where it should normally be placed has crashed and you need to relocate it to a different disk. You have … [Read more...] about How to Rename or Move Datafiles and Logfiles in Oracle Database

Filed Under: oracle, Oracle 10g, Oracle 11g

How To Size UNDO Tablespace For Automatic Undo Management

By admin

Sizing an UNDO tablespace requires three pieces of data. (UR) UNDO_RETENTION in seconds (UPS) Number of undo data blocks generated per second (DBS) Overhead varies based on extent and file size (db_block_size) The undo space needed is calculated as: UndoSpace = UR * (UPS * DBS) Two of the pieces of information can be obtained from the instance configuration: UNDO_RETENTION and DB_BLOCK_SIZE. The third piece of the formula requires a query being run against the database. The maximum … [Read more...] about How To Size UNDO Tablespace For Automatic Undo Management

Filed Under: oracle, Oracle 10g, Oracle 11g

How to duplicate a Oracle Database to a previous Incarnation

By admin

NOTE: In 11.2, there is a new option to duplicate syntax, INCARNATION, which allows you to duplicate the database to a previous incarnation using the RMAN duplicate command. For example: run { allocate auxiliary channel ch1 type 'SBT_TAPE' parms'ENV=(NB_ORA_CLIENT=xxx.com,NB_ORA_SERV=xxx.com)'; allocate auxiliary channel ch2 type 'SBT_TAPE' parms'ENV=(NB_ORA_CLIENT=xxx.com,NB_ORA_SERV=xxx.com)'; allocate auxiliary channel ch3 type 'SBT_TAPE' … [Read more...] about How to duplicate a Oracle Database to a previous Incarnation

Filed Under: oracle, Oracle 10g, Oracle 11g

How to Modify an Existing ASM Spfile in a RAC Environment

By admin

This post provides an example on how to modify an existing Automatic Storage Management (ASM) spfile in a two-node Real Application Clusters (RAC) Environment. These steps can be applied to a multiple node Real Application Clusters (RAC) Environment. Applies To: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1] If a spfile is used in Clustered ASM environments, then the spfile must be on a shared Clusterware device, i.e. shared spfile. Note: … [Read more...] about How to Modify an Existing ASM Spfile in a RAC Environment

Filed Under: oracle, Oracle 10g, Oracle 11g

How to list all the named events set for a database

By admin

Oracle Internal Events, both named event (eg: ERRORSTACK) as numeric events (eg 10046) can be set at the session level. This post outlines how DataBase Administrators can verify which events have been set in a specific session or in the entire system. This can be achieved through the ORADEBUG functionality. The exact syntax to use depends on the Oracle version you are using. If you want to retrieve the events set in a specific session, then use the following oradebug commands to identify the … [Read more...] about How to list all the named events set for a database

Filed Under: oracle, Oracle 10g, Oracle 11g

Step By Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMAN

By admin

This post covers the detailed steps for creating a physical standby database on a normal file system using RMAN for a primary database in ASM. Overview Here the Standby database can be created using the following 2 methods: Normal Restore and Recovery using RMAN. Creating a Duplicate database for Standby using RMAN. Method 1 Perform the backup of the ASM primary database ( Datafiles, Controlfile for standby and Archivelogs ) Make the backup pieces available on the Standby … [Read more...] about Step By Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMAN

Filed Under: ASM, oracle, Oracle 10g, Oracle 11g, oracle 12c, RMAN

Next Page »

Primary Sidebar

Recent Posts

  • How to Configure Automatic Package Updates on the Server in CentOS/RHEL 8
  • FATAL: Error inserting rds_rdma
  • Failed to start LSB: Bring up/down networking – On restarting network service CentOS/RHEL (DHCP client)
  • How To Add Timestamps To dmesg Kernel Boot Log in CentOS/RHEL
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary