Tales From A Lazy Fat Oracle DBA

$ prashantdixit/oracle90@ace as sysdba

  • Prashant Dixit is the FatDBA

  • Follow Tales From A Lazy Fat Oracle DBA on WordPress.com
  • My Twitter Feeds

  • Oracle Radio

  • Magic Of Oracle

  • Disclaimer!

    FatDBA or Oracle 'Ant' is an independent web-blog/site.The experiences, Test cases, views, and opinions expressed in this website are my own and does not reflect the views or opinions of my employer.

    This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content.
    Product and company names mentioned in this website may be the trademarks of their respective owners.

Articles

2 Responses to “Articles”

  1. Kumar Gaurav said

    Hi,

    I have installed oracle 11g and tried to take full backup of that. I set parameter log_archive_dest_1 to D:\backup\. I got the backup file created in supposed folder but logs are not getting created and showed error rman – 03002. The command I typed from rman prompt is given below.

    run {
    allocate channel t1 type disk;
    allocate channel t2 type disk;
    backup as compressed backupset filesperset 4 database format ‘D:\backup\online_full_%d_%s’;
    backup as compressed backupset archivelog all;
    }

    Kindly help.

    Gaurav

    • oracleant said

      Welcome Gaurav,
      My first question – What logs are you referring to …? (If Archive logs, please check if you have the archive log mode enabled)
      Where and when you are getting ORA-03002 .. ?

      Cause:
      Data corruptions (Most of the times)

      Solutions:
      1. Find out the DBINC_KEY on the rman database (Recovery catalog)
      SQL> SELECT NAME, RESETLOGS_TIME, DBINC_KEY FROM rc_database_incarnation WHERE dbid=xxxxxxxxxx;

      *Note: to identify DBID —
      [oracle@prashant1 ~]$ rman target /
      Recovery Manager: Release 10.2.0.1.0 – Production on Sat Nov 23 21:22:39 2013
      Copyright (c) 1982, 2005, Oracle. All rights reserved.
      connected to target database: QRCL (DBID=859215136)

      OR
      select name, dbid from v$database;

      2. Find out the problem file#
      SQL> SELECT dbinc_key, ts#, ts_create_scn, file# FROM tf WHERE DBINC_KEY=yyyyy;

      3. Take a note and remove the record from tf.
      4. Do a resync catalog using RMAN

      Good Luck!

      Thanks
      Prashant Dixit

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: