Home » RDBMS Server » Backup & Recovery » Unable to create auxiliary database thro RMAN (oracle 10.2.0.1.0 o/s: hp-ux 11.23 )
Unable to create auxiliary database thro RMAN [message #381495] Sat, 17 January 2009 05:20 Go to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

Dear sir,

Iam trying to create the auxiliary db for my target db thro rman..and getting the following error in RMAN prompt:

RMAN> connect auxiliary sys/oracle
connected to auxiliary database: AUX10 (not mounted)

RMAN> connect target sys/oracle@sbiwill10
connected to target database: SBIWILL1 (DBID=377898525)

RMAN> startup clone nomount force;
Oracle instance started

Total System Global Area 444596224 bytes

Fixed Size 1249464 bytes
Variable Size 130027336 bytes
Database Buffers 306184192 bytes
Redo Buffers 7135232 bytes

RMAN> duplicate target database to aux10;
..
..
iam getting below error:
executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 2009-01-17:16:51:53
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
using channel ORA_AUX_DISK_3

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/17/2009 16:51:54
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 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06100: no channel to restore a backup or copy of datafile 6
RMAN-06100: no channel to restore a backup or copy of datafile 5
RMAN-06100: no channel to restore a backup or copy of datafile 4
RMAN-06100: no channel to restore a backup or copy of datafile 3
RMAN-06100: no channel to restore a backup or copy of datafile 2
RMAN-06100: no channel to restore a backup or copy of datafile 1

RMAN>


further i checked, REPORT NEED BACKUP in rman prompt...
there is no records in the output.as per retention policy, i have min.no.of backups (i.e 1 copy )

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------

RMAN>


pls adv.

thank you,
kesavan.
Re: Unable to create auxiliary database thro RMAN [message #381502 is a reply to message #381495] Sat, 17 January 2009 07:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Where are you calling RMAN from?
If AUX is on another node, the
backupsets should be visible from another node.
NFS mount the /backup or ship them across.
Also try TSPITR.
DUPLICATE TARGET DATABASE TO DUP UNTIL TIME 'yourtime';

Re: Unable to create auxiliary database thro RMAN [message #381613 is a reply to message #381502] Mon, 19 January 2009 00:07 Go to previous messageGo to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

Dear sir,
Iam just try to create auxiliary db in my local machine only where my target db resides.

for my target db:
all my database files are kept in : D:\oracle\product\10.2.0\admin\SBIWILL10

for my auxiliary db
i have created one folder AUX10 same as abv , i.e : D:\oracle\product\10.2.0\admin\AUX10

my all backupset goes and get stored in below path:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'C:\RMAN_BACKUP\RB_%d_%t_%s_%p';
i.e. in c:/rman_backup - folder all my backup pieces are preseted...

now pls confirm, to which location i should move my target backup datas in order to create auxiliary database....as it looks "that place" for backp pieces to resotre when i run
DUPLICATE TARGET DATABASE TO AUX10;

pls guide me further.

thank you,
kesavan.




Re: Unable to create auxiliary database thro RMAN [message #381616 is a reply to message #381613] Mon, 19 January 2009 00:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmtroub.htm#i1007612
Re: Unable to create auxiliary database thro RMAN [message #381623 is a reply to message #381616] Mon, 19 January 2009 00:33 Go to previous message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member


DEAR SIR,
Thank you for giving trouble shooting doc...
I will try to resolve the same and get back to you in case of any queries.

thank you
kesavan.
Previous Topic: RMAN error - OS 64
Next Topic: Problem with backup
Goto Forum:
  


Current Time: Sat Dec 03 08:09:36 CST 2016

Total time taken to generate the page: 0.10499 seconds