Backup restore

[Former Member]

Hi All,

I have to do homogeneous system copy. ( ECC6 with Oracle 10.2 on HP-UX)

i have taken backup of PRD server(Whole online + Redo logs backup) we didnt get approval PRD server to down and take offline backup.

also taken backup of SANDBOX.

now, i took backup od control file as SQL>alter databse backupu using controlfile;

.trc file has been created, edited it in VI editor, changed the SID of PRD to SNB, copies this .trc file to sandbox.

now i have to restore backup of PRD to SNB.

System Copy using BACKUP of PRD server on Sandbox.

Source u2013 PRD (Production)

Target - SNB (Sandbox)

DB size of PRD - Size: 99.65 GB Total size: 400.39 GB

DB Size of SNB - 98.81 GB Total size: 400.39 GB

Take Full backups of both Servers (PRD & SNB)

Take backup of control file.

SQL> alter database backup controlfile to trace;

This created a .trc file in /oracle/PRD/saptrace/usertrace as PRD_ora_1234.trc

Copy this controlfile to SNB

Edit it through vi editor, replace the name of PRD to SNB through %s/PRD/SNB/g ( this changes the sid of PRD to SNB wherever presents)

Down the SAP & DB of target system (SNB)

Delete whole datafiles in SNB to free the space

Ie in /oracle/SNB/sapdata1 u2026 N

Now restore the backup through brtools,

Check the option in initSNB.sap parameter for backup type, drive, location

Ie. /oracle/SNB/102_64/dbs/initSNB.sap

Login through orasid  brtools  5 Restore and recovery  5 - Restore of individual backup files

with this restore option am not getting how to initialize tape & start backup.

Kindly suggest, how i can intialize tape on OS level & start restore.

Regards!!

[Former Member]

Helpful answers

[Former Member]

Hi Ashok,

Do u mean to copy all the logs files stored in /oracle/PRD/sapbackup(Production) to /oracle/SNB/sapbackup(sandbox).

backPRD.log

bdzdqvsp.tib

bdzdqwwv.ant

bdzdvbzn.and

bebakmja.aft

bebakmof.tib

bebakuel.tib

bebakule.tib

bebaphvk.tib

bebapjja.tib

bebapjmr.aft

bebapuno.tib

bebapuuj.ant

bebapwfz.ant

bebavumi.tib

bebavunr.ant

lost+found

rebaklaf.rsb

rebapcqz.rsb

restPRD.log

should i rename backPRD.log to backSNB.log ( mv backPRD.log backSNB.log with permission as orasnb:dba)

and also restPRD.log to restSNB.log (mv restPRD.log restSNB.log with permission as orasnb:dba)

Regards!!

Edited by: ashun8 on Jul 20, 2009 7:02 AM

[Former Member]

Hi ashun8,

Logfile backPRD.log

and the file craeted at the time of backup.

Yes you should rename to backSNB.log and the content inside the online backup log.

Regards

Ashok Dalai

[Former Member]

Hi Anjali,

Thnx for quick reply.

I have made the changes only for SID, remaining all as it is, what else should I change apart from control file. Kindly suggest me some steps.

I have taken the backup on Ultrium 4 drives. And this is online backup I have to restore.

Thnx & Regards

[Former Member]

Hi,

command

brbackup -q will get the tape no.

Initializing tape:

brbackup -c -i force -v <tape no>

Regards,

Ravi

[Former Member]

Hi ashun8,

Have you copied the backup logs from Production to Sandbox.

When you will be doing a restore then the tool will read the backup log to find out where is the backup stored and what are the files.

So copy the files and modify the files and do the restore.

Regards

Ashok Dalai

[Former Member]

first of all, are you sure that you have modified the control file fully as it is required to do backup and restore ?

and on which media you are taking the backups ?

once check the options, brtools -> Backup and database copy -> Whole database reset and then choose accordingly as from which backup you want to restore (offline or online)