Backup & Recovery :: RMAN-04002 - Ocipi Failed - ORA-1?

Oct 3, 2012

Microsoft Windows [Version 6.0.6002]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.

C:Users>rman

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Oct 3 16:24:38 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN> connect target sys/@proddb

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04002: ocipi failed, ORA--1

when i try to connect with the prod database by logging in the server,then it raise the above error.

i want to aware you with what i have done before it--

(1) this database is running on the port 1526 not on 1521, because of some reason new listner have to made.

(2) i can easily access this database without any error from my local machine, then it doesnot raise-ORA-12154: TNS:could not resolve the connect identifier specified

now i am going to take backup from RMAN at my local machine of same database , then

C:UsersNeetesh>rman target /@proddb

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Oct 3 16:29:47 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12154: TNS:could not resolve the connect identifier specified
C:UsersNeetesh>

View 11 Replies


ADVERTISEMENT

Backup & Recovery :: RMAN-00554 - Initialization Of Internal Recovery Manager Package Failed?

Feb 11, 2011

I have recently patched my catalog home to 9208 from 9204; the target database is still on 9204 but now I cannot connect to the catalog database.

oracle@mogw:TES1:/u01/app/oracle/admin/TES1/bdump
rman rcvcat rman/rman@RMANDB

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

[code]...

View 11 Replies View Related

Backup & Recovery :: RMAN-00554 - Initialization Of Internal Recovery Manager Package Failed

Jun 25, 2013

While connecting to target database from stand database. I am getting below error.

calhost dbs]$ sqlplus system/oracle@proddb

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:10 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[standdb@localhost dbs]$ rman target system/oracle@proddb auxiliary system/oracle@standdb

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:22 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

View 7 Replies View Related

Backup & Recovery :: RMAN Backup Failed

Apr 11, 2012

We are getting below error while doing backup of the database through RMAN.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch02 channel at 04/11/2012 00:23:24
ORA-19502: write error on file "/backup/PDWH/RMAN/PDWH_data_820_1_780279469.rmn", block number 961920 (block size=8192)
ORA-27072: File I/O error
Linux Error: 25: Inappropriate ioctl for device Additional information: 4 Additional information: 961920 Additional information: 802816

Even i checked the space & it was good enough to hold the backup.

View 10 Replies View Related

Recovery Manager (RMAN) :: Backup Got Failed With The Error ORA-19566?

Nov 29, 2012

One of database, while taking backup using RMAN, it failed with the following error:

RMAN-03009: failure of backup command on DISK4 channel at 11/28/2012 09:47:29
ORA-19566: exceeded limit of 0 corrupt blocks for file <faile_name>

I used DBV to identify the number of blocks corrupted.

I referred the Metalink iD 457422.1 & 336133.1. But it did not work since the corrupted blocks have got object in it.

I could able to find the object as well. it is one of the table in the datafile.

I used 'ALTER TABLE ... MOVE..' command to see if that works. But again getting the same error while taking the backup and corrupted blocks still exists.

DB Version : 10.2.0.5
OS Version : RHEL 5.6

View 5 Replies View Related

Backup & Recovery :: RMAN-12010 / Automatic Channel Allocation Initialization Failed

Nov 15, 2011

while executing a clone script i got the below error : -

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/15/2011 20:07:34
RMAN-12010: automatic channel allocation initialization failed
RMAN-06758: DB_UNIQUE_NAME is not unique in the recovery catalog

Here i understand that RMAN couldn't find which SPFILE to use to restore the target DB.

How do i check for the DB_UNIQUE_NAME in recovery catalog?

The proposed solution that i found was Use the FOR DB_UNIQUE_NAME option to specify the name of the instance whose parameter file you want to restore. how to implement this in my clone script?

View 7 Replies View Related

RMAN :: RMAN-03014 / Implicit Resync Of Recovery Catalog Failed

May 29, 2013

My oracle backup via Netbackup failing with error 6 (Netbackup) and i have checked the logs please find the RMAN log file as well.

