Schnell, schneller, rman (Backup und Restore)

Für ein schnelles Backup der Oracle Datenbank hat man, wenn man Glück hat, eine schnelle Backup Infrastruktur. Aber auch die schnellste Infrastruktur ist einfach immer zu langsam wenn es – warum auch immer – einfach mal schneller gehen muss 🙂 Wenn dann auch noch Oracle Flashback nicht genutzt werden kann weil es den Anforderungen nicht genügt oder schlichtweg nicht konfiguriert ist kann man i.d.R. schnell und einfach auf rman als Backuplösung zurück greifen.

Ich werde hier kurz erläutern wie man rman (Recovery Manager) für ein Backup in ein Filesystem, also ein rman backup to disk  (rman backup2disk) konfiguriert und im Notfall einen Restore aus dem Backup anfertigt.

Für die Nutzung von RMAN müssen zunächst die Parameter überprüft werden. Hierzu ist ein rman connect notwendig.

Zunächst verbindet man sich per rman gegen die Datenbank:

server:oraA01 4> rman

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Apr 3 10:50:11 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target /

connected to target database: A01 (DBID=54469256)

RMAN>

Hier ist es wichtig sich die DBID zu merken, da RMAN diese im Rahmen des Restores anfordern wird!

Als nächstes werden die aktuellen rman Parameter ausgelesen. Die Werte der aktuell gesetzten Parameter sollte man sich wegsichern um sie nach dem das Backup nicht mehr benötigt wird auch wieder zurücksetzen zu können. Damit die Werte gespeichert werden können muss die Datenbank gestartet sein, ansonsten kann rman keine Konfigurationsänderungen vornehmen, da diese in der DB gesichert werden.

Für das Backupszenario werden folgende Parameter gesetzt:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE DEVICE TYPE disk PARALLELISM 2;

Durch die Parallelität kann die Backup Geschwindigkeit gesteigert werden. Je nach Filesystemsetup / SAN-Leistung kann es sinnvoll sein den Wert auf 4 zu erhöhen und dazu 4 Channel zu definieren. In der Regel erzielt man mit 2 jedoch bereits einen ordentlichen Durchsatz.

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name A01 are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/A01/112_64/dbs/snapcf_A01.f'; # default

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters are successfully stored

RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;

new RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;

new RMAN configuration parameters are successfully stored

RMAN>

Nachdem die Parameter gesetzt sind kann das Backup gestartet werden. Das Backup wird mit 2 Channeln gestartet. Hierfür  wurde vorher die Parallelität auf 2 erhöht. Dies erhöht den Durchsatz. Es werden die Datenfiles sowie die Archivelogs gesichert. Das Zielverzeichnis für die Backupfiles ist das Filesystem unter /oracle/A01/backup und sollte entsprechend groß genug sein um das Backup aufnehmen zu können.

Die zu sichernden Files werden den verfügbaren Channeln wie eine Queue zur Abarbeitung zugeteilt:

RMAN>run

{

ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/oracle/A01/backup/%U';

ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/oracle/A01/backup/%U';

BACKUP DATABASE PLUS ARCHIVELOG;

release channel disk1;

release channel disk2;

}

Starting backup at 27-MAR-14

current log archived

channel disk1: starting archived log backup set

channel disk1: specifying archived log(s) in backup set

input archived log thread=1 sequence=110 RECID=87 STAMP=843315295

channel disk1: starting piece 1 at 27-MAR-14

channel disk2: starting archived log backup set

channel disk2: specifying archived log(s) in backup set

input archived log thread=1 sequence=111 RECID=88 STAMP=843315317

input archived log thread=1 sequence=112 RECID=89 STAMP=843315321

input archived log thread=1 sequence=113 RECID=90 STAMP=843315338

input archived log thread=1 sequence=114 RECID=91 STAMP=843315341

input archived log thread=1 sequence=115 RECID=92 STAMP=843315342

channel disk2: starting piece 1 at 27-MAR-14

channel disk1: finished piece 1 at 27-MAR-14

piece handle=/oracle/A01/backup/1up48442_1_1 tag=TAG20140327T155754 comment=NONE

channel disk1: backup set complete, elapsed time: 00:00:01

channel disk1: starting archived log backup set

channel disk1: specifying archived log(s) in backup set

input archived log thread=1 sequence=116 RECID=93 STAMP=843315810

input archived log thread=1 sequence=117 RECID=94 STAMP=843320476

input archived log thread=1 sequence=118 RECID=95 STAMP=843321474

channel disk1: starting piece 1 at 27-MAR-14

channel disk2: finished piece 1 at 27-MAR-14

piece handle=/oracle/A01/backup/1vp48442_1_1 tag=TAG20140327T155754 comment=NONE

channel disk2: backup set complete, elapsed time: 00:00:01

channel disk1: finished piece 1 at 27-MAR-14

piece handle=/oracle/A01/backup/20p48443_1_1 tag=TAG20140327T155754 comment=NONE

channel disk1: backup set complete, elapsed time: 00:00:01

Finished backup at 27-MAR-14

Starting backup at 27-MAR-14

channel disk1: starting full datafile backup set

channel disk1: specifying datafile(s) in backup set

input datafile file number=00056 name=/oracle/A01/sapdata1/crm_45/crm.data45

input datafile file number=00058 name=/oracle/A01/sapdata1/crm_47/crm.data47

input datafile file number=00006 name=/oracle/A01/sapdata1/crm_3/crm.data3

input datafile file number=00008 name=/oracle/A01/sapdata1/crm_5/crm.data5

input datafile file number=00010 name=/oracle/A01/sapdata1/crm_7/crm.data7

input datafile file number=00012 name=/oracle/A01/sapdata1/crm_9/crm.data9

input datafile file number=00014 name=/oracle/A01/sapdata1/crm_11/crm.data11

