Q

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. I suppose I have a complete copy of my database in d:backup, but I don't know the steps for recovering. The system requests archive log files. I don't know why.

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?

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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close