RE: rman question
- From: "Chitale, Hemant Krishnarao" <Hemant.Chitale@xxxxxx>
- To: <Brian.Zelli@xxxxxxxxxxxxxxx>
- Date: Wed, 27 Jul 2011 10:48:33 +0800
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Zelli, Brian
Sent: Wednesday, July 27, 2011 5:41 AM
To: Niall Litchfield
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx]
Sent: Tuesday, July 26, 2011 4:40 PM
To: Zelli, Brian
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxx<mailto:Brian.Zelli@xxxxxxxxxxxxxxx>> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
