Backing Up Oracle Databases on Linux Clients
Hi I need to cover this scenario:
I've got an Oracle Database running on Linux.
I've set one Backup which is sheduled once a day, which is an backup of the complete maschine.
It will backup to /backup/system.
Now I want an oracle full Backup running once a day and and backup of archivelog running all 4 hours.
How to to set "what to backup"? I Guess the directory where rman puts its backups.
But what does "where to backup" mean?
Will it just backup the rman backup peaces to an other medium, in case the backup peaces are lost?
When I try to restore the controlfile, I can only use the snapshot of the the server, is this correct?
Thx
Christian
Thx
I followed the scripts in the manual.
The question is how to restore controlfile or spfile form "RMAN backup", the directory where the
rman puts its backups (aus defined in cfg file)
I can't select "controlfile" or "spfile" here.
SELECT BACKUP LOCATION
LOCATION 1: Local folder: "/backup/oracle.sik/"
LOCATION 2: Local folder: "/backup/system/"
LOCATION 3: Local folder: "RMAN backup"
Or type + for add a new location...
Select location [1-3]: 3
================================================================================
SUMMARY:
Location: RMAN backup
--------------------------------------------------------------------------------
Choose one among the following recovery options:
1: Recover up to the latest available state
2: Recover to the point in time
3: Recover to system change number (SCN)
However, If I select ORASRV11.darkwing.net - Snapshot Maschine (which is an Backup of the complete Server) I can select controlfile or spfile.
Select files to restore:
1: tablespaces
2: spFile
3: controlFile
4: archiveLogs
Or select:
5: Recovery without restore
Thx
Christian
Hello Christian.
At first you need to recover RMAN backup from a file-level backup as described here: https://www.acronis.com/en-us/support/documentation/AcronisCyberProtect_15/index.html#36650.html
Then proceed as described on page 14of this guide: https://dl.managed-protection.com/u/pdf/AcronisCyberProtect_15_OracleBackup_whitepaper_en-US.pdf
Control file recovery
Use this method if a control file has been lost or corrupted after the latest backup.
To recover a control file
1. Recover the required RMAN backup from the file-level backup, as described earlier in this
section.
If you recover from the latest RMAN backup and it is intact, skip this step.
2. [In Windows] At the command prompt, type cd <scripts location folder>.
[In Linux] In the terminal, type cd /<scripts location folder>.
3. Run restore_controlfile.bat (in Windows) or restore_controlfile.sh (in Linux).
4. Run a full backup.
Recovering a control file resets logs, therefore the next backup must be full.