Script /opt/rman_script/st72_oracle_full.sh
==== started on Tue May 28 15:27:46 SGT 2013 ====
RMAN: /OraBase/V10203/bin/rman
ORACLE_SID: ST72
ORACLE_USER: oracle
ORACLE_HOME: /OraBase/V10203
NB_ORA_FULL: 1
NB_ORA_INCR: 0

[code]....

View 2 Replies View Related

Backup & Recovery :: Initialization Of Internal Recovery Manager Package Failed

Sep 28, 2011

I have a database in Archivelog mode and Flashback mode. I am trying to connect to RMAN. But am getting the error

SQL> select name,log_mode,flashback_on from v$database
2 /

NAME LOG_MODE FLA
--------- ------------ ---
ORCL ARCHIVELOG YES

SQL> show user
USER is "SYS"
SQL> host rman target /
[code]....

View 16 Replies View Related

Backup & Recovery :: RMAN Recovery Failing With Incremental Level 0 Backup

Feb 10, 2011

We are trying to restore a database on the different server using RAM incremental level 0 and 1 backups. We have weekly Incremental level 0 backups along with incremental backups on daily basis. During recovery of Incremental level 0 backup, RMAN is expecting/looking for Incremental Level 0 backup of prior week as well. Is this the usual process for RMAN to look for prior level 0 backup though we need to restore from the current level 0 backup and roll forward by a week with subsequent Level 1 backup.?

We intend to restore from the Level 0 of 1/16 and roll forward with daily incrementals till 1/22. RMAN is expecting level 0 backupsets from 1/9 backup as well and keep failing since those backups are not available. quick inputs since we are in middle of recovery and trying to resolve if this is even doable.

View 11 Replies View Related

RMAN :: Recovery Failed In Control File?

Sep 27, 2013

I took database backup without "change the controlfile configuration autobackup on".. and unfortunately i deleted my controlfile. Then I tried to restore my controlfile but it gives error,now how can i restore controlfile is there any other way to restore controlfile with aautobackup..

View 17 Replies View Related

Backup & Recovery :: RMAN Backup Deleted Even Within Recovery Window

Oct 18, 2011

I have problem on using "delete obsolete" in RMAN.

First, let describe my backup configuration.

1. Full backup every Monday (17-Oct, 10-Oct, 3-Oct, 26-Sep)
2. Incremental backup for other days
3. Enable autobackup of control file
4. Backup archive log every day
5. RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS
6. Execute "Delete obsolete" every day
7. control file is used instead of catalog

The results observed:
1. Backup of control files older than 30 days will be deleted
2. Backup of archive log files older than 30 days will be deleted.
3. Backup of datafiles older than ~14 days but before 30 days are also DELETED.

In my example, the backup of datafiles created at 26-Sep is deleted at 16-Oct.

I tried "restore database validate until time "sysdate-22"" at 17-Oct. And RMAN reported "datafile xx will be created automatically during restore operation". It seems that RMAN failed to do restoration up to 22 days ago. The retention policy I set seems not effective on datafile backups.

I checked view v$backup_set and the "Keep" is "No" and "Keep until" is empty.

The only thing I can think of, is the settings of "CONTROL_FILE_RECORD_KEEP_TIME". It is marked "7" in the Oracle, which is less than the retention. But I suppose this only causes the backup not deleted, but NOT be deleted earlier.

View 6 Replies View Related

Backup & Recovery :: SCN Based Backup Do RMAN Generate Backup From Archivelogs

Oct 18, 2012

understanding rman scn based Backup Algorithm .. In SCN based backup do rman generate backup from archivelogs ???

View 1 Replies View Related

RMAN :: Failed To Backup Because Archivelog Destination Was Out Of Space

Dec 16, 2012

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on t1 channel at 12/15/2012 06:15:11
RMAN-10015: error compiling PL/SQL program
RMAN-10033: error during compilation of job step 2: ORA-00603: ORACLE server session terminated by fatal error
ORA-04030: out of process memory when trying to allocate 400 bytes (PL/SQL DIANA,LISIMA: Add cells)

