Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN Restore issue on RAC ASM

jkkstar inc.Nov 13 2008 — edited Nov 14 2008
Hello,

I'm trying to restore PROD (3 node RAC+ASM) into DEV(2 node RAC+ASM). I've created 3 diskgroups DSS1, STORE1, +REC1.

OMF parameter set to STORE1

During restore of datafiles, datafiles releated to STORE1 gets restored to STORE1, But datafiles releated to DSS1 doesn't gets restored in DSS1 instead
those gets restored in STORE1.

I'm using "set newname" for both DSS1 and STORE1. At this moment +STORE1 space is full.

Need your suggestions.


run{
allocate channel ch4 type 'SBT_TAPE' parms="ENV=(NB_ORA_CLIENT=pjssoldb01.backup)" ;
set newname for datafile 114 to '+DSS1/JSPSOL0/DATAFILE/dss_indexes.294.632137057' ;
set autolocate on;
set until time "to_date('01/11/2008 23:00:00','DD/MM/YYYY HH24:MI:SS')";
restore datafile 114 until time "to_date('01/11/2008 23:00:00','DD/MM/YYYY HH24:MI:SS')";
switch datafile 114 to copy;
release channel ch4;
}

allocated channel: ch4
channel ch4: sid=5457 instance=JSUSOL91 devtype=SBT_TAPE
channel ch4: VERITAS NetBackup for Oracle - Release 5.1 (2006040521)

executing command: SET NEWNAME

executing command: SET autolocate

executing command: SET until clause

Starting restore at 13-NOV-08

channel ch4: starting datafile backupset restore
channel ch4: specifying datafile(s) to restore from backup set
restoring datafile 00114 to +DSS1/jsusol90/datafile/dss_indexes.294.632137057
channel ch4: reading from backup piece lqjul0b2_1_1
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file <lqjul0b2_1_1>
ORA-19870: error reading backup piece lqjul0b2_1_1
ORA-19504: failed to create file "+STORE1"
ORA-17502: ksfdcre:4 Failed to create file +STORE1
ORA-15041: diskgroup space exhausted
failover to previous backup



Thanks,


kam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2008
Added on Nov 13 2008
5 comments
4,189 views