RMAN test

[hannah00]

Hi all,

I have been reading and teting about RMAN. Anyway, below is what I have :

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'd:\rman_test\3\
control_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 100 M;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK MAXPIECESIZE 100 M;
CONFIGURE CHANNEL 3 DEVICE TYPE DISK MAXPIECESIZE 100 M;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\RMAN_TEST\1\CONTROL_%U';
RMAN configuration has no stored or default parameters







--backup command

RMAN> run
2> {
3> allocate channel c1 device type disk maxpiecesize=100m format 'd:\rman_test\1
\RMAN_%U';
4> allocate channel c2 device type disk maxpiecesize=100m format 'd:\rman_test\2
\RMAN_%U';
5> allocate channel c3 device type disk maxpiecesize=100m format 'd:\rman_test\3
\RMAN_%U';
6> backup database plus archivelog;
7> backup current controlfile;
8> backup spfile;
9> }


When I am trying to do the recovery, I got some errors:

D:\RMAN_TEST>rman target sys/manager

Recovery Manager: Release 9.2.0.6.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database (not started)

RMAN> set dbid=1442013850

executing command: SET DBID

RMAN> startup nomount

Oracle instance started

Total System Global Area 122757048 bytes

Fixed Size 454584 bytes
Variable Size 71303168 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes

RMAN> restore controlfile from autobackup;

Starting restore at 10-MAY-05

using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
channel ORA_DISK_1: looking for autobackup on day: 20050510
channel ORA_DISK_1: looking for autobackup on day: 20050509
channel ORA_DISK_1: looking for autobackup on day: 20050508
channel ORA_DISK_1: looking for autobackup on day: 20050507
channel ORA_DISK_1: looking for autobackup on day: 20050506
channel ORA_DISK_1: looking for autobackup on day: 20050505
channel ORA_DISK_1: looking for autobackup on day: 20050504
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 05/10/2005 13:06:36
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

BTW, when I only do

restore controlfile

it's working just fine and I was able to restore the controlfile.

How come it doesn't find the autobackup ??? I am missing something here.

thanks,