RMAN Recovery Help

From: Mattyw <wilson_m56_at_hotmail.com>
Date: 20 Apr 2006 09:18:12 -0700
Message-ID: <1145549892.683312.86320@e56g2000cwe.googlegroups.com>

Hi, I'm an Oracle Newbie having some issues with Recovering a Database and testing Oracle Disaster Recovery Procedures.

I've backed up the database using RMAN and have set configured it to use the Controlfile and AUTOBACKUP option....the backup procedure works fine...I have a subdir that creates the ControlFile and the Backup Files successfully.

When I try to restore I perform the following steps:

C:\>rman target /

Recovery Manager: Release 9.2.0.1.0 - Production

connected to target database: INFL (not mounted)

RMAN> set dbid 2094076708;

executing command: SET DBID

RMAN> startup force nomount;

Oracle instance started

Total System Global Area 214505976 bytes

Fixed Size                      453112 bytes
Variable Size                109051904 bytes
Database Buffers             104857600 bytes
Redo Buffers                    143360 bytes

RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; Starting restore at 20-APR-06

using target database controlfile instead of recovery catalog allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: looking for autobackup on day: 20060420
channel ORA_DISK_1: looking for autobackup on day: 20060419
channel ORA_DISK_1: looking for autobackup on day: 20060418
channel ORA_DISK_1: looking for autobackup on day: 20060417
channel ORA_DISK_1: looking for autobackup on day: 20060416
channel ORA_DISK_1: looking for autobackup on day: 20060415
channel ORA_DISK_1: looking for autobackup on day: 20060414
channel ORA_DISK_1: no autobackup in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 04/20/2006 17:14:18 RMAN-06172: no autobackup found or specified handle is not a valid copy or piec

RMAN> I want to be able to change the channel to point to the correct location...or the correct channel...but when I try I get the following;

RMAN> allocate channel 1 device type disk;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands

RMAN-01005: syntax error: found "integer": expecting one of: "for" RMAN-01007: at line 1 column 18 file: standard input

RMAN> I've tried lots of different syntax but can't get it to work....I can't configure the channel because the database isn't mounted!

Any help would be appreciated as I'm getting nowhere with this....am I going about it the completely wrong way??......we need a solution where we can restore the DB to a new system for testing purposes.

Regards
Matt. Received on Thu Apr 20 2006 - 11:18:12 CDT