Restore/Recovery of HOT full backup.
First post to this board please be nice......
I am having extreme difficulty recovering a database instance from a Hot,Full backup.
For something that appears to be so simple is proving to be most difficult for some
reason (yea, I know what you are thinking). Yes, it is true, I am new to
Oracle and have no formal training at this point but I am working at it.
Level of experience (Two Weeks).
Please see below for a description of exactly what I am doing.
**************************************************************************
Facts:
Oracle Version: Oracle Release 9.2.0.3.0
OS : Linux 2.4.19-64GB-SMP
Type of Backup: Full Hot Backup using RMAN of a DB in archivelog mode.
Backup Script - begin
cp $ORACLE_HOME/dbs/spfile${1}.ora /backup/${1}/
connect target /;
configure controlfile autobackup off;
configure snapshot controlfile name to '/backup/${1}/snapcf_@.f';
configure channel device type disk maxpiecesize 1g format = '/backup/${1}/bkup_%U';
configure retention policy to redundancy 1;
crosscheck backup;
crosscheck archivelog all;
backup full database plus archivelog;
delete noprompt obsolete;
list backup of database;
exit;
Backup Script - End
After the backup is run, I verify and list the backup, here is some of the output:
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 337M DISK 00:02:20 11-NOV-03
BP Key: 2 Status: AVAILABLE Tag: TAG20031111T110530
Piece Name: /backup/nisc/bkup_02f65rfq_1_1
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 193369 11-NOV-03 /ora02/oradata/instanceTest/undotbs01.dbf
3 Full 193369 11-NOV-03 /ora02/oradata/instanceTest/drsys01.dbf
6 Full 193369 11-NOV-03 /ora02/oradata/instanceTest/users01.dbf
8 Full 193369 11-NOV-03 /ora03/oradata/instanceTest/CIS01.dbf
9 Full 193369 11-NOV-03 /ora04/oradata/instanceTest/CIS02.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 309M DISK 00:01:42 11-NOV-03
BP Key: 3 Status: AVAILABLE Tag: TAG20031111T110530
Piece Name: /backup/instanceTest/bkup_03f65rkc_1_1
SPFILE Included: Modification time: 11-NOV-03
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 193487 11-NOV-03 /ora02/oradata/instanceTest/system01.dbf
4 Full 193487 11-NOV-03 /ora02/oradata/instanceTest/indx01.dbf
5 Full 193487 11-NOV-03 /ora02/oradata/instanceTest/tools01.dbf
7 Full 193487 11-NOV-03 /ora02/oradata/instanceTest/xdb01.dbf
10 Full 193487 11-NOV-03 /ora03/oradata/instanceTest/CIS03.dbf
11 Full 193487 11-NOV-03 /ora04/oradata/instanceTest/CIST01.dbf
12 Full 193487 11-NOV-03 /ora04/oradata/instanceTest/NISCSYS01.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4 47K DISK 00:00:01 11-NOV-03
BP Key: 4 Status: AVAILABLE Tag: TAG20031111T110944
Piece Name: /backup/instanceTest/bkup_04f65rnp_1_1
List of Archived Logs in backup set 4
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 11 193366 11-NOV-03 193568 11-NOV-03
Everything appears to be included in the backup set.
Restore procedures
I then shutdown the instance and remove all files associated with the instance to simulate a major failure.
The I begin the restore process which is as follows:
RMAN> connect target /
connected to target database (not started)
RMAN> set DBID = 468787819;
executing command: SET DBID
RMAN> startup nomount;
connected to target database (not started)
Oracle instance started
Total System Global Area 319886088 bytes
Fixed Size 451336 bytes
Variable Size 268435456 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes
RMAN> restore controlfile from "/backup/instanceTest/bkup_03f65rkc_1_1";
Starting restore at 11-NOV-03
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=8 devtype=DISK
channel ORA_DISK_1: restoring controlfile
channel ORA_DISK_1: restore complete
replicating controlfile
input filename=/ora01/oradata/instanceTest/control01.ctl
output filename=/ora02/oradata/instanceTest/control02.ctl
output filename=/ora03/oradata/instanceTest/control03.ctl
Finished restore at 11-NOV-03
RMAN> startup mount;
database is already started
database mounted
RMAN> recover database;
Starting recover at 11-NOV-03
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/11/2003 14:36:13
RMAN-06094: datafile 1 must be restored
I have tried every variation of this that I can possibly think of:
I have tried restoring the snapshot control file and there seems
to be no difference. I would appreciate any input on what I may be doing wrong from start to finish.