Ask the Expert

Steps for recovery after making copy of database

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:ORACLEORADATARECORVSYSTEM01.DBF d:backup
alter tablespace SYSTEM end backup;
alter tablespace UNDOTBS1 begin backup;
host copy D:ORACLEORADATARECORVUNDOTBS01.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:ORACLEORADATARECORVCWMLITE01.DBF d:backup
alter tablespace CWMLITE end backup;
alter tablespace DRSYS begin backup;
host copy D:ORACLEORADATARECORVDRSYS01.DBF d:backup
alter tablespace DRSYS end backup;
alter tablespace EXAMPLE begin backup;
host copy D:ORACLEORADATARECORVEXAMPLE01.DBF d:backup
alter tablespace EXAMPLE end backup;
alter tablespace INDX begin backup;
host copy D:ORACLEORADATARECORVINDX01.DBF d:backup
alter tablespace INDX end backup;
alter tablespace ODM begin backup;
host copy D:ORACLEORADATARECORVODM01.DBF d:backup
alter tablespace ODM end backup;
alter tablespace TOOLS begin backup;
host copy D:ORACLEORADATARECORVTOOLS01.DBF d:backup
alter tablespace TOOLS end backup;
alter tablespace USERS begin backup;
host copy D:ORACLEORADATARECORVUSERS01.DBF d:backup
alter tablespace USERS end backup;
alter tablespace XDB begin backup;
host copy D:ORACLEORADATARECORVXDB01.DBF d:backup
alter tablespace XDB end backup;
alter tablespace TS_DATA_URECORV begin backup;
host copy D:ORACLEORADATARECORVTS_DATA_URECORV.ORA d:backup
alter tablespace TS_DATA_URECORV end backup;
alter database backup controlfile to trace;
alter database backup controlfile to 'd:backupcontrol.RECORV.10Abr061122';
alter system switch logfile;

I suppose I have a complete copy of my 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 requests archive log files. I don't know why.

My other question: If, for example, I drop the database and I re-create it but without users, tablespaces, etc, only the database, is it possible to recover the original database from d:backup?

    Requires Free Membership to View

When you restore with a backup control file, Oracle will ask you for archived redo logs to apply. Most people just issue AUTO at the prompt and let Oracle automatically determine the archived redo logs to apply. Since you are using a backup control file, you will eventually be faced with a situation where Oracle tries to apply an archived redo log that was never created. At this point, reply CANCEL. Then open the database with RESETLOGS.

This was first published in April 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: