RMAN restore of full backup fails completely
Andreas Zimmermann
after searching for a hint to solve this problem for quite some time, I
thought I might try it here to get help - I am a RMAN novice, so please
excuse me seeming uninformed or plain dumb, but since this is a production
problem posting instead of reading to even more material than I already did
and trying around more is not really an option.
Situation:
We have servers (DELL 2650, 6 disks, 12 GB RAM) both running CentOS 5
(Redhat) & Oracle 10gR2. Both servers are set up the same way (and running 4
instances each - 2 production, 1 development, 1 reporting) with one being
the production server (the 2 production instances up & running in archivelog
mode connected to our web application) and one the development / reporting
server. Overnight the production data is automatically restored to the 'warm
backup' server (via RMAN full / cumulative backups & archivelogs) to have a
somewhat actual failover in case of emergency and for reporting. After a
disk failure on the production server we actually had to switch over and
everything worked fine up to that point: restored the last cumulative backup
and recovered to the last archived log ... so far so good. Now that the
other server has new disks and is back in business I wanted to set it up as
'warm backup' again but unfortunately I ran into problems that I neither
understand nor can solve (which is a result of not understanding what's
happening obviously). Here is what I try to do:
1. Take a full (online) backup of the production instance(s) via RMAN using
one of the following scripts (i tried both full backup & cumulative lvl 0)
-- script 1
run{
backup database;
sql 'alter system archive log current';
backup archivelog all;
}
exit;
-- script 2
run{
backup incremental level 0 cumulative device type disk tag
'daily_incr_backup_lvl_0' database include current controlfile;
sql 'alter system archive log current';
backup device type disk tag 'archivelog_backup' archivelog all not backed up
delete all input;
crosscheck backupset;
crosscheck archivelog all;
delete noprompt obsolete device type disk;
}
exit;
2. Copy all the files generated over to the apropriate path in the Flash
Recovery Area of the warm backup server (via sync)
3. Try to restore & recover those backups on the repaired warm backup server
using our original restore script which worked fine (e.g. for the emergency
switch / restore / recover) - resulting in the following error msg or a
similar one (here is the logfile that is generated by my script):
[oracle@wd-db-05 log]$ more 20081118-234000-RESTOREANDRECOVER-IBS.log
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Nov 18 23:40:00
2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: IBS (DBID=507845374, not open)
RMAN> run{shutdown immediate;
2> startup nomount;
3> restore controlfile from autobackup;
4> alter database mount;
5> restore database;
6> recover database;
7> alter database open resetlogs;
8> }
9> exit;
using target database control file instead of recovery catalog
database dismounted
Oracle instance shut down
connected to target database (not started)
Oracle instance started
Total System Global Area 2147483648 bytes
Fixed Size 1220460 bytes
Variable Size 268435604 bytes
Database Buffers 1862270976 bytes
Redo Buffers 15556608 bytes
Starting restore at 18-NOV-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=322 devtype=DISK
recovery area destination: /var/log/oracle/Flash_Recovery_Area/IBS
database name (or database unique name) used for search: IBS
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/autobackup/2008_11_18/o1_mf_s_671153040_4l78qkb3_.
bkp
channel ORA_DISK_1: control file restore from autobackup complete
output filename=/local/oracle/IBS/ibs/control01.ctl
output filename=/local/oracle/IBS/ibs/control02.ctl
output filename=/local/oracle/IBS/ibs/control03.ctl
Finished restore at 18-NOV-08
database mounted
released channel: ORA_DISK_1
Starting restore at 18-NOV-08
Starting implicit crosscheck backup at 18-NOV-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=322 devtype=DISK
Crosschecked 46 objects
Finished implicit crosscheck backup at 18-NOV-08
Starting implicit crosscheck copy at 18-NOV-08
using channel ORA_DISK_1
Finished implicit crosscheck copy at 18-NOV-08
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15696_4l4q0zt0_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15697_4l4qx49f_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15698_4l4rsg0c_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15699_4l4solol_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15700_4l4tkq54_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15701_4l4vg14f_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15702_4l4wb5qw_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15703_4l4x69wt_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15704_4l4y2n7s_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15705_4l4yyxwm_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15706_4l4zv2mp_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15707_4l50q7ds_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15708_4l51mhsb_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15709_4l52hn1x_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15710_4l53ctjs_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15711_4l54847d_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15712_4l554fxt_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15713_4l560lnt_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15714_4l56wqcd_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15715_4l57rwbk_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15716_4l58o16s_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15717_4l59k603_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15718_4l5bflcb_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15719_4l5c9y03_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15720_4l5d61hp_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15721_4l5f2799_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15722_4l5fyjy6_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15723_4l5gtood_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15724_4l5hptbh_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15725_4l5jm41c_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15726_4l5kh8pf_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15727_4l5lcfy9_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15728_4l5m7g99_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15729_4l5n3lhg_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15730_4l5nzqlw_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15731_4l5ow3jz_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15732_4l5prcmo_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15733_4l5qnkjt_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15734_4l5rjpnw_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15735_4l5sdvgw_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15736_4l5t9540_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15737_4l5v59sx_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15738_4l5w1gmn_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15739_4l5wxm96_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15740_4l5xsx6n_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15741_4l5yp3wx_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15742_4l5zl8mq_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15743_4l60gf7r_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15744_4l61bpx8_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15745_4l626x94_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15746_4l6332xr_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15747_4l63z7j9_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15748_4l64vkb6_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15749_4l65qox7_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15750_4l66mtly_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15751_4l67hz7w_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/archivelog/2008_11_18/o1_mf_1_15528_4l69ljd1_.arc
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/backupset/2008_11_18/o1_mf_ncnn0_DAILY_FULL_BACKUP_LV_4l4pwljw_.bkp
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/backupset/2008_11_18/o1_mf_annnn_ARCHIVELOG_BACKUP_4l4px0rb_.bkp
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/backupset/2008_11_18/o1_mf_annnn_ARCHIVELOG_BACKUP_4l4pxld9_.bkp
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/backupset/2008_11_18/o1_mf_annnn_ARCHIVELOG_BACKUP_4l4py39t_.bkp
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/autobackup/2008_11_18/o1_mf_s_671069235_4l4pwmt6_.bkp
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/autobackup/2008_11_18/o1_mf_s_671069298_4l4pylw5_.bkp
File Name:
/var/log/oracle/Flash_Recovery_Area/IBS/IBS/autobackup/2008_11_18/o1_mf_s_671153040_4l78qkb3_.bkp
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/18/2008 23:40:28
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
Recovery Manager complete.
Searching for a solution I found out that I can make the DB work rebuilding
the controlfile from trace but that will not recover the data to the point
in time it should (afaik), so that does not really help me.
I don't really know why this is not working, since I take a full backup and
just try to restore / recover it to get a 'baseline' on the backup server -
is there anything I am missing or doing wrong or is there another constraint
that I just miss out on ?! What can I do to finally establish RMAN backups
again ?!
Any idea, tip or help would be greatly appreciated - thanks in advance !
Kind regards
Andy
sybr...@hccnet.nl
Andy, I'm just guessing here, so here goes
1 You are not using a catalog database.
2 You might have autobackup controlfile on, but it is not obvious
3 Your autobackup has been made *prior* to the backup!
Ie the autobackup is made when datafile 0 is included in the
backupset, datafile 0 is the SYSTEM tablespace
Using
backup database plus archivelog
the autobackup is made *after* the backup, so the backup is in the
controlfile subsituting the catalog
5 Your controlfile is too old, and you are asking for *complete*
recovery, implying your controlfile is current.
6 As your controlfile is not current the only thing you can do is
*incomplete* recovery, and open the database with resetlogs.
After you have gone through this, please correct your *first* backup
script. The second is executing too many superfluous statements.
Hth
--
Sybrand Bakker
Senior Oracle DBA
joel garry
wrote:
> Hi,
>
> after searching for a hint to solve this problem for quite some time, I
> thought I might try it here to get help - I am a RMAN novice, so please
> excuse me seeming uninformed or plain dumb, but since this is a production
> problem posting instead of reading to even more material than I already did
> and trying around more is not really an option.
>
> Situation:
>
> We have servers (DELL 2650, 6 disks, 12 GB RAM) both running CentOS 5
> (Redhat) & Oracle 10gR2. Both servers are set up the same way (and running 4
> instances each - 2 production, 1 development, 1 reporting) with one being
> the production server (the 2 production instances up & running in archivelog
> mode connected to our web application) and one the development / reporting
> server. Overnight the production data is automatically restored to the 'warm
> backup' server (via RMAN full / cumulative backups & archivelogs) to have a
> somewhat actual failover in case of emergency and for reporting. After a
> disk failure on the production server we actually had to switch over and
> everything worked fine up to that point: restored the last cumulative backup
> and recovered to the last archived log ... so far so good. Now that the
> other server has new disks and is back in business I wanted to set it up as
> 'warm backup' again but unfortunately I ran into problems that I neither
> understand nor can solve (which is a result of not understanding what's
> happening obviously). Here is what I try to do:
Unscientific wild-ass guess here: check the docs about incarnations
and orphaned backups. I'm wondering if somewhere in all this you did
a flashback or recovery or read-only or something that made those 4
data files strange as far as RMAN is concerned. LIST INCARNATION, v
$datafile, alert log and the backup logs may provide clues.
jg
--
@home.com is bogus.
Bollards^H^H^H^Hocks
http://www.manchestereveningnews.co.uk/news/s/1077703_call_for_bollards_inquiry
DA Morgan
> Unscientific wild-ass guess here:
http://www.battleagainstanyguess.com/baag/
Sorry ... I couldn't resist.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
joel garry
> joel garry wrote:
> > Unscientific wild-ass guess here:
>
> http://www.battleagainstanyguess.com/baag/
> Sorry ... I couldn't resist.
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> Puget Sound Oracle Users Groupwww.psoug.org
There must be a joke about ugliness here somewhere... :-)
If it were a _scientific_ wild-ass guess, it would be... a hypothesis!
jg
--
@home.com is bogus.
Shakespeare
Something like http://www.dba-oracle.com/images/redneck_mentor.jpg I GUESS?
(and yes, the guy on the left IS DKB!)
Shakespeare
Andreas Zimmermann
>
> 1 You are not using a catalog database.
> 2 You might have autobackup controlfile on, but it is not obvious
> 3 Your autobackup has been made *prior* to the backup!
> Ie the autobackup is made when datafile 0 is included in the
> backupset, datafile 0 is the SYSTEM tablespace
> Using
> backup database plus archivelog
> the autobackup is made *after* the backup, so the backup is in the
> controlfile subsituting the catalog
> 5 Your controlfile is too old, and you are asking for *complete*
> recovery, implying your controlfile is current.
> 6 As your controlfile is not current the only thing you can do is
> *incomplete* recovery, and open the database with resetlogs.
>
> After you have gone through this, please correct your *first* backup
> script. The second is executing too many superfluous statements.
>
> Hth
> --
> Sybrand Bakker
> Senior Oracle DBA
Hi Sybrand,
thanks for the quick response ...
1. Yes, we don't use a catalog DB, just the controlfile
2. Yes, autobackup for controlfiles is on
3. I did a full online backup using your suggested command 'backup database
plus archivelog', when i try a restore on the other server however, the
result is not really different :( ... in addition I issued a 'list
backupset' which shows that the files should be there since they're clearly
in the backupset (by my understanding):
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Nov 22 13:19:27
2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: USERDB (DBID=3794760173)
RMAN> run{shutdown immediate;
2> startup nomount;
3> restore controlfile from autobackup;
4> alter database mount;
5> restore database;
6> recover database;
7> alter database open resetlogs;
8> }
9> exit;
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
connected to target database (not started)
Oracle instance started
Total System Global Area 2147483648 bytes
Fixed Size 1220460 bytes
Variable Size 218103956 bytes
Database Buffers 1912602624 bytes
Redo Buffers 15556608 bytes
Starting restore at 24-NOV-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=322 devtype=DISK
recovery area destination: /var/log/oracle/Flash_Recovery_Area/USERDB
database name (or database unique name) used for search: USERDB
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found:
/var/log/oracle/Flash_Recovery_Area/USERDB/USERDB/autobackup/2008_11_22/o1_mf_s_671457672_4ljl
79g8_.bkp
channel ORA_DISK_1: control file restore from autobackup complete
output filename=/local/oracle/UserDB/userdb/control01.ctl
output filename=/local/oracle/UserDB/userdb/control02.ctl
output filename=/local/oracle/UserDB/userdb/control03.ctl
Finished restore at 24-NOV-08
database mounted
released channel: ORA_DISK_1
For record type ARCHIVED LOG recids from 82 to 5946 are re-used before
resync
For record type BACKUP PIECE recids from 5 to 5893 are re-used before resync
For record type BACKUP SET recids from 5 to 5686 are re-used before resync
Starting restore at 24-NOV-08
Starting implicit crosscheck backup at 24-NOV-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=322 devtype=DISK
Crosschecked 52 objects
Finished implicit crosscheck backup at 24-NOV-08
Starting implicit crosscheck copy at 24-NOV-08
using channel ORA_DISK_1
Finished implicit crosscheck copy at 24-NOV-08
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name:
/var/log/oracle/Flash_Recovery_Area/USERDB/USERDB/autobackup/2008_11_22/o1_mf_s_671457672_4ljl79g8_.bkp
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/24/2008 13:02:06
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
Recovery Manager complete.
RMAN> list backupset;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6500 1.85G DISK 00:11:18 22-NOV-08
BP Key: 6688 Status: AVAILABLE Compressed: YES Tag:
TAG20081122T105607
Piece Name:
/var/log/oracle/Flash_Recovery_Area/USERDB/USERDB/backupset/2008_11_22/o1_mf_annnn_TAG20081122T105607_4ljgfbjr_.bkp
List of Archived Logs in backup set 6500
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
[...]
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6501 1.82G DISK 00:11:03 22-NOV-08
BP Key: 6689 Status: AVAILABLE Compressed: YES Tag:
TAG20081122T105607
Piece Name:
/var/log/oracle/Flash_Recovery_Area/USERDB/USERDB/backupset/2008_11_22/o1_mf_annnn_TAG20081122T105607_4ljh2w61_.bkp
List of Archived Logs in backup set 6501
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
[...]
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6502 Full 3.73G DISK 00:41:28 22-NOV-08
List of Datafiles in backup set 6502
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 240270500 22-NOV-08 /local/oracle/UserDB/userdb/system01.dbf
2 Full 240270500 22-NOV-08
/local/oracle/UserDB/userdb/undotbs01.dbf
3 Full 240270500 22-NOV-08 /local/oracle/UserDB/userdb/sysaux01.dbf
4 Full 240270500 22-NOV-08 /local/oracle/UserDB/userdb/users01.dbf
5 Full 240270500 22-NOV-08
/local/oracle/UserDB/userdb/userdb_data_01.dbf
6 Full 240270500 22-NOV-08
/local/oracle/UserDB/userdb/userdb_data_02.dbf
7 Full 240270500 22-NOV-08
/local/oracle/UserDB/userdb/userdb_data_03.dbf
8 Full 240270500 22-NOV-08
/local/oracle/UserDB/userdb/undotbs03.dbf
9 Full 240270500 22-NOV-08
/local/oracle/UserDB/userdb/undotbs02.dbf
11 Full 240270500 22-NOV-08
/local/oracle/UserDB/userdb/userdb_idx_01.dbf
12 Full 240270500 22-NOV-08
/local/oracle/UserDB/userdb/userdb_idx_02.dbf
13 Full 240270500 22-NOV-08
/local/oracle/UserDB/userdb/userdb_idx_03.dbf
Backup Set Copy #1 of backup set 6502
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:41:28 22-NOV-08 YES TAG20081122T111849
List of Backup Pieces for backup set 6502 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
6690 1 AVAILABLE
/var/log/oracle/Flash_Recovery_Area/USERDB/USERDB/backupset/2008_11_22/o1_mf_nnndf_TAG20081122T111849_4ljhqxfx_.bkp
6691 2 AVAILABLE
/var/log/oracle/Flash_Recovery_Area/USERDB/USERDB/backupset/2008_11_22/o1_mf_nnndf_TAG20081122T111849_4ljk1k1j_.bkp
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6503 85.08M DISK 00:00:39 22-NOV-08
BP Key: 6692 Status: AVAILABLE Compressed: YES Tag:
TAG20081122T120025
Piece Name:
/var/log/oracle/Flash_Recovery_Area/USERDB/USERDB/backupset/2008_11_22/o1_mf_annnn_TAG20081122T120025_4ljl5tg5_.bkp
List of Archived Logs in backup set 6503
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 263 240218120 22-NOV-08 240272074 22-NOV-08
1 264 240272074 22-NOV-08 240328208 22-NOV-08
1 265 240328208 22-NOV-08 240351234 22-NOV-08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6504 Full 9.70M DISK 00:00:00 22-NOV-08
BP Key: 6693 Status: AVAILABLE Compressed: NO Tag:
TAG20081122T120112
Piece Name:
/var/log/oracle/Flash_Recovery_Area/USERDB/USERDB/autobackup/2008_11_22/o1_mf_s_671457672_4ljl79g8_.bkp
Control File Included: Ckp SCN: 240352988 Ckp time: 22-NOV-08
SPFILE Included: Modification time: 22-NOV-08
4. The only way I can get the database 'back up' at that point is to
recreate the controlfile from trace and do a 'recover database until cancel'
with following alter database open resetlogs (which leaves me with totally
not up to date data at all of course)
5. As I said, I am a novice to RMAN and I might lack knowledge of basics -
unfortunately I do not really have the time to catch up right now (since
this is production) ... I do not understand why i can't restore from this
backup since it - according to the list - contains all needed data files but
nevertheless tells me that some of them are missing. Any idea how I actually
can make this backup / restore work again ?! Any way to tell RMAN to just
use those files (a restore from that specific backupset using it's tag did
not work eihter) ?!
Kind regards,
Andy
sybr...@hccnet.nl
<Soul...@nurfuerspam.de> wrote:
>5. As I said, I am a novice to RMAN and I might lack knowledge of basics -
>unfortunately I do not really have the time to catch up right now (since
>this is production) ... I do not understand why i can't restore from this
>backup since it - according to the list - contains all needed data files but
>nevertheless tells me that some of them are missing. Any idea how I actually
>can make this backup / restore work again ?! Any way to tell RMAN to just
>use those files (a restore from that specific backupset using it's tag did
>not work eihter) ?!
>
>Kind regards,
>
>Andy
Hi Andy,
Just a few guesses again.
In 9i the crucial part of a restore from the controlfile is
set dbid <id of the source database>
prior to the
restore autobackup
command.
It looks like you already have a target db, so you are trying to
overwrite a target db. The target db will have a *different* dbid, so
you are restoring the *wrong* controlfile.
What I would need you to do is
- confirm you have set up a target database with a different id
- make sure you use the
set dbid
command *prior* to restore autobackup!!!!!!! (the dbid is in the
backup log) (you can change the location where RMAN expects the
autobackup too, by using the set auto backup controlfile to...)
- make sure you have a *proper* autobackup made *after* the database
backup. Backup database plus archivelog will take care of this.
Just backup database will *not*
You can catalog backups in 10g RMAN.
However, if the dbid in the backups is different from the dbid in the
target database you seem to have, you can jump through the ceiling,
but it won't work.
Andreas Zimmermann
Hi Sybrand,
you're right, I try to overwrite the 'target database' on the second server,
however the DBIDs of both databases are identical (which is logical since
the one on 'db-06' - former backup server, now production - was a backup /
restore of db-05 - former production, now backup):
[oracle@wd-db-06 root]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Nov 24 16:19:52
2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: USERDB (DBID=3794760173)
---
[oracle@wd-db-05 ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Nov 24 16:18:36
2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: USERDB (DBID=3794760173)
So that is not the problem as far as I can say ... the same with having the
*proper* autobackup - since I used the command you suggested in your first
post for a new full online backup (with the restore failing in the same way
as mentioned before) ... :(
You say I can catalog backups in 10g RMAN ... what does that mean, how to do
it & could that possibly solve the problem ?!
Kind regards,
Andy
sybrandb
wrote:
>
> - Tekst uit oorspronkelijk bericht weergeven -
Hi Andy,
Reading the Matthew Hart RMAN book on your behalf I found there now is
restore controlfile autobackup from '<autobackup controlfile piece
name>'
I still think you are restoring the wrong controlfile.
You are using the FRA, and the correct controlfile apparently isn't in
the FRA.
You really need to ascertain whether those files are backed-up right
after the backup on the source server.
So far you never posted any backup log results, only big pieces on
junk pertaining to the restore. Not very helpful.
With respect to cataloguing backuppieces, I read the manuals on your
behalf and I came up with
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/maint007.htm#BRBSC204
In the past you needed to reproduce the entire source server directory
structure on the target server or it wouldn't work.
Now you can relocate backup-pieces.
Obviously you can also copy 'missing' backuppieces and catalog them
prior to the restore.
Somehow either your backup sucks, or you are restoring the wrong
controlfile.
As you seem not to follow my directions to the letter, you are
difficult to help, and this is evolving into free consultancy.
As I am not looking over your shoulder, and don't seem to be willing
to do any background reading yourself, it probably has to stop here.
Regards,
Andreas Zimmermann
>Regards,
---
Hi Sybrand,
first of all, thank you for all the time you invested trying to help me, I
really appreciate it. I understand that you don't want to waste more time on
doing so & that is ok, I somehow doubt that this has to be ended the way you
did though b/c it is rather unfriendly.
Just for the record:
1. As I mentioned I did the backup using your suggested command 'backup
database plus archivelog' which - according to you - will do exactly what
you said is needed to do (archiving the controlfile last) ... since there
was no error on the backup I did not post anything about it in order to not
make the posting even longer ... instead I posted stuff on the restore b/c
that is where the problem occurs (and I thought that would be the place you
can actually see where the root of the problem is - dumb me!). As a side
note: You could have mentioned that more information from the backup side
would help, I gladly would have come up with it ...
2. As I mentioned, both servers are identical - same OS, same Oracle
version, same databases & even the same directory structure down to the FRA
... this setup was chosen to avoid any file structure related problems. To
ensure the right backupsets are used, I deleted all other sets that were on
the backup machine which means the ONLY backups on there are the ones that
resulted from your command (which somehow eliminates any piossibility to
restore the 'wrong' controlfile unless I'm very much mistaken). In addition
the lateron issued 'list backupset' shows that all the files that I'd expect
to be there are actually listed - and with the list coming from the catalog
which in my case is located in the controlfile that somehow proves that the
controlfile 'should' be the right one (again, if I am not wrong).
3. About cataloguing, well, I tried the CATALOG RECOVERY AREA even before I
started posting (and it did not help), my question was more meant to make
sure that I did not miss anything that someone with more experience might
realize right away ... in fact - logically - I should not need any older /
other files from FRA using a fresh full backup for the restore anyways if
everything goes right (which it doesn't)
Frankly I do not really see where I did not follow your 'instructions' and I
repudiate your allegation to be just a lazy bum looking for an easy solution
for free without trying to help myself by reading - be sure I tried a lot
myself and read way more than I ever wanted to know about RMAN before I was
desperate eough to post here ... unfortunately I do have to take care of a
'few' more (SQL) servers in a 24/7/365 environment too so that my time to
'play around' with something that - originally - should just be standard
task in Oracle is somehow limited - given that I still want to sleep at
least the 4-5 hours I get atm or if I actually want to see my wife & kids
for a change.
Kind regards,
Andy