Monthly Archives: August 2014

Data Guard / RMAN’ s archivelog deletion policy.

ARCHIVELOG DELETION POLICY FOR PHYSICAL STANDBY DATABASES. SQL> set pagesize 9999SQL> set linesize 120SQL> select * from v$flash_recovery_area_usage;FILE_TYPE         PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES——————– —————— ————————- —————CONTROL FILE                  0             0        0REDO LOG                   4.02             0        4ARCHIVED LOG              42.51             […]

RMAN Restoration and Recovery

RMAN> list backup summary;List of Backups===============Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag——- — — – ———– ————— ——- ——- ———- —9 B A A DISK 30-MAR-07 1 1 NO TAG20070330T09201610 B F A DISK 30-MAR-07 1 1 NO TAG20070330T09214811 B A A DISK 30-MAR-07 1 1 NO TAG20070330T09254712 B F […]

How to restore an RMAN backup from TAG

SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup mount;ORACLE instance started.Total System Global Area 608174080 bytesFixed Size 2085840 bytesVariable Size 381684784 bytesDatabase Buffers 218103808 bytesRedo Buffers 6299648 bytesDatabase mounted.SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release – 64 bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@dbhost oracle]$ rman […]

Renaming SYSTEM datafiles of Oracle Database

SQL> alter tablespace system offline;alter tablespace system offline*ERROR at line 1:ORA-01541: system tablespace cannot be brought offline; shut down if necessary Renaming datafiles of SYSTEM tablespace:- 1. Shut down the databaseSQL> shu immediateDatabase closed.Database dismounted.ORACLE instance shut down. 2. Start the database in mount mode : SQL> startup mountORACLE instance started. Total System Global Area […]

Opatch PSU Oracle Solaris on SPARC (64-bit)

bash-3.00$ cd $ORACLE_HOME -bash-3.00$ mv OPatch OPatch.OLD -bash-3.00$ cp /u01/app/oracle/product/11.2.0/db_1/ -bash-3.00$ unzip -bash-3.00$ opatch version /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch: whereis: not found Invoking OPatch OPatch Version: OPatch succeeded. -bash-3.00$ -bash-3.00$ export PATH=$PATH:/usr/ucb -bash-3.00$ opatch version Invoking OPatch OPatch Version: OPatch succeeded. -bash-3.00$ 2- Download the patch number 9952216 and unzip the file: […]

opatch: whereis: not found

while invoking Opatch: version apply/ora_backup/u0001/patches/OPatch/OPatch/opatch: whereis: not foundfix:>export PATH=$PATH:/usr/ucb>/ora_backup/u0001/patches/OPatch/OPatch/opatch applyInvoking OPatch

Prereq “checkApplicable” for patch ” passed.

bash-3.2$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckApplicable -ph /export/home0/16902043Oracle Interim Patch Installer version (c) 2013, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/11.2.0/db_1Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.locOPatch version : version : file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-08-22_15-10-45PM_1.log Invoking prereq “checkapplicable” Prereq “checkApplicable” for patch 16902043 passed. OPatch succeeded.

kkjcre1p: unable to spawn jobq slave process, error 1089

ORA-01089 is just a warning that the DB is being shut down. If a job is about to be spawned when shutdown of database is in progress, you will see these errors in the alert log file and this is perfectly valid.  SOLUTION There is no harm at all because of  this warning being logged to […]

ORA-00020: maximum number of processes (%s) exceeded

SQL> show parameter processes NAME TYPE VALUE ———————————— ———– —————————— processes integer 150 SQL> select count(*) from v$process; COUNT(*) ———- 149 SQL> alter system set processes=300 scope=spfile; System altered. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. SQL> show parameter processes NAME TYPE VALUE ———————————— ———– —————————— […]

CUPS: Print-Job: Unauthorized

Print-Job: Unauthorized Resume-Printer: Unauthorized PID 29644 (/usr/lib/cups/backend/lpd) stopped with status 1! Solution: To resolve these errors edit printers.conf file. vi /etc/cups/printers.conf Edit the following line: AuthInfoRequired username,password Replace the line with instead: AuthInfoRequired none Restart the CUPS service. /etc/init.d/cups restart service cups restart

RMAN Catalog Upgrade to Oracle

It sounds so simple – but in this specific case a bit of doc reading is required as upgrading the RMAN catalog to handle Oracle databases is not as trivial as in the past. Thanks to a German customer and a friendly colleague from Sales Consulting in Stuttgart I have learned my RMAN lesson […]

How to Create a Copy of Table Data

Nowing how to copy existing table data is beneficial to any DBA. This tutorial will demonstrate how to copy an existing table’s data into a new table. Examples with walkthrough explanation are provided.Let’s see the syntax and example for creating a copy of old_table into new_table in oracle. Syntax: Create table new_table as select * […]