RE: restore using rman

From: Chitale, Hemant K <Hemant-K.Chitale_at_sc.com>
Date: Fri, 17 Oct 2014 10:49:13 +0800
Message-ID: <0BDF2A25A09ADD40908745EEFC0A0FB6027D1036_at_HKJUMXMB103B.zone1.scb.net>

On Windows, you'd have to create the Service for the database instance before you do the Restore.  

You don't need to (pre)create a database - whether on Windows or Linux or Unix. You

1. install the RDBMS software to the same patchset level
2. create or copy the instance parameter file (if changing the controlfile location, database name, unique name, FRA etc update the parameter file)
3. STARTUP NOMOUNT
4. RESTORE CONTROLFILE
5. ALTER DATABASE MOUNT
6. RESTORE DATABASE (if changing datafile locations use SET NEWNAME)
7. RECOVER DATABASE

Hemant K Chitale    

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zelli, Brian Sent: Friday, October 17, 2014 1:11 AM
To: oracle-l (oracle-l_at_freelists.org) Subject: restore using rman  

ok, I have been backing up my database using rman. No catalog, no archivelogmode.

I now have a separate server with which to test a restore.

I loaded the oracle software.

Do I have to create a dummy database first so that I can mount it in order to start the restore?

I see things that reference rman commands in the book I am using. Do I have to create anything first using rman on this new server?  

I'm not quite sure what to start with. I have the controlfile, and other files. Just don't know how to recover/restore........  

Brian    

This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.

This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 17 2014 - 04:49:13 CEST