Topic: Backup & Recovery >> Falsche Speicherort RMAN Backups
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Falsche Speicherort RMAN Backups |
| eyecycas |
Posted: Jul 03, 2008 07:37:24 AM |
Total Post: 6
Joined: Nov, 2007
|
Hallo,
meine RMAN-Backups werden immer unter $ORACLE_HOME/dbs abgelegt (s. output filename).
Starting backup at 01-JUL-08
channel d1: starting datafile copy
input datafile fno=00001 name=...
output filename=/global/ora-dg/oracle-vol/product/10.2.0/dbs/data_D-TECRBR_I-935235287_TS-SYSTEM_FNO-1_9ajkd53s tag=TAG
Das RMAN-Skript soll aus einem anderen Skript aufgerufen werden.
Bei der Angabe "backup format" im CMD-File für RMAN, schreibt RMAN zwar an den richtigen Speicherort, würde aber bedeuten, daß ich bei 8 Instancen, immer das CMD-File dynamisch erzeugen und ausführen müßte, da die Zielverzeichnisse bei jeder Instance anders liegen.
Mein Ziel ist die Konfiguration über die Instance mit CONFIGURE.
Leider bleibt der Befehl
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/global/.../%U.bkp';
wirkungslos.
Derzeit sieht mein Skript so aus (mit backup format):
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
backup
format '/global/.../%U.bkp'
database plus archivelog;
release channel d1;
release channel d2;
}
Meine RMAN-Einstellungen sind:
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/global/.../%F.bck';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COPY;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/global/.../%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/global/.../snap_tecrbr.f';
Wie kann ich über die Instance-Einstellungen!! (Default Permanent Settings mit CONFIGURE) erreichen, daß RMAN den richtigen Speicherort wählt?
Kann mir jemand weiterhelfen? |
|
|
 Avnish |
| Posted: Jul 09, 2008 02:26:04 AM |  |
|
Total Post: 153
Joined: Dec, 2007
|
Hi
Can you write this thread in English Please. So everyone understand your problem & give you a proper solution.
Thanks & Regards
Avnish Yadav
|
|
|
|
|
| eyecycas |
| Posted: Jul 09, 2008 02:56:15 PM | |
|
Total Post: 6
Joined: Nov, 2007
|
Hello Avnish Yadav,
I'm so sorry. I was that hurry up, that I wrote it just in German. ;o)
One day later I subscribed it in Englisch (Topic: wrong RMAN backup location with CONFIGURE). Here you can find the solution too. ;o)).
Unfortunately I don't know how delete this thread.
Anyway; Thanks for replying me!
bye-bye
eyecycas
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 856 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 281 |
| neeraj sharma | 254 |
| Ramesh Jois | 245 |
| Bishal Khetan | 207 |
|
|
