RE: rman question
Date: Wed, 27 Jul 2011 10:48:33 +0800
Message-ID: <B50E89E32AE9D848BC2DC93BD744308DF2ED4A_at_HKJUMXMB107B.zone1.scb.net>
If you don't have ARCHIVELOG mode, all your backups are "Consistent" backups made when the database is MOUNTed but not OPEN.
Your restore and recovery scenario practice must also include the case where you have also lost the controlfile. How you restore the controlfile depends on how you backup (or autobackup) the controlfile. The controlfile must be available and database MOUNTed before you can do a RESTORE DATABASE.
(of course the final question is : WHY you don't have ARCHIVELOG mode enabled ? there are situations where a database is left in NOARCHIVELOG mode but that must be a conscious decision after understanding all the ramifications).
Hemant K Chitale
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zelli, Brian
Sent: Wednesday, July 27, 2011 5:41 AM
To: Niall Litchfield
Cc: oracle-l_at_freelists.org
Subject: RE: rman question
Since we don't archive log on this database, I believe a restore will do it. I just took the Oracle 11g admin class part II which dealt with rman but a lot from the em standpoint. Plus we were on windows and the manual was unix. My db's are on unix so I was ok with it. In the past I did mostly unix scripted backups so I am familiar with all things oracle, just not as versed on rman as I wish. Hence the class......... We did practice recovery and restore.
From: Niall Litchfield [niall.litchfield_at_gmail.com] Sent: Tuesday, July 26, 2011 4:40 PM
To: Zelli, Brian
Cc: oracle-l_at_freelists.org
Subject: Re: rman question
Essentially yes. You *may* I doubt it in your case not have picked up on the distinction of restore (when you need to pull back files from the backups) and recovery (application of archived redo). RECOVER will not do the restore part - except where archive logs are not on disk, and RESTORE will not do the recover bit. So for complete restore and recovery you will need
RESTORE <DATABASE|DATAFILE>;
RECOVER <DATABASE|DATAFILE>;
These will use the most recent appropriate available backups (including incrementals) to attempt a complete recovery.
On 26 Jul 2011 19:23, "Zelli, Brian"
<Brian.Zelli_at_roswellpark.org<mailto:Brian.Zelli_at_roswellpark.org>> wrote:
So I've been putzing around with rman and now I have a list of backups. If I want to restore the very last copy of the db, all I have to do is issue a:
RMAN> recover database;
that's it? And it will take that last copy even though I have about 7 or 8 listed?
ciao,
Brian
This email and any attachments are confidential and may also be privileged. If you are not the addressee, do not disclose, copy, circulate or in any other way use or rely on the information contained in this email or any attachments. If received in error, notify the sender immediately and delete this email and any attachments from your system. Emails cannot be guaranteed to be secure or error free as the message and any attachments could be intercepted, corrupted, lost, delayed, incomplete or amended. Standard Chartered PLC and its subsidiaries do not accept liability for damage caused by this email or any attachments and may monitor email traffic.
Standard Chartered PLC is incorporated in England with limited liability under company number 966425 and has its registered office at 1 Aldermanbury Square, London, EC2V 7SB.
Standard Chartered Bank ("SCB") is incorporated in England with limited liability by Royal Charter 1853, under reference ZC18. The Principal Office of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In the United Kingdom, SCB is authorised and regulated by the Financial Services Authority under FSA register number 114276.
If you are receiving this email from SCB outside the UK, please click http://www.standardchartered.com/global/email_disclaimer.html to refer to the information on other jurisdictions.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 26 2011 - 21:48:33 CDT