input datafile file number=00016 name=/oracle/A01/sapdata1/crm_13/crm.data13

input datafile file number=00018 name=/oracle/A01/sapdata1/crm_15/crm.data15

input datafile file number=00020 name=/oracle/A01/sapdata1/crm_17/crm.data17

input datafile file number=00022 name=/oracle/A01/sapdata1/crm_19/crm.data19

input datafile file number=00024 name=/oracle/A01/sapdata1/crm_21/crm.data21

input datafile file number=00026 name=/oracle/A01/sapdata1/crm_23/crm.data23

input datafile file number=00032 name=/oracle/A01/sapdata1/crm701_6/crm701.data6

input datafile file number=00035 name=/oracle/A01/sapdata1/crm_24/crm.data24

input datafile file number=00037 name=/oracle/A01/sapdata1/crm_26/crm.data26

input datafile file number=00039 name=/oracle/A01/sapdata1/crm_28/crm.data28

input datafile file number=00041 name=/oracle/A01/sapdata1/crm_30/crm.data30

input datafile file number=00043 name=/oracle/A01/sapdata1/crm_32/crm.data32

input datafile file number=00045 name=/oracle/A01/sapdata1/crm_34/crm.data34

input datafile file number=00047 name=/oracle/A01/sapdata1/crm_36/crm.data36

input datafile file number=00049 name=/oracle/A01/sapdata1/crm_38/crm.data38

input datafile file number=00051 name=/oracle/A01/sapdata1/crm_40/crm.data40

input datafile file number=00053 name=/oracle/A01/sapdata1/crm_42/crm.data42

input datafile file number=00055 name=/oracle/A01/sapdata1/crm_44/crm.data44

input datafile file number=00028 name=/oracle/A01/sapdata1/crm701_2/crm701.data2

input datafile file number=00029 name=/oracle/A01/sapdata1/crm701_3/crm701.data3

input datafile file number=00034 name=/oracle/A01/sapdata1/crmusr_1/crmusr.data1

input datafile file number=00001 name=/oracle/A01/sapdata1/system_1/system.data1

channel disk1: starting piece 1 at 27-MAR-14

channel disk2: starting full datafile backup set

channel disk2: specifying datafile(s) in backup set

input datafile file number=00057 name=/oracle/A01/sapdata1/crm_46/crm.data46

input datafile file number=00002 name=/oracle/A01/sapdata1/undo_1/undo.data1

input datafile file number=00004 name=/oracle/A01/sapdata1/crm_1/crm.data1

input datafile file number=00005 name=/oracle/A01/sapdata1/crm_2/crm.data2

input datafile file number=00007 name=/oracle/A01/sapdata1/crm_4/crm.data4

input datafile file number=00009 name=/oracle/A01/sapdata1/crm_6/crm.data6

input datafile file number=00011 name=/oracle/A01/sapdata1/crm_8/crm.data8

input datafile file number=00013 name=/oracle/A01/sapdata1/crm_10/crm.data10

input datafile file number=00015 name=/oracle/A01/sapdata1/crm_12/crm.data12

input datafile file number=00017 name=/oracle/A01/sapdata1/crm_14/crm.data14

input datafile file number=00019 name=/oracle/A01/sapdata1/crm_16/crm.data16

input datafile file number=00021 name=/oracle/A01/sapdata1/crm_18/crm.data18

input datafile file number=00023 name=/oracle/A01/sapdata1/crm_20/crm.data20

input datafile file number=00025 name=/oracle/A01/sapdata1/crm_22/crm.data22

input datafile file number=00031 name=/oracle/A01/sapdata1/crm701_5/crm701.data5

input datafile file number=00033 name=/oracle/A01/sapdata1/crm701_7/crm701.data7

input datafile file number=00036 name=/oracle/A01/sapdata1/crm_25/crm.data25

input datafile file number=00038 name=/oracle/A01/sapdata1/crm_27/crm.data27

input datafile file number=00040 name=/oracle/A01/sapdata1/crm_29/crm.data29

input datafile file number=00042 name=/oracle/A01/sapdata1/crm_31/crm.data31

input datafile file number=00044 name=/oracle/A01/sapdata1/crm_33/crm.data33

input datafile file number=00046 name=/oracle/A01/sapdata1/crm_35/crm.data35

input datafile file number=00048 name=/oracle/A01/sapdata1/crm_37/crm.data37

input datafile file number=00050 name=/oracle/A01/sapdata1/crm_39/crm.data39

input datafile file number=00052 name=/oracle/A01/sapdata1/crm_41/crm.data41

input datafile file number=00054 name=/oracle/A01/sapdata1/crm_43/crm.data43

input datafile file number=00030 name=/oracle/A01/sapdata1/crm701_4/crm701.data4

input datafile file number=00027 name=/oracle/A01/sapdata1/crm701_1/crm701.data1

input datafile file number=00003 name=/oracle/A01/sapdata1/sysaux_1/sysaux.data1

channel disk2: starting piece 1 at 27-MAR-14

channel disk2: finished piece 1 at 27-MAR-14

piece handle=/oracle/A01/backup/22p48446_1_1 tag=TAG20140327T155756 comment=NONE

channel disk2: backup set complete, elapsed time: 00:30:12

channel disk1: finished piece 1 at 27-MAR-14

piece handle=/oracle/A01/backup/21p48446_1_1 tag=TAG20140327T155756 comment=NONE

channel disk1: backup set complete, elapsed time: 00:30:22

Finished backup at 27-MAR-14

Starting backup at 27-MAR-14

current log archived

channel disk1: starting archived log backup set

channel disk1: specifying archived log(s) in backup set

input archived log thread=1 sequence=119 RECID=96 STAMP=843323300

channel disk1: starting piece 1 at 27-MAR-14

channel disk1: finished piece 1 at 27-MAR-14

