Video Screencast Help

Oracle DB backup questions

Created: 01 Dec 2013 | 6 comments

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

 

 

Operating Systems:

Comments 6 CommentsJump to latest comment

Marianne's picture

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).

 

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

santave's picture

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's picture

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.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

santave's picture

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?

Marianne's picture

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....

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Nicolai's picture

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.

Assumption is the mother of all mess ups.

If this post answered your'e qustion -  Please mark as a soloution.