Database Software

We are running Oracle 10.2.0.3, and I am practicing a Disaster Recovery restore, meaning that I do not want to use RMAN duplicate to get the destination database running. The test assumes that the source database has been destroyed, and we are attempting to restore the source database backups on a separate server running the same version of Oracle. Please note that we are not using a recovery catalog.

Here are the steps I've taken so far:

- Make a note of the source database dbid (3725550444)

- Copy the disk-based backups from the source server to the destination server (note that the control file backups are named cf_*)

ls -lrth $DBA_RMAN_BACKUP/drtest
.
.
.
-rw-r----- 1 oracle dba 274M Jul 27 01:27 df_INCR0_t661138018_s3653_p1
-rw-r----- 1 oracle dba 377M Jul 27 01:27 df_INCR0_t661138018_s3652_p1
-rw-r----- 1 oracle dba 403M Jul 27 01:27 df_INCR0_t661138017_s3651_p1
-rw-r----- 1 oracle dba 8.3M Jul 27 01:27 cf_c-3725550444-20080727-00
-rw-r----- 1 oracle dba 38K Jul 27 01:27 logs_t661138071_s3657_p1
-rw-r----- 1 oracle dba 2.5K Jul 27 01:27 logs_t661138071_s3658_p1
-rw-r----- 1 oracle dba 48M Jul 27 01:27 logs_t661138071_s3656_p1
-rw-r----- 1 oracle dba 95M Jul 27 01:27 logs_t661138071_s3655_p1
-rw-r----- 1 oracle dba 8.3M Jul 27 01:27 cf_c-3725550444-20080727-01
-rw-r----- 1 oracle dba 40K Jul 27 23:10 df_INCR1_t661216203_s3662_p1
-rw-r----- 1 oracle dba 43M Jul 27 23:10 df_INCR1_t661216203_s3660_p1
-rw-r----- 1 oracle dba 32M Jul 27 23:10 df_INCR1_t661216203_s3661_p1
-rw-r----- 1 oracle dba 8.3M Jul 27 23:10 cf_c-3725550444-20080727-02
-rw-r----- 1 oracle dba 2.5K Jul 27 23:10 logs_t661216227_s3667_p1
-rw-r----- 1 oracle dba 26K Jul 27 23:10 logs_t661216227_s3666_p1
-rw-r----- 1 oracle dba 63M Jul 27 23:10 logs_t661216227_s3665_p1
-rw-r----- 1 oracle dba 95M Jul 27 23:10 logs_t661216227_s3664_p1
-rw-r----- 1 oracle dba 8.3M Jul 27 23:10 cf_c-3725550444-20080727-03
-rw-r----- 1 oracle dba 40K Jul 28 23:19 df_INCR1_t661303169_s3671_p1
-rw-r----- 1 oracle dba 48M Jul 28 23:19 df_INCR1_t661303168_s3669_p1
-rw-r----- 1 oracle dba 38M Jul 28 23:19 df_INCR1_t661303169_s3670_p1
-rw-r----- 1 oracle dba 8.3M Jul 28 23:19 cf_c-3725550444-20080728-00
.
.
.

- Create $ORACLE_HOME/admin/$ORACLE_SID directories for the destination database

- Verify that the desired control file backup exists

ls -lh /dd1/jps/rman_source_db/cf_c-3725550444-20080727-00

-rw-r--r-- 1 oracle dba 8.3M Jul 30 14:34 /dd1/jps/rman_source_db/cf_c-3725550444-20080727-00

- Attempt to restore the control file

rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Thu Jul 31 10:35:26 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database (not started)

RMAN> set dbid=3725550444

executing command: SET DBID

RMAN> startup nomount;

Oracle instance started

Total System Global Area 935329792 bytes

Fixed Size 2034504 bytes
Variable Size 574624952 bytes
Database Buffers 352321536 bytes
Redo Buffers 6348800 bytes

RMAN> restore controlfile from '/dd1/jps/rman_source_db/cf_c-3725550444-20080727-00';

Starting restore at 31-JUL-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/31/2008 10:37:01
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

Any ideas? The backup exists. Why is RMAN having trouble with it?

Message was edited by:
shew01