CODEWITHSUNDEEP
oracle-databasebackuprecovery
Sarith
Sarith

Reputation: 147

Backup and Recovery Scenario

Can anyone show me the step of restore and recovery of below scenario?

I have used the differential backup (cumulative) everyday.

RUN {
  RECOVER COPY OF DATABASE WITH TAG "whole_database_copy";
  BACKUP INCREMENTAL LEVEL 1 CUMULATIVE FOR RECOVER OF COPY WITH TAG  "whole_database_copy" DATABASE;
}

I have copies of all datafile, all backup sets, all redo log files with all archive logs on different media.

My system has crashed and all of my working database files are lost.

How can I do to recover my database to another server?

Regards, Sarith

Upvotes: 1

Views: 533

Answers (2)

Matthew Watson
Matthew Watson

Reputation: 14233

Contact Oracle support right now.. Unless you can afford to lose this data, don't mess about with listening to what people on forums have to say, now is not the time to experiment.

Upvotes: 1

FerranB
FerranB

Reputation: 36807

Have you tried to execute RECOVER DATABASE sentence?

Anyway, a very important sencence about backups: A backup have not ended until a recovery have been tried.

Upvotes: 0

Related Questions