Home » RDBMS Server » Backup & Recovery » ora-01031
ora-01031 [message #271305] Mon, 01 October 2007 03:53 Go to next message
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
Re: ora-01031 [message #271306 is a reply to message #271305] Mon, 01 October 2007 03:57 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

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

Babu
Re: ora-01031 [message #271307 is a reply to message #271305] Mon, 01 October 2007 04:02 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
source database name is-----newdb

target database name is(auxiliary)----AUX
Re: ora-01031 [message #271308 is a reply to message #271307] Mon, 01 October 2007 04:15 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


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


Try and let me know
Re: ora-01031 [message #271309 is a reply to message #271305] Mon, 01 October 2007 04:19 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
ya i had tried that also but am getting the same error.

Re: ora-01031 [message #271315 is a reply to message #271305] Mon, 01 October 2007 04:35 Go to previous messageGo to next message
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 ~]$
Re: ora-01031 [message #271316 is a reply to message #271309] Mon, 01 October 2007 04:36 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


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

Babu
Re: ora-01031 [message #271318 is a reply to message #271305] Mon, 01 October 2007 05:02 Go to previous messageGo to next message
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 249 times)
Re: ora-01031 [message #271346 is a reply to message #271318] Mon, 01 October 2007 06:57 Go to previous messageGo to next message
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 /


Re: ora-01031 [message #271349 is a reply to message #271305] Mon, 01 October 2007 07:10 Go to previous messageGo to next message
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?
Re: ora-01031 [message #271354 is a reply to message #271349] Mon, 01 October 2007 07:19 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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?
Re: ora-01031 [message #271358 is a reply to message #271355] Mon, 01 October 2007 07:34 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
in that case add nofilenamecheck at the end of duplicate target database command.
Re: ora-01031 [message #271366 is a reply to message #271305] Mon, 01 October 2007 07:53 Go to previous messageGo to next message
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>
Re: ora-01031 [message #271371 is a reply to message #271366] Mon, 01 October 2007 08:06 Go to previous messageGo to next message
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
Re: ora-01031 [message #271809 is a reply to message #271305] Wed, 03 October 2007 01:12 Go to previous messageGo to next message
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>
Re: ora-01031 [message #271860 is a reply to message #271809] Wed, 03 October 2007 03:24 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


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....
Re: ora-01031 [message #271870 is a reply to message #271305] Wed, 03 October 2007 04:00 Go to previous messageGo to next message
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 330 times)
Re: ora-01031 [message #271891 is a reply to message #271870] Wed, 03 October 2007 05:19 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


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

Set orale_sid=newdb

rmna target=sys/ora@newdbd

rman> list backup

Re: ora-01031 [message #272485 is a reply to message #271891] Fri, 05 October 2007 04:17 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Aravind,

I re-solve your issue.
Previous Topic: delete input in RMAN
Next Topic: Export With DBMS_JOB
Goto Forum:
  


Current Time: Thu Dec 08 10:44:08 CST 2016

Total time taken to generate the page: 0.09180 seconds