We received the above error message after the following event:

rman failed to backup because archivelog destination was out of space

We moved SOME of the archivelog file manually using operating system command mv to another location so that our application can run first.When the engineers restarted the rman to backup, we receive the above error.

View 7 Replies View Related

Backup & Recovery :: 2 Separate RMAN Backup One Backup Is Of Only Datafile

Jan 24, 2011

I have 2 seperate rman backup one backup is of only datafile ,spfile and controlfile which i am able to restore and recover without any problem say bkp1 taken at 10 am

other set of backup is of only archive log files of same day but later time than datafile backup say bkp2 taken at 8pm...if i restore and recover bkp1 and try to restore bkp2 it gives error datafile exist (possibly due to fact both backup have control file)

if i just restore bkp1 and try to restore bkp2 so that i can do one recover at time
it gives error datafile permission issue (possibly due to fact both backup have control file)

I want to restore database upto 8pm time how can i use both bkp1 and bkp2 to do it(restore datafiles and apply all archive logs on it)

View 17 Replies View Related

Backup & Recovery :: RMAN Restore / Recovery To Previous Cold Backups

Aug 13, 2013

My scenario is: database is in archivelog mode.

I run DLY cold backups including controlfile & archivelogs and keep 3 gens of backups and archivelogs to 3 days also. What is the correct procedure to restore back to an old cold backup. Database is backed up Mon,Tue,Wed on Thur we require to bring database back to Tuesday DLY security.

I have tried:
startup mount
restore database from tag 'DLYTUE'
recover database

( this just rolls forward on all archive logs once it restores datafiles, not getting to point to alter database open resetlogs.)

Next tried to :

recover database archivelog tag 'DLYTUE'
( same outcome )

What is the correct rman procedure including should I remove old archive logs from working OS directory ? Also need to know once I restore back and open database to TUE security how do you tidy up the archive logs and dumps which are no longer require i.e. : weds..

I have read about using the set until time option but how to I get absolute time from when cold backup completed if this is the correct procedure.

View 9 Replies View Related

Recovery Manager (RMAN) :: Backup-Based Duplication Without A Target And A Recovery Catalog Connection?

Sep 30, 2012

how to duplicate it on oracle 11g xe windows 2003

i have read from documentation but getting some error.

in last

E:Documents and SettingsAdministrator>rman
Recovery Manager: Release 11.2.0.2.0 - Production on Sun Sep 30 03:03:09 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect auxiliary sys/12
connected to auxiliary database: XE (not mounted)
RMAN>
RMAN> DUPLICATE DATABASE TO xe

[code]...

Backup-Based Duplication Without a Target and a Recovery Catalog Connection?

View 6 Replies View Related

Backup & Recovery :: Incomplete Recovery Shows RMAN-20207

Jan 4, 2012

when i performed incomplete recovery i try to set until time but it shows RMAN-20207:until time or recovery window shoubld be before resetlogs.

View 3 Replies View Related

Backup & Recovery :: RMAN-06428 / Recovery Catalog Is Not Installed

Jan 1, 2012

REGISTER DATABASE;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 01/01/2012 11:02:40
RMAN-06428: recovery catalog is not installed

View 4 Replies View Related

Backup & Recovery :: Finding Rman Restore And Recovery Process?

Feb 7, 2011

I have a doubt regarding the process the RMAN follows for restore and recovery of the database.

My Level 0 full backup completes on Saturdays at around 11 am after taking 8 hours (It starts at 3am).On Sunday, I ask RMAN to restore (on a different box) till Saturday 11:30 am.Then, after the restore is successful, I recover it till 11:45 am.

The recovery also goes fine and Iam able to clone to test box.

Till what time is the database restored? I assume its till 11 am since the L0 backup finishes at 11 am though I have asked it to restore till 11:30 am

During the recovery, ONLY the archives generated between Saturday 3 am and till the time i asked for recovery (Saturday 11:45 am ) are required. But, checking the recovery log file, i was surprised to see that RMAN has restored archive files starting from Friday 9:30 pm (Much before the time the Level 0 backup even started).

