Oracle Community Network
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?
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.
3. Compression in policy will use memory on the client. This is not recommended unless client is on a very slow network.
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,
Does it mean, my DB2 already backed up?
Not sure how exactly you are going about browsing in the GUI.
It is possible that DB2 is backed up with another script/policy.
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
When opening browser in gui, I also use sys user
Ideally, I should not able to see DB2 files, right?
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.
Thanks for the answers