Re: rman

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 10 Mar 2006 19:28:22 +0100
Message-ID: <dusfnk$kmf$1@news3.zwoll1.ov.home.nl>

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; # default CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
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 MAXSETSIZE TO UNLIMITED; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'D:\ORACLE\ORA92\DATABASE\SNCFDB920.ORA'; # default

RMAN> shutdown immediate;

database closed
database dismounted
Oracle instance shut down

RMAN> startup mount
connected to target database (not started) Oracle instance started
...sga info

RMAN> backup database include current controlfile;

Starting backup at 10-MAR-06
[snip irrelevant data]

input datafile fno=00007 name=D:\ORACLE\ORADATA\DB920\TOOLS01.DBF channel ORA_DISK_1: finished piece 1 at 10-MAR-06 piece handle=D:\ORACLE\ORA92\DATABASE\08HDKP2V_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56 Finished backup at 10-MAR-06

Starting Control File and SPFILE Autobackup at 10-MAR-06 piece handle=D:\ORACLE\ORA92\DATABASE\C-3655888283-20060310-00 comment=NONE Finished Control File and SPFILE Autobackup at 10-MAR-06

DB was shut and physically removed. Services still running.

D:\oracle\ora92\bin>rman target / nocatalog

RMAN> startup nomount;
Oracle instance started
[snip SGA]

RMAN> restore controlfile from 'D:\ORACLE\ORA92\DATABASE\08HDKP2V_1_1';

Starting restore at 10-MAR-06

using channel ORA_DISK_1
channel ORA_DISK_1: restoring controlfile channel ORA_DISK_1: restore complete
replicating controlfile
input filename=D:\ORACLE\ORADATA\DB920\CONTROL01.CTL output filename=D:\ORACLE\ORADATA\DB920\CONTROL02.CTL output filename=D:\ORACLE\ORADATA\DB920\CONTROL03.CTL Finished restore at 10-MAR-06

RMAN> alter database mount;

database mounted

RMAN> restore database;

Starting restore at 10-MAR-06

using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to D:\ORACLE\ORADATA\DB920\SYSTEM01.DBF
restoring datafile 00002 to D:\ORACLE\ORADATA\DB920\UNDOTBS01.DBF
restoring datafile 00003 to D:\ORACLE\ORADATA\DB920\DRSYS01.DBF
restoring datafile 00004 to D:\ORACLE\ORADATA\DB920\EXAMPLE01.DBF
restoring datafile 00005 to D:\ORACLE\ORADATA\DB920\INDX01.DBF
restoring datafile 00006 to D:\ORACLE\ORADATA\DB920\ODM01.DBF
restoring datafile 00007 to D:\ORACLE\ORADATA\DB920\TOOLS01.DBF
restoring datafile 00008 to D:\ORACLE\ORADATA\DB920\USERS01.DBF
restoring datafile 00009 to D:\ORACLE\ORADATA\DB920\XDB01.DBF

channel ORA_DISK_1: restored backup piece 1 piece handle=D:\ORACLE\ORA92\DATABASE\04GHOKSU_1_1 tag=TAG20050413T104901 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 10-MAR-06

RMAN> recover database;

Starting recover at 10-MAR-06
using channel ORA_DISK_1

starting media recovery

unable to find archive log

archive log thread=1 sequence=1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 03/10/2006 19:25:25 RMAN-06054: media recovery requesting unknown log: thread 1 scn 4796066

RMAN> alter database open resetlogs;

database opened

Could it be you restored from a previous backup attempt?!?

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Fri Mar 10 2006 - 12:28:22 CST