| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Rookie restore problem
Sorry about, I caught this thread in the midle, but where are the important 'switch log file' commands at the begining and ending of the script?
"Howard J. Rogers" wrote:
> <todd_at_nospam.org> wrote in message news:9a592b$tu$1_at_news.netmar.com...
> > This what I have been doing to attempt to restore on a different machine:
> >
> > Short version
> > 1) I installed Oracle on new machine (same directory structure)
> > 2) I created a new control file(s) by issuing: alter database backup
> > controlfile to trace;
> > 3) I modify that script to add additional .dbf file that was in the old
> > database (CONTROLROOM.dbf)
> > 4) I run the script in svrmgrl to create new control files using RESETLOGS
> > instead of NORESETLOGS, because I didn't back the redo logs up
> > 5) I copy over all the backup .dbf files to new machine
> > 6) using svrmgrl, connect internal, startup mount
> > 7) alter database open resetlogs
> > 8) message about how the system01.dbf file needs recovery
> > 9) recover database using backup controlfile until cancel;
> > 10) when prompted for the arc file, I hit enter, but the .arc file doesn't
> > exist.
> >
> > Did I screw this up by not backing up the arc files?
>
> Yes. You say you are doing this to 'restore on a different machine'. How
> can you possibly restore anything without all available redo (online and
> archived) being made available to the recovering Instance? In your case,
> it's worse since your backup script takes hot backups -those *must* have
> redo applied to them to make them internally consistent, otherwise they are
> simply useless.
>
> I don't understand why you are having to add a new line to reference a file
> that was 'in the old database'. If it was in the old database, why wasn't
> it in the trace file? Was it backed up? Will the original database's redo
> stream make reference to that file? You're trying to do recovery... get
> that right first, and then worry about plugging in extra files. If that
> datafile was not included in the original hot backups, forget it until
> you've dealt with the recovery of that which *was* there.
>
> It also doesn't help that you copied the DBF files *after* running the
> create controlfile script. They are supposed to be there at the point of
> creating the controlfile, so that Oracle can determine the highest SCN
> number to place in the header of the new controlfile. How else is it
> supposed to know the point to which the database should be recovered?
>
> And, for the record, if you are ever prompted to supply a piece of redo
> which you know doesn't exist, the procedure is to allow the current recovery
> to fail, then restart it with a 'recover database until cancel', and when
> prompted for the missing log, to type the word 'cancel'.
>
> However: that's not your real problem here. Your real problem is that your
> basic approach is up the spout. What are you trying to achieve? A complete
> recovery of a clone? Then there is no need to issue a resetlogs at all,
> unless you are also wishing to rename the clone database -and if I were you,
> I'd get the recovery done as one operation, and worry about renaming things
> as a completely separate exercise. You have hot backups -archive logs are
> not optional extras. You need all archives available since the time the
> first tablespace in your script was put in backup mode. Anything other than
> that just is not going to work.
>
> Regards
> HJR
>
> >
> > Todd
> >
> >
> > In article <3ABDB15E.F7334B42_at_netvigator.com>, Reid Lai
> > <reidlai_at_netvigator.com> writes:
> > >What are your steps?
> > >
> > >Reid
> > >
> > >todd_at_nospam.org wrote:
> > >
> > >> I backed up a database using the following script:
> > >> /*************************************************************/
> > >> /* Description: Oracle Backup script */
> > >> /* Usage: Execute in SYSDBA-privileged SQL*Plus session */
> > >> /*************************************************************/
> > >>
> > >> PROMPT Backup up database to jar file
> > >> PROMPT $ORACLE_BASE/backups/db-backup.tar
> > >>
> > >> PROMPT Backing up SYSTEM tablespace ...
> > >> PROMPT
> > >> ALTER TABLESPACE system BEGIN BACKUP;
> > >> HOST cp $ORACLE_BASE/oradata/www/system01.dbf $ORACLE_BASE/backups/.
> > >> ALTER TABLESPACE system END BACKUP;
> > >>
> > >> PROMPT SYSTEM tablespace backed up.
> > >> PROMPT
> > >>
> > >> PROMPT Backing up TOOLS tablespace ...
> > >> PROMPT
> > >> ALTER TABLESPACE tools BEGIN BACKUP;
> > >> HOST cp $ORACLE_BASE/oradata/www/tools01.dbf $ORACLE_BASE/backups/.
> > >> ALTER TABLESPACE tools END BACKUP;
> > >>
> > >> PROMPT TOOLS tablespace backed up.
> > >> PROMPT
> > >>
> > >> PROMPT Backing up TEMP tablespace ...
> > >> PROMPT
> > >> ALTER TABLESPACE temp BEGIN BACKUP;
> > >> HOST cp $ORACLE_BASE/oradata/www/temp01.dbf $ORACLE_BASE/backups/.
> > >> ALTER TABLESPACE temp END BACKUP;
> > >>
> > >> PROMPT TEMP tablespace backed up.
> > >> PROMPT
> > >>
> > >> PROMPT Backing up USERS tablespace ...
> > >> PROMPT
> > >> ALTER TABLESPACE users BEGIN BACKUP;
> > >> HOST cp $ORACLE_BASE/oradata/www/users01.dbf $ORACLE_BASE/backups/.
> > >> ALTER TABLESPACE users END BACKUP;
> > >>
> > >> PROMPT USERS tablespace backed up.
> > >> PROMPT
> > >>
> > >> PROMPT Backing up SYSTEM tablespace ...
> > >> PROMPT
> > >> ALTER TABLESPACE system BEGIN BACKUP;
> > >> HOST cp $ORACLE_BASE/oradata/www/system01.dbf $ORACLE_BASE/backups/.
> > >> ALTER TABLESPACE system END BACKUP;
> > >>
> > >> PROMPT SYSTEM tablespace backed up.
> > >> PROMPT
> > >>
> > >> PROMPT Backing up RBS tablespace ...
> > >> PROMPT
> > >> ALTER TABLESPACE rbs BEGIN BACKUP;
> > >> HOST cp $ORACLE_BASE/oradata/www/rbs01.dbf $ORACLE_BASE/backups/.
> > >> ALTER TABLESPACE rbs END BACKUP;
> > >>
> > >> PROMPT SYSTEM RBS backed up.
> > >> PROMPT
> > >>
> > >> PROMPT Backing up DRSYS tablespace ...
> > >> PROMPT
> > >> ALTER TABLESPACE drsys BEGIN BACKUP;
> > >> HOST cp $ORACLE_BASE/oradata/www/drsys01.dbf $ORACLE_BASE/backups/.
> > >> ALTER TABLESPACE DRSYS END BACKUP;
> > >>
> > >> PROMPT DRSYS tablespace backed up.
> > >> PROMPT
> > >>
> > >> PROMPT Backing up INDX tablespace ...
> > >> PROMPT
> > >> ALTER TABLESPACE indx BEGIN BACKUP;
> > >> HOST cp $ORACLE_BASE/oradata/www/indx01.dbf $ORACLE_BASE/backups/.
> > >> ALTER TABLESPACE indx END BACKUP;
> > >>
> > >> PROMPT INDX tablespace backed up.
> > >> PROMPT
> > >>
> > >> PROMPT Backing up CONTROLROOM tablespace ...
> > >> PROMPT
> > >> ALTER TABLESPACE controlroom BEGIN BACKUP;
> > >> HOST cp $ORACLE_BASE/oradata/db/CONTROLROOM.dbf $ORACLE_BASE/backups/.
> > >> ALTER TABLESPACE controlroom END BACKUP;
> > >>
> > >> PROMPT CONTROLROOM tablespace backed up.
> > >> PROMPT
> > >>
> > >> PROMPT Backing up database control file ....
> > >> PROMPT
> > >>
> > >> ALTER DATABASE BACKUP CONTROLFILE TO
'$ORACLE_BASE/backups/controlbkup.ctl'
> > >> REUSE;
> > >>
> > >> PROMPT Database Control file backed up.
> > >> PROMPT
> > >>
> > >> PROMPT Backing up misc files.....
> > >> PROMPT
> > >>
> > >> HOST cp $ORACLE_HOME/dbs/initwww.ora $ORACLE_BASE/backups/.
> > >> HOST cp $ORACLE_HOME/dbs/orapwwww $ORACLE_BASE/backups/.
> > >> HOST cp $ORACLE_HOME/network/admin/*.ora $ORACLE_BASE/backups/.
> > >> HOST cp /etc/oratab $ORACLE_BASE/backups/.
> > >> HOST cp /etc/rc.d/init.d/dbora $ORACLE_BASE/backups/.
> > >>
> > >> PROMPT misc files backed up
> > >> PROMPT
> > >>
> > >> -------------------------
> > >>
> > >> I have a different box with Oracle installed that I would like to
restore
the
> > >> backup from above. I've tried a few different ways, but I'm not having
any
> > >> luck. Any suggestions?
> > >>
> > >> Thanks,
> > >> Todd
> > >>
> > >> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
Web
 |
 |