Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rman issue

Status
Not open for further replies.

v1nsr

Technical User
Oct 4, 2012
50
QA
Hi 605,

we are getting the below error while trying to restore through RMAN , script and the error is below

creating datafile file number=1 name=/oradb3/PARISLIV/dbf/system01.dbf
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/28/2012 17:25:35
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/oradb1/PARISLIV/dbf/system01.dbf'

Recovery Manager complete.

oracle,PARISLIV [/scc/oracle/admin/rman_DR]>

***********************


#
# The DR rman script sends the backup to the DataDomain Pool.
run {
allocate channel t1 type 'SBT_TAPE'
parms 'ENV=(
NSR_SERVER=svr-blk-legato1,
NSR_CLIENT=svr-unx-hscare,
NSR_DATA_VOLUME_POOL=DataDomain)';
#
#
set newname for datafile '/oradb1/PARISLIV/dbf/system01.dbf' to '/oradb3/PARISLIV/dbf/system01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/sysaux01.dbf' to '/oradb3/PARISLIV/dbf/sysaux01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/undotbs01.dbf' to '/oradb3/PARISLIV/dbf/undotbs01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/users01.dbf' to '/oradb3/PARISLIV/dbf/users01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/scratch01.dbf' to '/oradb3/PARISLIV/dbf/scratch01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsa_audit01.dbf' to '/oradb3/PARISLIV/dbf/tsa_audit01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_assessment01.dbf' to '/oradb3/PARISLIV/dbf/tsi_assessment01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_careplan01.dbf' to '/oradb3/PARISLIV/dbf/tsi_careplan01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_client01.dbf' to '/oradb3/PARISLIV/dbf/tsi_client01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_finance01.dbf' to '/oradb3/PARISLIV/dbf/tsi_finance01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_inpatient01.dbf' to '/oradb3/PARISLIV/dbf/tsi_inpatient01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_lookup01.dbf' to '/oradb3/PARISLIV/dbf/tsi_lookup01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_meetmanage01.dbf' to '/oradb3/PARISLIV/dbf/tsi_meetmanage01.dbf' ;

set newname for datafile '/oradb1/PARISLIV/dbf/tsi_mentalhealth01.dbf' to '/oradb3/PARISLIV/dbf/tsi_mentalhealth01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_palmtops01.dbf' to '/oradb3/PARISLIV/dbf/tsi_palmtops01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_referral01.dbf' to '/oradb3/PARISLIV/dbf/tsi_referral01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_security01.dbf' to '/oradb3/PARISLIV/dbf/tsi_security01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_text01.dbf' to '/oradb3/PARISLIV/dbf/tsi_text01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_waitlists01.dbf' to '/oradb3/PARISLIV/dbf/tsi_waitlists01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_ch_campaigns01.dbf' to '/oradb3/PARISLIV/dbf/tsi_ch_campaigns01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_ch_general01.dbf' to '/oradb3/PARISLIV/dbf/tsi_ch_general01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsi_ch_results01.dbf' to '/oradb3/PARISLIV/dbf/tsi_ch_results01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_assessment01.dbf' to '/oradb3/PARISLIV/dbf/tst_assessment01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_careplan01.dbf' to '/oradb3/PARISLIV/dbf/tst_careplan01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_client01.dbf' to '/oradb3/PARISLIV/dbf/tst_client01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_finance01.dbf' to '/oradb3/PARISLIV/dbf/tst_finance01.dbf' ;

set newname for datafile '/oradb1/PARISLIV/dbf/tst_inpatient01.dbf' to '/oradb3/PARISLIV/dbf/tst_inpatient01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_lookup01.dbf' to '/oradb3/PARISLIV/dbf/tst_lookup01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_meetmanage01.dbf' to '/oradb3/PARISLIV/dbf/tst_meetmanage01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_mentalhealth01.dbf' to '/oradb3/PARISLIV/dbf/tst_mentalhealth01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_palmtops01.dbf' to '/oradb3/PARISLIV/dbf/tst_palmtops01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_referral01.dbf' to '/oradb3/PARISLIV/dbf/tst_referral01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_security01.dbf' to '/oradb3/PARISLIV/dbf/tst_security01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_text01.dbf' to '/oradb3/PARISLIV/dbf/tst_text01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_text_storage01.dbf' to '/oradb3/PARISLIV/dbf/tst_text_storage01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_waitlists01.dbf' to '/oradb3/PARISLIV/dbf/tst_waitlists01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_ch_campaigns01.dbf' to '/oradb3/PARISLIV/dbf/tst_ch_campaigns01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_ch_general01.dbf' to '/oradb3/PARISLIV/dbf/tst_ch_general01.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_ch_results01.dbf' to '/oradb3/PARISLIV/dbf/tst_ch_results01.dbf' ;

set newname for datafile '/oradb1/PARISLIV/dbf/tsa_audit02.dbf' to '/oradb3/PARISLIV/dbf/tsa_audit02.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsa_audit03.dbf' to '/oradb3/PARISLIV/dbf/tsa_audit03.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tsa_audit04.dbf' to '/oradb3/PARISLIV/dbf/tsa_audit04.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_text_storage02.dbf' to '/oradb3/PARISLIV/dbf/tst_text_storage02.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_text_storage03.dbf' to '/oradb3/PARISLIV/dbf/tst_text_storage03.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_text_storage04.dbf' to '/oradb3/PARISLIV/dbf/tst_text_storage04.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_text_storage05.dbf' to '/oradb3/PARISLIV/dbf/tst_text_storage05.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_text_storage06.dbf' to '/oradb3/PARISLIV/dbf/tst_text_storage06.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_text_storage07.dbf' to '/oradb3/PARISLIV/dbf/tst_text_storage07.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_text_storage08.dbf' to '/oradb3/PARISLIV/dbf/tst_text_storage08.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_text_storage09.dbf' to '/oradb3/PARISLIV/dbf/tst_text_storage09.dbf' ;
set newname for datafile '/oradb1/PARISLIV/dbf/tst_text_storage10.dbf' to '/oradb3/PARISLIV/dbf/tst_text_storage10.dbf' ;
#
#
restore database;
#
}
 
Hi v1nsr,

please do not address your threads to me personally - this is a forum.

Unfortunately, i cannot be very helpful as my Oracle experiences are very limited.
However, as these are Oracle errors, you should find more help if you look at the error codes.
It might be that this problem is access rights related.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top