cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle DB backup questions

santave
Level 4

Hi All,

Sorry if I asked more questions below, please help to understand this.

1. I have 2 ora databases in one server, have different SID and TNS.
The backup for DB1 with SID1 in rman script is completed succesfully, when I browse backup, I can see all datafiles for DB1 and DB2
Does it mean rman backup both DB1 and DB2?

2. For DB restoration (datafiles, tablespace, arclog), do I just follow restore wizard in client gui, like doing FS restore?
Or I have to create rman restore script?

3. If I enabled compress in policy, any impact of this? pros and cons?

Thanks Alot

 


 

6 REPLIES 6

Marianne
Level 6
Partner    VIP    Accredited Certified

1. Check rman output file. 
It will tell you what exactly was backed up.

2. Use rman from cmd on client or create rman script.
GUI on the client can also be used, but restore options are limited to last backup. See NBU for Oracle guide for details: http://www.symantec.com/docs/DOC5175  Best to work with Oracle dba.

3. Compression in policy will use memory on the client. This is not recommended unless client is on a very slow network (e.g. 10BaseT). Policy compress option is discussed in NBU Admin Guide I:  http://www.symantec.com/docs/DOC5157 
Best to leave compression on hardware (enabled by default on tape drives).

 

santave
Level 4

I check reman outout file, I see this:

channel ch02: specifying datafile(s) in backup set
input datafile file number=00020 name=+DATADB1/DB1/datafile/xxxxxx_data_DB1.dbf
input datafile file number=00012 name=+DATADB1/DB1/datafile/xxxxxx_data_DB1.dbf

But in gui I can browse DB2 datafiles also,

+DATADB2/DB2/datafile/xxxxxxx_DB2.dbf

Does it mean, my DB2 already backed up?

Marianne
Level 6
Partner    VIP    Accredited Certified

Not sure how exactly you are going about browsing in the GUI.
It is possible that DB2 is backed up with another script/policy. 
Check policies for this client on the master and other output files on the client.
dbclient log on the client may also help (if log folder was created).

Best to get your dba to confirm with RMAN that both databases are indeed backed up.

santave
Level 4

Im sure, DB2 is never been backup yet. It strange for me, I can see files on DB2.

I use sys user for TARGET_CONNECT_STR in rman script
CONNECT='sys/xxxxx@DB2SID3';
When opening browser in gui, I also use sys user

Ideally, I should not able to see DB2 files, right?

Nicolai
Moderator
Moderator
Partner    VIP   

3: Do not enable compression in the policy. It uses too many CPU cycles, and tape drives will no be able to compress data again.

Marianne
Level 6
Partner    VIP    Accredited Certified

We still don't know if you are actually browsing backup images in the GUI or if you are simply browsing local instances on the Oracle server.

What happens if you use RMAN to list backups?
Work with your dba....