I don't think that you can do a resetlogs before you have restored the database
files. Did you try restoring the files first and running the script as the last
step?
Cheers,
Tony
On 17 June 2017 4:59:39 AM AEST, Bob-W1TI <w1ti@xxxxxxxxxxx> wrote:
Not sure, but do you need to create the directory first
(/oradata01/SFINA021)
havent used rman in eons, but if this was generic cloning it would need
to be done.
bob
On 06/16/2017 02:45 PM, Lyall Barbour wrote:
Hi,file.
I feel like this is not as complicated as i'm making it.
Oracle 12.1.0.2
WHat i have: RMAN backup(s) of my database. I have the init.ora
trace file backup of the controlfilesARCHIVELOG
what i don't have: any datafiles, controlfiles, redo logs, etc.
I can mount the database, but when i try to create the controfiles
from the trace file, i get
CREATE CONTROLFILE SET DATABASE "BLAH" RESETLOGS FORCE LOGGING
*'/oradata01/SFINA021/SYSTEM.01.dbf'
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
which is very true. after i created the controlfiles and mounted the
database, i was going to RMAN and do a CATALOG START WITH, etc. and
restore...
Help? lol isn't this just a database cloning i'm essentially doing?
Lyall Barbour
-- //www.freelists.org/webpage/oracle-l ;