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 fails with RMAN-03002 ORA-01180

DOAOct 31 2012 — edited Oct 31 2012
Hello all,

running 11.1.0.6.0 on linux (db_name oralive), heaving rman backup of the current db.

Created a new server installed 11.2.0.1.0 (db_name oratest) on same OS.

Is was installed and running OK

for restoring rman backup here on new sever followed stpes

1.stoped all services of oratest and removed all datafile.
2.export oracle_sid=oralive and nomount db.
3.connected rman target / (new server side)
4. restore control file from back piece usidn "RMAN> restore controlfile from '/rman_bkp/ctrl_c-4224751439-20111103-01’;"

5. alter database mount. (db mounted)

5.create script rest.sh as below to resote database:

rman nocatalog log=/u05/restore.log << EOF
connect target /
run {
allocate channel ch1 type disk;
set newname for datafile '/u01/system01.dbf' to '/u01/system01.dbf';
set newname for datafile '/u01/sysaux01.dbf' to '/u01/sysaux01.dbf';
set newname for datafile '/u01/users01.dbf' to '/u01//users01.dbf';
set newname for datafile '/u01/sysaux02.dbf' to '/u01/sysaux02.dbf';
set newname for datafile '/u01/UNDOTBS' to '/u01/UNDOTBS';
restore database;
Switch datafile all;
}
EOF


getting below error:

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Oct 31 11:18:20 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

RMAN>
connected to target database: ORALIVE (DBID=1588909009, not open)
using target database control file instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15>
allocated channel: ch1
channel ch1: SID=63 device type=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 31-OCT-12
Starting implicit crosscheck backup at 31-OCT-12
Crosschecked 8 objects
Finished implicit crosscheck backup at 31-OCT-12

Starting implicit crosscheck copy at 31-OCT-12
Crosschecked 400 objects
Finished implicit crosscheck copy at 31-OCT-12

searching for all files in the recovery area
cataloging files...
no files cataloged


creating datafile file number=1 name=/u01/system01.dbf
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/31/2012 11:18:29
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/u01/system01.dbf'

RMAN>

Recovery Manager complete.


checked backup peice permission heaving 777

can any body have somthing for me please ?

Thnks in ADV...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 28 2012
Added on Oct 31 2012
6 comments
1,206 views