why does RMAN require the old archive log files.

View 4 Replies View Related

Backup & Recovery :: RMAN Duplicate Set Until Time Using Wrong Backup Piece Name To Restore?

Feb 26, 2012

We are doing RMAN Duplicate set until time to refresh daily our test database for our developers and it taking long time to finish. We noticed on the restore log that RMAN was using a day old old backup pieces to refresh the test database and don't immediately use the latest backup pieces instead.

For additional details here's the rman duplicate command we are using which we run daily(mon-sat) at 4am once daily full backup on production completed.

RMAN Duplicate commands:
run
{
set until time "to_date(to_char(sysdate,'Mon DD YYYY') || ' 04:00:00', 'Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel ch1 type disk;
duplicate target database to testdb;
}
exit

Is there a way on how to let RMAN use the latest backup pieces instead?

View 1 Replies View Related

Backup & Recovery :: ORA-01655 On CREATE USER (splitted From RMAN Backup Error)

Dec 22, 2012

I created a tablespace named 'data'.During create a new user with default tablespace 'data',I got following error message:

SQL> create user rman identified by rman default tablespace data
temporary tablespace temp

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01655: unable to extend cluster SYS.C_USER# by 2 in tablespace

OS:Windows XP
Oracle 10g

View 2 Replies View Related

Backup & Recovery :: RMAN Full Backup Failing When Backing Up Temp File?

Jan 28, 2011

I am tryign to run a split onlike full backup from the os useign the sap command which is linked to rman..Command that i am useing is ...

brbackup -u / -c force -t online_split -m full -p initBR1_onlinefull.sap

The backup goes thru but i get this erro on the end...

BR0522I 57 of 57 files/save sets processed by RMAN
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.26
BR0505I Full database backup (level 0) using RMAN successful
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.28

[code]...

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>
connected to target database: BR1 (DBID=2250873886)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>
29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42

[code]...

Recovery Manager complete.
ERR_RC: 1
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.32
BR0279E Return code from 'brtools -f printcmd -U /oracle/BR1/sapbackup/..befcdgxn..cmd -C
/oracle/BR1/sapbackup/.befcdgxn.cmd | rsh scrbdefrmr207 /bin/sh -c "'LANG=C SHELL=/bin/sh/oracle/BR1/102_64/bin/rman

[code]...

I have check on the system .. There is not file like that but thwre on on the db i,e

eshtsm20:orabr1 88> pwd
/oracle/BR1/sapdata1/perfman_1
eshtsm20:orabr1 89> ls -ltr
total 102408
-rw-r----- 1 orabr1 dba 104865792 Aug 30 09:05 perfman.data1

View 13 Replies View Related

Backup & Recovery :: Restore Dropped Or Wrongly Updated Table Using RMAN Backup?

Feb 9, 2011

Is it possible to restore dropped table OR wrongly updated table using RMAN backup.

View 18 Replies View Related

Backup & Recovery :: RMAN Script Delete The Backup Pieces Older Than 2 Days

Jan 8, 2013

Is this script is enough to delete the backup pieces older than 2 days.

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
configure device type disk parallelism 1 backup type to compressed backupset;