piece handle=/oracle/A01/backup/23p485t4_1_1 tag=TAG20140327T162820 comment=NONE

channel disk1: backup set complete, elapsed time: 00:00:01

Finished backup at 27-MAR-14

Starting Control File and SPFILE Autobackup at 27-MAR-14

piece handle=/oracle/A01/112_64/dbs/c-54469256-20140327-00 comment=NONE

Finished Control File and SPFILE Autobackup at 27-MAR-14

released channel: disk1

released channel: disk2

Sollte es bei der Sicherung zu Problemen mit den Archivelogs kommen hilft ein Crosscheck i.d.R. weiter, wenn z.B. ein gestartetes Backup mit der Meldung abbricht, dass ein erwartetes Archivelog nicht verfügbar ist:

RMAN> run

2> {

3> ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/dev/null/';

4> BACKUP DATABASE PLUS ARCHIVELOG;

5> release channel disk1;

6> }

allocated channel: disk1

channel disk1: SID=39 device type=DISK

Starting backup at 04-APR-14

ORACLE error from target database:

ORA-00258: manual archiving in NOARCHIVELOG mode must identify log

released channel: disk1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup plus archivelog command at 04/04/2014 16:07:03

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

ORA-19625: error identifying file /oracle/A01/oraarch/A01arch1_1_821223336.dbf

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

Rman räumt mit einem corsscheck archivelog all entsprechend auf:

RMAN> crosscheck archivelog all;

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=39 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=70 device type=DISK

validation failed for archived log

archived log file name=/oracle/A01/oraarch/A01arch1_1_821223336.dbf RECID=1 STAMP=821412030

validation failed for archived log

archived log file name=/oracle/A01/oraarch/A01arch1_2_821223336.dbf RECID=2 STAMP=821628786

[…]

validation failed for archived log

archived log file name=/oracle/A01/oraarch/A01arch1_85_821223336.dbf RECID=85 STAMP=826509655

validation failed for archived log

archived log file name=/oracle/A01/oraarch/A01arch1_86_821223336.dbf RECID=86 STAMP=826548893

Crosschecked 86 objects

Die mit rman angefertigten Backups kann man sich mit list backup anzeigen lassen:

RMAN> LIST BACKUP;

List of Backup Sets

===================

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

1       44.50K     DISK        00:00:00     27-MAR-14

BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T155754

Piece Name: /oracle/A01/backup/1vp48442_1_1

List of Archived Logs in backup set 1

Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

---- ------- ---------- --------- ---------- ---------

1    111     8076014695 27-MAR-14 8076014735 27-MAR-14

1    112     8076014735 27-MAR-14 8076014738 27-MAR-14

1    113     8076014738 27-MAR-14 8076014748 27-MAR-14

1    114     8076014748 27-MAR-14 8076014752 27-MAR-14

1    115     8076014752 27-MAR-14 8076014755 27-MAR-14

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

2       182.32M    DISK        00:00:01     27-MAR-14

BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T155754

Piece Name: /oracle/A01/backup/1up48442_1_1

List of Archived Logs in backup set 2

Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

---- ------- ---------- --------- ---------- ---------

1    110     8075852809 27-MAR-14 8076014695 27-MAR-14

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

3       22.40M     DISK        00:00:00     27-MAR-14

BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T155754

Piece Name: /oracle/A01/backup/20p48443_1_1

List of Archived Logs in backup set 3

Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

---- ------- ---------- --------- ---------- ---------

1    116     8076014755 27-MAR-14 8076017024 27-MAR-14

1    117     8076017024 27-MAR-14 8076031879 27-MAR-14

1    118     8076031879 27-MAR-14 8076034908 27-MAR-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

4       Full    241.23G    DISK        00:30:11     27-MAR-14

BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T155756

Piece Name: /oracle/A01/backup/22p48446_1_1

List of Datafiles in backup set 4

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

2       Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/undo_1/undo.data1

3       Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/sysaux_1/sysaux.data1

4       Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_1/crm.data1

5       Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_2/crm.data2

7       Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_4/crm.data4

9       Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_6/crm.data6

11      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_8/crm.data8

13      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_10/crm.data10

15      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_12/crm.data12

17      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_14/crm.data14

19      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_16/crm.data16

21      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_18/crm.data18

23      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_20/crm.data20

25      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_22/crm.data22

27      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm701_1/crm701.data1

30      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm701_4/crm701.data4

31      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm701_5/crm701.data5

33      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm701_7/crm701.data7

36      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_25/crm.data25

38      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_27/crm.data27

40      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_29/crm.data29

42      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_31/crm.data31

44      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_33/crm.data33

46      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_35/crm.data35

48      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_37/crm.data37

50      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_39/crm.data39

52      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_41/crm.data41

54      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_43/crm.data43

57      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_46/crm.data46

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

5       Full    242.58G    DISK        00:30:18     27-MAR-14

BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T155756

Piece Name: /oracle/A01/backup/21p48446_1_1

List of Datafiles in backup set 5

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

1       Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/system_1/system.data1

6       Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_3/crm.data3

8       Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_5/crm.data5

10      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_7/crm.data7

12      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_9/crm.data9

14      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_11/crm.data11

16      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_13/crm.data13

18      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_15/crm.data15

20      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_17/crm.data17

22      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_19/crm.data19

24      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_21/crm.data21

26      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_23/crm.data23

28      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm701_2/crm701.data2

29      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm701_3/crm701.data3

32      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm701_6/crm701.data6

34      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crmusr_1/crmusr.data1

35      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_24/crm.data24

37      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_26/crm.data26

39      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_28/crm.data28

41      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_30/crm.data30

43      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_32/crm.data32

45      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_34/crm.data34

47      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_36/crm.data36

49      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_38/crm.data38

51      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_40/crm.data40

53      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_42/crm.data42

55      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_44/crm.data44

56      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_45/crm.data45

58      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_47/crm.data47

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

