Re: rman
- From: Frank van Bortel <frank.van.bortel@xxxxxxxxx>
- Date: Fri, 10 Mar 2006 19:28:22 +0100
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...
.
- Prev by Date: Re: Oracle RDBMS version 11 status?
- Next by Date: Re: db_Writer performance
- Previous by thread: Re: rman
- Next by thread: Re: rman
- Index(es):
Relevant Pages
|