run
{
allocate channel d1 type disk ;
backup filesperset 5 format '/u06/backup/EBSDEV/EBSDEV_data_t%t_s%s_p%p' database ;
sql 'alter system archive log current' ;
backup filesperset 20 format '/u06/backup/EBSDV3/EBSDV3_arch_t%t_s%s_p%p' archivelog all delete input ;

[Code]....

View 1 Replies View Related

Backup & Recovery :: Does Full Cold Backup Of RMAN Include Online Redologs

Jan 8, 2013

Does the full cold backup of rman include online redologs?

So that at the time of recovery when i restore the database the online redologs also restored to that point?

View 2 Replies View Related

Backup & Recovery :: Check Current Value For Limit Channel In Rman Backup?

Mar 19, 2009

Would like to check how do we check the current value for limit channel in rman backup..

eg set limit channel d1 kbytes 2024800;

View 2 Replies View Related

Backup & Recovery :: Configured Tivoli And Getting Error While Execute RMAN Backup

Nov 17, 2012

We have configured tivoli and getting the below error while execute rman backup.

> rman target / catalog rman/*****@CATLOGDB
Recovery Manager: Release 11.2.0.3.0 - Production on Sat Nov 17 13:35:03 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: AMTMXPRD (DBID=534215973)
connected to recovery catalog database

[code]....

View 6 Replies View Related

Backup & Recovery :: RMAN Backup Fails On Windows When Using Batch File?

May 3, 2011

I am trying to setup incremental backup on my windows OS based server using RMAN command in batch file. When I use batch file in OS scheduler it is working fine, when I am calling same batch file from my LOCAL desktop PC it throws errors as below.

D:> \3.193.211.19sgdba
mankp_acressit.bat
D:>rman catalog rman/******@acressit target / cmd
file=E:sgdba
mankp_arch.rcv log E:sgdba
mansit_arch_rman_backup.log
RMAN-00557: could not open MSGLOG "E:sgdba

[code]....

Both single and double quotes (' or ") are accepted for a quoted-string.

Quotes are not required unless the string contains embedded white-space.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00556: could not open CMDFILE "E:sgdba
mankp_arch.rcv"

[code]....

* on my DB server I am login using my administrator account, on my PC I dont have admin account.

* I have checked remote execution using local user as well as admin user.

* I have checked the permission and my local ID & EVERYONE has all permission in that folder.

View 2 Replies View Related

Backup & Recovery :: Restore RMAN Backup In New Server / Got Error 06172

Jun 21, 2011

We are using Oracle 10g R2 in Windows Server 2003. I'm trying to restore a database in a new server, using RMAN backups.

Our external consultant configured RMAN scripts for full and incremental backups but never tested them . Since he just doesn't show up, I'm forced to tested them, restoring the whole database in a new server.

My instance is named MTDPROD, and I will create all from scratch.

At current server, RMAN files are generated in:
//192.168.1.149/g$/XXXSRV4-ArcLogs/MTDPROD/RMAN

At new server, I run all these commands:

C:>oradim -new -sid MTDPROD -intpwd mtdprod
Instance created
-- I created the relevant folder hierarchy under <ORACLE_BASE>
directory
-- Then, I created the relevant directories for Oracle Database, as
follows:
--a. Create BDUMP, CDUMP, and UDUMP directories under '<ORACLE_ BASE>

[code]....

By instance, I see a lot of this kind of files:

- FULL_MTDPROD_20110529_386_1.BAK
- INCR_MTDPROD_20110621_480_7.BAK
And only see these two files:
- C-2169285856-20110527-03
- C-2169285856-20110527-04

It seems that this C-2169285856-.... files only were on 27/05/2011 and then no more. However, the FULL_... and INCR_.. files are generated every day. The FULL is generated at the end of each month and INCR is generated every day.

This is the backfull.sql:

run {
allocate channel c1 type disk maxpiecesize=4G;
CROSSCHECK archivelog all;
backup
incremental level 0
format '\192.168.1.149g$XXXSRV4-arclogsMTDPRODRMANFULL_

[code]....

This is the backincr.sql:

run {
allocate channel c1 type disk maxpiecesize=4G;
CROSSCHECK archivelog all;
backup
incremental level 1 cumulative
format '\192.168.1.149g$XXXSRV4-arclogsMTDPRODRMANINCR_
%d_%T_%s_%p.bak'

[code]....

View 6 Replies View Related

Backup & Recovery :: Tape Streaming Not Happening While Performing RMAN Backup

Oct 29, 2011

Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough.What could be a solution to make tape streaming happen during the backup?

A.Configure backup optimization

B.Configure the channel to increase MAXOPENFILES

C.Configure the channel to increase the capacity with the RATE parameter

D.Configure the channel to adjust the tape buffer size with the BLKSIZE option

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved