Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: test restore

Re: test restore

From: <sybrandb_at_hccnet.nl>
Date: Wed, 20 Jun 2007 23:26:35 +0200
Message-ID: <do6j73hc6g44169g39653g6knt7751s0qs@4ax.com>


On Wed, 20 Jun 2007 21:00:46 -0000, cptkirkh <khill_at_scic.com> wrote:

>I am trying to learn how to restore an oracle server. I have the
>backup files being shared and I am attempting to restore to a new
>host. We run Oracle 10g on windows server 2003. I managed to get up
>to the final step listed below:
>
>
>1. Install new database with same name
>2. Rman target / nocatalog
>3. Shutdown immediate
>4. Copy latest autobackup controlfile to new server
>5. Startup nomount
>6. Set dbid to dbid of source database
>7. Restore spfile to pfile 'location of pfile' from 'location of
>autobackup file';
>8. Restore controlfile from 'location of autobackup file';
>9. Alter databse mount
>10. Restore database
>11. Recover database
>
>Now I want to run the alter database open resetlogs command and I get
>the following. Now it has been two weeks between the recover and and
>the alter database open resetlog command. It gives me this error.
>
>RMAN-00571:
>===========================================================
>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
>===============
>RMAN-00571:
>===========================================================
>RMAN-03002: failure of alter db command at 06/20/2007 15:57:09
>ORA-01152: file 1 was not restored from a sufficiently old backup
>ORA-01110: data file 1: 'F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
>\SYSTEM01.DBF
>
>Did I mess up this whole process by waiting two weeks to perform this
>command?

step 4 copy *latest* autobackup controlfile and step 6a
set until ... <the moment you made this backup> is missing
consequently you are conducting *complete* recovery, which means until *now*.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Wed Jun 20 2007 - 16:26:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US