OraFAQ Forum: Backup & Recovery » ora-01031

Home » RDBMS Server » Backup & Recovery » ora-01031

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-01031 [message #271305]

Mon, 01 October 2007 03:53

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

when am trying to connect to auxiliary database am getting the below error.i had checked my password file and i had re-created it.but still am getting the error.

[oracle@infra ~]$ rman target sys/hcl@newdb catalog rman/rman@dbsib auxiliary sys/hcl@AUX

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Oct 1 17:24:40 2007

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

connected to target database: NEWDB (DBID=2873463223)
connected to recovery catalog database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges

Report message to a moderator

Re: ora-01031 [message #271306 is a reply to message #271305]

Mon, 01 October 2007 03:57

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

babu.knb@gmail.com

May i know your source and target (auxiliary) database name ??

Babu

Report message to a moderator

Re: ora-01031 [message #271307 is a reply to message #271305]

Mon, 01 October 2007 04:02

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

source database name is-----newdb

target database name is(auxiliary)----AUX

Report message to a moderator

Re: ora-01031 [message #271308 is a reply to message #271307]

Mon, 01 October 2007 04:15

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

babu.knb@gmail.com

rman TARGET=sys/oracle@newdb AUXILIARY=sys/oracle@aux

Try and let me know

Report message to a moderator

Re: ora-01031 [message #271309 is a reply to message #271305]

Mon, 01 October 2007 04:19

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

ya i had tried that also but am getting the same error.

Report message to a moderator

Re: ora-01031 [message #271315 is a reply to message #271305]

Mon, 01 October 2007 04:35

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

[oracle@infra ~]$ rman target=sys/hcl@newdb auxiliary=sys/hcl@AUX

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Oct 1 19:16:46 2007

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

connected to target database: NEWDB (DBID=2873463223)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
[oracle@infra ~]$

Report message to a moderator

Re: ora-01031 [message #271316 is a reply to message #271309]

Mon, 01 October 2007 04:36

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

babu.knb@gmail.com

Send me your whole script (i need entire script step by step)

Babu

Report message to a moderator

Re: ora-01031 [message #271318 is a reply to message #271305]

Mon, 01 October 2007 05:02

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

am attaching the newdb(source database) and AUXDB (auxiliary database) detailed script.
please look after that and provide me a solution.
operating system which am using is RHEL 4.0

Attachment: Details.rar
(Size: 3.05KB, Downloaded 1390 times)

Report message to a moderator

Re: ora-01031 [message #271346 is a reply to message #271318]

Mon, 01 October 2007 06:57

NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad

Member

aravind, try this out from the the system having aux instance

export $ORACLE_SID=aux


rman target sys/hcl@newdb auxiliary /

Report message to a moderator

Re: ora-01031 [message #271349 is a reply to message #271305]

Mon, 01 October 2007 07:10

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

thanks a lot nandakumar,now aux is got connected,but when am using duplicate command,its showing

RMAN> run {
2> allocate auxiliary channel t1 type disk;
3> allocate auxiliary channel t2 type disk;
4> allocate auxiliary channel t3 type disk;
5> duplicate target database to AUX;
6> }

allocated channel: t1
channel t1: sid=155 devtype=DISK

allocated channel: t2
channel t2: sid=154 devtype=DISK

allocated channel: t3
channel t3: sid=153 devtype=DISK

Starting Duplicate Db at 01-OCT-07
released channel: t1
released channel: t2
released channel: t3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/01/2007 21:58:08
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename /new/oracle/product/db/oradata/newdb/users01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary filename /new/oracle/product/db/oradata/newdb/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary filename /new/oracle/product/db/oradata/newdb/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary filename /new/oracle/product/db/oradata/newdb/system01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary filename /new/oracle/product/db/oradata/newdb/redo03.log conflicts with a file used by the target database
RMAN-05001: auxiliary filename /new/oracle/product/db/oradata/newdb/redo02.log conflicts with a file used by the target database
RMAN-05001: auxiliary filename /new/oracle/product/db/oradata/newdb/redo01.log conflicts with a file used by the target database

RMAN>

wheather i want to change the source database file names?

Report message to a moderator

Re: ora-01031 [message #271354 is a reply to message #271349]

Mon, 01 October 2007 07:19

NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad

Member

aravind, did you use db_file_name_convert and log_file_name_convert parameters in the pfile ? If not set them, and try again.

[Updated on: Mon, 01 October 2007 07:21]

Report message to a moderator

Re: ora-01031 [message #271355 is a reply to message #271305]

Mon, 01 October 2007 07:24

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

am using the same path which i was using in source database(newdb),so is it necessary to create db_file_name_convert?

Report message to a moderator

Re: ora-01031 [message #271358 is a reply to message #271355]

Mon, 01 October 2007 07:34

NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad

Member

in that case add nofilenamecheck at the end of duplicate target database command.

Report message to a moderator

Re: ora-01031 [message #271366 is a reply to message #271305]

Mon, 01 October 2007 07:53

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

ya i found out that but am facing this issue now.
just say me wheather i want to create flash_recovery_area in AUXILIARY database?

RMAN> run {
2> allocate auxiliary channel t1 type disk;
3> allocate auxiliary channel t2 type disk;
4> allocate auxiliary channel t3 type disk;
5> duplicate target database to AUX nofilenamecheck;
6> }

using target database control file instead of recovery catalog
allocated channel: t1
channel t1: sid=155 devtype=DISK

allocated channel: t2
channel t2: sid=154 devtype=DISK

allocated channel: t3
channel t3: sid=153 devtype=DISK

Starting Duplicate Db at 01-OCT-07

contents of Memory Script:
{
set until scn 807390;
set newname for datafile 1 to
"/new/oracle/product/db/oradata/newdb/system01.dbf";
set newname for datafile 2 to
"/new/oracle/product/db/oradata/newdb/undotbs01.dbf";
set newname for datafile 3 to
"/new/oracle/product/db/oradata/newdb/sysaux01.dbf";
set newname for datafile 4 to
"/new/oracle/product/db/oradata/newdb/users01.dbf";
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 01-OCT-07

channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /new/oracle/product/db/oradata/newdb/system01.dbf
restoring datafile 00002 to /new/oracle/product/db/oradata/newdb/undotbs01.dbf
restoring datafile 00003 to /new/oracle/product/db/oradata/newdb/sysaux01.dbf
restoring datafile 00004 to /new/oracle/product/db/oradata/newdb/users01.dbf
channel t1: reading from backup piece /new/oracle/product/db/database/flash_reco
very_area/NEWDB/backupset/2007_10_02/o1_mf_nnndf_TAG20071002T053639_3j32whxo_.bk
p
ORA-19870: error reading backup piece /new/oracle/product/db/database/flash_reco
very_area/NEWDB/backupset/2007_10_02/o1_mf_nnndf_TAG20071002T053639_3j32whxo_.bk
p
ORA-19505: failed to identify file "/new/oracle/product/db/database/flash_recove
ry_area/NEWDB/backupset/2007_10_02/o1_mf_nnndf_TAG20071002T053639_3j32whxo_.bkp"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information:
failover to previous backup

channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /new/oracle/product/db/oradata/newdb/system01.dbf
restoring datafile 00002 to /new/oracle/product/db/oradata/newdb/undotbs01.dbf
restoring datafile 00003 to /new/oracle/product/db/oradata/newdb/sysaux01.dbf
restoring datafile 00004 to /new/oracle/product/db/oradata/newdb/users01.dbf
channel t1: reading from backup piece /new/oracle/product/db/database/flash_reco
very_area/NEWDB/backupset/2007_10_01/o1_mf_nnndf_TAG20071001T231745_3j2dp1dp_.bk
p
ORA-19870: error reading backup piece /new/oracle/product/db/database/flash_reco
very_area/NEWDB/backupset/2007_10_01/o1_mf_nnndf_TAG20071001T231745_3j2dp1dp_.bk
p
ORA-19505: failed to identify file "/new/oracle/product/db/database/flash_recove
ry_area/NEWDB/backupset/2007_10_01/o1_mf_nnndf_TAG20071001T231745_3j2dp1dp_.bkp"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information:
failover to previous backup

released channel: t1
released channel: t2
released channel: t3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/01/2007 22:33:29
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>

Report message to a moderator

Re: ora-01031 [message #271371 is a reply to message #271366]

Mon, 01 October 2007 08:06

NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad

Member

copy the backup from newdb to the same location in the system having the aux instance

Report message to a moderator

Re: ora-01031 [message #271809 is a reply to message #271305]

Wed, 03 October 2007 01:12

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

when am trying to duplicate the target database am facing the following error.please provide me a solution.

RMAN> run {
2> allocate auxiliary channel t1 type disk;
3> allocate auxiliary channel t2 type disk;
4> allocate auxiliary channel t3 type disk;
5> duplicate target database to AUX nofilenamecheck;
6> }

allocated channel: t1
channel t1: sid=155 devtype=DISK

allocated channel: t2
channel t2: sid=154 devtype=DISK

allocated channel: t3
channel t3: sid=153 devtype=DISK

Starting Duplicate Db at 03-OCT-07

contents of Memory Script:
{
set until scn 816923;
set newname for datafile 1 to
"/new/oracle/product/db/oradata/newdb/system01.dbf";
set newname for datafile 2 to
"/new/oracle/product/db/oradata/newdb/undotbs01.dbf";
set newname for datafile 3 to
"/new/oracle/product/db/oradata/newdb/sysaux01.dbf";
set newname for datafile 4 to
"/new/oracle/product/db/oradata/newdb/users01.dbf";
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 03-OCT-07

channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /new/oracle/product/db/oradata/newdb/system01.dbf
restoring datafile 00002 to /new/oracle/product/db/oradata/newdb/undotbs01.dbf
restoring datafile 00003 to /new/oracle/product/db/oradata/newdb/sysaux01.dbf
restoring datafile 00004 to /new/oracle/product/db/oradata/newdb/users01.dbf
channel t1: reading from backup piece /new/oracle/product/db/database/flash_recovery_area/NEWDB/backupset/2007_10_03/o1_mf_nnndf_TAG20071003T230959_3j7nzj9y_.bkp
ORA-19870: error reading backup piece /new/oracle/product/db/database/flash_recovery_area/NEWDB/backupset/2007_10_03/o1_mf_nnndf_TAG20071003T230959_3j7nzj9y_.bkp
ORA-19505: failed to identify file "/new/oracle/product/db/database/flash_recovery_area/NEWDB/backupset/2007_10_03/o1_mf_nnndf_TAG20071003T230959_3j7nzj9y_.bkp"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information:
failover to previous backup

channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /new/oracle/product/db/oradata/newdb/system01.dbf
restoring datafile 00002 to /new/oracle/product/db/oradata/newdb/undotbs01.dbf
restoring datafile 00003 to /new/oracle/product/db/oradata/newdb/sysaux01.dbf
restoring datafile 00004 to /new/oracle/product/db/oradata/newdb/users01.dbf
channel t1: reading from backup piece /new/oracle/product/db/database/flash_recovery_area/NEWDB/backupset/2007_10_03/o1_mf_nnndf_TAG20071003T222421_3j7l9xhw_.bkp
ORA-19870: error reading backup piece /new/oracle/product/db/database/flash_recovery_area/NEWDB/backupset/2007_10_03/o1_mf_nnndf_TAG20071003T222421_3j7l9xhw_.bkp
ORA-19505: failed to identify file "/new/oracle/product/db/database/flash_recovery_area/NEWDB/backupset/2007_10_03/o1_mf_nnndf_TAG20071003T222421_3j7l9xhw_.bkp"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information:
failover to previous backup

channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /new/oracle/product/db/oradata/newdb/system01.dbf
restoring datafile 00002 to /new/oracle/product/db/oradata/newdb/undotbs01.dbf
restoring datafile 00003 to /new/oracle/product/db/oradata/newdb/sysaux01.dbf
restoring datafile 00004 to /new/oracle/product/db/oradata/newdb/users01.dbf
channel t1: reading from backup piece /new/oracle/product/db/database/flash_recovery_area/NEWDB/backupset/2007_10_02/o1_mf_nnndf_TAG20071002T060933_3j34t5gy_.bkp
ORA-19870: error reading backup piece /new/oracle/product/db/database/flash_recovery_area/NEWDB/backupset/2007_10_02/o1_mf_nnndf_TAG20071002T060933_3j34t5gy_.bkp
ORA-19505: failed to identify file "/new/oracle/product/db/database/flash_recovery_area/NEWDB/backupset/2007_10_02/o1_mf_nnndf_TAG20071002T060933_3j34t5gy_.bkp"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information:
failover to previous backup

released channel: t1
released channel: t2
released channel: t3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/03/2007 16:09:20
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>

Report message to a moderator

Re: ora-01031 [message #271860 is a reply to message #271809]

Wed, 03 October 2007 03:24

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

babu.knb@gmail.com

1. Set oracle_sid=newdb

2. rman target=sys/oracle@newdb

3. run
{
backup database;
backup archivelog all;
}

4. Set oracle_sid=Aux

5.

RMAN> run {
allocate auxiliary channel t1 type disk;
allocate auxiliary channel t2 type disk;
allocate auxiliary channel t3 type disk;
duplicate target database to AUX ;
}

Try and let me know....

Report message to a moderator

Re: ora-01031 [message #271870 is a reply to message #271305]

Wed, 03 October 2007 04:00

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

thanks babu,
i had done what u had said but still am facing the same error.

tell me babu wheather i want to create flash_recovery_area in AUX?

i facing this problem for the last 2 days,
i had crosscheck my backup and archive log also.
but still am facing the same error.
provide me a solution for this

Attachment: ERROR.rtf
(Size: 6.16KB, Downloaded 1774 times)

Report message to a moderator

Re: ora-01031 [message #271891 is a reply to message #271870]

Wed, 03 October 2007 05:19

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

babu.knb@gmail.com

In your source database backup available ??? If available post here.

Set orale_sid=newdb

rmna target=sys/ora@newdbd

rman> list backup

Report message to a moderator

Re: ora-01031 [message #272485 is a reply to message #271891]

Fri, 05 October 2007 04:17

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

babu.knb@gmail.com

Aravind,

I re-solve your issue.

Report message to a moderator

Previous Topic:	delete input in RMAN
Next Topic:	Export With DBMS_JOB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 19:08:53 CST 2024