cancel
Showing results for 
Search instead for 
Did you mean: 

Backup issue

former_member759680
Contributor
0 Kudos

Hello,

We have configured RMAN to take backups (Oracle 10g, AIX, Netweaver 7)

During offline backups, I noticed that RMAN doesn't backup the TEMP datafiles.

However, brbackup still backs them up on disk

Could you please guide me how do I configure brbackup to backup up the temp datafiles also on the tape, where the rest of the backup is being done?

I am not sure about the initSID.sap parameter taht I needt to change for this.

Log:

#FILE..... /oracle/D3W/sapdata1/system_1/system.data1
#SAVED.... bebuykjd  710/746
BR0522I 21 of 21 files/save sets processed by RMAN
BR0284I BRBACKUP time stamp: 2009-11-02 02.02.17, elapsed time: 0:18
BR0502I Normal database backup using RMAN successful
BR0284I BRBACKUP time stamp: 2009-11-02 02.02.19, elapsed time: 0:02
BR0307I Shutting down database instance D3W ...
BR0284I BRBACKUP time stamp: 2009-11-02 02.03.02, elapsed time: 0:43
BR0308I Shutdown of database instance D3W successful
BR0284I BRBACKUP time stamp: 2009-11-02 02.03.02, elapsed time: 0:00
BR0202I Saving /oracle/D3W/sapdata1/temp_1/temp.data1
BR0203I to /oracle/D3W/rmanbackup/bebuykjd/temp.data1 ...
#FILE..... /oracle/D3W/sapdata1/temp_1/temp.data1
#SAVED.... /oracle/D3W/rmanbackup/bebuykjd/temp.data1  #1/1
BR0284I BRBACKUP time stamp: 2009-11-02 03.04.53, elapsed time: 61:51
BR0063I 1 of 12 files processed - 2129.008 MB of 8662.605 MB done
BR0204I Percentage done: 24.58%, estimated end time: 6:14
BR0001I ************______________________________________
BR0284I BRBACKUP time stamp: 2009-11-02 03.04.54, elapsed time: 0:01
BR0202I Saving /oracle/D3W/sapdata1/temp_2/temp.data2
BR0203I to /oracle/D3W/rmanbackup/bebuykjd/temp.data2 ...

Accepted Solutions (0)

Answers (1)

Answers (1)

stefan_koehler
Active Contributor
0 Kudos

Hello Gautam,

please check metalink note #305993.1 .. it answers all your questions.

The availability of the tempfiles is not a requirement to recover or open a database after restore. The tempfiles listed in DBA_TEMP_FILES are not checkpointed so they can be of any generation, or non-existant. They can either be dropped or recreated after the database has been opened. RECOVER DATABASE will not consider tempfiles, and since tempfiles aren't datafiles, then RECOVER DATAFILE will raise an error since the datafile does not exist.

Specific to 10 G - Tempfiles Recovery via RMAN

================================================

When you restore the database from an RMAN backup, the first thing you need to do is recreate the temporary tablespace files. Because temporary tablespaces do not contain permanent objects to recover, RMAN does not back them upu2014no reason to waste backup resources on non-permanent objects. However, the Oracle Database needs temporary tablespaces for many operations to run efficiently. So, wouldn't it be nice if RMAN backed them up as well?

In Oracle Database 10g Release 2, it does.

When you recover a database, the temporary tablespace files are automatically recreated too.

Regards

Stefan

former_member759680
Contributor
0 Kudos

Thanks a ton Stefan.

The RMAN part is crystal clear now.

However, the doubts about BRBACKUP still persist -

1. Why does Brbackup still backup the temp datafiles?

(Ideally, since I am calling RMAN_tape in initSID.sap, Brbackup should just leave the temp files)

2. While restoring, I would be using BRRESTORE. I know, RMAN doesn't need temp files for a successful restore. But can BRRESTORE perfrom a successful restore without the tempfiles?

former_member204746
Active Contributor
0 Kudos

1) it depends on which option your chose to run BRBACKUP with... check options under "-m"

2) yes, BRRESTORE's job is to restore files, not to recover the database. so, this is not an issue. Check usage for BRRECOVER.

former_member759680
Contributor
0 Kudos

One more doubt

All the datfiles (except Tempfiles) are backed up directly on tape.

The following log should expalin how:

BR0202I Saving G:\ORACLE\EBD\SAPDATA5\EBP_2\EBP.DATA2
BR0284I BRBACKUP time stamp: 2009-11-01 21.02.38, elapsed time: 0:00
BR0202I Saving G:\ORACLE\EBD\SAPDATA6\EBPADM_3\EBPADM.DATA3
BR0284I BRBACKUP time stamp: 2009-11-01 21.02.38, elapsed time: 0:00
BR0202I Saving G:\ORACLE\EBD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1
BR0284I BRBACKUP time stamp: 2009-11-01 21.02.39, elapsed time: 0:01
BR0202I Saving G:\ORACLE\EBD\SAPDATA2\EBPXTAB_19\EBPXTAB.DATA19
BR0284I BRBACKUP time stamp: 2009-11-01 21.54.54, elapsed time: 52:15
BR0521I Backup of database file save set piece - piece handle=EBD_bebuxzsx.645_1 tag=BEBUXZSX comment=API Version 2.0,MMS Version 5.0.0.0

But the tempfiles are backed up on the disk itself

Why are the tempfiles also not backed up on piece handle=EBD_bebuxzsx.645_1 tag=BEBUXZSX ?

the parameters in initSID.sap are

backup_dev_type = rman_disk tape_copy_cmd = rman

disk_copy_cmd = rman

tape_address = /dev/nmt0

util_par_file = initPQ1_RMAN_full_offline_weekly.utl

What parameter should I modify to accomplisg the backup of tempfiles on the RMAN utility (Tape drive, I suppose) as well?

Thanks.

Edited by: Gautam Poddar on Nov 3, 2009 7:32 AM

Edited by: Gautam Poddar on Nov 3, 2009 7:41 AM

Edited by: Gautam Poddar on Nov 3, 2009 7:42 AM