6       6.04M      DISK        00:00:00     27-MAR-14

BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T162820

Piece Name: /oracle/A01/backup/23p485t4_1_1

List of Archived Logs in backup set 6

Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

---- ------- ---------- --------- ---------- ---------

1    119     8076034908 27-MAR-14 8076040522 27-MAR-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

7       Full    17.80M     DISK        00:00:00     27-MAR-14

BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T162821

Piece Name: /oracle/A01/112_64/dbs/c-54469256-20140327-00

SPFILE Included: Modification time: 25-JUL-13

SPFILE db_unique_name: A01

Control File Included: Ckp SCN: 8076040531   Ckp time: 27-MAR-14

RMAN>

Der Restore mit rman läuft wie folgt beschrieben ab:

Zunächst wird die Datenbank gestoppt.

server:oraA01 48> sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 28 09:19:40 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Bevor das Backup zurück gespielt werden kann müssen die Data-Files im sapdata* gelöscht werden. Somit wird verhindert, dass Files, die nach dem Backup erzeugt wurden im Filesystem liegen bleiben und dort verweisen bzw. es beim erneuten Anlegen zu Fehlern kommt. Achtung, es sollten nur die data-Files und nicht die Ordner gelöscht werden, denn im Gegensatz zu den brtools erstellt rman die benötigten Zielordner für die data-Files nicht selbstständig. Wer also eine größere mkdir-Schleife verhindern will sollte hier Vorsicht walten lassen. Sofern die Zielverzeichnisse nicht vorhanden sind kann das Datenfile nicht restored werden und der Restore schlägt fehl!

find /oracle/A01/sapdata* -type file -exec ls -al {} \;

Wenn die Ausgabe OK ist und nur Datafiles enthält kann per find gelöscht werden:

find /oracle/A01/sapdata* -type file –exec rm {} \;

Die Datenbank wird zunächst in den nomount-Status gebracht. Anschließend wird das crontrolfile aus der Sicherung restored.

server:oraA01 56> sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 28 09:28:28 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 2388422656 bytes

Fixed Size                  2209096 bytes

Variable Size            1207962296 bytes

Database Buffers         1174405120 bytes

Redo Buffers                3846144 bytes

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Als nächstes wird rman gestartet. Beim Start von rman gibt dieser nach dem connect target zwar die SID aus, nicht mehr jedoch die DBID!

server:oraA01 57> rman

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Mar 28 09:28:44 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target /

connected to target database: A01 (not mounted)

Um die DBID, die man sich aus dem ersten connect während des Backuplaufs geholt hat zu setzen gibt man rman die DBID per set Befehl vor:

rman> SET DBID 54469256;

Sollte man die ID nicht haben, so findet man diese zum Beispiel im Oracle Alertlog:

server:oraA01 28> grep -i dbid /oracle/A01/saptrace/diag/rdbms/a01/A01/trace/alert_A01.log

DBID will be changed from 3773767397 to new DBID of 35226790 for database A01

DBID will be changed from 3773767397 to new DBID of 54469256 for database A01

server:oraA01 29>

Nachdem die DBID bekannt ist kann das Controlfile als Basis für weitere Aktivitäten restored werden:

RMAN> run

2> {

3> ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/oracle/A01/backup/%U';

4> RESTORE CONTROLFILE FROM AUTOBACKUP;

5>   release channel disk1;

6> }

allocated channel: disk1

channel disk1: SID=96 device type=DISK

Starting restore at 28-MAR-14

channel disk1: looking for AUTOBACKUP on day: 20140328

channel disk1: AUTOBACKUP found: c-54469256-20140327-01

channel disk1: restoring control file from AUTOBACKUP c-54469256-20140327-01

channel disk1: control file restore from AUTOBACKUP complete

output file name=/oracle/A01/origlogA/cntrl/cntrlA01.dbf

output file name=/oracle/A01/origlogB/cntrl/cntrlA01.dbf

output file name=/oracle/A01/sapdata1/cntrl/cntrlA01.dbf

Finished restore at 28-MAR-14

released channel: disk1

RMAN>

Nachdem das Controlfile wieder verfügbar ist kann die DB gemounted werden.

SQL> alter database mount;

Database altered.

SQL>

Der Restore wird gestartet:

a) rman restore mit recover starten

rman>

run

{

ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/oracle/A01/backup/%U';

ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/oracle/A01/backup/%U';

set until time "to_date('2014-03-28 12:30:00', 'YYYY-MM-DD HH24:MI:SS')"; --> Zeitstempel kurz vor dem letzten Archivelog (Completion Time).

RESTORE DATABASE;

RECOVER DATABASE;

release channel disk1;

release channel disk2;

}

b) rman restore mit manuellem recover starten

Wird der rman ohne recover gestartet müssen hinterher die Archivelogs per sql recover nachgezogen werden.

RMAN> run

{

ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/oracle/A01/backup/%U';

ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/oracle/A01/backup/%U';

RESTORE DATABASE;

release channel disk1;

release channel disk2;

}

allocated channel: disk1

channel disk1: SID=127 device type=DISK

Starting restore at 28-MAR-14

channel disk1: starting datafile backup set restore

channel disk1: specifying datafile(s) to restore from backup set

channel disk1: restoring datafile 00001 to /oracle/A01/sapdata1/system_1/system.data1

channel disk1: restoring datafile 00007 to /oracle/A01/sapdata1/crm_4/crm.data4

channel disk1: restoring datafile 00011 to /oracle/A01/sapdata1/crm_8/crm.data8

channel disk1: restoring datafile 00015 to /oracle/A01/sapdata1/crm_12/crm.data12

channel disk1: restoring datafile 00019 to /oracle/A01/sapdata1/crm_16/crm.data16

channel disk1: restoring datafile 00023 to /oracle/A01/sapdata1/crm_20/crm.data20

