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: Backup en Caliente

Re: Backup en Caliente

From: <rankbishop_at_yahoo.com>
Date: 11 Apr 2006 01:18:06 -0700
Message-ID: <1144743486.042771.57760@t31g2000cwb.googlegroups.com>


Hi.
I'm trying to do a complete backup of my database. I've used archive log mode.
The steps were the following:
alter tablespace SYSTEM begin backup;
host copy D:\ORACLE\ORADATA\RECORV\SYSTEM01.DBF d:\backup\ alter tablespace SYSTEM end backup;
alter tablespace UNDOTBS1 begin backup;
host copy D:\ORACLE\ORADATA\RECORV\UNDOTBS01.DBF d:\backup\ alter tablespace UNDOTBS1 end backup;
alter tablespace TEMP begin backup;
alter tablespace TEMP end backup;
alter tablespace CWMLITE begin backup;
host copy D:\ORACLE\ORADATA\RECORV\CWMLITE01.DBF d:\backup\ alter tablespace CWMLITE end backup;
alter tablespace DRSYS begin backup;
host copy D:\ORACLE\ORADATA\RECORV\DRSYS01.DBF d:\backup\ alter tablespace DRSYS end backup;
alter tablespace EXAMPLE begin backup;
host copy D:\ORACLE\ORADATA\RECORV\EXAMPLE01.DBF d:\backup\ alter tablespace EXAMPLE end backup;
alter tablespace INDX begin backup;
host copy D:\ORACLE\ORADATA\RECORV\INDX01.DBF d:\backup\ alter tablespace INDX end backup;
alter tablespace ODM begin backup;
host copy D:\ORACLE\ORADATA\RECORV\ODM01.DBF d:\backup\ alter tablespace ODM end backup;
alter tablespace TOOLS begin backup;
host copy D:\ORACLE\ORADATA\RECORV\TOOLS01.DBF d:\backup\ alter tablespace TOOLS end backup;
alter tablespace USERS begin backup;
host copy D:\ORACLE\ORADATA\RECORV\USERS01.DBF d:\backup\ alter tablespace USERS end backup;
alter tablespace XDB begin backup;
host copy D:\ORACLE\ORADATA\RECORV\XDB01.DBF d:\backup\ alter tablespace XDB end backup;
alter tablespace TS_DATA_URECORV begin backup; host copy D:\ORACLE\ORADATA\RECORV\TS_DATA_URECORV.ORA d:\backup\ alter tablespace TS_DATA_URECORV end backup; alter database backup controlfile to trace; alter database backup controlfile to
'd:\backup\control.RECORV.10Abr061122';
alter system switch logfile;

(every database)

I suppose I have a complete copy of may database in d:\backup\, but I don`t know the steps for recovering.
If I try:

(after copying d:\backup\ in the directory of my database)

SQl > STARTUP MOUNT

SQL >RECOVER DATABASE USING BACKUP CONTROLFILE;  ...The system request archive log files: ORA-00279: el cambio 618807 generado en 04/05/2006 08:19:34 es necesario para el thread 1
ORA-00289: sugerencia: D:\ORACLE\ORADATA\RECORV\ARCHIVE\1_2.DBF ORA-00280: el cambio 618807 para el thread 1 está en la secuencia número 2

Especificar log: {<RET>=sugerido | nombre_archivo | AUTO | CANCEL}

I don`t know why. Can anyone tell me what I did wrong?

Other question: If ,for example, I drop the database and I recreate it but
(without users, tablespaces, etc.., only database).Is it possible
recovery the original database from d:\backup\?. Received on Tue Apr 11 2006 - 03:18:06 CDT

Original text of this message

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