| Unable to create auxiliary database thro RMAN [message #381495] |
Sat, 17 January 2009 05:20  |
kesavansundaram
Messages: 183
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 #381613 is a reply to message #381502] |
Mon, 19 January 2009 00:07  |
kesavansundaram
Messages: 183
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