channel disk1: restoring datafile 00030 to /oracle/A01/sapdata1/crm701_4/crm701.data4

channel disk1: restoring datafile 00031 to /oracle/A01/sapdata1/crm701_5/crm701.data5

channel disk1: restoring datafile 00036 to /oracle/A01/sapdata1/crm_25/crm.data25

channel disk1: restoring datafile 00040 to /oracle/A01/sapdata1/crm_29/crm.data29

channel disk1: restoring datafile 00044 to /oracle/A01/sapdata1/crm_33/crm.data33

channel disk1: restoring datafile 00048 to /oracle/A01/sapdata1/crm_37/crm.data37

channel disk1: restoring datafile 00052 to /oracle/A01/sapdata1/crm_41/crm.data41

channel disk1: restoring datafile 00057 to /oracle/A01/sapdata1/crm_46/crm.data46

channel disk1: reading from backup piece /oracle/A01/backup/2cp486a5_1_1

channel disk1: piece handle=/oracle/A01/backup/2cp486a5_1_1 tag=TAG20140327T163515

channel disk1: restored backup piece 1

channel disk1: restore complete, elapsed time: 00:23:15

channel disk1: starting datafile backup set restore

channel disk1: specifying datafile(s) to restore from backup set

channel disk1: restoring datafile 00002 to /oracle/A01/sapdata1/undo_1/undo.data1

channel disk1: restoring datafile 00003 to /oracle/A01/sapdata1/sysaux_1/sysaux.data1

channel disk1: restoring datafile 00004 to /oracle/A01/sapdata1/crm_1/crm.data1

channel disk1: restoring datafile 00005 to /oracle/A01/sapdata1/crm_2/crm.data2

channel disk1: restoring datafile 00009 to /oracle/A01/sapdata1/crm_6/crm.data6

channel disk1: restoring datafile 00013 to /oracle/A01/sapdata1/crm_10/crm.data10

channel disk1: restoring datafile 00017 to /oracle/A01/sapdata1/crm_14/crm.data14

channel disk1: restoring datafile 00021 to /oracle/A01/sapdata1/crm_18/crm.data18

channel disk1: restoring datafile 00025 to /oracle/A01/sapdata1/crm_22/crm.data22

channel disk1: restoring datafile 00033 to /oracle/A01/sapdata1/crm701_7/crm701.data7

channel disk1: restoring datafile 00038 to /oracle/A01/sapdata1/crm_27/crm.data27

channel disk1: restoring datafile 00042 to /oracle/A01/sapdata1/crm_31/crm.data31

channel disk1: restoring datafile 00046 to /oracle/A01/sapdata1/crm_35/crm.data35

channel disk1: restoring datafile 00050 to /oracle/A01/sapdata1/crm_39/crm.data39

channel disk1: restoring datafile 00054 to /oracle/A01/sapdata1/crm_43/crm.data43

channel disk1: reading from backup piece /oracle/A01/backup/2dp486a5_1_1

channel disk1: piece handle=/oracle/A01/backup/2dp486a5_1_1 tag=TAG20140327T163515

channel disk1: restored backup piece 1

channel disk1: restore complete, elapsed time: 00:20:55

channel disk1: starting datafile backup set restore

channel disk1: specifying datafile(s) to restore from backup set

channel disk1: restoring datafile 00008 to /oracle/A01/sapdata1/crm_5/crm.data5

channel disk1: restoring datafile 00012 to /oracle/A01/sapdata1/crm_9/crm.data9

channel disk1: restoring datafile 00016 to /oracle/A01/sapdata1/crm_13/crm.data13

channel disk1: restoring datafile 00020 to /oracle/A01/sapdata1/crm_17/crm.data17

channel disk1: restoring datafile 00024 to /oracle/A01/sapdata1/crm_21/crm.data21

channel disk1: restoring datafile 00028 to /oracle/A01/sapdata1/crm701_2/crm701.data2

channel disk1: restoring datafile 00029 to /oracle/A01/sapdata1/crm701_3/crm701.data3

channel disk1: restoring datafile 00032 to /oracle/A01/sapdata1/crm701_6/crm701.data6

channel disk1: restoring datafile 00034 to /oracle/A01/sapdata1/crmusr_1/crmusr.data1

channel disk1: restoring datafile 00037 to /oracle/A01/sapdata1/crm_26/crm.data26

channel disk1: restoring datafile 00041 to /oracle/A01/sapdata1/crm_30/crm.data30

channel disk1: restoring datafile 00045 to /oracle/A01/sapdata1/crm_34/crm.data34

channel disk1: restoring datafile 00049 to /oracle/A01/sapdata1/crm_38/crm.data38

channel disk1: restoring datafile 00053 to /oracle/A01/sapdata1/crm_42/crm.data42

channel disk1: restoring datafile 00058 to /oracle/A01/sapdata1/crm_47/crm.data47

channel disk1: reading from backup piece /oracle/A01/backup/2bp486a5_1_1

channel disk1: piece handle=/oracle/A01/backup/2bp486a5_1_1 tag=TAG20140327T163515

channel disk1: restored backup piece 1

channel disk1: restore complete, elapsed time: 00:22:06

channel disk1: starting datafile backup set restore

channel disk1: specifying datafile(s) to restore from backup set

channel disk1: restoring datafile 00006 to /oracle/A01/sapdata1/crm_3/crm.data3

channel disk1: restoring datafile 00010 to /oracle/A01/sapdata1/crm_7/crm.data7

channel disk1: restoring datafile 00014 to /oracle/A01/sapdata1/crm_11/crm.data11

channel disk1: restoring datafile 00018 to /oracle/A01/sapdata1/crm_15/crm.data15

channel disk1: restoring datafile 00022 to /oracle/A01/sapdata1/crm_19/crm.data19

channel disk1: restoring datafile 00026 to /oracle/A01/sapdata1/crm_23/crm.data23

