Oracle DB backup question

by Boyce Helgren

Jan 30, 2014

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

Load Previous Replies
  • up

    Boyce Helgren

    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?

    Jan 30, 2014

  • up

    Jesse Eadie

    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.

    Jan 30, 2014

  • up

    Kirby Paterson

    Thanks for the answers

    Feb 27, 2014