John, i think the scenario here should be rare.
Restore from 2 backups ago, noarchivelogmode, open resetlogs since backup.
so we had to reset incarnation and it appears rman was confused because
of the current control file and old datafiles.
joe
[EMAIL PROTECTED] wrote:
>The controlfile get
And wouldn't that be the place you wanted to start if you were doing a PITR?
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 04, 2002 3:21 PM
On all of my 8.1.7 and below DB's I do a controlfile backup after the level
backup
On all of my 8.1.7 and below DB's I do a controlfile backup after the level backup and
archivelog all delete input is finished. I had problems cloning a database because
RMAN back's up the controlfile first and then does the level backup etc.
...JIM...
>>> [EMAIL PROTECTED] 10/4/02 8:53:27 AM
When you are doing point-in-time recovery you have to use the backup
controlfile anyway and start with a level 0 which has the backup controlfile
and roll forward using incrementals or just the archivelogs. I don't know
if this answers your question but I will be glad to try again with more
info.
I haven't really been following this thread closely but whenever you do a
level 0 rman backup it will include the controlfile. If you need to recover
to a point in time you can recover using backup controlfile to that point in
time.
HTH,
Ruth
- Original Message -
To: "Multiple recipients
The controlfile gets backed up automatically when you do a RMAN full backup.
I have been having a debate this morning regarding a situation where we do
weekly full backups using RMAN and and a daily RMAN "archivelog all delete
input".
I contend we should do a "archivelog all delete input INCLUDI
Here is an example from 8.1.7.4
oracle@loki:/orabak >rman nocatalog
Recovery Manager: Release 8.1.7.4.0 - Production
RMAN> connect target /
RMAN-06005: connected to target database: LIVL
(DBID=750735866)
RMAN-06009: using target database controlfile instead
of recovery catalog
RMAN> run {
2>
Connor, my problem(fault) was I didnt make a copy of the control
file(and in 8.1.7, you don't get it backed up by default like in 9i,
right?).
I attempted to bring the db in nomount and restore the control file,
rman reply "no controlfile backup found".
joe
Connor McDonald wrote:
>What fol
yea the last question was rhetorical, i'd forgotten to back up the
control file, a hole in my backup strategy.
joe
DENNIS WILLIAMS wrote:
>Joe - You da man. An impressive tour de force in working around RMAN. Was
>your last statement rhetorical? I think you answered that question - that
>you
What follows might be all hogwash, you could have
tried this:
DECLARE
devtype varchar2(256);
doneboolean;
BEGIN
devtype := dbms_backup_restore.deviceallocate('',
params=>'');
dbms_backup_restore.restoresetdatafile;
dbms_backup_restore.restorecontrolfileto('/tmp/foo.bar');
dbms_bac
Joe - You da man. An impressive tour de force in working around RMAN. Was
your last statement rhetorical? I think you answered that question - that
you didn't have the right control file. Impressive that you were able to
creatively work around the obvious limitation. This is the reason we test
rec
11 matches
Mail list logo