channel disk1: restoring datafile 00027 to /oracle/A01/sapdata1/crm701_1/crm701.data1

channel disk1: restoring datafile 00035 to /oracle/A01/sapdata1/crm_24/crm.data24

channel disk1: restoring datafile 00031 to /oracle/A01/sapdata1/crm701_5/crm701.data5

channel disk1: restoring datafile 00036 to /oracle/A01/sapdata1/crm_25/crm.data25

channel disk1: restoring datafile 00040 to /oracle/A01/sapdata1/crm_29/crm.data29

channel disk1: restoring datafile 00044 to /oracle/A01/sapdata1/crm_33/crm.data33

channel disk1: restoring datafile 00048 to /oracle/A01/sapdata1/crm_37/crm.data37

channel disk1: restoring datafile 00052 to /oracle/A01/sapdata1/crm_41/crm.data41

channel disk1: restoring datafile 00057 to /oracle/A01/sapdata1/crm_46/crm.data46

channel disk1: reading from backup piece /oracle/A01/backup/2cp486a5_1_1

channel disk1: piece handle=/oracle/A01/backup/2cp486a5_1_1 tag=TAG20140327T163515

channel disk1: restored backup piece 1

channel disk1: restore complete, elapsed time: 00:23:15

channel disk1: starting datafile backup set restore

channel disk1: specifying datafile(s) to restore from backup set

channel disk1: restoring datafile 00002 to /oracle/A01/sapdata1/undo_1/undo.data1

channel disk1: restoring datafile 00003 to /oracle/A01/sapdata1/sysaux_1/sysaux.data1

channel disk1: restoring datafile 00004 to /oracle/A01/sapdata1/crm_1/crm.data1

channel disk1: restoring datafile 00005 to /oracle/A01/sapdata1/crm_2/crm.data2

channel disk1: restoring datafile 00009 to /oracle/A01/sapdata1/crm_6/crm.data6

channel disk1: restoring datafile 00013 to /oracle/A01/sapdata1/crm_10/crm.data10

channel disk1: restoring datafile 00017 to /oracle/A01/sapdata1/crm_14/crm.data14

channel disk1: restoring datafile 00021 to /oracle/A01/sapdata1/crm_18/crm.data18

channel disk1: restoring datafile 00025 to /oracle/A01/sapdata1/crm_22/crm.data22

channel disk1: restoring datafile 00033 to /oracle/A01/sapdata1/crm701_7/crm701.data7

channel disk1: restoring datafile 00038 to /oracle/A01/sapdata1/crm_27/crm.data27

channel disk1: restoring datafile 00042 to /oracle/A01/sapdata1/crm_31/crm.data31

channel disk1: restoring datafile 00046 to /oracle/A01/sapdata1/crm_35/crm.data35

channel disk1: restoring datafile 00050 to /oracle/A01/sapdata1/crm_39/crm.data39

channel disk1: restoring datafile 00054 to /oracle/A01/sapdata1/crm_43/crm.data43

channel disk1: reading from backup piece /oracle/A01/backup/2dp486a5_1_1

channel disk1: piece handle=/oracle/A01/backup/2dp486a5_1_1 tag=TAG20140327T163515

channel disk1: restored backup piece 1

channel disk1: restore complete, elapsed time: 00:20:55

channel disk1: starting datafile backup set restore

channel disk1: specifying datafile(s) to restore from backup set

channel disk1: restoring datafile 00008 to /oracle/A01/sapdata1/crm_5/crm.data5

channel disk1: restoring datafile 00012 to /oracle/A01/sapdata1/crm_9/crm.data9

channel disk1: restoring datafile 00016 to /oracle/A01/sapdata1/crm_13/crm.data13

channel disk1: restoring datafile 00020 to /oracle/A01/sapdata1/crm_17/crm.data17

channel disk1: restoring datafile 00024 to /oracle/A01/sapdata1/crm_21/crm.data21

channel disk1: restoring datafile 00028 to /oracle/A01/sapdata1/crm701_2/crm701.data2

channel disk1: restoring datafile 00029 to /oracle/A01/sapdata1/crm701_3/crm701.data3

channel disk1: restoring datafile 00032 to /oracle/A01/sapdata1/crm701_6/crm701.data6

channel disk1: restoring datafile 00034 to /oracle/A01/sapdata1/crmusr_1/crmusr.data1

channel disk1: restoring datafile 00037 to /oracle/A01/sapdata1/crm_26/crm.data26

channel disk1: restoring datafile 00041 to /oracle/A01/sapdata1/crm_30/crm.data30

channel disk1: restoring datafile 00045 to /oracle/A01/sapdata1/crm_34/crm.data34

channel disk1: restoring datafile 00049 to /oracle/A01/sapdata1/crm_38/crm.data38

channel disk1: restoring datafile 00053 to /oracle/A01/sapdata1/crm_42/crm.data42

channel disk1: restoring datafile 00058 to /oracle/A01/sapdata1/crm_47/crm.data47

channel disk1: reading from backup piece /oracle/A01/backup/2bp486a5_1_1

channel disk1: piece handle=/oracle/A01/backup/2bp486a5_1_1 tag=TAG20140327T163515

channel disk1: restored backup piece 1

channel disk1: restore complete, elapsed time: 00:22:06

channel disk1: starting datafile backup set restore

channel disk1: specifying datafile(s) to restore from backup set

channel disk1: restoring datafile 00006 to /oracle/A01/sapdata1/crm_3/crm.data3

channel disk1: restoring datafile 00010 to /oracle/A01/sapdata1/crm_7/crm.data7

channel disk1: restoring datafile 00014 to /oracle/A01/sapdata1/crm_11/crm.data11

channel disk1: restoring datafile 00018 to /oracle/A01/sapdata1/crm_15/crm.data15

