While connecting to catalog and running rman script, you may face below error. ERROR: RMAN-06429: TARGET database is not compatible with this version of RMAN RMAN-06618: RMAN client and database release mismatch; indicated database release is 12.1.0.2   Solution: […]

                              You may face RMAN-20035: invalid high RECID  after connecting to catalog database.   executing command: SET COMMAND ID starting full resync of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of set command at […]

                                   While doing expdp  the dumpfile to a NFS mount point, you may receive below error. Error: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, […]

                   If you want to restore particular sequence of archivelogs from RMAN tape backup, then follow below steps.   connect target sys/******@CRM_DB connect catalog RMAN_tst/*****@catdb run { allocate channel t1 type SBT_TAPE parms ‘ENV=(NSR_SERVER=nwwerpw,NSR_CLIENT=tsc_test01,NSR_DATA_VOLUME_POOL=DD086A1)’connect sys/****@CRM_DB; set archivelog destination to ‘/dumparea/’; restore archivelog from sequence 7630 until sequence […]

              In this article we will explain how to restore the database to point in time using rman tape backup. NOTE – This restore method will overwrite the existing database.(as we are restoring the database to same location). Please take necessary backup if required. 1. start the database in mount […]

Use below rman script to delete archive logs older than 2 days. rman target / DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘sysdate-2’; CROSSCHECK ARCHIVELOG ALL; DELETE EXPIRED ARCHIVELOG ALL;   For standby database:     rman target / CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘sysdate-2’; CROSSCHECK ARCHIVELOG ALL; DELETE […]

         While creating a catalog for the database, received below error. RMAN-07539: insufficient privileges to create or upgrade the catalog schema   RMAN> connect target sys/oracle#1234@ARCDB connected to target database: ARCDB (DBID=605774762) RMAN> connect catalog RMAN_st/rman@catlogdb connected to recovery catalog database RMAN> create catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS […]

PROBLEM:             While taking export or import  , you may face below issue. oracle@TEST0$ impdp dumpfile=CX_HIZRI_TRANS_Apr10.dmp logfile=test_1_cx_hizri.log tables=SIEBEL.CX_HIZRI_TRANS directory=TESTDIR table_exists_action=truncate  Import: Release 12.1.0.2.0 – Production on Sun Apr 10 14:30:23 2016  Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.  Username: / as sysdba  Connected to: Oracle Database […]

You may get ORA-38706: Cannot turn on FLASHBACK DATABASE logging while enabling flashback Problem: SQL> alter database flashback on; alter database flashback on * ERROR at line 1: ORA-38706: Cannot turn on FLASHBACK DATABASE logging. ORA-38709: Recovery Area is not enabled.   solution:   Put database in archivelog mode , if not       […]

              While connecting to catalog database using RMAN you may get below error like . PL/SQL package DBMS_RCVMAN version 12.01.00.01 in RCVCAT database is not current. Problem:   oracle@TEST:~/RMAN/TEST$ rman Recovery Manager: Release 12.1.0.2.0 – Production on Tue Feb 23 09:27:33 2016 Copyright (c) 1982, 2014, Oracle and/or its […]