channel disk1: restoring datafile 00022 to /oracle/A01/sapdata1/crm_19/crm.data19

channel disk1: restoring datafile 00026 to /oracle/A01/sapdata1/crm_23/crm.data23

channel disk1: restoring datafile 00027 to /oracle/A01/sapdata1/crm701_1/crm701.data1

channel disk1: restoring datafile 00035 to /oracle/A01/sapdata1/crm_24/crm.data24

4       Full    241.23G    DISK        00:30:11     27-MAR-14

BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T155756

Piece Name: /oracle/A01/backup/22p48446_1_1

List of Datafiles in backup set 4

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

2       Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/undo_1/undo.data1

3       Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/sysaux_1/sysaux.data1

4       Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_1/crm.data1

5       Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_2/crm.data2

7       Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_4/crm.data4

9       Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_6/crm.data6

11      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_8/crm.data8

13      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_10/crm.data10

15      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_12/crm.data12

17      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_14/crm.data14

19      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_16/crm.data16

21      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_18/crm.data18

23      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_20/crm.data20

25      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_22/crm.data22

27      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm701_1/crm701.data1

30      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm701_4/crm701.data4

31      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm701_5/crm701.data5

33      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm701_7/crm701.data7

36      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_25/crm.data25

38      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_27/crm.data27

40      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_29/crm.data29

42      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_31/crm.data31

44      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_33/crm.data33

46      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_35/crm.data35

48      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_37/crm.data37

50      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_39/crm.data39

52      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_41/crm.data41

54      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_43/crm.data43

57      Full 8076034916 27-MAR-14 /oracle/A01/sapdata1/crm_46/crm.data46

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

5       Full    242.58G    DISK        00:30:18     27-MAR-14

BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T155756

Piece Name: /oracle/A01/backup/21p48446_1_1

List of Datafiles in backup set 5

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

1       Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/system_1/system.data1

6       Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_3/crm.data3

8       Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_5/crm.data5

10      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_7/crm.data7

12      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_9/crm.data9

14      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_11/crm.data11

16      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_13/crm.data13

18      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_15/crm.data15

20      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_17/crm.data17

22      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_19/crm.data19

24      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_21/crm.data21

26      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_23/crm.data23

28      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm701_2/crm701.data2

29      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm701_3/crm701.data3

32      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm701_6/crm701.data6

34      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crmusr_1/crmusr.data1

35      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_24/crm.data24

37      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_26/crm.data26

39      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_28/crm.data28

41      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_30/crm.data30

43      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_32/crm.data32

45      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_34/crm.data34

47      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_36/crm.data36

49      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_38/crm.data38

51      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_40/crm.data40

53      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_42/crm.data42

55      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_44/crm.data44

56      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_45/crm.data45

58      Full 8076034914 27-MAR-14 /oracle/A01/sapdata1/crm_47/crm.data47

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

6       6.04M      DISK        00:00:00     27-MAR-14

BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T162820

Piece Name: /oracle/A01/backup/23p485t4_1_1

List of Archived Logs in backup set 6

Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

---- ------- ---------- --------- ---------- ---------

1    119     8076034908 27-MAR-14 8076040522 27-MAR-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

7       Full    17.80M     DISK        00:00:00     27-MAR-14

BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T162821

Piece Name: /oracle/A01/112_64/dbs/c-54469256-20140327-00

SPFILE Included: Modification time: 25-JUL-13

SPFILE db_unique_name: A01

Control File Included: Ckp SCN: 8076040531   Ckp time: 27-MAR-14

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

8       16.00K     DISK        00:00:00     27-MAR-14

BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T163512

Piece Name: /oracle/A01/backup/27p486a1_1_1

List of Archived Logs in backup set 8

Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

---- ------- ---------- --------- ---------- ---------

1    121     8076041662 27-MAR-14 8076041666 27-MAR-14

1    122     8076041666 27-MAR-14 8076041669 27-MAR-14

1    123     8076041669 27-MAR-14 8076041673 27-MAR-14

1    124     8076041673 27-MAR-14 8076041676 27-MAR-14

1    125     8076041676 27-MAR-14 8076041679 27-MAR-14

1    126     8076041679 27-MAR-14 8076041682 27-MAR-14

1    127     8076041682 27-MAR-14 8076041685 27-MAR-14

1    128     8076041685 27-MAR-14 8076041692 27-MAR-14

1    129     8076041692 27-MAR-14 8076041695 27-MAR-14

1    130     8076041695 27-MAR-14 8076041702 27-MAR-14

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

9       29.27M     DISK        00:00:01     27-MAR-14

BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T163512

Piece Name: /oracle/A01/backup/26p486a0_1_1

List of Archived Logs in backup set 9

Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

---- ------- ---------- --------- ---------- ---------

1    111     8076014695 27-MAR-14 8076014735 27-MAR-14

1    112     8076014735 27-MAR-14 8076014738 27-MAR-14

1    113     8076014738 27-MAR-14 8076014748 27-MAR-14

1    114     8076014748 27-MAR-14 8076014752 27-MAR-14

1    115     8076014752 27-MAR-14 8076014755 27-MAR-14

1    116     8076014755 27-MAR-14 8076017024 27-MAR-14

1    117     8076017024 27-MAR-14 8076031879 27-MAR-14

1    118     8076031879 27-MAR-14 8076034908 27-MAR-14

1    119     8076034908 27-MAR-14 8076040522 27-MAR-14

1    120     8076040522 27-MAR-14 8076041662 27-MAR-14

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

10      7.50K      DISK        00:00:00     27-MAR-14

BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T163512

Piece Name: /oracle/A01/backup/28p486a1_1_1

List of Archived Logs in backup set 10

Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

---- ------- ---------- --------- ---------- ---------

1    131     8076041702 27-MAR-14 8076041705 27-MAR-14

1    132     8076041705 27-MAR-14 8076041709 27-MAR-14

1    133     8076041709 27-MAR-14 8076041712 27-MAR-14

1    134     8076041712 27-MAR-14 8076041715 27-MAR-14

1    135     8076041715 27-MAR-14 8076041718 27-MAR-14

1    136     8076041718 27-MAR-14 8076041721 27-MAR-14

1    137     8076041721 27-MAR-14 8076041724 27-MAR-14

1    138     8076041724 27-MAR-14 8076041727 27-MAR-14

1    139     8076041727 27-MAR-14 8076041730 27-MAR-14

1    140     8076041730 27-MAR-14 8076041733 27-MAR-14

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

11      182.32M    DISK        00:00:01     27-MAR-14

BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T163512

Piece Name: /oracle/A01/backup/25p486a0_1_1

List of Archived Logs in backup set 11

Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

---- ------- ---------- --------- ---------- ---------

1    110     8075852809 27-MAR-14 8076014695 27-MAR-14

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

12      6.50K      DISK        00:00:00     27-MAR-14

BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T163512

Piece Name: /oracle/A01/backup/29p486a2_1_1

List of Archived Logs in backup set 12

Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

---- ------- ---------- --------- ---------- ---------

1    141     8076041733 27-MAR-14 8076041736 27-MAR-14

1    142     8076041736 27-MAR-14 8076041739 27-MAR-14

1    143     8076041739 27-MAR-14 8076041742 27-MAR-14

1    144     8076041742 27-MAR-14 8076041745 27-MAR-14

1    145     8076041745 27-MAR-14 8076041748 27-MAR-14

1    146     8076041748 27-MAR-14 8076041786 27-MAR-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

13      Full    116.45G    DISK        00:30:02     27-MAR-14

BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T163515

Piece Name: /oracle/A01/backup/2cp486a5_1_1

List of Datafiles in backup set 13

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

1       Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/system_1/system.data1

7       Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/crm_4/crm.data4

11      Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/crm_8/crm.data8

15      Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/crm_12/crm.data12

19      Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/crm_16/crm.data16

23      Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/crm_20/crm.data20

30      Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/crm701_4/crm701.data4

31      Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/crm701_5/crm701.data5

36      Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/crm_25/crm.data25

40      Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/crm_29/crm.data29

44      Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/crm_33/crm.data33

48      Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/crm_37/crm.data37

52      Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/crm_41/crm.data41

57      Full 8076041823 27-MAR-14 /oracle/A01/sapdata1/crm_46/crm.data46

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

14      Full    117.67G    DISK        00:30:15     27-MAR-14

BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T163515

Piece Name: /oracle/A01/backup/2dp486a5_1_1

List of Datafiles in backup set 14

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

2       Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/undo_1/undo.data1

3       Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/sysaux_1/sysaux.data1

4       Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/crm_1/crm.data1

5       Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/crm_2/crm.data2

9       Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/crm_6/crm.data6

13      Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/crm_10/crm.data10

17      Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/crm_14/crm.data14

21      Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/crm_18/crm.data18

25      Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/crm_22/crm.data22

33      Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/crm701_7/crm701.data7

38      Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/crm_27/crm.data27

42      Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/crm_31/crm.data31

46      Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/crm_35/crm.data35

50      Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/crm_39/crm.data39

54      Full 8076041824 27-MAR-14 /oracle/A01/sapdata1/crm_43/crm.data43

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

15      Full    124.49G    DISK        00:31:02     27-MAR-14

BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T163515

Piece Name: /oracle/A01/backup/2bp486a5_1_1

List of Datafiles in backup set 15

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

8       Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm_5/crm.data5

12      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm_9/crm.data9

16      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm_13/crm.data13

20      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm_17/crm.data17

24      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm_21/crm.data21

28      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm701_2/crm701.data2

29      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm701_3/crm701.data3

32      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm701_6/crm701.data6

34      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crmusr_1/crmusr.data1

37      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm_26/crm.data26

41      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm_30/crm.data30

45      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm_34/crm.data34

49      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm_38/crm.data38

53      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm_42/crm.data42

58      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm_47/crm.data47

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

58      Full 8076041822 27-MAR-14 /oracle/A01/sapdata1/crm_47/crm.data47

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

16      Full    125.20G    DISK        00:31:06     27-MAR-14

BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T163515

Piece Name: /oracle/A01/backup/2ap486a5_1_1

List of Datafiles in backup set 16

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

6       Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm_3/crm.data3

10      Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm_7/crm.data7

14      Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm_11/crm.data11

18      Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm_15/crm.data15

22      Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm_19/crm.data19

26      Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm_23/crm.data23

27      Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm701_1/crm701.data1

35      Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm_24/crm.data24

39      Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm_28/crm.data28

43      Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm_32/crm.data32

47      Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm_36/crm.data36

51      Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm_40/crm.data40

55      Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm_44/crm.data44

56      Full 8076041821 27-MAR-14 /oracle/A01/sapdata1/crm_45/crm.data45

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

17      5.75M      DISK        00:00:00     27-MAR-14

BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20140327T170633

Piece Name: /oracle/A01/backup/2ep4884p_1_1

List of Archived Logs in backup set 17

Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

---- ------- ---------- --------- ---------- ---------

1    147     8076041786 27-MAR-14 8076047031 27-MAR-14

RMAN>

Das manuelle Recover wird innerhalb von sqlplus ausgeführt. Anschließend wird ein alter database open restlogs abgesetzt und unbedingt eine neue Fullsicherung der Datenbank gezogen!

sql>recover database until time '2014-03-28:12:30:00'
sql>alter database open resetlogs;

Die im Rahmen des Backup2Disk Szenarios gesetzten Parameter sollten wieder auf ihren Standard zurückgestellt werden (default).

Hierzu kann man rman anweisen die Parameter per clear wieder auf Standard zurück zu setzen.

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP clear;
RMAN> CONFIGURE DEVICE TYPE DISK clear;

About the author