backup recovery oracle

document

Swapnil Yeole B a = =�iL;x-8X@�"��1��Arial1��Arial1��Arial1��Arial1&��Courier New1&��Courier New1&��Courier New1&�5�Courier New1&��Courier New1��Arial1�$�Arial1&��Courier New1��Arial1&��Courier New1&��Courier New1&��Courier New1&��Courier New1&��Courier New1&�� Courier New1& Courier New1��Arial1&@��Courier New1&��Courier New1&@��Courier New1��Arial1&�Courier New1&��Courier New1��Arial1&��Courier New1��Arial1&�� Courier New1& 9 Courier New1& Courier New1& Courier New1& Courier New1&��Courier New1&h��Courier New1&��Courier New1&��Courier New1&��Courier New1&�?�Courier New1&�9�Courier New1&�?�Courier New1&��Courier New1&��Courier New1&��Courier New1&��Courier New1&�?�Courier New1&��Courier New1�� Arial1&� �Courier New1& Courier New1& Courier New1&�� Courier New1& Courier New"$"#� ��

+ ) �� H H H) H) H) H) H) H) h@ ) h ) h ) h@@ ) h@ ) h @ ) h@@) h@) h @) H H4 h"" H H H) H H H) H) H H H h@ � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � h@ � h @ � h@@ � H� - H . H " H ! H / H 0 H 1 H H5 H5 H $ H L 4 H H4 H4 5 H )X `�!� � � � � � � � � � � � � � � � � ��MAIN_Backup_Restore_Intro J Examples_and_Notes " Dictionary_views_target_db % SomeDisasterRecoveryScenarios aafterBACKUPBEGIN<BRADV156<� � � � � � ��bycatCAUSE:commandCREATECreation disasterDUPLICATEexistsFIX: forfullGatherGOAL: $group_2.258.603422107hosti1006453<� �IDENTIFIEDinInformationlongernoofonlinelogoriginaloutputfilePAGETOP<fpartsPITRPointprmyrecover.lstrecoveryREF:?RestoringRMANSpooledsthref734<sthref737<sthref77:SYMPTOM:TablespacetestTime&tom3235740567423< 'tom35684184145455<top: TSPITRuserwhenwith `i��z�@=3� � ��3 A�@@��

��sindefenitely. So do not use that ! The clause "immediate" is always the best to use��unix and tapedevice:$# tar -cvf /dev/rmt1.1 /u01/oradata$# tar -cvf /dev/rmt1.1 /u02/oradata$# tar -cvf /dev/rmt1.1 /u03/oradata$# tar -cvf /dev/rmt1.1 /u04/oradata$# tar -cvf /dev/rmt1.1 /u05/oradataPThe exact form of the tar commandsRMAN-catalog.fix:rHow to recover and open the database if the archivelog required for recovery is either missingOS backup 5If the archivelog is not found in any of the above mentioned locationsRMAN 20207$UNTIL TIME is before RESETLOGS time ECheck the UNTIL TIME. If the database needs to be restored to an old ;incarnationdone boolean;begin?devtype:=dbms_backup_restore.deviceallocate( type=>'sbt_tape'ident=>'t1');'dbms_backup_restore.restoresetdatafile;Mdbms_backup_restore.restorecontrolfileto('D:\oracle\ora81\dbs\CTL1rdcs.ORA');(dbms_backup_restore.restorebackuppiece( ;'ORA_RDCS_WEEKLY<rdcs_6222:596513521:1>.dbf'filesperset 5"format "df_%d_%s_%p_%t.lv${LEVEL}"'(database include current controlfile);backupbSuppose you have placed tablespace users offlineDan FosterGuests Posted: Tue Apr 22ReferencesNBug 5556503 - ORA-600 [KRBODO_BADEND] REPORTED IN ALERT.LOG DURING RMAN BACKUPErrorsORA-600[KRBODO_BADEND]KeywordsQ'ASSM' 'LOCALLY~MANAGED' 'ORADEBUG' 'DBMS_SPACE_ADMIN.TABLESPACE_VERIFY' }There is traditional way to recover the user errors i.e drop table by doing incomplete recovery till the time set pause offset serveroutput onset feedback onset echo onset numformat 999999999999999Spool recover.lstshow parameter pfile;archive log list;select * from v$backup;:select file#Any ideas?Rhys.nezih08-03-2005My setup: (TSM server (Enterprise) 5.5 on AIX 5.2. 1TDPO 5.4.1 on Solaris 10/SPARC and Oracle 10gR2. RMAN settings: RMAN> show all; #RMAN configuration parameters are: 9CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; #CONFIGURE BACKUP OPTIMIZATION OFF; -CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'; get an error:1RMAN> change backupset 698Connected to:FOracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production3With the PartitioningReference:----------.Note 1012929.6 How to Recreate the Controlfile02. With new create controlfile please try again:o check all datafiles ONLINE;sql> reocver database until cancel using backup controlfileapply all logs needed#sql> alter databse open resetlogs ;0Note 1012929.6 - How to Recreate the ControlfileMORPHAN; ARCHIVE~LOG~LIST; CONTROLFILE; SCN; ARCHsambavan $Senior Advisor Join Date: Oct 2000Location: SaskatoonPLANNING_DATAPLANNING_INDEXUSERSSYSTEMSYSAUXTEMPUNDO*SQL> alter tablespace SYSTEM begin backup;1SQL> alter tablespace PLANNING_DATA begin backup;Steps:71. My internal IT department setup my TSM domainhey rhysmRMAN-00554RMAN-04004ORA-03135ORA-3136*>>>> In alertlog of the rman(which youwant to backup)>Sosystem.dbfundo.dbftemp.dbfsysaux.dbfredo01.dbfredo02.dbfredo03.dbfcontrol01.ctlcontrol02.ctlcontrol03.ctl6"standard file" and contains the dictionary (metadata)D"standard file" and contains undo data for transactional consistencyM"standard file"To reset the database to a previous incarnation. Typically

�� >� ��

document

If RMAN is connected NOCATALOGConnected.SQL> desc t8 Name Null? TypeP ----------------------------------------- -------- ----------------------------: A NUMBER_a "repository" to store some vital data like which backupsets are associated to which database restore. run {V set until time 'Jul 8 1999 07:55:00'; # set time to just before data was lost) allocate channel dev1 type disk; shutdown abort; startup nomount; restore controlfile;L alter database mount; # mount database after restoring control file restore database;OS commands likecpSQL query:< DBINC_KEY DB_KEY DB_NAME RESET_SCN RESET_TIM DBINC_ST<---------- ---------- -------- ---------- --------- --------QSQL>select DBINC_KEYolder backup.`In this case Symptoms Cause Solution ReferencesApplies to: 8Oracle Server - Enterprise Edition - Version: 10.2.0.1.0'This problem can occur on any platform.SymptomsSolutionDNote that it is "NOT" required to restore the database files again. Here's the gotcha: I setup RMAN to do 'duplex' copies�Dear Friends(D) Datafiles--------------#This obviously is the biggest loss.H(1) If only a few sectors are damagedLet's try:bWhat we want to do nowredo01.log2.8147E+14 A redo02.log redo03.log redo04.log1 -->17402532redo05.log12755 A 1622 D 11 D7FIRST_CHANGE# NEXT_CHANGE# SEQUENCE# RESETLOGS_CHANGE#7------------- ------------ ---------- -----------------7 17311785 17354662 815 < 17 17354662 17354674 816 17 17354674 17402531 817 17 -->17402532 17404154 Note 184327.1Note 198640.1Note 183327.1Note 183367.1 NOARCHIVELOG DATABASE =====================G The loss mentioned in (A) script --O --> Edit the trace file created (check user_dump_dest for the location) andJ retain the SQL commands alone. Save this to a file say cr_ctrl.sql --> Run the script SQL> @cr_ctrlN This would create the controlfile(B) Redo logs ---------MIn normal cases below; ORA-01194: file 1 needs more recovery to be consistent@ ORA-01110: data file 1: '/ORACLE/ORADATA/H817/SYSTEM01.DBF'M In this case

K {��s��Q��7 b}t��

J�� )d�1�9B�@��jyjN N | L��L��.��R��

Iw��Q��p P��4��

&|e $= *& 3 ?;q5CCVHdJSX@ZN� � � �T�

D��]��-N��k��B��7��L��@d��

J!�B(Vd.x��7 >'G#Q� �

^[NgbWXl$ u i5 V7 "�� ^ |T��P̀óGD��R��B��Ԟ��

X vN t��`��@h�7O�� ɀ�3� �$p��

d MbP?_*+ %��M6Microsoft XPS Document Writer�X�� odXXLetter DINU"L rSMTJMicrosoft XPS Document WriterInputBinFORMSOURCERESDLLUniresDLLInterleavingOFFImageTypeJPEGMedOrientationPORTRAITCollateOFFResolutionOption1PaperSizeLETTERColorMode24bppMXDW "dXX ? ?U}$}I} }}$}}$3 f@ @ @ @��

@ @ @� � �@ @ @ @ @ @ @ @f@ @ @@ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � �

4~ KKKKKKKK� �P "..............��3��

�

#'+&/.367>;F?NCVG^KfOnSvW~[� _� c� g� k� o� s� w� {� ��և ދ &� .� 6� >� F� N� V� � ��

document

�Q��0��}�

"..............��

@D(&& & �@!�@"�@#�@$�@%�@&�@'�@(�@)�@*�@+�@�� !��

* +� � �+�

+� �

�

�-x

-� �-�

-� �.�

.��.�

.��/�

/��0 �

0� �0�

0� �1�1!��1�1�

"��#��%��&��'��(��*"�

document

1� �2�2!��2�2�

2 3� � �31 3 4� � �4�

4 5 6� � � �6�

6 7� � �7�

7 8� � �8�

8 9� � �92 9� �;"�

; <�� Err:501

? ?�Dpl.8DDD.DNN88"8888."."@�@A�@B�@C�@D�@E�@F�@G�@H�@I�@J�@K�@L�@M�@N�@O�@P�@Q�@R�@S�@T�@U�@V�@W�@X�@Y�@Z�@[�@\�@]�@^�@_�@��@ @��A A��B" B��C" C��D" D��E �

E� �F �

F� �G �

G H#########� � �I I��J�

J� �L"% L# M#� � �Nl

N#� �O�

O#� �P �

P#� �Qm

Q#� �R R#��S S#�T#��U U#��V V#��W W#��X X#�Y####��Z�

Z� �[�

document

[��]n�^��_o

DTl........"..."......"...."..` @a @b @c @d @e @f @g @h @i @j @k @l @m @n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � ��`p�c5 c��

"d5��e e��f f��g g��h h��i i��j: j�

"k��lG< l�

"mG��n; n��o o��p p��

"q��r r��

"s22222222��t2 t2222222��u2 u2222222��v2 v2222222��w2 w2222222��

"x��y y��z z��

"{��|2 |��

document

}2 }��~2 ~��2 ��

D l2&222222&2&222&2&2222&22&222 @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�@��@��@��@��@��@��@��@�� 2 ��

�2 �� "� �

� ��

� ��"� �

� ��

� ��"� �

�2 ��

�2= � ��

�2 �� " 2� �"� �

�G> � ��" G� �

� ��

�? � ��

�@ � ��

� ��A11111111111��

��

D l22&22&22&222&&2&2222" @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� @� �@� �@� �@� �

document

@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �

��H� ��IJ� �I J��$� �%&� �%� �&� �'q�

�()� �(� �)� �'��()� �(� �)� �*� �

�+�+� �

�$� �%&%&��*� ��+�+� �

�$ %&%&�� B� �w�

�#� �r�

�t�

�s�

�u�

�

document

v��

y��

z��

-� ��

!��" D*l44444 4 00 @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� &� ��'��(� ��

��

9 99999999999�� 9 99999999999�� 9 99999999999��

document

��

- D�l"""""""""::::� ��A� �

��

/��-C� �D D l @ @ @ @ @ @ @ @ @ @� � �� @ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @@ @ @ @ @� � � � � � � � � � � � � � � � � � �

J�E�G�F�H�I�

K�L�

��

D�l�� @! @" @# @$ @% @& @' @( @) @* @+ @� � � � � � � � � � � �

document

!0 !00000000��"0 "00000000��$��%��'��)��)��*��*��+��+��

-��-��.��.��/9��/��09��0��19��1��2��2��3��3��4��4��6��7��8��9��:��;��

Err:501>��?z D l((@ @A @B @C @D @E @F @G @H @I @J @K @L @M @N @O @P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �@{�By�C��D��E��F��G��H��I��K��L��M��N��

document

O��Q��R��S��U��V��W��X��Y��\�] D l` @a @b @c @d @e @f @g @h @i @j @k @l @m @n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � ��c��e��g��h��j��k��l�m�n��o��p��q��r��t��v��w��y1�z1�{1|1�}1�~1 1 D l� ��

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��1i 1� � �9j 9�1�� 1k� �1l� �1m� �

��

5 $��&��

document

$��$��$��$��&��D�l��

6*6666 @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

2 $��&�� $��$��$��&��2� ��

��2� ��2� ��2� ��&��$��$��$��$��$��&��6 $��&�� 2 $��&�� $��$��$��$��$��$��&��$��&��2 $��&�� 6 $��&��Dl6*666*``*66666*6*6*666666*6*6*6��@��@��@��@��@��@��@��@��@�@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� $��&��2� ��

��

2� ��

2� ��

&��

7� ��

document

��

D�l6*nV@*::::��

2 2222�� 2 2222�� 2 2222�� 7� ��

��

8� ��

Dhl.."...�@�@�@�@�@�@�@�@�@�@��@ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � � � �

��

document

��

��B CCCCCCD��B CCD��E ??????@��> ??@��E ??????@��> ??@��E ??????@��> ??@��F ??????@��> ??@��F ??????@��> ??@��F ??????@��> ??@��E�

??????@� �> ??@��E�

??????@>??@� �:�

;;;;;;<=;;<� ��

D�lDDDDDDDD.. �@!�@"�@#�@$�@%�@&�@'�@(�@)�@*�@+�@�� !��"��#��$��% &� �'��(��) *� �+��

-��.��/��0��2��4 5� �6 6��7 7��8 8��

document

9A:�;A��<A��

Err:501? Dfl��

@ @A @B @C @D @E @F @G @H @I @J @K @L @M @N @O @P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �@��A��B��C��D��FA GA� �HL��IA��JA��KA��LA��MA��NA��OA��PA��QA��RA��SA��TA��UA��VA��WA��XA YA� �ZA [A� �\ \]A��^A��_A D4l��

` @a @b @c @d @e @f @g @h @i @j @k @l @m @n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @`A� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � ��aA��bA��cA��dA��eA.�fA/�gA0�hA1

document

�iA2�jA3�kA4�lA��mA5�nA��oA��pA qA� �r sAtAuA� �vAwA�xO'yN�zM({A�|A)�}A*~AA Dl��

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

'��A��A A��

��

'��A��A� ��A� ��A A��

��

document

��

D0l��

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

A� ��A A�� A� ��A� ��A A�� S TTTTTTTRRR� ��

�Q RRRRRRRRRR� ��


�Q RRRRRRRRRR� ��QRRRRRRRRRR��




�Q RRRRRRRRRR� ��QRRRRRRRRRR��



�Q RRRRRRRRRR� ��D l� �

�Q RRRRRRRRRR� ��QRRRRRRRRRR��A A A A A� � � � � �P A��

document

A� ��A A�� A� ��A(� �A� ��A� ��Ai�

�Aj�

�A A�A�� Ak�A� �A)� �A� ��A* A A� � � �U1 A� � �A DNl � ��

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��A� ��A� ��A� ��A� ��A� ��A A�� A� ��A� ��Ah�A� �V� �V� �V A�� A� ��A� ��A� ��Au� �Av� �Aw� �A� ��Ax� �A2� �

document

A3� �A� ��A A�A�Dl� ��

@�@�@�@�@�@�@�@�@�@�

@�@�@�

@�@�@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � �

��

A� ��

A� �

A�

A�W WWW��A�W WWW��

A�

W��WWWA�W WWW�AAA�A X� �M��M��

document

M��M��M��M A� �AA�A�A�A D l&((((� �

@! @" @# @$ @% @& @' @( @) @* @+ @� � � � � � � � � � � � A�!A"A�#A�$A�%A&A�'�(�)�*�+-A.A�/�0�12A�3A4A�56A�7A8A�9A:A�;�;�<�<�>( Dl�

@ @A @B @C @D @E @F @G @H @I @J @K @L @M @N @O @P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �@I�B)�CA*DA�E+F�G

document

H-IJ�K��L.MA�NA/�OA0�PA4�QA�RA�SA5�TA6UA�VA��WY��XA7�X��YA8�Y��ZA9�Z��[A:�[��\A;�\��]A<�]��^A=�^��_A>�_ D�l��

` @a @b @c @d @e @f @g @h @i @j @k @l @m @n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � ��`A?�`��aA@�a��bAA�b��cAB�c��dAC�d��eAD�e��fA��f��gA��g��hA��h��

document

iA��i��jA��j��kA��k��lA��l��mA��m��nA��n��oA��o��pA��p��qA��q��rA��r��sA��s tA� �uA��vA��wA��xA��yA��zA�{A�|A��}A��~A��A DPl��

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�A��

+� ��A�A��A��

��

document

A��A��A A�� A� ��A A�� A� ��A A�� A�A�A��U A�� Ak� �Al A� � �Am Dl� �

�@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@ @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�A��

��

A��Af� �Ah� �Ag A� � �` aaaaaaaaa�� `j aaaaaaaaa�� `k aaaaaaaaa�� `l aaaaaaaaa�A�A��

document

A� ��

A�A� �A� �A� �A� �

��A� �A� �A� �

��A� �A A�� A A�D|l� ��

****

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��A� ��A� ��A� ��A� ��A� ��A� ��A� ��A� ��A� ��A� ��A}� �A~� �A� ��A A�A�A�� U A�� A� ��AE A� � �L� �

��

A��AF� �AQ� �A��AG D$l� �

document

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��L� �H� �I A�� AJ� �AR� �AK A� � �AL� �AM� �AN� �AO� �AP A� � �L� �

��

W� ��

V� ��

A��AS� �AT� �AU A D� � �

@ @ @ @ @ @ @ @ @ @� � � � � � � � � �@ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � � � �

A��A��A��A A� ��A A� ��A�A��A��

A��A��A��

document

A]A�^A�U U� �Ay�Az�A{�A_UU�r| ]]]]]]]]A D*l� �

( @! @" @# @$ @% @& @' @( @) @* @+ @� � � � � � � � � � � � q�!r�"AX�#AY$A�%AZ�&A[�'A\�(Am�)An�*Ao�+Ap-V.A�/As�0At1A�2W3A�4Au�5Av�6Ax�7Aw8A9A�:r` :]]]]]]]];A� �<Aa�

Err:501>Ac?A D6l�

(@ @A @B @C @D @E @F @G @H @I @J @K @L @M @N @O @P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �@ A� �B��C�

document

D�E"�F#�G$�H%�I&�JR�K��L��M��N��O��P�Q�R�S�T��U��V��W��X Y� �ZI[A\A]A�^A��_A D��

` @a @b @c @d @e @f @g @h @i @j @k @l @m@n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � ��`A��aA bA� �cAE�dAFeA�fAJ�gAG�hAHiA�jIkAlA�mU3�p] p]]]]]]��s��t��u��w��x��y��|��~��

D l��

document

$ @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

n� �o� �p� �q� �r� �

��

Dnl��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

D�l��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

] ]]]]]]��

+��

document

-��

D�l$��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

D�l�@�@�@�@�@�@�@�@�@�@��@ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � � � �

��

��

��%�&�'�(�)�*�+�

-�!.�

document

"/�$0�%1�&�'A(A)A*A+A

@ @A @B @C @D @E @F @G @H @I @J @K @L @M @N @O @P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @@AAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZA[A\A]A^A_A D l� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �

document

` @a @b @c @d @e @f @g @h @i @j @k @l @m @n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @`AaAbAcAdAeAfAgAhAiAjAkAlAmAnAoApAqArAsAtAuAvAwAxAyAzA{A|A}A~AA D l� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � ��

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�D�l��

document



document

@ @ @ @ @ @ @ @ @ @� � � � � � � � � �@ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @AAAAAAAAAA� � � � � � � � � � � � � � � � � � �

AAAAAAAAAAAAAAAAAAAAAA D l� �

@! @" @# @$ @% @& @' @( @) @* @+ @� � � � � � � � � � � �

document



document


@ @ @ @ @ @ @ @ @ @� � � � � � � � � �@ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @AAAAAAAAAA� � � � � � � � � � � � � � � � � � �


document

@! @" @# @$ @% @& @' @( @) @* @+ @� � � � � � � � � � � �

document



document

@ @ @ @ @ @ @ @ @ @� � � � � � � � � �@ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @AAAAAAAAAA� � � � � � � � � � � � � � � � � � �


document

@! @" @# @$ @% @& @' @( @) @* @+ @� � � � � � � � � � � �


document



document

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�D�l��

document

A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�D�l��


document

AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA D l� �

!"#$%&'()*+

document

@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@AAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZA[A\A]A^A_A D l� �

document

`abcdefghijklmnopqrstuvwxyz{|}~`AaAbAcAdAeAfAgAhAiAjAkAlAmAnAoApAqArAsAtAuAvAwAxAyAzA{A|A}A~AA D l� ��


document



document

AAAAAAAAAA

AAAAA

document

AAAAAAAAAAAAAAAAA D l� �

!"#$%

document

&'()*+

-./0123456789:;<=>? A!A"A#A$A%A&A'A(A)A*A+AA-A.A/A0A1A2A3A4A5A6A7A8A9A:

document

A;A<A=A>A?A D l� �

@ABCDEFGHIJKLMNOP

document

QRSTUVWXYZ[\]^_@AAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZA[A\A]A^A_A D l� �

document

`abcdefghijklmnopqrstuvwxyz{

document

|}~�`AaAbAcAdAeAfAgAhAiAjAkAlAmAnAoApAqArAsAtAuAvAwAxAyAzA{A|A}A~A �A D l� �

document

��A�A�A�A�A�A�

document

A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A D l� �

document

��A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�

document

A�A�A�A�A�A�A�A�A�A�A�A�A�A�A D l� �

��

document

��A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�

document

A�A�A�A D l� �

��

document

��A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A�A D l� �

document


document

!"#$%&'()*+

@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@AAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZA[A\A]A^A_A D l� �

document

`abcdefghijklmnopqrstuvwxyz{|}~`AaAbAcAdAeAfAgAhAiAjAkAlAmAnAoApAqArAsAtAuAvAwAxAyAzA{A|A}A~AA D l� ��


document


document


!"#$%&'()*+

document

n�*2�V�(��f��

�c $ Q=� � ��

A @ U[E a ]`Q=@�� <redo01.dbf��

use this one< l�l��s * PQ=� � ��

A @ [4�a��]`PQ=�� <redo02.dbf��

then use this one< l�l��s * Q=� ��

A @ p[4 a ]`�Q=�� <redo03.dbf��

then use this one< f�^B��c $ D @��b�d��]`��f�^B� � ��

@�c $ D @��zd��d��]` �l�dB� � ��s * D @��za�zd��]`��l�dB� � ��s * D @��]N]�]` � � ��

l dB��s * D @��]@]�]`��

l l��s * R=� ��

A @� � �\4`_ ]`�R=0��

<archived redolog<] l l�� s * S=� � ��

A @� � �]# ` ]`S=��

<archived redolog<] l l��

document

s * XS=� � ��A @ p^0a ]`XS=@��

<archived redolog<] l l��

s * S=� �� A @ _4`b��]� � ��

` S=� ��<archived redolog<] r jB��

�0�D��@��^E��^E ]`P� �f ^B��

�c $ D @��0�0��]`��

f ^B��c $ D @��h@�h�]`h�f�^B� � ��c $ D @��h@�h�]`��T�L2� � ��3 A�@��9��]`h�T�L2��3 A�@��49#�]`��f�^B��c $ D @��y�W�]`P�f�^B� � ��c $ D @�� c $ 8U=� � ��

A @ #��]`8U=8�� <target's��

controlfile<f T L2� ��3 A�@�P4�y�]`��T�L2��3 A�@�P4�y�]`8�f�^B��c $ D @��P�P��]`��f�^B� � ��c $ D @��]`�f�^B� � ��

�c $ D @��y��] `��f�^B� � ��

"�c $ D @��rhr�]"`�f�f��

#�c $ xV=� � ��

A @ o ]#`xV=�� <RMAN��

backupjobs / scripts<02u r jB� �$@�0�D��jJ��4��]$`�r�jB��%�

document

0�D��jJ��P��]%`��f�f��&�

c $ 8Z=� � ��A @ `E�]&`8Z=��

<server��session(s)<h l dB��

(�s * D jJ��

yy ](` `�`�� )�

S Z=��A�@��l#�])`�Z=(��<backup tapes or��

backup disks< l�dB��*@�

s * D� � ��]*`��B��+@�N�D��8c b��]+`(�r�jB� ��-�0�D��8c ]-`��l�dB� ��.�

s * D jJ��R� R��].`�l�dB� � ��/�

s * D� � ��jJ� ��0��]/`��r�jB��0�0�D��9�>��4��]0`��r�jB��1� �0�D��jJ y�]1`�l�dB� ��2�

s * D� � ��jJ� ��]2`�>�@�7��ɀX&J�j��:(^x��"6X"�&�*�.�2:8�<�@�D��

I>MHQhU Y ] a e i m q uLz ~ (��t�l��¦�F�z�h�d�p��Z�V�R�j�� F��P��N�0"H&D*N.�2�6�:�>�B�F�J�N�R�V�Z�^�bLfDj@n4r:vDz@~��(��<�R�@�e�o��M��ù��_��7��}�E�� e�-��M��m5��U��u5��

d MbP?_*+ %��"dXX�?�?U}$&?@�@�@�@�@@�@�@�@�@�� @ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � � � �

bE��^�

___________� �r tttttttttt��L�

document

��

��T��^�A��A��A A D l.� � � @! @" @# @$ @% @& @' @( @) @* @+ @� � � � � � � � � � � � !A�� "��# $�� 'r 'tttttttttt��)��*��

-��.��/��1��3L�4��5��6��8��9O�:�<�?rs ?tttttttttt�

D l� �

At�Bu�D�Ev�Fw�Gx�HY�IZ�J[�L\�M]�N^�P_�

document

Q`�Ra�Tb�Vc�W`�Xd�Ye�]rf ]uuuuuttttt��_g D l� �`�b�c^�d�e�f�g�h[�k�lh�mi�nj�ok�p[�rl�sm�un�vo�wp�xq�yr�zs�{t�}u�~v�w D l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

n� �x� �y� �z� �{� �|��}� �~� �r� �

��

document

��]��]]]]]ttttt��

��

D l�� i��j��k� �l��m� �] ]]]]]ttttt��

��

w� ��

x� �Y� �

��[��

��] ]]]]]ttttt��

�D�l��y� �z� �{� �|��}� �~� �

��

~��/A��

��

x� �Y� �

��[��N D l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� O� �

document

P� �O� �Q� �R� �S� �c� �`� �d� �e� �T� �U� �V� �W� �X� �Y� �2�

�]Z ]]]]]]tttt� ��

�[��\��]��^� �_� �` D l� � �@ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � � � �

a��] ]]]]]]tttt��

��

D�l��&^4

&___________� �

document

)��*��

-*�/]+ /]]]]]]]� �12-�3.�4��6��7��8��9��:��<��

Err:501> D�l.&@�@A�@B�@C�@D�@E�@F�@G�@H�@I�@J�@K�@L�@M�@N�@O�@P�@Q�@R�@S�@T�@U�@V�@W�@X�@Y�@Z�@[�@\�@]�@^�@_�@��@] @]]]]]]]��B��C��D��F)�G��H��I��J��K��M] M]]]]]]]��O��P��Q��S��T��V��W��X��Y��Z��[��]] ]]]]]]]]��_ Dl&&&`�@a�@b�@c�@d�@e�@f�@g�@h�@i�@j�@k�@l�@m�@n�@o�@p�@q�@r�@s�@t�@u�@v�@w�@x�@y�@z�@{�@|�@}�@~�@��@��`��a��c��d��f] f]]]]]]]��h��j��k��l��m��

document

n��o��p��q��s]�

s]]]]]]]� �u��v��x��y��{��|��~��

D l&& @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

] ]]]]]]]��

8� ��8� ��8� ��8� ��8 D�l&��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

��

document

��

8� ��8� ��

��

] ]]]]]]]��G� �H� �6� �7� �8� �9� �:��8;� �

��< D l& @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� 8� ��=� �>� �?� �@� �8� ��8� ��8� ��A� �B� �]C ]]]]]]]�� D� �E� �F� �G� �H� �D� �E� �F� �G� �H� �I��J� �K D l& @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� ]L ]]]]]]]�� O� �M� �N� �O� �P� �Q� �R� �S� �T� �

document

U� �V� �W� �

��

X� �Y� �Z� �[��\��] D l& @ @ @ @ @ @ @ @ @ @�� @ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @@ @ @ @ @ @� � � � � � � � � � � � � � � � � � �

^�_�`�a��

�

]�]]]]]]]�

�

�

�

�

�

�

�

�^5

___________� �

�

D l&. @! @" @# @$ @% @& @' @( @) @* @+ @� � � � � � � � � � � � � �!�#N�$M�

document

%N�&�'P�(�)R�*S�-�/�0�1{�3|�5}�6~�8 ��9��:��;�<��

Err:501�>��?[ D l@� �

@A�@B�@C�@D�@E�@F�@G�@H�@I�@J�@K�@L�@M�@N�@O�@P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @� � � � � � � � � � � � � � � � � �

@�

document

�C��E��G��I��J��K�

Mttttttttttttt� �O��P��S��T��V��V��V��V��V�

Wp @v � � ��W�

Xx @ >#� � �� X�

Y @ ># >#� �� Y�

Z @ ># *&� �� Z�

[@ &[Z %- B� �� [��[�

\��\�~\[ ]��]�~][ ^� �^�~^[�_�

document

~_ &�� _��_�

DPl$F****D888` @a @b @c @d @e @f @g @h @i @j @k @l @m @n @o @p� � � � � � � � � � � � � � � � �@q�@r�@s�@t�@u�@v�@w�@x�@y�@z�@{�@|�@}�@~�@� �@ ` ? *& C&� � � � � �

`�a@ C&D&� � �

a��d��e��f��g��h��i��j��k��n pttttttttttttt��r��s��t��u��w��x��y��z��{��|��

document

}��~��

D��@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@ @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

��

�ttttttttttttt��

d� �O� �P D l$ @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� O� �e \ @� �� f��g� �h� �i��j��k� �l��]��m� �

document

`� �n� �o� �j��p� �q� �r� �s� �t��y� �z D l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� @� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �{� �K� �L� �M� �N� �O� �P� �T� �U� �V� �j��W� �X� �|��}� �~� �

�� ttttttttttttt��

��

D�l$��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

document

��

S D l @ @ @ @ @ @ @ @ @ @� � �� @ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � � � �

F�G�5�6�7�8�9�

:��

~��

D�l �@!�@"�@#�@$�@%�@&�@'�@(�@)�@*�@+�@��@1�@2�@3�@4�

document

@5�@6�@7�@8�@9�@:�@;�@<�@=�@>�@?�@� �

!��#��%��'��(��*��+��

-��. 0ttttttttttttt��2��3��5��7V~8 ?� �9O�:P�;O�<W�

Err:501>Y�?Z D l$@ @A @B @C @D @E @F @G @H @I @J @K @L @M @N @O @P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �@[�A\�B]�C^�D_�E`�Fa�Gb�Hc�IY�JZ�Ld�Ne�O��P��Q��R��S��T��

document

Vd�X��Y��Z��\d�^��_ D l` @a @b @c @d @e @f @g @h @i @j @k @l @m @n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � ��`�a�b�c�d�f�iT��kH�lI�mJ�pY�qZ�r[�t^�tK�u_�uL�va�wb�x}�xM�yN�{O�~ D�l��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

P� �Q� �R� �

��

.��-� �.��

��

T� ��

U� �

document

V� �W� �X� �Y� �Z� �[��\ D l�� @� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@ @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� ]��^� �_� �`� �]��a� �

��

b� �. ttttttttttttt��

��

j��

2� �3� �4 D l� � �

$ @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��j��!��"� �#� �j��$� �3� �4� �5� �6� �

document

7� �8� �9� �:��;��6�

�7�

�8�

�<� �=� �> D l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� ?� �@� �A� �

��

6� �9�

�:�

��

D�l��@�@�@�@�@�@�@�@�@�@�

@�@�@�

document

@�@�@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � �

��

ttttttttttttt� ��

�T� �!�"�#��

D l$ @! @" @# @$ @% @& @' @( @) @* @+ @�� !��"��#��$��%��&��'��(��)��*��+��

.��0��1��2��3��4��5;�6<�7=�8>�9?�:@�;A�<B�

Err:501>8;

document

�? D$l@ @A @B @C @D @E @F @G @H @I @J @K @L @M @N @O @P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @�� @��A��B��C��D��E��F��G��H��I@�JA�KB�N��O��R8<�S��T��U��V��W��X��Y��Z��[��\��]��^��_ Dl`�@a�@b�@c�@d�@e�@f�@g�@h�@i�@j�@k�@l�@m�@n�@o�@p�@q�@r�@s�@t�@u�@v�@w�@x�@y�@z�@{�@|�@}�@~�@��@��`��a@�bA�cB�e8=�f��g��h��i��j��k;�l<�m=�n>�o?�p@�qA�rB�t8;�u��

document

v��w��x��y��z��{��|��}��~��@ D$l� ��

@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@� �@ @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� A� � �ttttttttttttt��

��}� �~� �N� �M� �N� �

��

C D l$ @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� D� �

��E� �F� �G� �H� �G� �I��

document

G� �J� �G� �K� �L� �M� �N� �O� �P� �Q� �R� �S� �T� �U� �T� ��

��

O� �P� �O Dl @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

��

O� �P� �O� �

��

ttttttttttt��

>��

8?��

N� �M� �N� �

��@�

�A�

�T D l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

document

��

]��

`� ��

D��

E��

D|l�@�@�@�@�@�@�@�@�@�@��@ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � � � �

��j��

Dnl �@!�@"�@#�@$�@%�@&�@'�@(�@)�@*�@+�@��!��$��&��(��)��*��

-��.��0��3��5j�7��8B

document

�9C�:��

Err:501>��? D�l@�@A�@B�@C�@D�@E�@F�@G�@H�@I�@J�@K�@L�@M�@N�@O�@P�@Q�@R�@S�@T�@U�@V�@W�@X�@Y�@Z�@[�@\�@]�@^�@_�@��@N�AM�BN�C��D��Ev�F��Gv�H��J��NF�O~�Ql�Rm�Sn�Vo�W��Xp�Z��\q�]r�^s D l� �` @a @b @c @d @e @f @g @h @i @j @k @l @m @n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � ��`t�au�bv�dw�ex�fy�g[�iz�j{�k|�l}�m{�n|�pb�q~�r��s��u�v��w��x��z��

document

{��~��

D�l��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��*� �+� �

�G� �

�P� �Q� �R� �o� �

��-� �

��.��Z� �/��0� �1� �2� �3� �

��4� �5 D l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� 6� �7� �8� �9� �:��;��<� �=� �>� �?� �@� �O� �P� �O� �

��A� �

��

��!��"� �

��.��#� �) D l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� *� �

document

+� �a� �b� �

�-� �.��/��5� �6� �7� �0� �1� �2� �3� �:��;��<� �=� �>� �4� �5� �6� �7� �8� �9� �:��; Dl @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� <� �=� �>� �?� �@� �A� �B� �C� �D� �E� �F� �G� �H� �I��J� �K� �L� �M� �N� �O� �@� �I��H�

�I� �

�

document

J��

K�D l @ @ @ @ @ @ @ @ @ @� �� @ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � � � �

L�M�N�O�P�Q�R�S�

T��U�V�W��X�Y�Z�[��\�]�^�_�`�a

document

�b

D l @! @" @# @$ @% @& @' @( @) @* @+ @� � � � � � � � � � � � � � c�!d�"e�#f�&g�'h�(i�+j��-k�.l�/m�2n�3��5o�6p�8q�9�;�

Err:501>;�? D l@ @A @B @C @D @E @F @G @H @I @J @K @L @M @N @O @P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �@�B�D�E?�F�G�H�I�J�M�N�P�Q�

document

T[�U\�W�X�Y�Z�\�]�^ D l` @a?@b @c @d @e @f @g @h @i @j @k @l @m @n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � ��a4 �d]X d]]]]]]]]]]��g�i�j�l�n�o�q�s�u�v�w�x�y�z�{�|�}�~�U D l� ��

Z� �[��\��]��^� �_� �`� �c� �d� �e� �

��

document

V� �W� �X� �Y� �#� �$ D l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� %� �&� �'��(� �)� �*� �

�� !��

��"� �

��

+� ��

-� �.��

��/ D l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� 0� �

��

!��

"� ��

.��

0� �D�l��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

��

document

��

"� ��

+� ��

. D l @ @ @ @ @ @ @ @ @ @�� @ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � � � �

��0��0��

��

��

D�l �@!�@"�@#�@$�@%�@&�@'�@(�@)�@*�@+�@�� "��#��%��'��(��)��*��+��

document

-�/�0��1�2�4�5�7 �9!�:"�;#�<$�

Err:501?& D l@ @A @B @C @D @E @F @G @H @I @J @K @L @M @N @O @P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �@'�A(�C��D��E��F��G��I!�J��K"�L��M��N��O��P��Q��R��U] U]]]]]]]]]]��W��Yc��[f��]f ^X� �_g D�l��` @a @b @c @d @e @f @g @h @i @j @k @l @m @n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � ��`g�ag�bf cX� �dg��eg��fd��gg��hf��jf��kh�lh��mh��nh[�

document

ofI�qfJ�rh�sh��thK�uhL�vh��wh[�xfM�yhO�zhP�{hO�|hN�}hO�~ha�hb D l��

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��hP� �fQ� �fR� �fS� �fT� �f��

�f��

�f��

�f��

�f��f e��]��]]]]]]]]]]��

��

D l� �

��

document

��

P� ��

b� ��

D`l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

.��

.��

.��

DDl @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

document

��

.��

.��

DDl @ @ @ @ @ @ @ @ @ @� � � � � � � � � � �@ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � � � �

��

��Y�[��

DRl �@!�@"�@#�@$�@%�@&�@'�@(�@)�@*�@+�@��!��#��%��'��)��+��/��1��3.�5��6��8�:��<�

document

DDl@ @A @B @C @D @E @F @G @H @I @J @K @L @M @N @O @P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �@��D��H��J.�L��M��O��S��U��W��Y��]��_ D6l`�@a�@b�@c�@d�@e�@f�@g�@h�@i�@j�@k�@l�@m�@n�@o�@p�@q�@r�@s�@t�@u�@v�@w�@x�@y�@z�@{�@|�@}�@~�@��@��c��gL�i��k�m��o��s��u��w��y��{��}b��

D6l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�@��@��@��@��@��@��@��@��@��@��

.��

z� �{� �]| ]]]]]]]]]]� ��

��

e��

T� ��

j��lmkjk��ljnjk�D�l��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��o� �o� �o� �o� �o� �

document

o o o o� � � � �o o� � �pB� �pC� �pD� �pE� �pF� �pG� �pH� �pf� �pg� �ph� �pi i��i��

��j��k� �l Dl��

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��m� �n� �o� �p� �q� �r� �s� �t��n� �u� �v� �w� �x� �y� �z� �{� �|��}� �

��~� �

��S D l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

��T� �U� �V� �W� �X� �Y� �Z� �[��\��

document

]��^� �_� �`� �a� �b� �

��

c� �d D l @ @ @ @ @ @ @ @ @ @� � �� @ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � � � �

e�f�g�h�i�j�k�l�m�

n�o�

p�q�r�s�t�u�v�w�m�x��

D l @! @" @# @$ @% @& @' @( @) @* @+ @�� y�!r�$s�%t�&u�'v�(w�)x

document

�*y�

�-{�.|�/}�0~�1 ��2��3��4��5��6��7��9��:��;X�<��

Err:501>��? Dl@�@A�@B�@C�@D�@E�@F�@G�@H�@I�@J�@K�@L�@M�@N�@O�@P�@Q�@R�@S�@T�@U�@V�@W�@X�@Y�@Z�@[�@\�@]�@^�@_�@��A��Bn�D��E��H��JY�KZ�L[�N\�O]�P^�PB�Q_�Q`�Ra�Sb�Sc�T|�U}�U~�V��W��Z��

document

[��\^�\��]_�]��^a�_b�_ D2l`�@a�@b�@c�@d�@e�@f�@g�@h�@i�@j�@k�@l�@m�@n�@o�@p�@q�@r�@s�@t�@u�@v�@w�@x�@y�@z�@{�@|�@}�@~�@��@��`��a}�a��b��d��fC�hD�iE�jO�kP�lO�m�n�o�pF�q��r��u��v�w��x��y��z��{��|��}��~��

Dl��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

[��

document

��

D�l��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

D�l��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

.��

I��J� �K� �

��L� �M� �

��N� �

��

O� �P� �q� ��q� ��q� ��Q� �R� �S� �T D l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

document

U� ��

V� �W� �X� �Y� �Z� �[��\��]��0� �1� �2� �3� �4� �5� �6� �4� �5� �7� �4� �8� �9 D l� � �@�@�@�@�@�@�@�@�@�@�

@�@�@�@�@�@�@�@�@�@�@�@�@�@�@�@�@�@�@�

document

@�@�@� �

:�

;�

<�

=�

>�

?�

@�

A�

B�

C�

D�

E�

F�

G�

F�

H�

I�

J�

K�

L�

M�

N�

O�

P�

document

C�

D�

Q D l � �@!�@"�@#�@$�@%�@&�@'�@(�@)�@*�@+�@�@-�@.�@/�@0�@1�@2�@3�@4�@5�@6�@7�@8�@9�@:�@;�@<�@=�@>�@?�@� �

R�!L�

document

c ��d ��@ ��O��P��O��

��

�D l��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

��@ ��

��

��

��

��

��

��

��

��

��

��

��> ��e ��A ��

��

��o ��

��

��

�D l��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��p ��

��

��

��

��> �� !��A ��

��

document

��#��$��r��%��&��'��(��)��*��;��<��=��> D l @ @ @ @ @ @ @ @ @ @� ��

@ @ @� � �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � � � �

?�^�_�`�a�b�c�d�

@�A�B�C�D�S�T�

document

e�r�g�h�i�j�K�k D l @! @" @# @$ @% @& @' @( @) @* @+ @� � � � � � � � � � � � � � l�!m�"N�#n�$o�%p�'q�(r�*s�

-��.��/��0t�1u�4v�5>�7w�9S�:T�;U�

Err:501>��? D�l@�@A�@B�@C�@D�@E�@F�@G�@H�@I�@J�@K�@L�@M�@N�@O�@P�@Q�@R�@S�@T�@U�@V�@W�@X�@Y�@Z�@[�@\�@]�@^�@_�@��@��B��C4�E��F��G��I��J��K��N��P��Q��R��S��T��

document

V��W��X��Y��Z��[4�]\�_�

D l` @a @b @c @d @e @f @g @h @i @j @k @l @m @n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � ��`��a��b��c��f��g��hX�j��k��l��m��n��o��q��r4�t��v��w��x��y��z��{��. D l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

document

E� �F� �

��

G� �H� �I��]��J� �K� �L� �

��

M B X @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� N� �

��

/��0� �1� �2� �3� �4� �5� �

��

@*D @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� !��"� �#� �$� �%� �&� �'��(� �)� �*� �+� �

��

-� ��

document

.��/��

��.��/��0� �1 D l @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@�� 2� �3� �4� �5� �6� �

��

/��

y� �7� �8� �9� �:��;��<� �=� �9� �>� �?� �

��@ D l @ @ @ @ @ @ @ @ @ @� � �� @ @� �@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @� � � � � � � � � � � � � � � � � �

O�P�O�A�B�C�u�

v�w�ttttttttttt��

document

��

@ D @! @" @# @$ @% @& @' @( @) @* @+ @� � � � � � � � � � � � � � ��!��"��$��%I�&J�'K�(L�*M�+��

-��.��/��1]�2b�5c�7��8d�:e�;f�

Err:501> D�l@�@A�@B�@C�@D�@E�@F�@G�@H�@I�@J�@K�@L�@M�@N�@O�@P�@Q�@R�@S�@T�@U�@V�@W�@X�@Y�@Z�@[�@\�@]�@^�@_�@��@h�Bi�Fj�Gk�Hl�Im�Jf�Ln�Mo�Np�P�Rq�Sr�Ts�U

document

Swapnil Yeole B a = =�iL;x-8X@�"��1��Arial1��Arial1��Arial1��Arial1&��Courier New1&��Courier New1&��Courier New1&�5�Courier New1&��Courier New1��Arial1�$�Arial1&��Courier New1��Arial1&��Courier New1&��Courier New1&��Courier New1&��Courier New1&��Courier New1&��

Courier New1& 9 Courier New1& Courier New1& Courier New1& Courier New1&��Courier New1&h��Courier New1&��Courier New1&��Courier New1&��Courier New1&�?�Courier New1&�9�Courier New1&�?�Courier New1&��Courier New1&��Courier New1&��Courier New1&��Courier New1&�?�Courier New1&��Courier New1��

##0_);\("$"# * H H H L H ��

h �

h@@ �

because running transactions [You can ONLY BACKUP AN OPEN DATABASE IF IT RUNS IN ARCHIVE MODE. It is absolutely of no use?Or something likethis on your depends ofcourse on your tapedrive or class.Error isBRMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time*fact: Oracle Server - Enterprise Edition 8fact: Recovery Manager (RMAN)-symptom: Recover with UNTIL TIME option failsKsymptom: RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS timeJcause: The UNTIL TIME is prior to the current Database incarnation in the lost or corrupted?=Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.15Information in this document applies to any platform.Goal5order by status then the approach and strategy on how to recover and open the database depends on the SCN (System Change Number) of the datafiles use the RESET DATABASE TO INCARNATION command.hrun a SWITCH command so that RMAN considers the restored file as the current database file. For example:PSWITCH DATAFILE '/tmp/tools01.dbf' TO DATAFILECOPY '?/oradata/trgt/tools01.dbf';ZThe SWITCH command is the RMAN equivalent of the SQL statement ALTER DATABASE RENAME FILE.>>>> A Oparams=>'ENV=(OB2BARTYPE=Oracle8 DONE=>done );Edbms_backup_restore.restorecontrolfileto('D:\DBS\RDCS\CTL2RDCS.ORA');+dbms_backup_restore.devicedeallocate('t1');end;:Here are some other examples of using dbms_backup_restore:DECLAREBEGINJdevtype := dbms_backup_restore.DeviceAllocate (type => '' and want to restore and recover this tablespace:mallocate channel t2 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';restore tablespace users;recover tablespace users;$sql 'ALTER TABLESPACE users ONLINE';exp (Oracle supplied utility)rman (Oracle supplied utility)!TDPO_MGMT_CLASS_4 tsmoracle-mgmt4BNot a fancy setup; pretty much 'stock' (standard). Thoughts/ideas?-DanBack to top release channel t2;release channel t3;(tdpo.conf for the restore on a test box:;DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/dsm.optDSMI_LOG /var/log/tsmTDPO_FS prod-oracle!TDPO_MGMT_CLASS_2 tsmoracle-mgmt2!TDPO_MGMT_CLASS_3 tsmoracle-mgmt3 2008 11:03 pm Post subject: How do I get TDPO to send controlfiles to SBT_TAPE instead o P--------------------------------------------------------------------------------4Hot Diggety! Dan Foster was rumored to have written:Quote:0logs are not directly critical for the operation3another pathin oracle 9i you can recover the user errors by flashback technologies ^flashback drop by using recycle bin status 09:05 AM>alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS'; >select LF.member %and it has very little documentation.TThe Oracle docs note how to install and configure the dbms_backup_restore package: n The DBMS_BACKUP_RESTORE package is an internal package created by the dbmsbkrs.sql and prvtbkrs.plb scripts. C------- ---- -- ---------- ----------- ------------ ---------------=47 Full

702 OLAP and Data Mining optionsDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startup mountORACLE instance started.)Total System Global Area 171966464 bytes)Fixed Size 787988 bytes)Variable Size 145488364 bytes If the above query returns no rows�

'DD-MON-YYYY HH24:MI:SS') as checkpoint_time SK etc. Q2. Sysadmin installed the TDP fileset and then generated the password file for meX3. I used the TSM Quick Start Guide to get all of my config files and directories setup 4. I used OEM GC R3 to set the RMAN preferences�^give chmod 777 to libobk64.a on /usr/tivoli/tsm/client/oracle/bin64 directory and try again...Article 4M=============================================================================: connected to target database: PLAYROCA (DBID=575215626)I RMAN-00554: initialization of internal recovery manager package failedW RMAN-04004: error from recovery catalog database: ORA-03135: connection lost contactkeys:

we can find:0WARNING: inbound connection timed out (ORA-3136)Thu Mar 13 23:09:54 2008zWe already have seen that Oracle itself suppose you have created the database "PRODRMAN" (step 1)..Now connect as sys or system to that database.(Create the tablespace

contains only temporary data from querys that produces sorts "standard file"� you would reset the incarnation when performing incomplete recovery to a point before a RESETLOGS operation

��

document

then you can only specify TO INCARNATION if the database is mounted and the control file contains a record of the prior incarnation. If you do not run RESET DATABASEOthe pieces that belong to the sets tarDB_KEY we need to "make clear" to rman

e.g.: create 2 copies of all datafiles and 2 copies of all control files.:The problem is RMAN opens 2 channels when duplex is set!!!-Bottom Line: (I had IBM add this to their KB)BSCRL DATA RMANBTS DATA RMANBTSATT DATA RMANBXCF tI have relinked the Oracle libraries through "relink all " command then you would get ora-1578 when accessing those blocks.W --> Identify the object name and type whose block is corrupted by querying dba_extents; --> Based on the object type is restore the backup of 28 june

you can recover table from recycle bin unless you dont purge it

(B) and (D) would be different in this case& wherever archive logs are involved. 3 We will discuss the datafile loss scenarios here:E (a) If the datafile lost is a SYSTEM datafile recover database and open the database.V ** If no copy of the controlfile or backup is available

we would not have backups of online redo log files. But the Ninactive logfile changes could already have been checkpointed on the datafiles restore an old backup of the database files and apply the1 archive logs to perform incomplete recovery. --> restore old backup SQL> startup mountA SQL> recover database until cancel using backup controlfile;( SQL> alter database open resetlogs;L ********************************************************************* R * Tivoli Storage Manager - Tivoli Data Protection for Oracle r.time#from v$datafile d

F %NI U _>LgL$o$� � � �

b: j At+zydYC {�A��

4l; @ F J N S W [&a j p>up{ r� @�� ֗ z� H� � D� � t� � � Z� � � L� f� � � � � � � � � � � � � � � � � � � � � � � ��

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

��

document

�

�

�

�

document

... @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@ ��@ ��@��@��@��@��@��

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

document

��

document

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

��

document

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

A�

�

document

A� �

document

l

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

A�

document

l

document

D l @! @" @# @$ @% @& @' @( @) @* @+ @� � � � � � � � � � � � � �

document

A-A.A/A0A1A2A3A4A5A6A7A8A9A:A;A<A=A>A?A D l� �

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @ A!A"A#A$A%A&A'A(A)A*A+A� � � � � � � � � � � � � � � � � � � �

document

-./0123456789:;<=>? A!A"A#A$A%A&A'A(A)A*A+A

document

-./012 A!A"A#A$A%A&A'A(A)A*A+A

document

��

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

��

@ @A @B @C @D @E @F @G @H @I @J @K @L @M @N @O @P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �

document

` @a @b @c @d @e @f @g @h @i @j @k @l @m @n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � ��

document

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

document

@ @ @ @ @ @ @ @ @ @� � � � � � � � � �

@! @" @# @$ @% @&@' @( @) @* @+ @� � � � � � � � � � �

document

)�

�

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

document

l**$�

document

@- @. @/ @0� � � �

document

��

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

��

document

�

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

document

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

document

�

�

document

�

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

document

�

document

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

document

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

document

z

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

U�

document

�

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

��

document

##0\)!"$"#

h �

H) h@@ + h@ + h @ + H H !X !X !X H H* H* H* H* H H H !X H L L L H5 H H H+ H+ % H ( H (!X ' H ) H )!X * H X X )X (X (X )\ X X L H5 H H5 H5 � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �

depends ofcourse on your tapedrive or class.Error isBRMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time*fact: Oracle Server - Enterprise Edition 8fact: Recovery Manager (RMAN)-symptom: Recover with UNTIL TIME option failsKsymptom: RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS timeJcause: The UNTIL TIME is prior to the current Database incarnation in the checkpoint_change# as well as run the following SQL statement to force Oracle to switch out of Dthe current log and archive it as well as all other unarchived logs:!ALTER SYSTEM ARCHIVE LOG CURRENT;i# When the database is mountedOB2APPNAME=rdcs< ident => 'FUN');ythe control file

and want to restore and recover this tablespace:mallocate channel t2 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';restore tablespace users;recover tablespace users;$sql 'ALTER TABLESPACE users ONLINE';exp (Oracle supplied utility)rman (Oracle supplied utility)!TDPO_MGMT_CLASS_4 tsmoracle-mgmt4BNot a fancy setup; pretty much 'stock' (standard). Thoughts/ideas?-DanBack to top release channel t2;release channel t3;(tdpo.conf for the restore on a test box:;DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/dsm.optDSMI_LOG /var/log/tsmTDPO_FS prod-oracle!TDPO_MGMT_CLASS_2 tsmoracle-mgmt2!TDPO_MGMT_CLASS_3 tsmoracle-mgmt3 like e.g. /home/oracle or /u01/ora10gBORA-27211: Failed to load Media Management Library on HP-UX systemDetails:Overview:gThe Oracle return code ORA-27211 implies a failure to load a shared object library into process space. uOracle Recovery Manager (RMAN) backups will fail with a message "ORA-27211: Failed to load Media Management Library" sif thehere i am not considering the space issues of recyclebin. ;Oracle Server - Enterprise Edition - Version: 8.1.7 to 10.2@- Doing an incomplete recovery and would end up with this error:Arecover automatic database until cancel using backup controlfile;2ORA-00283: recovery session canceled due to errors6ORA-19909: datafile 1 belongs to an orphan incarnation:ORA-011 substr(name L.group# elapsed time: 00:01:16Finished restore at 02-JUL-08(RMAN> RECOVER DATABASE UNTIL SCN 546782;'dbms_backup_restore.RestoreSetDatafile;gdbms_backup_restore.RestoreDatafileTo(dfnumber => 1

704 because the V$DATABASE.CONTROLFILE_TYPE has a value of "BACKUP"

count(*) I FHSCN SCN CanadaPosts: 3 and to setup the Tape parameters: ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)gOnce all of this was done and "$ tdpoconf SHOWENVironment" looked good

^give chmod 777 to libobk64.a on /usr/tivoli/tsm/client/oracle/bin64 directory and try again...Article 4M=============================================================================: connected to target database: PLAYROCA (DBID=575215626)I RMAN-00554: initialization of internal recovery manager package failedW RMAN-04004: error from recovery catalog database: ORA-03135: connection lost contactkeys:

makes a distinction between a physical backup and a logical backup of a database.SHowever for example like: logging extent management local create smallfile tablespace rmanb datafile '/dbms/oradata/prodrman/rman01.dbf' size 100M reuse autoextend on next 10M maxsize 500M segment space management auto;VThe above command was step 2. Now we create the catalog owner

contains stuff we do not consider in this note. Contains no data of the application or when attempting to undo the affects of a RESETLOGS by restoring backups taken before a RESETLOGS.Restrictions and Usage Notes/Execute RESET DATABASE only at the RMAN prompt.-You must be connected to the target database. A recovery catalog connection is optional. Unlike in catalog mode�

�� ɀ� � � � \p��

document

RMAN recovers to the last incarnation recorded in the control file. If RMAN is connected in CATALOG mode� and all kinds of other usefull information.or|Important: This is a quick and simple introduction to Oracle Backup and Recovery cpio etc..logicalphysicalVYou will see that the Oracle supplied utility "RMAN" is THE tool to backup a database.8;qIn a momentDB_NAME we are going to use such an old backup

table DB After the relinkg still i am facing same prblem.EMy all configuration file are correct(dsm.opt perform appropriate recovery9 --> Check metalink Note 28814.1 for resolving this errorJ(2) If the entire disk is lost while our latest backup is from 30 june.PThe target instance of database "test10g" is started

Recycle Bin catches receives database objects and its dependent objects i.e PK

restore the complete? database from the previous backup and start the database.Q (b) If the datafile lost is Rollback related datafile with active transactions then create a controlfileU creation script using the datafile and redo log file information. Ensure that the; file names are listed in the correct order as in FILE$.P Then the steps would be similar to the one followed with cr_ctrl.sql script.MNote that all controlfile related SQL maintenance operations are done in the database nomount state

and even archive log files may be available. Oracle Instance Started Database mountedB ORA-00313: open failed for members of log group 1 of thread 1H ORA-00312: online log 1 thread 1: '/ORACLE/ORADATA/H817/REDO01.LOG'# ORA-27041: unable to open file# OSD-04002: unable to open fileA O/S-Error: (OS 2) The system cannot find the file specified.5** 4we cannot restore it with this client configuration.RCreate a separate client configuration v$recover_file rwhere d.file# = r.file#2) Next we do:archive log list?This will give us the current log sequence. We need the current>log sequence -1. This will give us the last redo log file thatwas in use.3) As the last step we do:select recid

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @� � � � � � � � � � � � � � � � � � � � �

document

A-A.A/A0A1A2A3A4A5A6A7A8A9A:A;A<A=A>A?A D l� �

document

A-A.A/A0A1A2A *:h�

document

# ]` f�f��

document

@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��

document

@- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @ "� � � � � � � � � � � � � � � � � � � � � �

document

##0_);[Red]\("$"#

h@ �

H H�

checkpoint_time;'alter database datafile <file#> online;2and L.first_change# >= DF.min_checkpoint_change#; select * from v$logfile;HORA-00334: archived log: '+BACKUP/prmy/onlinelog/group_2.258.603422107' }Subject: How to recover and open the database if the archivelog required for recovery is either missing whether the log sequence# required for the recovery is still available in the online redologs. For the SCN of the datafiles� openOB2BARLIST=ORA_RDCS_WEEKLY)' then RMAN may not be able to automatically catalog a needed online or archived log. In this situation

it overrides the default search path for the libobk library. %By default on the restore of the old copy of the controlfile (pre-upgrade)

1 L.thread#toname => 'D:\ORACLE_BASE\datafiles\SYSTEM01.DBF');fdbms_backup_restore.RestoreDatafileTo(dfnumber => 2 708 delete;List of Backup Pieces:BP Key BS Key Pc# Cp# Status Device Type Piece Name:------- ------- --- --- ----------- ----------- ----------B698 698 1 1 AVAILABLE SBT_TAPE df_546210555_706_1B702 702 1 1 AVAILABLE SBT_TAPE df_546296605_709_1B704 704 1 1 AVAILABLE SBT_TAPE df_546383776_712_1B708 708 then try to apply each of the redolog membes one at a time during the recovery. You may run the following query to determine the redolog members:If you have tried to apply all of the online redolog members instead of an archivelog during the recovery

FHTNM TABLESPACE_NAME916 @What is your oracle version i went for my first test drive.HI logged into RMAN

the following tools and commands can be used to backup an Oracle database:Tooltype of backup Some Disaster Recovery ScenariosoRestore the datafiles to their original locations. If volume names have changed that is

but its more tool oriented.redo logfilecontrol file3Before we explain that RESET DATABASE in nocatalog mode changes the incarnation only for the current RMAN session. You must issue a RESET DATABASE command before you can use RMAN with a target database that has been opened with the SQL statement ALTER DATABASE OPEN RESETLOGS option. If you do not�

document

then you can specify TO INCARNATION when the database is mounted. If database is mounted and is by no means a complete description.JThe archived redologs plays an important role in recovery of the database.2indexes you will see that there is also a difference in a socalled "open" backupRESET_SCN belongingto the prior incarnation.[We can do that by using the "RESET DATABASE TO INCARNATION <Key>" command. If we bring back[the database to that incarnation

which listst all "registered" databases.TYou may ofcourse query the tables and the viewsdsm.sys &tdpo.opt).FKindly provide some suggetions on this. Advanced apprications to them.sgabriel6207-16-2005 then one or more datafiles may need to be recovered . SQL> startup ORACLE instance started. ... Database mounted.C ORA-01157: cannot identify/lock data file 3 - see DBWR trace file< ORA-01110: data file 3: '/ORACLE/ORADATA/H817/USERS01.DBF'0Other possible errors are ORA-00376 and ORA-11139The views and queries to identify the datafiles would b but not mounted or opened.%2> allocate channel t1 type disk;3> set until scn 545773;4> restore controlfile;5> alter database mount;6> restore database ;7> recover database ;8> release channel t1;%9> alter database open resetlogs;10> } channel t1: sid=157 devtype=DISKStarting restore at 30-JUN-08=RMAN-03002: failure of restore comm

Index etc when you drop table.SQL> desc dept= DEPTNO NOT NULL NUMBER(2)@ DNAME VARCHAR2(14)@ LOC VARCHAR2(13)SQL> show recyclebin/opt/ora10g/product/10g/ - big tree of - subdirectories8/u04/oradata/planning/redo01.dbf

> restore from the previous backup and start the database.Q (c) If the datafile contains rollback with no active rollback segments

you can clear the logfile:I SQL> alter database clear logfile '/ORACLE/ORADATA/H817/REDO01.LOG';M Alternatively where the TDPO_NODE is named "DBLIMS_ORA" "and the TDPO_FS is "dblims_lisa". 0First we need to create a separate TDPO_OPTFILE:0------------------------------------------------($ cd /usr/tivoli/tsm/client/oracle/bin641The file is named "tdpo_DBLIMS.opt" in this case:G *********************************************************************N TDPO_FS dblims_lisa stamp

document

##0\)""$"#

h@@ �

lost or corrupted? & Doc ID: Note:465478.1 Type: HOWTO 6 Last Revision Date: 28-MAY-2008 Status: PUBLISHED Goal The assumption here is that we have exhausted all possible locations to find another good and valid copy or backup of the archivelog that we are looking for� it is important to know the mode of the database when the datafiles are backed up. That is whether the database is open or closed -RMAN reports errors similar to the following: In this case�

SBT_LIBRARY is not set. If an ORA-27211 error is seen for an Oracle RMAN backup� the incarnation was listed as 1. Now the real database incarnation is 2 70) from v$datafile;:select distinct checkpoint_change# from v$datafile_header;select status L.sequence#toname => 'D:\ORACLE_BASE\datafiles\UNDOTBS.DBF');h--dbms_backup_restore.RestoreDatafileTo(dfnumber => 3 it is much betterRis the following. But you must also read note 2 for an enhancement of this script.uThis is a backup of all objects in one schema (useraccount in the database. In this example but you always received the ORA-00310 error

FHSTA status backup client that you use and etc?Need more information...SamThanx%Life is a journey connected to target

then run SET NEWNAME commands before the restore and perform a switch after the restore to update the control file with the new locations for the datafiles (refer to"Performing Disaster Recovery").pas the RMAN repository information missing from the backup control file is available from the recovery catalog. bThere are special considerations when using a backup con� the user rman:#create user rman identified by rmandefault tablespace rmantemporary tablespace temp;- give the right permissions:8grant connect

here is a general dba rule:yIf we take a look at our sample database then RMAN refuses to access the recovery catalog because it cannot distinguish between a RESETLOGS operation and an accidental restore of an old control file. The RESET DATABASE command informs RMAN that you issued a RESETLOGS command.

document

however procedures etc..) to one or more file(s).BThese are the "real" database files. Here all modifications to allemployee_id number that isRESET_TIME characterized by the correct incarnation key

but you can also retrieve all kindsPof reports from the RMAN> prompt (which itself does query the tables and views).OYou absolutely do not have to interface to those tables and views. Just use the-rman executable to retrieve info and reports.RAs the last step we need to register the target database. In the following example1we register the PLANNING database to 12:05 AM&Send me your RMAN configuration scriptsanku07-18-2005name there is no controlfile of that specific SCN

redo02.dbf

you canM offline the datafile (after commenting the rollback_segments parameter O assuming that they are private rollback segments) and open the database. P (d) If the datafile is temporary

you can drop the logfile if you have atleast two other logfiles:. SQL> alter database drop logfile group 1;F --> If the logfile is the Current logfile After using correct TSM password it works:) ANU0260I Password successfully changed.NNow we got a new passwordfile "TDPO.dblims_ora" created for this node locally:N# ls -ltr ../bin/TDPO.* P -rw-r--r-- 1 root system 48 Feb 25 08:38 ../bin/TDPO.dbqis_ora P -rw-r--r-- 1 root system 48 Mar 12 12:29 ../bin/TDPO.dblims_o sequence#

document

document

##0.00_);\("$"#

h@ �

which could be in one of the following:.directories defined in the LOG_ARCHIVE_DEST_n 7another directory in the same server or another server standby database mounted or shutdown (normally) when the backup is taken.@If the datafiles are restored from an online or hot backup you can run the following SQL statement to force Oracle $to archive all noncurrent redo logs:ALTER SYSTEM ARCHIVE LOG ALL;5A log switch does not mean that the redo is archived.3/tmp/tools01.dbf and records it in the repository. dTo change the name for datafile ?/oradata/trgt/tools01.dbf to /tmp/tools01.dbf in the control file

you must use the CATALOG command to manually add the required logs to the repository so that recovery can proceed. TThe cataloging procedure is described in Oracle Database Backup and Recovery Basics.jAssuming that you enabled the control file autobackup feature for the target database

it is necessary to review the Oracle RMAN script and verify if SBT_LIBRARY ois either not set or is set correctly. If set so a mismatch appeared.4This can be verified by issuing the following query:set pagesize 20000set linesize 1000resetlogs_change# L.statustoname => 'D:\ORACLE_BASE\datafiles\MYSPACE.DBF'); dbms_backup_restore.RestoreBackupPiece(done => done� we backup all of Harry): Some files are just "there"� as shown in the example below

FHRBA_SEQ Sequence BSELECT status not a destination!sambavan #Send a private message to sambavan Find all posts by sambavan #3 08-29-2001 and then ran a connection test: allocate channel oem_sbt_backup type 'sbt_tape' format '%U' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';release channel oem_sbt_backup;SRMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATEHRMAN-12004: unhandled exception during com�

6then you must restore and mount a backup control file abefore you can perform recovery. When using a backup control file resource

planning

document

then the control file must have a record of the prior incarnation.Keywords and ParametersSyntax Element Description ITO INCARNATION primary_key Changes the current incarnation to an older incarnation. Specify the primary key of the DBINC record for the database incarnation. Run LIST INCARNATION OF DATABASE to obtain possible key values. After employee__name varchar(50)4I have used the following CREATE TABLESPACE command:WNow creating a backup[while the database is openDBINC_STATUS from DBINC;_If you were to open a sqlplus session to the RMAN database we are ableto use those older backups.STARTUP NOMOUNT;ALTER DATABASE MOUNT;S# step 5: make this incarnation the current incarnation and then list incarnations:ALTER DATABASE OPEN RESETLOGS;SSubject: RMAN-20011 Error When Restoring And Recovering To An Earlier Incarnation ( Doc ID: Note:455677.1 Type: PROBLEM 6 Last Revision Date: 23-AUG-2007 Status: MODERATED In this Document

or _4) because I was only allocating one channel (these values are only used when more than one channel is opened to TSM 10:25 AMThanks for your support.My rman script:<rman log=/backup/logs/level0_backup.log target / <<EOF8configure retention policy to recovery window of 7 days;!configure backup optimization on;$configure controlfile autobackup on;"configure maxsetsize to unlimited;run{)allocate channel t1 type 'sbt_tape' parmsB'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/cliestatus from v$datafile;6 SQL> select file# so lets take a look at the backups5of the controlfile with an SCN close to what we want.AWe are not going to list those backups

redo03.dbf/u03/oradata/planning/undo.dbfA/u05/oradata/planning/control01.dbf

offline the datafile and open the database. 6 Drop the tablespace and recreate the tablespace.( (e) If the datafile is DATA or INDEX

then do the following:( SQL> recover database until cancel; Type Cancel when prompted' SQL>alter database open resetlogs;M The 'recover database until cancel' command can fail with the following errors:N ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error reset database to incarnation key 2 RESET DATABASE TO INCARNATION 2;J# step 4: restore and recover the database to a point before the RESETLOGS"RESTORE DATABASE UNTIL SCN 154876;"RECOVER DATABASE UNTIL SCN 154876;G------- ------- -------- ---------------- ------- ---------- ----------Q1 2 TRGT 1334358386 PARENT 154381 OCT first_change#

document

##0.00\)'""$"#

h @ �

which means that the database is open when the backup is taken pA user does an insert

you can restore an autobackup of the control file. Because the autobackup uses a default format�

the filename should be libobk.sl for HP-UX 10

resetlogs_time @ L.first_change#handle => 'D:\ORACLE_BASE\RMAN_BACKUP\MYDB_DF_BCK05H2LLQP_1_1' just after you have created a database: these are "standard files" then the log sequence# required for recovery is no longer available in the online redolog.QORA-00279: change 189189555 generated at 11/03/2007 09:27:46 needed for thread 1 ORA-00289: suggestion : +BACKUP =ORA-00280: change 189189555 for thread 1 is in sequence #428 :Specify log: {<RET>=suggeste< d | filename | AUTO | CANCEL} EORA-00310: archived

resetlogs_change# 07:09 PM goodhealth #Junior Member Join Date: Dec 2000Posts: 75 !Oracle 8.1.7 running on HP-UX 11. #4 08-30-2001 but I can't restore. I get the following:1RMAN-03002: failure during compilation of command!RMAN-03013: command type: restoreNRMAN-03006: non-retryable error occurred during execution of command: IRESTORE/5.5.0.0 COMMITTED IBM Tivoli Storage Manager 64bit Server RuntimePath: /etc/objreposT channel tivoli: starting datafile backupset restore T channel tivoli: restoring controlfile

and using a recovery catalog recovery_catalog_owner to rman;0Next we create the catalog in database PRODRMAN:UOn unix

we only have a few files. But Oracle databases might contain hundredsRfile

document

then you can run RMAN commands such as RESTORE and RECOVER. ExamplesDResetting RMAN to a Previous Incarnation in NOCATALOG Mode: Example In NOCATALOG mode� since in my example database and a socalled "closed" backup you could have issued the followinggSo

we are ableto use those older backups.STARTUP NOMOUNT;ALTER DATABASE MOUNT;S# step 5: make this incarnation the current incarnation and then list incarnations:ALTER DATABASE OPEN RESETLOGS;SSubject: RMAN-20011 Error When Restoring And Recovering To An Earlier Incarnation ( Doc ID: Note:455677.1 Type: PROBLEM 6 Last Revision Date: 23-AUG-2007 Status: MODERATED In this Document

otherwise ORA-1194 and ORA-1110 errors occuronline but take for granted that0the command below shows us what we want to find:=25 Full 6.80M DISK 00:00:03 28-JUN-08O BP Key: 27 Status: AVAILABLE Compressed: NO Tag: TAG20080628T012918{ Piece Name: C:\ORACLE\FLASH_RECOVERY_AREA\TEST10G\BACKUPSET\2008_06_28\O1_MF_NCSNF_TAG20080628T012918_46C1KQ3F_.BK

control02.dbf

6 **Offline the tablespace and start the database.I **If you have a previous backup

RMAN is started in CATALOG mode next_change#from v$log_history+where sequence# = <current log sequence -1)EThis will show us the NEXT_CHANGE#

document

##0.00_);[Red]\("$"#

H h@@ � �

then we must apply at least the archivelog(s) or redolog(s) whose log sequence# are generated from the beginning and until the completion of the said backup that was used to restore the datafiles.8However or update

RMAN can restore it even though it does not have za repository available that lists the available backups. You can restore the autobackup to the default or a new location. NRMAN replicates the control file to all CONTROL_FILES locations automatically.~If you know the backup piece name (for example

11.00 and 11.11

checkpoint_change# L.first_time params => null);%dbms_backup_restore.DeviceDeallocate;END;/(>>>> In Net logs sqlnet.log we can find:RWarning: Errors detected in file /dbms/tdbaplay/ora10g/home/network/log/sqlnet.logL > ***********************************************************************" > Fatal NI connect error 12170. > > VERSION INFORMATION:B TNS for IBM/AIX RISC Sy like the dictionary "system.dbf" but you still cannot open the database

resetlogs_time 03:17 AM vinit #Senior Member Join Date: Oct 2000Posts: 466 remove until time after recover Wcommands make it possible to backup the files belonging to the tablespaces query v$archived_log to find out the archived log /details and note the format of the name column."SQL> select * from v$archived_log; RECID STAMP---------- ----------I THREAD# SEQUENCE# RESETLOGS_CHANGE# RESETLOGS FIRST_CHANGE# FIRST_TIM>This is Bug #5047758 as documented in Metalink note 247611.1. hTo remedy this

Bthe process is identical to recovery with a current control file make sure your environment variable ORACLE_SID points to the right Database:$ export ORACLE_SID=PRODRMANU(it does not always has to be in capital

created by the dba

document

you must mount a control file that knows about the incarnation that you want to recover. The following scenario makes an old incarnation of database trgt current again:CONNECT TARGET / NOCATALOGR# step 1: start and mount a control file that knows about the incarnation to whichN# you want to return. if the current control file does not know about it I only have one physical file "planning_data01.dbf" where the database is shutdown.QThe above list of rman commands the table DBINC

it used the channel appropriately named "DEFAULT").+)Article 33http://adsm.org/forum/archive/index.php?t-4549.htmlcI am facing the following error with RMAN backup with TDP for oracle in one of the My cluster Node.My Env:TDP for oracle with 5.2.1TSM 5.3 with LANFREEClient AIX with Oracle 9iR28I am able to take the lanfree backup from cluster no then you would have restore from an old backup and start the database.RNote that all redo log maintenance operations are done in the database mount state(C) Archive logsNIf the previous archive log files alone have been losterror from v$recover_file;E** If restoring to a replaced disk mounted with the same name mount the Database6-Restore the necessary files with the Restore command.0-Recover the datafiles with the Recover command.P PRecovery Manager: Release 9.0.1.4.0 - 64bit Production P(c) Copyright 2001 Oracle Corporation. All rights reserved. Pconnected to target database: LISA (not mounted)

control03.dbf$Those files are "static" and remainsthe same unless you to plan$But

restore it to a separate location.K **Then export the objects in the affected tablespace ( using User or table level export).7 **Create the tablespace in the original database.* **Import the objects exported above.O If the database is 8i or above

but the RESYNC command fails because the incarnation has not been reset in the catalog.'% rman target / catalog rman/rman@catdb7Copyright (c) 1995 i.e.the highest SCN

document

##0.00\)7*2_("$"* #

if the datafiles are restored from an offline or cold backup or delete statement on table(s). These changes are captured in a small buffer oin RAM (logbuffer)

from the media manager or because the piece is on disk)

-but libobk.so for HP-UX 11.23 (ia64) clients.;Example of an invalid entry for HP-UX 11.23 (ia64) clients:6PARMS='SBT_LIBRARY=/usr/openv/netbackup/bin/libob< k.sl':Example of a correct entry for HP-UX 11.23 (ia64) clients: B2136 (RMAN-20207)[I have a hot backup from yesterday. Try to do point-in-time recovery and get the following: RMAN-08031: re

Fto_char(checkpoint_time DF.min_checkpoint_change# from v$log L name="l0f93ro5_1_1"'kSuppose our planning database is still in non archive mode. If we place it in archive mode, Oracle will usekdifferent behaviour with regards to the redologs. This is what happens in archive mode: if the system needsgSo, we still have our three Online redologfiles (redo01.dbf, redo02.dbf, redo03.dbf) but because copiesoare created at some "archive log destination because the archivelog required for recovery is either missing

checkpoint_change# but there'sXthere could be a lot of activity on the online redologs. So an OS command is not the way*the database with the latest transactions.SAs you know issue the following command and/or include it in any stored scripts you might be using:

pYou must open the database with the RESETLOGS option after performing either complete or point-in-time recovery with a backup control file.vIf the online redo logs are inaccessible maybe your database id uses small capital).$ rman(call the rman executable)Starting recover at 02-JUL-08Gchannel ORA_DISK_1: starting archive log restore to default destination)channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=12|channel ORA_DISK_1: reading from backup piece C:\ORACLE\FLAS

and ment to contain indexes (of the application tables).Efile

document

then(# you must restore an older control file-RESTORE CONTROLFILE UNTIL TIME 'SYSDATE-250';3# step 2: obtain the primary key of old incarnation"LIST INCARNATION OF DATABASE trgt;)Database Buffers 25165824 bytes)Redo Buffers 524288 bytesDatabase mounted.SQL> alter database archivelog 2 /Database altered.SQL> alter databasevThe dba can create multiple tablespaces are very important. The first command tells rman4Some other examples of setting the retention policy:lEnsure that RMAN retains all backups needed to recover the database to any point in time in the last 7 days:@ RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;&Retain three backups of each datafile:3 RMAN> CONFIGURE RE as well as several other tables in the catalog

device type: SBT_TAPE then there is not muchto panic.P** Backup the current database files using hot or cold backup which would ensure0that you would not need the missing archive logs then :< O (1) Restore the affected datafile(s) using OS copy/restore commands from the previous backupThe RMAN> prompt appears:iNow10g

in a default installation

you can also use Transportable tablespace feature.(E) Parameter file ---------------AThis is not a major loss and can be easily restored. Options are:

2003 in the redo 8log file. It will also give us the FIRST_CHANGE# SCN in Bthis redo log file. We need these 2 SCN numbers to find out if we Acan use the redo log file for recovery against the file(s) found Cin 1). If the CHANGE# from 1) is between the FIRST_CHANGE# and the <NEXT_CHANGE# then we can use the redo log file for recovery.>If the CHANGE# from 1) is lower than FIRST_CHANGE# we need to -investigate an earlier online redo log file. GWhen we have identified which redo log files to use for the recovery weEperform the recovery using the redo log file(s) in the following way:HThe recover process will now display something similar to the following:JORA-00279: change 12599 generated at 08/18/98 13:25:48 needed for thread 1OORA-00289: suggestion : /oracle/OFA_base/app/oracle/admin/NE804DB1/arch/129.arc8ORA-00280: change 12599 for thread 1 is in sequence #1299Specify log: {<RET>=suggested | filename | AUTO | CANCEL}FAs the database is not in ARCHIVELOG mode we will not have the 129.arcBfile. Instead the name of the redo log file must be entered on theEcommand line. The filename must include the full path. After the redoGlog file has been applied the recover process will return: Log applied. &V#: C� � J��

document

document

##0_);_("$"* \(#

and the database is cleanly shutdown before the backup is taken and once the user commits his or her transaction

then you can specify zthe piece name using the RESTORE CONTROLFILE FROM 'filename' command. The server records the location of every autobackup in the alert log.{Because you are not connected to a recovery catalog

if you restore datafile ?/oradata/trgt/tools01.dbf to its default location

'DD-MON-YYYY HH24:MI:SS') as checkpoint_time v$logfile LF parms=""-ORA-27028: skgfqcre: sbtbackup returned error?ORA-19511: Error received from media manager layer we build a history of all changes that occurred on the database.Iwhich is ofcourse just some filesystem or directory on your host machine.jSure this means some extra Administrative maintenance. Somebody needs to take care of those archive logs lost or corrupted

_SELECT substr(name the contents of the online logs is most valuable if we need to recover_If we know of a way to archivesql "alter session set optimizer_mode=RULE";+Or nest in your stored script or run block:JCREATE SCRIPT SAMPLE_SCRIPT {sql "alter session set optimizer_mode=RULE";}I---------- ---------- ----------------- --------- ------------- ---------LNEXT_CHANGE# NEXT_TIME BLOCKS BLOCK_SIZE CREA REGI STA ARC DEL COMPLETIOL------------ --------- -----

then you must perform incomplete recovery to an SCN before the earliest SCN `in the online redo logs. This limitation is necessary because RMAN does not back up online logs.}During recovery elapsed time: 00:00:02Warchive log filename=C:\ORACLE\ORADATA\LOG\ARC00012_0658911298.001 thread=1 sequence=12Finished recover at 02-JUL-08$RMAN> ALTER DATABASE OPEN RESETLOGS;_So now we are going to reset the incarnation to the former one

created by the dba

document

2004 maybe not only for performance reasons< or you will only have the last file on tape!%# tar -cvf /dev< /rmt/0hc /u01/oradata%# tar -rvf /dev/rmt/0hc /u04/oradata%# tar -rvf /dev/rmt/0hc /u02/oradata%# tar -rvf /dev/rmt/0hc /u03/oradata%# tar -rvf /dev/rmt/0hc /u05/oradata store the incarnation information.`Suppose now that we want to "restore" the database to a prior incarnation

device name:GORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layerCIBM AIX RISC System/6000 Error: 106: Reserved errno was encounteredAdditional information: 70114SBT error = 7011

to connect and 11g

also some logs can be found here

(1) If there is a backup

Oracle. All rights reserved.4connected to target database: TRGT (DBID=1334531173)RMAN> RESYNC CATALOG;ORMAN-03009: failure of resync command on default channel at 11/01/2001 12:00:43ERMAN-20003: target database incarnation not found in recovery catalogRMAN> RESET DATABASE;<ORA-01578: ORACLE data block corrupted (file # 7in the redo 8log file. It will also give us the FIRST_CHANGE# SCN in Bthis redo log file. We need these 2 SCN numbers to find out if we Acan use the redo log file for recovery against the file(s) found Cin 1). If the CHANGE# from 1) is between the FIRST_CHANGE# and the <NEXT_CHANGE# then we can use the redo log file for recovery.>If the CHANGE# from 1) is lower than FIRST_CHANGE# we need to -investigate an earlier online redo log file. GWhen we have identified which redo log files to use for the recovery weEperform the recovery using the redo log file(s) in the following way:HThe recover process will now display something similar to the following:JORA-00279: change 12599 generated at 08/18/98 13:25:48 needed for thread 1OORA-00289: suggestion : /oracle/OFA_base/app/oracle/admin/NE804DB1/arch/129.arc8ORA-00280: change 12599 for thread 1 is in sequence #1299Specify log: {<RET>=suggested | filename | AUTO | CANCEL}FAs the database is not in ARCHIVELOG mode we will not have the 129.arcBfile. Instead the name of the redo log file must be entered on theEcommand line. The filename must include the full path. After the redoGlog file has been applied the recover process will return: Log applied. &V#: C� � J��

document

##0\);_("$"* "-"_);_(@_).))_(* #

that means that the database is either not open those changes are immediately written to zWhy is that organized in that way? Actually

the RMAN repository contains only information about available backups ~at the time of the control file backup. If you know the location of other usable backup sets or image copies

then RMAN restores bthe file ?/oradata/trgt/tools01.dbf and overwrites any file that it finds with the same filename. ^If you run a SET NEWNAME command before you restore a file

count(*)from v$datafile_headerWgroup by status < (select min(checkpoint_change#) min_checkpoint_change# from v$datafile_header where status='ONLINE') DF where LF.group# = L.group# dIf you want to know if you can recover from the Online logs (archive mode or non archive mode) error text:)sbtbackup: Failed to process backup file.OR another errorstackJRMAN-12004: unhandled exception during command execution on channel disk13cWith this series of command Gbecause after weeks or months or the corresponding log sequence# is no longer available in the online redolog

1 or copy elapsed time: 00:00:02.RMAN-08071: channel c1: deleting archivelog(s)PRMAN-08514: archivelog filename=E:\ORACLE\ORADATA\PROD\ARCHIVE\PRODT001S01538.ARC recid=15 stamp=420196579PRMAN-08514: archivelog filename=E:\ORACLE\ORADATA\PROD\ARCHIVE\PRODT001S01539.ARC recid=16 stamp=420239024PRMAN-08514: archivelog filename=

RMAN automatically searches for online and archived redo logs that are not recorded in the RMAN repository and we will use the backup that/was associated to that incarnation. Watch this:SNow we enter a session in the prodross database

and ment to contain the application tables.{or the undo tablespace

document

Oracle. All rights reserved.RMAN> connect target sys/sys5connected to target database: ORCL1 (DBID=1025591162)RMAN> backup database2> ;Starting backup at 12-DEC-07=using target database controlfile instead of recovery catalogallocated channel: ORA_DISK_1(channel ORA_DISK_1: sid=139 devtype=DISK4channel ORA_DI but also for Administration purposes.Y# exp system/manager@planning file=planning_06062008.dmp full=y log=planning_06062008.logSo using an sufficiently

errno = 106

or logon as from version 10g

for%example the "listener.log"

restore the fileO (2) If there is no backup

block # 3):ORA-01110: data file 7: '/oracle/oradata/trgt/tools01.dbf'>ORA-01578: ORACLE data block corrupted (file # 2in the redo 8log file. It will also give us the FIRST_CHANGE# SCN in Bthis redo log file. We need these 2 SCN numbers to find out if we Acan use the redo log file for recovery against the file(s) found Cin 1). If the CHANGE# from 1) is between the FIRST_CHANGE# and the <NEXT_CHANGE# then we can use the redo log file for recovery.>If the CHANGE# from 1) is lower than FIRST_CHANGE# we need to -investigate an earlier online redo log file. GWhen we have identified which redo log files to use for the recovery weEperform the recovery using the redo log file(s) in the following way:HThe recover process will now display something similar to the following:JORA-00279: change 12599 generated at 08/18/98 13:25:48 needed for thread 1OORA-00289: suggestion : /oracle/OFA_base/app/oracle/admin/NE804DB1/arch/129.arc8ORA-00280: change 12599 for thread 1 is in sequence #1299Specify log: {<RET>=suggested | filename | AUTO | CANCEL}FAs the database is not in ARCHIVELOG mode we will not have the 129.arcBfile. Instead the name of the redo log file must be entered on theEcommand line. The filename must include the full path. After the redoGlog file has been applied the recover process will return: Log applied. &V#: C� � J��

document

@��@��@��@��@��@��@��@��

document

##0_);_(* \(#

is in nomount mode or mounted when the backup is taken we have two "writes" of changes: First a process (logwriter) puts the changeskimmediately in the current redolog

add them to the 6control file RMAN repository with the CATALOG command.yBecause the repository is not available when you restore the control file

then RMAN creates a datafile copy Xwith the name that you specify. For example

resetlogs_change# run:) # SET UNTIL TIME '09/10/2000 13:45:00';; # Specify a nondefault autobackup format only if required; # SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK # TO '?/oradata/%F.bck';F ALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS='...'; # allocate manually% RESTORE CONTROLFILE FROM AUTOBACKUP? MAXSEQ 100 you have told rman to keep all backups that are not older than 5 days those archives can fill up your disk(s).]Production databases should really run in archive mode. If not since they are already overwritten during the redolog switches

60) the current log to the archive destination we need to reset +the database to the old incarnation number.IHere are the steps to reseting the correct incarnation and restoring the 6database to a point in time before the last resetlogs.*Note: Target database should be nomounted.71. Start RMAN and connect only to the catalog database. % rman catalog rman/rman@rcatM2. Execute the command that lists all the incar

Cand catalogs any that it finds so that it can use them in recovery.uRMAN attempts to find a valid archived log in any of the current archiving destinations with the current log format. `The current format is specified in the initialization parameter file used to start the instance v(or all instances in a Real Application Clusters installation). Similarly and have a look at Albert's table:*---------- -------------------------------We have done it!Note 6.Note 7.RESET DATABASESyntaxreset::=)Description of the illustration reset.gifPurposezTo reset the incarnation of the target database in the RMAN repository

which contains the "former" values of tabledata if users do DML (insert

document

elapsed time: 00:01:36*including current controlfile in backupset%including current SPFILE in backupset5F_NCSNF_TAG20071212T150529_3OZDPGX9_.BKP comment=NONE?channel ORA_DISK_1: backup set completethe current redolog the .dbf files

sbtopen: system error)Please suggest me any help for this prob.RgdsSankucheffern07-05-2005

to the catalog database Oracle strongly encourages all dba'sNto use the "expdp" utility instead (but many dba's still use the exp utility).#As an example of the expdb utility:5# exp system/manager file=sales.dmp tables=JOHN.SALES/# exp system/manager file=harry.dmp owner=HARRYl# expdp scott/tiger@db10g tables=EMP

but thoseof the database.5tables and indexes (and other objects) are collected.#In our example

copy sample file or create a new file and add the M required parameters. Ensure that the parameters db_name

block # 235)<ORA-01110: data file 2: '/oracle/oradata/trgt/undotbs01.dbf'OYou can then specify the corrupt blocks in the BLOCKRECOVER command as follows:BLOCKRECOVER DATAFILE 7 BLOCK 3 DATAFILE 2 BLOCK 235;?>>> After a Database Restore and Recoverin the redo 8log file. It will also give us the FIRST_CHANGE# SCN in Bthis redo log file. We need these 2 SCN numbers to find out if we Acan use the redo log file for recovery against the file(s) found Cin 1). If the CHANGE# from 1) is between the FIRST_CHANGE# and the <NEXT_CHANGE# then we can use the redo log file for recovery.>If the CHANGE# from 1) is lower than FIRST_CHANGE# we need to -investigate an earlier online redo log file. GWhen we have identified which redo log files to use for the recovery weEperform the recovery using the redo log file(s) in the following way:HThe recover process will now display something similar to the following:JORA-00279: change 12599 generated at 08/18/98 13:25:48 needed for thread 1OORA-00289: suggestion : /oracle/OFA_base/app/oracle/admin/NE804DB1/arch/129.arc8ORA-00280: change 12599 for thread 1 is in sequence #1299Specify log: {<RET>=suggested | filename | AUTO | CANCEL}FAs the database is not in ARCHIVELOG mode we will not have the 129.arcBfile. Instead the name of the redo log file must be entered on theEcommand line. The filename must include the full path. After the redoGlog file has been applied the recover process will return: Log applied. &V#: C� � J�� sS s[ d� fr�� y�� ~�׀ s x� � �į� Y� .}� R� � ;� � \� ��

document

@ @��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��@��QRRRRRRRRRR��

document

##0\);_(* "-"_);_(@_)?

then the datafiles are already synchronized in terms of their SCN. In this situation then shortly after that

you must use the SET DBID command to identify wthe target database. The DBID is used to determine the location of control file autobackups. Use SET DBID command only 'in the following special circumstances:rYou are connected to a recovery catalog and want to restore the control file

assume that you run the following commands:LSET NEWNAME FOR DATAFILE '?/oradata/trgt/tools01.dbf' TO '/tmp/tools01.dbf';.RESTORE DATAFILE '?/oradata/trgt/tools01.dbf';OIn this case

resetlogs_time then open the database and reset the online logs:\http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmrecov003.htm#i1006245 With the control file mounted�must be automatically included.eand that per default the backups will be stored to disk you might risk loss of data..Note: What is a tablespace?QA database consists of a number of files then we cannot normally open the database

recover we produce;"a cold" file that we can easily backup with an OS command.`This way so we execute the following command: RMAN> Set dbid 579966833;F4. Now we need to connect to the target instance so we can verify the database ID. RMAN> connect targetD RMAN-06005: connected to target database: R815 (DBID=579966833)B5. Since we are connected to both the recovery catalog and target J database

RMAN attempts to find the online redo logs 8by using the filenames as specified in the control file.If you changed the archiving destination or format during recovery� which means to do either of the following actions:/channel t1: starting datafile backupset restore"channel t1: restoring control file|channel t1: reading from backup piece C:\ORACLE\FLASH_RECOVERY_AREA\TEST10G\BACKUPSET\2008_06_27\O1_MF_NCSNF_TAG20080627T10323_469DWKVT_.BKP#channel t1: restored backup piece 1|piece

update

document

elapsed time: 00:00:20Finished backup at 12-DEC-074SQL> select to_char(sysdate for example redo03.log.LWhy not write directly to the real database files are the files with data.@(actually

07:03 AMXAnything with the SBT layer is usually indicative of an issue with the Oracle relinking.7Have you relinked Oracle after the TDP library install?sgabriel6207-06-2005

you use the "connect catalog" commandDEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.logB Control File Included: Ckp SCN: 545801 Ckp time: 28-JUN-08; 5 order by status

the Oracle software(but evidently

control_files

RMAN gives the error:J RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============J RMAN-00571: ===========================================================? RMAN-03002: failure of backup command at 03/03/2008 11:13:06_ RMAN-06059: expected archived log not found

document

:_("$"* #

we can immediately open the database without even applying archivelogs another process (db writer) writes the changesto the actual databasefiles.oThis is more failsafe than that the db writer was the only process writing changes. Ofcourse

but the database name is not unique in the recovery catalog.~Set the database identifier for the target database with SET DBID. RMAN displays the DBID whenever you connect to the target. pYou can also obtain it by inspecting saved RMAN log files

RMAN creates a datafile copy of ?/oradata/trgt/tools01.dbf named FThe cause of this problem has been identified in Bug 5556503. The cause of the issue is that the changes in the way the backup is performed is to use the space bitmaps to find the blocks that are currently allocated and need to be included in the backup The backup seems to misread the space and the

checkpoint_change# then follow the instructions found in "Performing Recovery with a Backup Control File" (see Article 2) &to restore and recover your datafiles.kof the targetdatabase(s) will always contain the latest rman backup information and that at every backupjob like our planning database shown in II.`But oracle also uses the logical concept of "tablespace". A tablespace has no meaning to the OS since the datafiles are in an inconsistent state. So

fuzzy even if the current online log wasn't even "full" we need to tell RMAN to reset the database incarnation to 2. ) We do this with the following command:

or if you added new online log members after the backup of .RMAN-06003: ORACLE error from target database:1ORA-00210: cannot open the specified control file=ORA-00202: control file: '/devel/dev02/dev10g/standbyctl.ctl':RMAN-04005: error from target database: ORA-01017: invalidusername/password;Starting backup at 17-MAY-08 released channel: t1 release elapsed time: 00:00:057output filename=C:\ORACLE\ORADATA\TEST10G\CONTROL01.CTL7output filename=C:\ORACLE\ORADATA\TEST10G\CONTROL02.CTL7output filename=C:\ORACLE\ORADATA\TEST10G\CONTROL03.CTLFinished restore at 27-JUN-08'So lets try the restore with SCN=5498300Starting implicit crosscheck backup at 27-JUN-080Finished implicit c

delete) on tables.Kare specifically created to contain all the application tables and indexes.Oa database that s in "archive mode"

document

'DD-MM-YYYY:HH24:MI:SS') 2 from dual 3 /TO_CHAR(SYSDATE like the planning files? >That is because professional databases uses "write ahead" logsethat captures changes. Ofcourse Oracle does not mind what file extension is in place)eone after the other

12:52 AMYep

and pass alongthe right credentials as in:RMAN>connect catalog rman/rman1RMAN-06008 connected to recovery catalog database checkpoint_change#

this could also have been"(binaries

2 db_block_size

lost of archived log compromises recoverabilityg ORA-19625: error identifying file /dbms/tdbaeduc/educroca/recovery/archive/arch_1_870_617116679.arch* ORA-27037: unable to obtain file status? IBM AIX RISC System/6000 Error: 2: No such file or directoryNote 1:KIf you no longer have a particular archivelog file you can let RMAN catalogCknow this by issuing

document

##0.00_);_("$"* \(#

because the datafiles are already in a consistent state there is a littlemore overhead this way.pa process called "recovery and rollback" takes place

querying the catalog

It's available only a workaround

checkpoint_time6order by status so its actually impossibleGUNTIL TIME cannot be less than the database creation time or RESETLOGS time. iBut the rman catalog database can hold much more data the controlfile(should be empty)PYou could go now to the second sheet "Some_RMAN_Notes" and see if you inderstand+all backup and restore examples over there.5Ofcourse#because the OS only knows of files.KBut in Oracle the following are the 3 options available to allow you to open the database: Option#1: Force open the database by setting the _ALLOW_RESETLOGS_CORRUPTION=TRUE in the init.ora. But there is no 100% guarantee that this will open the database. However�

checkpoint_change# we have all the latest transactionsin our new archived redolog._1. From the sqlplus utility you can issue OS commands by preceding them with the "!" character.J2. You can also exit sqlplus RMAN> reset database to incarnation 2;F We can now see that the current incarnation has been set back to 2. RMAN> list incarnation;B1 2 R815 579966833 YES 1 03-MAY-99

so that every logfile has a mirror on another filesystem).hNote: So please note that the database is using one redolog at the time. (If you follow Oracle's advice plus all archived redologs.YFrom the prompt

and a database that s not in archive mode.or thousends of files. 8Our "planning" database consists of the following files: RMAN-10035: exception raised in RPC: ORA-19502: write error on file "/db200_backup/archive_log03/EDPP_ARCH0_21329_1_492222998"�

document

'DD-------------------SQL> drop table tTable dropped.SQL> RMAN> run2> {L3> set until time "to_date('12-12-2007 15:09:42' the changed data will also be written to the true database file(s) and if all are used

that is the answer. Relink your Oracle libraries. Also ensure your tdpo.conf file states you want to use Lanfree option. When in doubt

RMAN-06428 recovery catalog is not installed#RMAN-06431 recovery catalog created[A number of tables and views are installed in the database PRODRMAN checkpoint_time ;VSTATUS RESETLOGS_CHANGE# RESETLOGS CHECKPOINT_CHANGE# CHECKPOINT_TIME COUNT(*)V------- ----------------- --------- ------------------ -------------------- ----------VONLINE 1 18-JUN-07 20344051 30-JUN-2008 08:20:56 8dSQL> SELECT substr(name

libraries etc..) lives.mThe whole organization of the Oracle Software

compatible are set correctlyK (3) If the spfile is lost

a script could contain code like:'Create a compressed export on the fly. # create a named pipe mknod exp.pipe p> # read the pipe - output to zip file in the background( gzip < exp.pipe > scott.exp.gz & # feed the pipe

document

##0.00\);_("$"* "-"??_);_(@_)6+1_(* #

except if there is a requirement to roll the database forward to a point-in-time after the said backup is taken. The critical key thing here is to ensure that all of the online datafiles are synchronized in terms of their SCN before we can normally open the database. So� which means that all uncommited changes will rollback

or looking at the filenames of control file autobackup. (refer to "Restoring Control File When Databases in the Catalog Have the Same Name: Example"). For example�

actually: - use: 0backup BLOCKS ALL <backup options and arguments>-BLOCKS ALL does not mean that all blocks will be backed up. It means that unused block optimization will not be used to speed up backup. Unused block optimization is a new feature in 10.2.0.2

checkpoint_change# and more types of data you are invited to finish this sheet first.YCHANGE ... NOKEEP is used to undo the effects of CHANGE ... KEEP you could create a tablespace consisting of 1 or more files.hIt would have been nice if you could store a large table over multiple files once the database is opened

resetlogs_change# do the OS commands

1or backup the files to tape with for example tar:{archived redologs type in those commands

blockno 612353 (blocksize=1024)ORA-27072: skgfdisp: I/O error)HP-UX Error: 2: No such file or directoryAdditional information: 612353select al.sequence# )order by al.sequence#Mtarget database (to backup)

document

'DD-MM-YYYY HH24:MI:SS')";4> restore database;5> recover database;6> }#executing command: SET until clauseStarting restore at 12-DEC-07(channel ORA_DISK_1: sid=159 devtype=DISK7channel ORA_DISK_1: starting datafile backupset restoreEchannel ORA_DISK_1: specifying datafile(s) to restore from backup setPrestoring datafile 00001 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\SYSTEM01.DBFPrestoring datafile 00002 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\UNDOTBS01.DBPrestoring datafile 00003 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\SYSAUX01.DBFOrestoring datafile 00004 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\USERS01.DBF+channel ORA_DISK_1: restored backup piece 1?F_NNNDF_TAG20071212T150529_3OZDMCGN_.BKP tag=TAG20071212T150529$channel ORA_DISK_1: restore completeFinished restore at 12-DEC-07Starting recover at 12-DEC-07using channel ORA_DISK_1starting media recoverymedia recovery completeFinished recover at 12-DEC-07#RMAN> alter database open resetlogsdatabase openedRMAN> list incarnationGDB Key Inc Key DB Name DB ID STATUS Reset SCN Reset TimeF1 1 ORCL1 1025591162 PARENT 1 09-MAR-04X2 2 ORCL1 1025591162 PARENT 318842 12-DEC-07<---------set thisZ3 3 ORCL1 1025591162 CURRENT 331575 12-DEC-07<-----its currentSQL> conn sys/sys as sysdba 2<\Since Oracle 10g return to the first redolog and start using that one again.XSo

view your environment with the "showenv" variable. Oh For the likes of me

and those objects livein the tablespace "rman".E5.1 Some notes about the RMAN architecture1

and the actual database

you can create it from the init parameter file (F) Oracle Software Installation The third sheet�

exp userid=scott/tiger file=exp.pipeXYou are certainly not required to set defaults in rman

document

##0.00_);_(* \(#

run the following SQL statement but`all committed changes (which were not yet written to the databasefiles) will be redone (redone).X\pSuppose a crash occurs. The current redolog has all commited changes captured.When the database starts up again

run:xIf you know that a different control file autobackup format was in effect when the control file autobackup was created

with BLOCKS ALL the backup will be done in the same way that it was done in 10.2.0.1 and previous versions. oThe tablespaces should be checked to avoid any other reason for this error using the dbms_space_admin package. *DBMS_SPACE_ADMIN.ASSM_TABLESPACE_VERIFY ( $ tablespace_name IN VARCHAR2

checkpoint_time ;Wthat it will not be eligible then the target's databaseBcontrolfile. In the controlfile so that the configured 'retention policy applies to the backup.ZFor example over multiple filesystems.This could benefit performance. EXTENT MANAGEMENT LOCAL;GIn this document then we must immediately rebuild the database. Database rebuild means doing the following

resetlogs_time<SELECT name and enter sqlplus again.8the true databasefiles

and after backup and after the last "}"

then

document

'DD-MM-YYYY HH24:MI:SS')";4> restore database;5> recover database;6> }#executing command: SET until clauseStarting restore at 12-DEC-07(channel ORA_DISK_1: sid=159 devtype=DISK7channel ORA_DISK_1: starting datafile backupset restoreEchannel ORA_DISK_1: specifying datafile(s) to restore from backup setPrestoring datafile 00001 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\SYSTEM01.DBFPrestoring datafile 00002 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\UNDOTBS01.DBPrestoring datafile 00003 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\SYSAUX01.DBFOrestoring datafile 00004 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\USERS01.DBF+channel ORA_DISK_1: restored backup piece 1?F_NNNDF_TAG20071212T150529_3OZDMCGN_.BKP tag=TAG20071212T150529$channel ORA_DISK_1: restore completeFinished restore at 12-DEC-07Starting recover at 12-DEC-07using channel ORA_DISK_1starting media recoverymedia recovery completeFinished recover at 12-DEC-07#RMAN> alter database open resetlogsdatabase openedRMAN> list incarnationGDB Key Inc Key DB Name DB ID STATUS Reset SCN Reset TimeF1 1 ORCL1 1025591162 PARENT 1 09-MAR-04X2 2 ORCL1 1025591162 PARENT 318842 12-DEC-07<---------set thisZ3 3 ORCL1 1025591162 CURRENT 331575 12-DEC-07<-----its currentSQL> conn sys/sys as sysdba you can tell Oracle in one statement that you are going to use OS commandsXto backup the tablespaces. Just take a look at the following listing all modifications to the database

since is midnight on a Tues

and creating the catalog.sEven stronger60)

could be as in the following example.)We can distinguish 3 "areas" so to speak:/dbms/oracle/adminnand thread from an archive destination to tape

Dictionary_views_target_db

but some options in your scriptsWthat you normally always would set

document

##0.00\);_(* "-"??_);_(@_) "Yes";"Yes";"No" "True";"True";"False" "On";"On";"Off"]� � � �

as shown belowpNow

Ethen specify a nondefault format for the restore of the control file.~If the channel that created the control file autobackup was device type sbt

* ts_option IN POSITIVE

and an earlier backup will be used. To remove the expiredDbackups from the catalog/controlfile use the delete expired command.RMAN> crosscheck backup;RMAN> delete expired backup;$8. Prepare for loss of controlfiles.set autobackup on_REASON: This will ensure that you always have an up to date controlfile available that has been2taken at the end of the cur only the last backups are listed.target databaserman catalogwhat kind of backup the following command prevents RMAN from considering backupsets with the tag 7'year_end_2002' as obsolete under the retention policy:WMaybe sometimes you want to change the status of a certain backup we sometimes come across the concept of "tablespace".F DATAFILE '/u01/oradata/planning/planning_data01.dbf' SIZE 100< 0M namely: (1) perform a full-database export

open_mode that is

it deletes them the script will execute.`And you can let rman run a script by starting with "run {" followed by as series of statements. statements & }`If you take a look again at the above backupscript

ofcourse

document

'DD-MM-YYYY HH24:MI:SS')";4> restore database;5> recover database;6> }#executing command: SET until clauseStarting restore at 12-DEC-07(channel ORA_DISK_1: sid=159 devtype=DISK7channel ORA_DISK_1: starting datafile backupset restoreEchannel ORA_DISK_1: specifying datafile(s) to restore from backup setPrestoring datafile 00001 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\SYSTEM01.DBFPrestoring datafile 00002 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\UNDOTBS01.DBPrestoring datafile 00003 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\SYSAUX01.DBFOrestoring datafile 00004 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\USERS01.DBF+channel ORA_DISK_1: restored backup piece 1?F_NNNDF_TAG20071212T150529_3OZDMCGN_.BKP tag=TAG20071212T150529$channel ORA_DISK_1: restore completeFinished restore at 12-DEC-07Starting recover at 12-DEC-07using channel ORA_DISK_1starting media recoverymedia recovery completeFinished recover at 12-DEC-07#RMAN> alter database open resetlogsdatabase openedRMAN> list incarnationGDB Key Inc Key DB Name DB ID STATUS Reset SCN Reset TimeF1 1 ORCL1 1025591162 PARENT 1 09-MAR-04X2 2 ORCL1 1025591162 PARENT 318842 12-DEC-07<---------set thisZ3 3 ORCL1 1025591162 CURRENT 331575 12-DEC-07<-----its currentSQL> conn sys/sys as sysdba which has the sameeffect as the script above:!SQL> ALTER DATABASE BEGIN BACKUP;SQL> ALTER DATABASE END BACKUP;LSo you do not need the separate ALTER TABLESPACE commands in Oracle 10g/11g.VNow we are pretty close to a correct and complete backup script are "liked to"

I cannot think of the command.sanku07-14-2005

the controlfile remains Authorative in the sense that this "latest info" recover

and then deletes the specific file it backed up while leaving rthe other copies on disk. If you specify the DELETE ALL INPUT option

will show you which dictionary views (of the Target DB) you can query on backups and recovery.ASimple intro Backup and Recovery of Oracle Databases 9i

can just as well be put as a configurable setting. 8Suppose you would give the following series of commands:'-- Example 3: Query on database backupsRMAN> list backup of database;--- Example 4: Query on backup of archivelogs:$RMAN> list backup of archivelog all;oThe primary purpose of the LIST command is to determine which backups are available. For examp

document

[$ -2]\ #�

to determine whether the datafiles are synchronized or not. Take note that we query the V$DATAFILE_HEADER in our example we have three redologs. They are used one after the other

then you must allocate one or more sbt channels. JBecause no repository is available

3 segment_option IN POSITIVE DEFAULT NULL);With: I * TS_VERIFY_BITMAPS: The bitmaps are verified against the extents. This will detect bits that are marked used or free wrongly and will also detect multiple allocation of extents. The file metadata will be validated against file$ and control file. This is the default option (1). oradebug set�

locations on controlfile backups-that can be utilised if complete loss occurs.9. Test your recovery[REASON: During a recovery situation this will let you know how the recovery will go withoutJactually doing itstatus so that it no longer.falls under the rules of the RETENTION POLICY.NTo allow backupsets with the tag year_end_2002 to be marked as obsolete based *on the retention policyCREATE TABLESPACE PLANNING_DATAF DATAFILE '/u02/oradata/planning/planning_data02.dbf' SIZE 1000M (2) create a brand new and separate database

checkpoint_change#where the data lives".\The exact form of the tar commands, depends ofcourse how your tapedrive or class is called..BThis is a backup of just one table, namely the table "JOHN.SALES":KThat is a copy of all relevant database files to tape(s) or backup disk(s).(-z1. On some unixes, rmt1.1 is the non-rewinding class of the tapedrive on rmt1, in contrast with "rmt1

thereby implementing some automatic maintenance on the archived logs.#About the SCN: System Change NumbersNow you may wonder why there is no specificationBWell

its silly to use that database. `Although you might not be happy to create a separate database

document

'DD-MM-YYYY HH24:MI:SS')";4> restore database;5> recover database;6> }#executing command: SET until clauseStarting restore at 12-DEC-07(channel ORA_DISK_1: sid=159 devtype=DISK7channel ORA_DISK_1: starting datafile backupset restoreEchannel ORA_DISK_1: specifying datafile(s) to restore from backup setPrestoring datafile 00001 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\SYSTEM01.DBFPrestoring datafile 00002 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\UNDOTBS01.DBPrestoring datafile 00003 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\SYSAUX01.DBFOrestoring datafile 00004 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\USERS01.DBF+channel ORA_DISK_1: restored backup piece 1?F_NNNDF_TAG20071212T150529_3OZDMCGN_.BKP tag=TAG20071212T150529$channel ORA_DISK_1: restore completeFinished restore at 12-DEC-07Starting recover at 12-DEC-07using channel ORA_DISK_1starting media recoverymedia recovery completeFinished recover at 12-DEC-07#RMAN> alter database open resetlogsdatabase openedRMAN> list incarnationGDB Key Inc Key DB Name DB ID STATUS Reset SCN Reset TimeF1 1 ORCL1 1025591162 PARENT 1 09-MAR-04X2 2 ORCL1 1025591162 PARENT 318842 12-DEC-07<---------set thisZ3 3 ORCL1 1025591162 CURRENT 331575 12-DEC-07<-----its currentSQL> conn sys/sys as sysdba but what we see aboveis still not complete!VYou will notice that I have left out the "/u04" and "/u05" filesystems. Why? Is it not3neccesarry to backup the redologs and controlfiles?ZYes or "identified by" a certain SCN.FRMAN-00554: initialization of internal recovery manager package failedXIs a general error code. You must turn your attention the the codes underneath this one.For example:Ustart from scratch. The former backups just belong to the former Incarnation

01:01 AM

and periodically that dataLwill be transferred to the catalog. That s called synchronizing the catalog.4You can expect something like the following to exist.SQL> select table_name fuzzy

then RMAN backs up exactly one copy of each cspecified log sequence number and thread

10g

you can list:)>>>> Restore & Recover The Whole DatabaseeIf the controlfiles and online redo logs are still present a whole database recovery can be achieved by running the following script:/ shutdown immediate; # use abort if this fails startup mount; restore database; Here is how a transaction works:jBy the name of these files

document

##0.00_);[Red]\([$ -2]\ #�

because we want to know the SCN recorded in the header of the physical datafile that is

you cannot use preconfigured channels. Restore the autobackup of the control file�

dbms_space_admin.TS_VERIFY_BITMAPS)oradebug tracefile_name(Or

and can avoid having to restore source datafiles again.SQL> recover database test;A10. Do not specify 'delete all input' when backing up archivelogsYREASON: Delete all input' will backup from one destination then delete both copies of theYarchivelog where as 'delete input' will backup from one location and then delete what hasVbeen backed up. The next backup will date/time etc..metadata:'You can use the following repositories:W1. The target's database controlfile (belonging to the database which rman will backup)database as well?Yes use this command:`If you want to prevent the use of a backup marked with KEEP in restore and recovery operationsYSo and finally (3) import the recent export dump. This option can be tedious and time consuming

ARCHIVE_CHANGE# MSELECT HXFIL File_num which is rewindingnpthird party tools that use rmanvstill an issue with the online redologs (which are not tablespaces). Actually

we do not ask from you to understand the script below. Its an RMAN script you can configure that as a default as shown in section 5.2.\Secondly

just for holding rman's metadata

document

'DD-MM-YYYY HH24:MI:SS')";4> restore database;5> recover database;6> }#executing command: SET until clauseStarting restore at 12-DEC-07(channel ORA_DISK_1: sid=159 devtype=DISK7channel ORA_DISK_1: starting datafile backupset restoreEchannel ORA_DISK_1: specifying datafile(s) to restore from backup setPrestoring datafile 00001 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\SYSTEM01.DBFPrestoring datafile 00002 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\UNDOTBS01.DBPrestoring datafile 00003 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\SYSAUX01.DBFOrestoring datafile 00004 to C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\USERS01.DBF+channel ORA_DISK_1: restored backup piece 1?F_NNNDF_TAG20071212T150529_3OZDMCGN_.BKP tag=TAG20071212T150529$channel ORA_DISK_1: restore completeFinished restore at 12-DEC-07Starting recover at 12-DEC-07using channel ORA_DISK_1starting media recoverymedia recovery completeFinished recover at 12-DEC-07#RMAN> alter database open resetlogsdatabase openedRMAN> list incarnationGDB Key Inc Key DB Name DB ID STATUS Reset SCN Reset TimeF1 1 ORCL1 1025591162 PARENT 1 09-MAR-04X2 2 ORCL1 1025591162 PARENT 318842 12-DEC-07<---------set thisZ3 3 ORCL1 1025591162 CURRENT 331575 12-DEC-07<-----its currentSQL> conn sys/sys as sysdba but again we have the open file issue. The "ALTER TABLESPACE.." or "ALTER DATABASE.."RRMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME isbefore RESETLOGS timeUI do confirm that backupsets are in the catalog database. Here is my recovery script.|Suppose the Planning database is shutdown. This means that no proces and are"detached from the new incarnation.SYou "just start again from 0" when you create new backups from the new incarnation.SBut

tablespace_name checkpoint_change#

and then deletes that log from all archive destinations. yNote that there are special considerations related to deletion of archived redo logs in standby database configurations. >See Oracle Data Guard Concepts and Administration for details.>>>Backups of Backup SetsnThe RMAN BACKUP BACKUPSET command backs up previously created backup sets. Only backu

11gRThis sheet explains some basic features on the subject of "how to create backups".tThe fourth sheet

you might even have guessed there purpose: they are "logs" to make the "redo" Iof transactions possible in case of a malfunction (crash) of some sort.BRMAN-03009: failure of allocate command on t1 channel at date/time@RMAN-03009: failure of backup command on t1 channel at date/timeetc..I-> Means most of the time that you have Media Management Library pro

document

##0.00\) "Ja";"Ja";"Nee" "Waar";"Waar";"Niet waar" "Aan";"Aan";"Uit" � ��

and not the V$DATAFILE if redo01.dbf gets full

optionally setting the maximum number of days backward that RMAN can search (up to 366) Sand the initial sequence number that it should use in its search for the first day. If you know that your control file contained information about configured channels that will be useful to you in the rest of the restore process� �

if the tablespace is not ASSM

then delete all that are backed up. This means that you will have theWarchivelogs since the last backup available on disk in location 2 (as well as backed up<once) and two copies backup up prior to the previous backup.FSee Note 443814.1 Managing multiple archive log destinations with RMANfor details.=- Running in Archivelog mode=- multiplexing the controlf an export or cold or hotThe "real" dataRemark: should one backup that>on how to backup and restore (and recover) an Oracle database.BERY_AREA\ORCL1\ORCL1\ARCHIVELOG\2007_12_12\O1_MF_1_5_3OZFHKNJ_.ARCParchive log filename=C:\ORACLE\FLASH_RECOVERY_AREA\ORCL1\ORCL1\ARCHIVELOG\2007_102_12\O1_MF_1_5_3OZFHKNJ_.ARC thread=1 sequenc Zthen mark these backups as UNAVAILABLE. RMAN will not delete the records for these backupsAVAILABLE again.efrom the RMAN repository suppose I create the tablespace "PLANNING_DATA" but once we successfully open the new database

substr(HXFNM when we are backing up the tablespaces

and notice that it also backups thedIn an Oracle database we do not see a "channel" alocation in the script. A "channel" is a Server session\which will access the database

Yonly a very small database is required with an rman tablespace (which does not need to be-This repository is called the "rman catalog".\larger than 100M). Ofcourse

document

you signal Oracle to place the tablespaces inetheir "normal" mode again can we still use the former backups

owner( 2 from dba_tables where owner='RMAN';BAL DATA RMANBBCB DATA RMANBBCF DATA RMANBBDF DATA RMANBBP DATA RMANBBRL DATA RMA resetlogs_change#

and they can be backed up to any available device type.DRMAN issues an error if you attempt to run BACKUP AS COPY BACKUPSET.bThe BACKUP BACKUPSET command uses the default disk channel to copy backup sets from disk to disk. `To back up from disk to tape

SomeDisasterRecoveryScenarios

no space

document

which derives the information from the controlfile.#select statusfWhat happens if redo03.dbf gets full also? The system has no other choice than to return to redo01.dbf[the system will use redo02.dbf. If that one gets full also

you can exit the RMAN client at this point

then: ' DBMS_SPACE_ADMIN.TABLESPACE_VERIFY (- tablespace_name IN VARCHAR2

restored recover the datafile many process could be at work on manyjchanged many blocks all over the file. Actually but will not try to use them in restore and recovery until they are marked JThe following options in changing the status of backups will be discussed:CHANGE & KEEP / NO KEEP CHANGE & AVAILABLE / UNAVAILABLEJCHANGE .. KEEP / NO KEEP: Changing Retention Policy Status of RMAN Backups0CONFIGURE ENCRYPTION FOR DATABASE OFF; # and I want to let it have two files:nThat would work. Note that the tablespace consists of two files then we expect minimal or perhaps no data loss at all. Before you try this option

1:to backup those structures. So how do we handle this then?<Fortunately

a sort of "clock" is running. This is not about time selects the data

if a database is used as the rman catalog

document

by using the SQL command "ALTER TABLESPACE <table_space_name> END BACKUP".bYou do that by issuing the SQL command "ALTER TABLESPACE <table_space_name> BEGIN BACKUP" command if we really need to do so? Yes they can.JSuppose we have restored and recovered the target database to a prior SCN.[In that case

Gand therefore has not been subject to an independent technical review. ZRecovering to a previous incarnation after setting the database incarnation to a previous hdatabase incarnation and restoring the controlfile resetlogs_timesSUBSTR(NAME

you must either configure or manually allocate a non-disk channel.Uses for Backups of Backup SetsbThe BACKUP BACKUPSET command is a useful way to spread backups among multiple media. For example

will show you some important problems from which you may recover.What is in this file??interresting features that are not mentioned in this document. " recover database;X alter database open resetlogs; # this command automatically resets the databaseY # so that this incarnation is the new incarnation } Solution Explanation: M

tape not loaded etc..)&ERR 5: Test your Media Management API:&====================================== Testing the Media Management APIwOn specified platforms

document

checkpoint_change# the system will use redo03.dbf.fand starts using that one again! So

to clear manually allocated channels from step "c". If you then restart the RMAN client and mount the database those configured channels become available for your use in the rest of the restore and recovery process.Otherwise� �

S verify_option IN POSITIVE DEFAULT TABLESPACE_VERIFY_BITMAP);oradebug setmypid3execute dbms_space_admin.tablespace_verify('USERS')jAlthough the documentation does not say that this will verify the metadata against file$ and control file.

and bring the datafile online. 0For example we really do not know what has changed at different partsTof the filesequence=>1);>dbms_backup_restore.RestoreArchivedLog(thread=>1 over two separate filessystems /u01 and /u02.aNow I could create a table ensure that you have a good and valid backup of the current database. Option#2: If you have a good and valid backup of the database�

70) File_name we can archive the current online redolog with:&SQL> alter system archive log current;Zof the database files

but it s about a numberhthat's continuously increasing. Oracle uses this number to uniquely identify any change in the database.^So and writes the data to the backuplocation.TRMAN comes preconfigured with one DISK channel that you can use for backups to disk.BSo

much more historical(SQL> ! Tar -rvf /dev/rmt0.1 /u06/backup-4. Backup an Oracle Database with OS commands2when files are added or deleted from the database.xall relevant files at a particular moment. If you have such a "dynamic" script

document

PThe upper variable is the ORACLE_SID that now "points" to the PLANNING database.jNow you want to logon to the database. There are several ways to do that. What you could do is illustratedin the following examples:$ sqlplus /nologOR$ sqlplus username/passwordSQL> connect / as sysdbaSQL>((you already are connected or logged on))Note: How to shutdown we have opened the target with the "reset logs" clause

mounting the controlfile1

^you can execute the following BACKUP command weekly as part of the production backup schedule:# makes backup sets on diskIEvidently

RMAN will allow a restore Jand recover of the database using a backup from before the last resetlogs.Solution References: NOracle8i Recovery Manager User s Guide

Oracle provides a diagnostic tool called "sbttest". This utility performs a simple test of the PBug 4548861 RMAN RESTORE ARCHIVELOG UNTIL SEQUENCE TAKES A LONG TIME TO COMPLETECNote 342999.1 First Resync on Production Host After Running RMAN on?Bug 2876717 RMAN backup starts SLOW if READ-ONLY device is used

document

N to_char(checkpoint_time the use of the logs is somewhat "circular"

restore and perform incomplete recovery of the database

to restore and recover datafile 7: /RMAN> SQL 'ALTER DATABASE DATAFILE 7 OFFLINE'; RESTORE DATAFILE 7; RECOVER DATAFILE 7; . SQL 'ALTER DATABASE DATAFILE 7 ONLINE'; :Oracle Database Backup and Recovery Advanced User's Guide{Once you have an SPFILE� but there is a very high probability your copy is totally inconsistent.\If you want to use OS commands on a open databasesequence=>2);>dbms_backup_restore.RestoreArchivedLog(thread=>1 for example EMPLOYEES then restore the database from the said backup

FHTYP Type and it will determine if "recovery" is needed on one or more files.AWe will explain how to stop and start a database from the prompt.zFirst of all

for example if you backup to disk

you don't need to adjust it all the timeaOnce logged on the the database via sqlplus

document

that is SYS and a new incarnationwas created.Lets see how this looks in rmanXthen after the recovery

restoring and recovering Bthe database with an appropriate time60) REC FUZ CHECKPOINT_CHANGE# RESETLOGS_CHANGE# RESETLOGSs------------------------------------------------------------ --- --- ------------------ ----------------- ---------s/dbms/tdbaprod/prodroca/database/default/system01.dbf NO YES 20344051 1 18-JUN-07s/dbms/tdbaprod/prodroca/database/default/und

also this path could be somewhere else like /home/oracle/adminvThis manual is suitable for Oracle 9i

Release 1 (8.1.6) - Part No. A76990-01JOracle9i Recovery Manager User s Guide

June 18

document

'DD-MON-YYYY HH24:MI:SS') as checkpoint_time that is: use the logsif redo03.dbf is fullthen use redo01 again>-- Example 1: Query on the incarnations of the target database#RMAN> list incarnation of database;#RMAN-03022: compiling command: listList of Database IncarnationsCDB Key Inc Key DB Name DB ID CUR Reset SCN Reset TimeC------- ------- -------- ---------------- --- ---------- ----------B1 2

as described in Oracle Database Backup and Recovery Basics Use an UNTIL clause to specify a target time �

you can start the target database instance you MUST "inform" Oracle about your plans2to backup the database using a certain OS command.< ndifferent blocks at the same time. When your copy command is busy copying the filesequence=>3); dbms_backup_restore.RestoreBackupPiece(done => done� and let it "live" in tablespace PLANNING_DATA:CREATE TABLE EMPLOYEES()TABLESPACE PLANNING_DATA;cNow I know for sure on which files the table will be on. Additionally and recover the database by applying up to the last available archivelog. In this option

HXERR Validity logon to the OS (or "su -") as the "oracle user" (that is probably the account that also owns the software).oIf you have more than one Oracle instance running on your system

suppose a user Updates you do not need to specify a "channel".XNow let us take a look at a second backup script

you can get lists of the relevant databasefiles via:SQL> select * from v$logfile;!SQL> select * from v$controlfile;!SQL> select name from v$datafile;-4.2 Backup an open database with OS commands.=to use command like shown in section 4.1 on an open database.bA database file consists of blocks which ultimately consists of diskpages. At the time of creationUof the

document

then you have the authority to start or stop a database.Rwhereas "system" is one of the standard administrative superusers in the database.wActually you must have opened the database with the "reset logs" clause.RMAN> connect target /$RMAN> connect catalog rman/rman@rmanthis is the new incarnation

getting RMAN-20011 errors. hThis is a known issue that is documented in an unpublished BUG. The currently is no patch for the BUG open_mode

10g

Release 1 (9.0.1) - Part No. A9013[Subject: Recover With Until Time fails With RMAN-20207 When Time Is Before Last RESETLOGS ( Doc ID: Note:159405.1 Type: PROBLEM 6 Last Revision Date: 15-MAY-2003 Status: PUBLISHED lLet's first take a look at what exactly should be backupped frequently. We will use an example of an simple 'pOracle database

2007:See Sheet 4 "SomeDisasterScenarios" for complete examples.OThis example is quite similar to the example above. But there is a difference. 5if we still can use a backup that s several days old.Also�

document

count(*) from v$datafile_header 5group by status as shown in the following example:&RMAN> list backup of tablespace users; RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archive log in the recovery catalogOracle Error :: RMAN-20242Cspecification does not match any archivelog in the recovery catalogBNo archive logs in the specified archive log ra�

SCN or log sequence number for the recovery prior to the first SCN of the online redo logs. In this example�

restore the control file from autobackup and mount it. If you are restoring to a new host� those processes could have^If you have done thathandle => 'D:\ORACLE_BASE\RMAN_BACKUP\MYDB_LOG_BCK0DH1JGND_1_1' if the table gets very largeuI could benefit from "parallel IO" because of the two independent filesystems (assuming those are on separate disks).Flashback complete.dReports which database files need to be backed up to meet a configured or specified retention policysUse the REPORT NEED BACKUP command to determine which database files need backup under a s we will only recover the database up to the last archivelog that is applied

FROM v$datafile;FROM v$datafile_header;FROM v$datafile_headerFROM v$database;QSELECT GROUP# its very likely you need to export a variablegthat "points" to the correct "SID" (Oracle database identifier)<

or Deletes which backups the database to tape(s).dSo

you may specify the blocksize you favor

document

every Oracle database has two very important superusers

Zhowever checkpoint_change#

and 11g. Ofcourse

let's call it "PLANNING"

on your Oracle version

document

checkpoint_change# 2008 7:52 AM Reply pYou must run the RECOVER command after restoring a backup control file

the online redo logs have been lost

you should review the considerations described in "Restore and Recovery of the Database on a New Host".OYou are restoring the database to a new host with the same directory structure."You do not use a recovery catalog..In this scenario Oracle will take certain "measures" to insure that your OS copy commandwill produce a correct result.h(Actually params => null);Note 2:-------Idevtype := dbms_backup_restore.DeviceAllocate(type => '' REPORT NEED BACKUP reports which objects need backup under the currently configured retention policy. XThe output for a configured retention policy of REDUNDANCY 1 is similar to this example:REPORT NEED BACKUP;4RMAN retention policy will be applied to the command and any data after that are lost. If no archivelogs are applied at all

THREAD# like for example in the following way:$ export ORACLE_SID=PLANNING35.4 Changing the status of backups on disk or tape.B "/u06/archives"

or Inserts a row in or from a table from the RMAN> prompt

like 4K

document

namely "sys" and "system"

there is a workaround. The problem is RMAN does an implicit catalog of all files]in flash Recovery area. This causes the current incarnation to change to latest incarnation. TThe workaround is to execute "reset database to incarnation" command after mounting @the restored control file or when ever RMAN-20011 is signalled. iand presence of new archive logs is recor ARCHIVE_CHANGE#7NAME OPEN_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE#7--------- ---------- ------------------ ---------------7PRODROCA READ WRITE 20344051 20324343VSQL> SELECT GROUP#

there are differences between those versions

which

rman could have some nasty bugs. It has happened before. Be sure to check the most important bugsOThis will list all your online redolog files and their respective sequence and first change numbers. 4SELECT V1.GROUP#

document

checkpoint_time The results of the above query must return one and only one row for the online datafiles even if no datafiles have been restored.=RMAN-03002: failure of recover command at 08/29/2001 14:23:09ERMAN-06054: media recovery requesting unknown log: thread 1 scn 86945PPerforming Recovery with a Backup Control File and No Recovery Catalog: ScenariogThis section assumes that you have RMAN backups of the control file

and the most recent archived log sequence number is 13243. This example shows ihow to restore the control file autobackup

perform the following steps:/# Start RMAN and connect to the target database% rman TARGET SYS/oracle@trgt&# Set the DBID for the target databaseRMAN> SET DBID 676549873;NRMAN> STARTUP FORCE NOMOUNT; # rman starts instance with dummy parameter fileRUN& ALLOCATE CHANNEL t1 DEVICE TYPE sbt;! RESTORE SPFILE FROM AUTOBACKUP;6# Res it will copy complete block(s) to the online redologs if such a block is being modified whileVIf you have recent backups of the parameter file availableident => 'FUN');'dbms_backup_restore.RestoresetdataFile;Vdbms_backup_restore.RestoreControlFileto('D:\ORACLE_BASE\controlfiles\CONTROL01.CTL');jdbms_backup_restore.RestoreBackupPiece('D:\ORACLE_BASE\Rman_Backup\MYDB_DF_BCK0BH1JBVA_1_1'RMAN retention policy is set to redundancy 12Report of files with less than 1 redundant backupsFile #bkps Name@---- ----- ------------------------------------------------------2 0 /oracle/oradata/trgt/undotbs01.dbfRMAN> REPORT UNRECOVERABLE;hReports which database files require backup because they have been affected by some NOLOGGING operation such as a then we can only recover the database from the backup that is restored. However

SEQUENCE# you should probably add to your backup commands:\is in operation on those archived logs and only the last couple of days are in (for example)[So how do you use OS commands at an open Oracle database (that is running in archive mode)?%for every tablespace in the database.@As an example

this9That number is called the "System Change Number" you can give singular commands

8K

document

whereas the "sys" accountjhas all possible powers in the database. But you can make perfect full dabase exports using system or sys.dIt might look a bit weird

.Finished implicit crosscheck copy at 27-JUN-08rFile Name: C:\ORACLE\FLASH_RECOVERY_AREA\TEST10G\BACKUPSET\2008_06_27\O1_MF_ANNNN_TAG20080627T103227_469DXG4D_.BKPrFile Name: C:\ORACLE\FLASH_RECOVERY_AREA\TEST10G\BACKUPSET\2008_06_27\O1_MF_ANNNN_TAG20080627T104805_469FTQ6T_.BKPrFile NameTHREAD#

but with !This is just the Oracle Software.%to do an upgrade

in this example

MEMBER

document

which means that they are already synchronized in terms of their SCN. Otherwise but do not use a recovery catalog.jYou are not connected to a recovery catalog and want to restore the control file or server parameter file.=The server parameter file is lost and you want to restore it.ZTo recover the database with an autobackup of the control file without a recovery catalog:yThis package

then performs recovery of the database to log sequence 13243. You have one tape drive containing backups of all the datafiles and archived redo logs through log 1124�

and you wish toJ # recover to that point-in-time. In this way RMAN restores the databaseG # to the same structure that the database had at the specified time. ALTER DATABASE MOUNT;# SET UNTIL SEQUENCE 1124 THREAD 1; RESTORE DATABASE; RECOVER DATABASE;URMAN> ALTER DATABASE OPEN RESETLOGS; # Reset the online logs after recover and you make sure that you\always can fallback on a good copy (in case the current one gets missing)done => done);Vdbms_backup_restore.RestoreControlFileto('D:\ORACLE_BASE\controlfiles\CONTROL02.CTL');Vdbms_backup_restore.RestoreControlFileto('D:\ORACLE_BASE\controlfiles\CONTROL03.CTL');/ MERR 9: RMAN-00554 initialization of internal recovery manager package failed:Ythat the archived redologs have the '.arc' extension backup pieces and datafile copies that are obsolete if we restored from an online or hot backup

MEMBERS we show how to do this for our PLANNING database.RFor easy reference

or SCN.Fchange is characterized by a unique number that is

16K

document

but if you connect yourself to the database like in "connect / as sysdba"rWe don t go in deeper on those specifics

elapsed time: 00:01:25Starting recover at 27-JUN-08?channel t1: starting archive log restore to default destination!channel t1: restoring archive log archive log thread=1 sequence=11|channel t1: reading from backup piece C:\ORACLE\FLASH_RECOVERY_AREA\TEST10G\BACKUPSET\2008_06_27\O1_MF_ANNNN_TAG20080627T10327_469DXGSEQUENCE#

or install a patch.5or some other filesystem or directory of your choice.(was installed in /opt/ora10g/product/10g+Location of Oracle Software ( ORACLE_HOME )for example in the location:I Software (Static stuff)EII Databasefiles (Will change constantly while the database is open)a directory like for example:32. Tools and commands you use to backup a d

contains of a small number of database files.>>>> Full Backup 1.>>>> Full Backup 2.JCreating a full backup can even be as simple as in the following example. WIf you backup to tape

SEQUENCE#

document

if the results return more than one row for the online datafiles along with the target database version of DBMS_RCVMAN

as well as autobackups .of the control file and server parameter file. The following scenario restores and recovers the database to the most recently available archived log�

tell Recovery Manager+ # to do this using SET NEWNAME commands:< SET NEWNAME FOR DATAFILE 1 TO '/dev/vgd_1_0/rlvt5_500M_1';< SET NEWNAME FOR DATAFILE 2 TO '/dev/vgd_1_0/rlvt5_500M_2';< SET NEWNAME FOR DATAFILE 3 TO '/dev/vgd_1_0/rlvt5_500M_3';" SET UNTIL SEQUENCE 124 THREAD 1;L SWITCH DATAFILE ALL; # Update control file then all is fine.VOtherwise but any other will be good as well.EWe also assume that the script runs late in the evening that is then we may not be able to open the database

ARCHIVED we show again on which filesystems the database files resides:File:associated tablespace

derived from this "clock".aSuppose you shutdown the database. If you shutdown it "cleanly" one statement

32K etc..} Backup Piece 27 28-JUN-08< C:\ORACLE\FLASH_RECOVERY_AREA\TEST10G\BACKUPSET\2008_06_28\O1_MF_NCSNF_TAG20080628T012918_46C1KQ3F_.BKP%Backup Set 39 28-JUN-08} Backup Piece 43 28-JUN-08 C:\ORACLE\FLASH_RECOVERY_AREA\TEST10G\BACKUPSET\2008_06_28\O1_MF_NCNNF_TAG20080628T013052_46C1KY

document

because the purpose here is how to show you to stop or start a database.Stop a database:(SQL> shutdown normal | immediate | abortjIf you use "normal"

elapsed time: 00:00:01Warchive log filename=C:\ORACLE\ORADATA\LOG\ARC00011_0658480420.001 thread=1 sequence=11/media recovery completeMEMBERS

than the backup host. HThe note is for TDPO releases only

your allocate channel command would probably look similar to thecThis will mark all backups older than one day as obsolete. Now in this example we are going to testQIf you did a recovery of a database to a certain point in time

FIRST_CHANGE# FROM V$LOG V1

document

then the datafiles are still not synchronized yet. In this case is automatically installed in every Oracle database uwhen the catproc.sql script is run. This package interfaces with the Oracle database server and the operating system Sto provide the I/O services for backup and restore operations as directed by RMAN. The docs also note that The DBMS_BACKUP_RESTORE package has a PL/SQL procedure to normalize filenames on Windows NT platforms. ZOracle DBA John Parker gives this example of dbms_backup_restore to recover a controlfile:declaredevtype varchar2(256);�

which in this example is log 1124 in thread 1. It assumes that:AContinue to get ORA-27211 Failed to load media management libraryjhad a remarkably similar experience a few months ago with Legato NetWorker and performed all of the steps eA good rman script that will backup your database and archived logs

restore all relevant network files such as tnsnames.ora and listener.ora by means of operating system utilities. Start RMAN and connect to the target database. If you do not have the Oracle Net files� you might consider an additional statement to your backupscript that copies%the parameterfile to a safe location.VBut this document is supposed to be a quick intro on the subject of backup an restore.hAlthough you can manage rman backups and restores via the graphical interface of the Enterprise Manager or at night.2mv /u06/archives/today/*.arc /u06/archives/1dayago?So not needed dto meet a specified retention policy because we still need to apply the archivelogs generated during the said backup in order to synchronize the SCN of the datafiles before we can normally open the database.vOption#3: Manually extract the data using the Oracle's Data Unloader (DUL)

STATUS

then the checkpoint process will2update all database fileheaders with the last SCN.iThis is very important like for example:Sto where you want to backup

and hence not supported.J This last option should only be used in cooperation with Oracle Support =- mount the Database =- recover DatabaseRbut if you are in doubt you can perform a full resync using the follwoing command:RMAN> resync catalog; ---------- ---------------------# 1 db was never gebackupped 2 before 1st backupSQL> select * from person;# all

document

Oracle waits until all transactions are finished which could mean that you might waitUare rolled back and the database will shutdown cleanly

elapsed time: 00:00:02Finished recover at 27-JUN-08:new incarnation of database registered in recovery catalog(starting full resync of recovery catalogfull resync complete"Now we return to database test10g.kBeyond this point the recovery would have to make reference to the online redo logs which are not present. kDisaster recovery is therefore a type ofARCHIVED

which use TDPO_OPTFILE environment. :i.e. Release 2.2.0 and above. (NOT for ADSM Connect Agent)HThis article is for DBA's and consultants who need the alternate client restore functionality.=How to achieve alternate client restore with RMAN and Tivoli <------------------------------------------------------------KThe alternate client restore functionality means

or a certain SCN

V$LOGFILE V2 WHERE V1.GROUP# = V2.GROUP# ; +SELECT FILE#

document

we need to apply archivelog(s) or redolog(s) to synchronize all of the online datafiles. By the way is automatically installed in every Oracle database uwhen the catproc.sql script is run. This package interfaces with the Oracle database server and the operating system Sto provide the I/O services for backup and restore operations as directed by RMAN. The docs also note that The DBMS_BACKUP_RESTORE package has a PL/SQL procedure to normalize filenames on Windows NT platforms. ZOracle DBA John Parker gives this example of dbms_backup_restore to recover a controlfile:declaredevtype varchar2(256);�

and that will work in most cases&2> allocate channel t1 type disk;3> backup full database ;/4> backup (spfile) (current controlfile) ;/5> sql 'alter system archive log current';

then connect using operating system authentication. Specify the DBID for the target database with the SET DBID command�4RMAN has some important advantages over OS commands:T2. "Automatic" history of your backups effectively by specifying the OBSOLETE keyword. If you do not specify any dother options which is performed by Oracle Field Support at the customer site on the next business day and for an extra charge. If the customer wants to pursue this approach

FIRST_CHANGE# FROM v$log;SELECT * FROM v$log_history;SELECT * FROM v$recover_file;SELECT * FROM v$recovery_log;FROM X$KCVFH;1SELECT hxfil FileNo

because if you start that database again because you might want to choose between tape or disk.WIn this example

which means that they are already synchronized in terms of their SCN. Otherwise�

document

that is

tablespaceSTATUS

that you want to restore 2backups on a different host like the backup host. (This is needed in several circumstances:I- Creation of a standby database using DUPLICATE DATABASE ... FOR STANDBYLLet's start with a simple example. We have a database called LISA

UAs far as rman "sees it"

CHANGE# FROM V$RECOVER_FILE; 9If the CHANGE# is GREATER than the minimum FIRST_CHANGE# Uof your logs

document

take note of the CHECKPOINT_TIME in the V$DATAFILE_HEADER

6> backup archivelog all delete input ;7> release channel t1;8> }dSo even with the small "retention period" of one day

as described in "Performing Recovery with a Backup Control File and No Recovery Catalog: Scenario".hRun the STARTUP NOMOUNT command. RMAN attempts to start the instance with a dummy server parameter file.`Allocate a channel to the media manager and then run the RESTORE SPFILE FROM AUTOBACKUP command.iRun STARTUP FORCE NOMOUNT mode so that the ins of which you can retreive lists and reports.T3. Faster and slimmer backups because rman "knows" what to backup of files we keep two days of archived redologs on disk.{ Piece Name: C:\ORACLE\FLASH_RECOVERY_AREA\TEST10G\BACKUPSET\2008_06_27\O1_MF_NCNNF_TAG20080627T103209_469DWV0Z_.BKPB Control File Included: Ckp SCN: 549850 Ckp time: 27-JUN-08=114 Full 6.80M DISK 00:00:03 27-JUN-08P BP Key: 122 Status: AVAILABLE Compressed then REPORT OBSOLETE displays the backups that are obsolete according to the current 4retention policy we need the complete name

FHSTA status FROM x$kcvfhall;SELECT * FROM v$backup;$allocate channel d1 type 'SBT_TAPE';$allocate channel d2 type 'SBT_TAPE';$allocate channel d3 type 'SBT_TAPE';restore databaseFuntil time "to_date('Aug 27 2001 02:00:00'

the Oracle processes will check the SCNnon-0 p The program encountered an error. Either the media manager is not installed or it is not configured correctly. To use sbttest: Make sure the program is installed� you see that two channels are created before the actual backupcommandsdare called. These channels will write to tape

if the results return more than one row for the online datafiles

document

in a consistent way.lThe "abort" option

datafileFIRST_CHANGE# FROM v$log;N GROUP# THREAD# SEQUENCE# MEMBERS ARC STATUS FIRST_CHANGE#N---------- ---------- ---------- ---------- --- ---------------- -------------N 1 1 901 1 YES INACTIVE 20324346N 2 1 902 1 NO CURRENT 20344051N 3 1 898 1 YES INACTIVE

which is Klocated on host "DBLIMS" and we want to restore a controlfile of LISA on a host called "DBQIS". MWe have copied the init.ora file of LISA and already started the instance in QNOMOUNT state. First we check

a new Database Incarnation has been created

a datafile can be recovered from the online logs even if the database. runs in NONArchive mode.3Subject: How To Recover Using The Online Redo Log ) Doc ID: Note:186137.1 Type: BULLETIN 6 Last Revision Date: 11-OCT-2007 Status: PUBLISHED (How to recover using the online redo log(========================================;To easily and quickly fin

document

which indicates the date and time how far the datafiles have been recovered. The results of the query above may return some offline datafiles. So�

we can restore a backup from several days old.WActually

the minimum required set of backups is backups of some datafiles compared1Subject: ORA-600 [Krbodo_badend] On Rman Backup ( Doc ID: Note:412170.1 Type: PROBLEM 5 Last Revision Date: 20-JUN-2008 Status: REVIEWED Changes6Oracle Server - Enterprise Edition - Version: 10.2.0.2RMAN backup .An RMAN backup fails with the internal error: ^ ORA-00600: internal error code most dba's do both types of backups as shown in the following example:RMAN> REPORT OBSOLETE;\In the simplest case phone# and email address of the person who has the authority to sign the work order in behalf of the customer.5 sql 'alter system archive log current';2 backup archivelog all delete input ;! release channel t1;! release channel t2; }_select substr(name

'Mon DD YYYY HH24:MI:SS')";recover databaseEuntil time "to_date('Aug 27 2001 1:25:00'

included in your system path because in the statement you might see the "sbt_tape"Aidentifier. This is "rman language" for "we will backup to tape".6>4> backup full database ;Article 1 recover database; alter database open;}^This will result in all datafiles being restored then recovered. RMAN will apply archive logs Sas necessary until the recovery is complete. At that point t

then the datafiles are still }not synchronized yet. In this case

document

immediately kills the database. In this case

archived redo logsubstr(member

if there is a backup of the controlfile available:Q$ rman target / catalog tsm/tsm@tsm

and all backupPand you can also use image copies with non-RMAN restore and recovery techniques.jTo create image copies and have them recorded in the RMAN repository

this Freduces the available options to quickly recover a database. Basically2 options are available: a) restore from a backup6 b) recover the database using the online redo logs.JOption a) is straight forward and will not be covered here. Only importantGthing to mention is that option a) WILL cause loss of data if there has@been updates/inserts to the database sin

document

ensure that all of the required datafiles are online

only a separate rman tablespace and a user rman is required. So you could useZan existing database for holding the rman repository. But if that database is an importantmallocate channel t2 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; mallocate channel t3 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; (sql 'alter system archive log current'; #backup incremental level = ${LEVEL}

psome archived redo logs generated after the time of the backup arguments: [krboDo_badend] whereas the "physical backup"BFrThe logical backup is then probably scheduled less frequently and can be used as some sort of "last resort" you could crosscheck all backups on disk

1

'Mon DD YYYY HH24:MI:SS')";$sql "alter database open resetlogs";release channel d1;release channel d2;release channel d3;2## If successful

and linked with Oracle by typing sbttest at the command line: UIf the program is operational restores and recovers it

we need to apply archivelog(s) or redolog(s) to synchronize all of the online datafiles. By the way�

document

the fileheaders have not been updated withMthe last SCN

or control file. Backups that have expiredL. Backups restricted by time1

backup (spfile) (current controlfile) ;

run the RMAN BACKUP AS COPY command U(or

ORA-1113 or both

document

because we may not be able to recover later the offline datafile once we open the database in resetlogs. Even though we can recover the database beyond resetlogs for the Oracle database starting from 10g and later versions due to the introduction of the format "%R" in the LOG_ARCHIVE_FORMAT

only a separate rman tablespace and a user rman is required. So you could useZan existing database for holding the rman repository. But if that database is an importantmallocate channel t2 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; mallocate channel t3 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; (sql 'alter system archive log current'; #backup incremental level = ${LEVEL}

and at least one autobackup of the control file.lThe basic procedure for disaster recovery begins with restoring an autobackup of the server parameter file [641] or as4way for an easy restore of an object (like a table).)/u02/oradata/planning/planning_indx01.dbf/u03/oradata/planning/users.dbf /u03/oradata/planning/system.dbf /u03/oradata/planning/sysaux.dbf/u03/oradata/planning/temp.dbf;hosts to match for a restore to the DR host tape or both60)

need to run reset database below##reset database__________________goodhealth View Public Profile %Send a private message to goodhealth Find all posts by goodhealth #2 08-29-2001

you should see a display of the online documentation. }Execute the program then brings it back online: run { - allocate channel dev1 type 'sbt_tape'; 5 sql "ALTER TABLESPACE tbs_1 OFFLINE IMMEDIATE"; restore tablespace tbs_1; recover tablespace tbs_1; * sql "ALTER TABLESPACE tbs_1 ONLINE"; } .Recovering Datafiles Restored to New LocationsiThe following example allocates one disk channel and one media mana

take note of the CHECKPOINT_TIME in the V$DATAFILE_HEADER

document

so at a restart recovery is needed (using the online redologs).%You will only seldom use this option.CSo under normal circumstance

path name70) FROM v$logfile;6SQL> SELECT GROUP#

sql 'alter system archive log current';) backup archivelog all delete input ; release channel t1; }2Some time after the backup

alternatively

we first need to ident<ify which files need to be recovered.>1) First we mount the database then issue the following query:select * from v$recover_file; BThis will give us a list of the files that need media recovery. It@will also give us CHANGE#

document

it is recommended that you online the required datafiles now than after the database is open in resetlogs to avoid any possible problems. However

;as described in Oracle Database Backup and Recovery Basics.\The following notes and restrictions apply regardless of whether you use a recovery catalog:GArticle 1. Oracle Article. Recover a datafile with missing archivelogs+Article 5. Oracle paper: Disaster RecoveryArticle 6: Oracle Paper8Article 7. How to use the Online redologs for recovery.-Article 8. Oracle pa [] AND to disablePASSWordaccess GENERATE.EAfter that using any one of the following commands:)RMAN> CROSSCHECK BACKUP DEVICE TYPE DISK;(RMAN> CROSSCHECK BACKUP DEVICE TYPE SBT;ARMAN> CROSSCHECK BACKUP; # crosshecks all backups on all devices RThe REPORT SCHEMA command lists and displays information about the database files.hAfter connecting RMAN to the target database an recover

06:14 PM

specifying any of the arguments described in the online documentation. For example and restores o< ne of the datafiles in tablespace TBS_1 to a different location: ' allocate channel dev1 type disk; - allocate channel dev2 type 'sbt_tape'; 6 sql "ALTER TABLESPACE tbs_1 OFFLINE IMMEDIATE"; 5 set newname for datafile 'disk7/oracle/tbs11.f' # to 'disk9/oracle/tbs11.f'; restore tablespace tbs_1; switch datafile all; +

which indicates the date and time how far the datafiles have been recovered./1. Compression: your backups can be compressed.nBut be carefull. Every Oracle RDBMS version has bugs

document

you shutdown a database cleanly with:SQL> shutdown immediateStartup a database:bIf the database is down

device typesubstr(member

albert does an insert.'---------- ---------------------------- 3 after 1ste backup >>> Now we run our first backup:!>>> Now we run our second backup:9Some time after the second backup

configure the default backup type for disk as image copies using LCONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY before performing a backup). kA database server session is used to create the copy

i.e. the SCN where the media recovery@must start. To get the name of the file use the FILE# column and#query against v$datafile like this:select name from v$datafile)where file# = <file# from v$recover_file>or like this in 9i: select substr(d.name

document

in some cases

and using gzip or compress [] went swimmingly issue REPORT SCHEMA as shown in this example:RMAN> REPORT SCHEMA;&# Show items that beed 7 days worth of## archivelogs to recover completely'report need backup days = 7 database; 7if you separate those objects in their own tablespaces.qto re-use a certain redolog fuzzy

enter the following Cto create test file some_file.f and write the output to sbtio.log: &% sbttest some_file.f -trace sbtio.logxYou can also test a backup of an existing datafile. For example RMAN allows incomplete recovery to a specified time

of which fixes and patchsets will be released regularly.-and check whether you need a fix or patchset.or RMAN> connect target /Hhow long to keep backups available

document

but you are connected as a sysdba

tag1

albert does an insert. 4 after 2nd backup >>> Now we run our third backup:@SQL> SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER() from dual;)DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER())-----------------------------------------JThe SCN at that time is 549794. But ofcourse the SCN is always increasing.TNow we want to restore to SCN where there were only two records in the PER

and the server session also performs actions such as Vvalidating the blocks in the file and recording the image copy in the RMAN repository.aYou can also use an operating system command such as the UNIX dd command to create image copies

1

document

we intentionally offline the datafile(s)

you can typically create small exports from even quite large databases. For example� [] and the DBAs not familiar with RMAN/TDPOJwere impressed. We then set up a RMAN catalog db it will FIRST MAKE A COPY OF THAT FILE AND STORE THAT COPY IN SOME DESIGNATED PLACE.eThis location checkpoint_change#

this command tests datafile tbs_33.f of database PROD: % sbttest tbs_33.f -dbname prodeExamine the output. If the program encounters an error SCN or sequence number:run { shutdown immediate;( set until time 'Nov 15 2000 09:00:00';B # set until scn 1000; # alternatively

before considering them as obsolete.xThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process

document

you can easily startup a database withSQL> startup6SQL> mount pfile="full_path_to_parameterfile_init.ora"SQL> alter database open;if you need to explicitly!startup a database with a certainor default init_<sid>.ora.4.1 Backup a closed database with OS commands. If a database is closed�

or recoverability. Incarnations of a databasegBy default70) FROM v$logfile; GROUP# SUBSTR(MEMBER

status

rthough these will not be validated

30) fname

document

because we are doing a partial database restore

a 500GB database can be exported to a 25GB exportfile. Note by Antapex: never rely completely on your physical backup. Make sure you have a good and recent export of the database as well.&5NArticle 2. TEST: Incomplete Recovery to a point in time: up to a certain SCNNArticle 3. TEST: Incomplete Recovery to a point in time: up to a certain S� [] which worked great where the "archived" redologs are stored resetlogs_change#

it provides messages describing the failure. 9For example you can specify SCNR # set until sequence 9923; # alternatively

and therefore has not been

document

no process is acting on the databasefiles. If you have shutdown the database in a clean way

RMAN lists backups by backup1

substr(name

nor are they recorded in the RMAN repository. You can use the CATALOG command Vto add image copies created with native operating system tools in the RMAN repository.">>>Using RMAN-Created Image CopiespIf you run a RESTORE command

r.online_status

document

or perhaps we don't need the contents of the said datafile.DYou may run the following query to determine the offline datafiles: #select file#

which means you are logged on to the database as "sys".# oslevel5.2.0.0)(It's actually at 5.2 ML9 + some patches)DI haven't seen any issues so far [] too.Steve Stackwickr Posted: Wed Apr 23 is usually called "archive log destination" resetlogs_timefrom v$datafile_header;Lselect name

if Oracle cannot find the library you can specify log sequence number alter database open resetlogs;VThe incomplete recovery requires the database to be opened using the RESETLOGS option.>>>> Disaster RecoveryqIn a disaster situation where all files are lost you can only recover to the last SCN in the archived redo logs. { Piece Name: C:\ORACLE\FLASH_RECOV

subject to an independent technical review. VOracle also recommends that in response you gather the fixed objects' statistics via: \exec dbms_stats.gather_fixed_objects_stats()on the recovery catalog database(s) in question.Labels: Bugs

document

all files are6consistent and have the same SCN in their fileheaders.uIt does not matter whether the database is in archive mode

which means that it serially lists each backup or proxy copy Xand then identifies the files included in the backup. You can also list backups by file.hBy default70)Q---------- ---------------------------------------------------------------------- ----------------------------1There are two ways to recover from this scenario:K (1) If there is a backup of the Oracle home and Oracle Inventory

1

then by default RMAN restores a datafile or control file to its original location jby copying an image copy backup to that location. Image copies are chosen over backup sets because of the Yextra overhead of reading through an entire backup set in search of files to be restored.Iwhich contains several logfiles

r.error

document

name from v$datafile 4where file# in (select file# from v$datafile_header ( where status='OFFLINE');vYou may issue the following SQL statement to change the status of the required datafile(s) from "OFFLINE" to "ONLINE":dIf we are lucky that the required log sequence# is still available in the online redologs and the corresponding redolog member is still physic

though I would not recommend doingEthis to anyone except the truly desperate. It's by far better to stayDsupported for the server side. You can usually get away with downrevGclients past the officially supported revs [] `The second sheet 2008 9:50 am Post subject: How do I get TDPO to send controlfiles to SBT_TAPE instead o QOn Thuif database is inarchive modeLIf you need to see examples that can be used for real open_mode

you see: Plibobk.so could not be loaded. Check that it is installed properly rman can perform blockrecovery.]RMAN creates backups of your database. But you can use rman with multiple databases

RMANeUpon moving to 10g

document

or not. Just use your favourite command to copy the filesNto a dump disk or tape(s)

RMAN lists in verbose mode. You can also list backups in a summary mode if the verbose mode SWriting to disk restoreN them to the respective directories. Note if you change the Oracle Home

70)$ FILE# STATUS SUBSTR(NAME

like the main log file "alert.log" where4all important events (and oracle errors) are logged.PIt can contain also the directory "pfile" where the parameter file "init.ora" orP"spfile.ora" can be located. Such a parameterfile contains all kinds of settingsOfor the Oracle instance (like how much memory it may use

r.change#

document

then we may apply them instead of the archivelog. To confirm

but server [and support] is%too important to risk for most folks.BThen there's that TSM server revs may have some relation to deviceAsupport of the underlying AIX OSExamples_and_Notes Apr 10 please see section 4.run {{ allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';{ allocate channel t2 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';% backup full database ;5 backup (spfile) (current controlfile) checkpoint_change#

and that LD_TLIBRARY_PATH environment variable (or its equivalent on your platform) includes the Sdirectory where this file can be found. Here is some additional information on the cause of this error:Jld.so.1: sbttest: fatal: libobk.so: open failed: No such file or directoryJTo do this possiblyon different host machines.XAny way

you may experience poor performance when using RMAN with a 10g recovery catalog. qResync operations

document

like for example for our example PLANNING database:$# tar -cf /dev/rmt1.1 /u06/archivesrNow its left to the DBA or sysdamin

is easy for the Server session L the inventory would not be aware of thid new path and you would not beJ able to apply patchsets. Also restore to the same OS user and group. (2) Perform a fresh InstallPRACTICAL SCENARIO==================MIn most cases

1

or how many processescan be concurrent at a time).nRMAN full backup is the issue here. In 10.2.0.2 has been introduced a new feature that avoids having to read <all the blocks of the datafile during full datafile backup. pStarting with 10.2.0.2

document

issue the following query

particularly for newer devices.@In my case shows some examples of rman backup and recovery scripts.ERR 6: RMAN-12004=================Hi 2008 at 3:26 PM 5regardless of the actual configured retention policy.;# Show/Delete items with more than 2 newer copies available0report obsolete redundancy = 2 device type disk;0delete obsolete redundancy = 2 device type disk;3# Show datafiles that connot currently be recoveredreport unrecoverable database;ryou listed with the same results. The problem turned out to be very simpl ARCHIVE_CHANGE# from v$database;Qselect GROUP#

we have to connect to the target database whether you use rman to backup a single database

in particular will run extremely slow

document

to create a good shell script

because the Hosts Operating SystemS"knows" how to write to disks. So there will never be "difficult" parameters in the"allocate channel" command.CIn this case when a disk is lost

70)Y---------- ------- ----------------------------------------------------------------------H 1 SYSTEM /dbms/tdbaprod/prodroca/database/default/system01.dbfI 2 ONLINE /dbms/tdbaprod/prodroca/database/default/undotbs01.dbfH 3 ONLINE /dbms/tdbaprod/prodroca/database/default/sysaux01.dbfG 4 ONLINE /dbms/tdbaprod/prodroca/database/de

if database compatibility is 10.0.2 full backups of locally managed datafiles might use othe space bitmaps so that only blocks that are currently allocated need to be read and included in the backup. The validity of the backups reading the whole datafile or using the space bitmaps is the same (as long as error us not signaled). Performance problems rman:;Known�

document

as shown below

I hadn't changed anything elseBDF DATA RMANBDFATT DATA RMANBOFFR DATA RMANBORL DATA RMANBRCVER DATA RMANBRLH DATA RMANBRR Dan Foster <tronic183 < at > evilphb.org> wrote:My setup:'TSM server (Enterprise) 5.5 on AIX 5.2.0TDPO 5.4.1 on Solaris 10/SPARC and Oracle 10gR2.ADo you really have TSM 5.5 running on AIX 5.2? I wondered if thatCwould work we were running a 32-bit version of Oracle on it. 2Installing the 32-bit client solved the problem. Inform RMAN that the SQL statement ALTER DATABASE OPEN RESETLOGS has been executed and that a new incarnation of the target database has been created. Note that if you run the RMAN command ALTER DATABASE OPEN RESETLOGS (not the SQL stat�THREAD#

AND to the catalog.That can be done as follows:$rman&RMAN> connect system/password@PLANNING7connected to target database: PLANNING (DBID=899275577)5(you see that rman now has retrieved the database id)(RMAN> connect catalog rman/rman@PRODRMAN&connected to recovery catalog databaseRMAN> register database;RMAN0TABLE_NAME TAB or many databases

increasing the overall amount of time your backup jobs take to run to fruition.Optional parameters:A -dbname specifies the database name which will be used by SBT > to identify the backup file. The default is "sbtdb"C -trace specifies the name of a file where the Media Management 3 software will write diagn

document

possibly in a dynamic form that might discoverhEither the name specification (the one you entered) is wrong

the allocate channel command have the simple form of:+allocate channel <channel_name> type disk; So for example:allocate channel d1 type disk; !the help of specialized libaries.ZThe tapedrive or taperobot can probably only be accessed by specific third-party software.(Suppose we have target database prodrossktape library by acting as the Oracle database serve more than one type of file could be lost.'The recovery in this scenario would be:A (1) A combination of each of these data loss recovery scenariosD (2) Perform entire database restore from the last backup and applyJ archive logs to perform recovery. This is a highly preferred method " but could be time consuming.@Note: For any issues or clarifications

status

I have come across of a recently revised Metalink Note : 247611.1 (revised on 27-02.2007) which addressed several known performance problems with RMAN backup and recove< ry./The note has workaround for the following bugs:MBug 5219484 - CATALOG RESYNCS ARE VERY SLOW - ROUT TABLE HAS 6 MILLION ROWS +HBu

document

that is to determine the redolog member(s) that you can apply to recover the database:1set echo on feedback on pagesize 100 numwidth 16 [The purpose of a tablespace is at least twofold: performance gain

so got by with that.nHowever you cannot simply copy it as you would a backup database file icreated with an operating system utility; you must use the RMAN RESTORE command to extract its contents. ZIn contrast and kind of thought it would then RMAN resets the target database automatically so that you do not have to run RESET DATABASE. By resetting the databaseSEQUENCE#

we are ready to backup the target database. But its much better to set rman needsZSo if we add that statement to our backup script

line 5038ORA-06512: at line 1JRMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT rowExamples and notes on rmancThe display also indicates the meaning of each argument. For example

document

or you could be using mismatched versions Xbetween RMAN and the database (don't know since you didn't provide any version details).Note 5:Hi there!IWe are having problems with an Oracle backup. The compiling of the backupHcommand fails with the error message: RMAN-20242: specification does not

the sbttest utility is located in $ORACLE_HOME/bin. Obtaining Online Documentation< NFor online documentation of sbttest call into Oracle SupportLNote 103176.1 - How to Recover Having Lost Controlfiles and Online Redo LogsJNote 184327.1 - Common Causes and Solutions on ORA-1157 Error Found in B&RLNote 198640.1 - How to Recover from a Lost Datafile with Different ScenariosINote 183327.1 - Common Causes and Solutions on ORA-376 Error Found in B&RJNote 183367.1

checkpoint_change# -SQL> SELECT file#

the first question you need to ask yourself is

document

and neat administration.4Suppose you have a large database with large tables.1. Possible performance gain:E DATAFILE '/u01/oradata/planning/planning_data01.dbf' SIZE 1000M2. Neat Administration:dWould it not be great if you

if you need to restore and recover a current datafile the database can use image copies created by the RMAN BACKUP AS COPY command without additional processing.cRMAN automates the procedure for restoring files. You do not need to go into the operating system but Tivoli sez u need AIX5.3. Just wondering.Steve--Stephen StackwickJacob & Sundstrom RMAN considers the new incarnation as the current incarnation of the database.Yor some other specified time. Use the RMAN RECOVER command to perform media recovery and 0apply logs or incremental backups automatically. RMAN Media Recovery: Basic StepshIf possibleMEMBERS

or store we have the transactions in the redologscovered as well.YThe solutions is TO ARCHIVE THE ONLINE LOGS with the right commands in our backup script.jSofar we have the tablespaces covered and the contents of the redologs. What is left are the controlfiles.VAlso here we have an open file issue that cannot be easily handled with an OS command.EBefore we go fur

following is the description for two optional parameters: VSubject: OERR: RMAN-12004 unhandled exception during command execution on channel %s * Doc ID: Note:291388.1 Type: REFERENCE 6 Last Revision Date: 22-NOV-2004 Status: PUBLISHED RMAN-12004 (RMAN-12004)= unhandled exception during command execution on channel %s =This messag

document

match any archivelog in the recovery catalogHBut RMAN is only supposed to backup any archived logs that are there and"then insert them in the catalog...(Did anybody experience anything similar?

issue the following on the command line: % sbttestEThe program displays the list of possible arguments for the program: )Error: backup file name must be specifiedLUsage: sbttest backup_file_name # this is the only required parameter& <-dbname database_name>' <-trace trace_file_name> <-remove_before>" <-no_remove_after> Total System Global Area 171966464 bytes

status

Am i using duplex copies

document

for example

and if you have an image copy of the datafile INote 133870.1: RMAN-20242: Specification does not Match any Archivelog in# the Recovery CatalogCNote 180169.1: RMAN OPS Archivelog Restore Fails with RMAN-20242^The purpose of this article is to resolve RMAN-20242 when trying to backup archived log files.SCOPE & APPLICATIONPRMAN 'archivelog l blocate the backup that you want to use Inc.401 East Pratt St. make the recovery catalog available to perform the media recovery. If it is not availableARCHIVED

Ssome default values in the catalog that has to do on how exactly we want to backup.ZNote: You can also connect to the target database and the catalog database in one command we need to know what exactly a control file is.^Well

RMAN-12004 always means that you should investigate on the accompanying error messages.PSubject: RMAN-12004

document

This is 8.1.7 on HP-UX with Legato NetworkerThanks

connect to the target database and recovery catalog (if you use one)Fixed Size 787988 bytes

checkpoint_change#% FILE# STATUS CHECKPOINT_CHANGE#%---------- ------- ------------------% 1 ONLINE 20344051% 2 ONLINE 20344051% 3 ONLINE 20344051% 4 ONLINE 20344051% 5 ONLINE 20344051% 6 ONLINE 20344051% 7 ONLINE 20344051% 8 ONLINE

if so

document

separate your tables and indexes on separate tablespaces?sAlso

I used the "Test Backup" button on the Backup Setting OEM page. It's a simple test consisting of:=backup as BACKUPSET current controlfile tag '05252007020711';7restore controlfile validate from tag '05252007020711';.And... it fails with this lovely error output:VRMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/22/2007 16:28:09JORA-19506 and manually copy files into the appropriate directories. iWhen you issue a RESTORE command Suite 2214Baltimore mor if you do not maintain a recovery catalogSTATUS

#NAME? the real data (tables and indexes) are in the tablespaces. The controlfile only contains?You can get a list of all current setting by using the command:RMAN> show all; 5.3 Creating backups with rman.TLets start with a basic backup script that really will make a complete (open) backup8connected to target database: PRODROSS (DBID=1443222271)kSpecify the desired ob

RMAN-10035

document

iIf i ask rman to backup archivelogs that are more than 2days old and there are none

and then gexecute the LIST BACKUP command. Specify the desired objects with the listObjList clause. For exampleVariable Size 145488364 bytes

resetlogs_change#

i'll bet you don't have a value for "TDPO_MGMT_CLASS_2" in your tdpo.opt file.&This was a hard lesson learned... :-) Phttp://dba-brent.blogspot.com/2007/06/issues-with-rman-on-aix-using-tdp-for.html! --> SQL> alter database open;7 (b) SQL> alter database backup controlfile to trace;R -- This would have created a readable trace file containing create controlfile

document

maybe there are several "schema's" (useraccount) in your database

name="0aiiceoi_1_2" RMAN directs a server session to restore the correct backups to either:oTo restore a datafile MD 21202-3003(410) 539-1135 * (866) 539-1135sstackwick < at > jasi.coms Posted: Wed Apr 23 then RMAN uses metadata from the target database control file. _If both the control file and recovery catalog are lostFIRST_CHANGE# from v$log;1select GROUP#

rman is ready storing some parameters (like the name and dbid) in the catalog.5.2 Setting defaults.Wwith passing to the rman executable the right credentials &then LIST BACKUP displays all backups.`So

ORA-27072 Errors With Incremental RMAN Backup ( Doc ID: Note:437444.1 Type: PROBLEM 6 Last Revision Date: 24-JUL-2007 Status: MODERATED This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process�

document

thats not an error. [you dont lose days worth of redo that might still be hanging in a redo log if it gets lost.TIf the database runs in archive mode

you can enter:FLIST BACKUP; # lists backup setsDatabase Buffers 25165824 bytes

resetlogs_time

document

and you would create a neat administration{Suppose the Planning database is open. Now

parms="":ANS0231E (RC2025) The management class name was not found.YNice huh?? What the heck is "ANS0231E (RC2025) The management class name was not found."? If you think that's depressing� either mount the database or keep it open and take the datafile to be restored offline. fWhen RMAN performs a restore 2008 10:51 am Post subject: How do I get TDPO to send controlfiles to SBT_TAPE instead o 9Hot Diggety! Steve Stackwick was rumored to have written:There's two kinds of 'work':5- 'probably technically works but you're on your own'vs.7- '20 foot wall of flames will erupt if you attempt it'>IBM's statement in this particular case is more of the former then you can still recover the database?The generic steps for media recovery using RMAN are as follows:k when performing whole database recoverysubstr(member

as in the following example:CFirst we configure several persistant parameters for this instance:>RMAN> configure retention policy to recovery window of 5 days; to create the backup of the Oracle PLANNING database while its running

and therefore has not been subject to an independent technical review. 8Oracle Server - Enterprise Edition - Version: 10.1.0.5.0=Getting this error during the incremental backups with rman: @RMAN-00579: the following error occurred at 06/20/2007 04:12:30 4RMAN-03015: error occurred in stored script inc_wed IRMAN-03007: retryable error occurred during

document

you also want to backup the archived logfiles.aHow "much" of archive you want to backup

image copiesRedo Buffers 524288 bytes RMAN> restore controlfile from 'C:\oracle\flash_recovery_area\orcl1\ORCL1\BACKUPSET\2007_12_12\O1_MF_NCSNF_TAG20071212T150529_3OZDPGX9_.BKP'(channel ORA_DISK_1: sid=160 devtype=DISK)channel ORA_DISK_1: restoring controlfileEoutput filename=C:\ORACLE10G\ORACLE\ORADATA\ORCL1\ORCL1\C�

checkpoint_change#

document

that s actually a requirement if we want to use the "exp" or "expdp" uitilites.rNow you may have seen on

try entering "ANS0231E" into Google. There is less than 30 results worldwide! I hate when that happens... After working with IS and IBM for 3 weeks (3 weeks!!!)� it creates the restored files as datafile image copies and records them oin the repository. The following table describes the behavior of the RESTOREEpresumably partly to reduce costs in regression testing (amongst manyBother valid reasons). And or open the database when performing online tablespace recovery. U-To perform incomplete recovery

1

RMAN> configure default device type to disk;*RMAN> configure controlfile autobackup on;\RMAN> configure channel device type disk format 'C:\Oracle\Admin\W2K2\Backup%d_DB_%u_%s_%p';BNext we perform a complete database backup using a single command:< jThe recovery catalog should be resyncronized on a regular basis so that changes to the database str goes as shown below./But beware that the script is not yet complete!UAnd if the archived redologs are in "/u06/archives"

blockno 6924289 (blocksize=512) ORA-27072: skgfdisp: I/O error *Linux Error: 2: No such file or directory Additional information: 6924289 CRMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE. BACKUPPIECECREATE *The filesystem involved was out of space. 5Add space to the filesystem involved in your backup. OSubject: Resync Catalog ret

document

is really your choice. Suppose some sort of maintenance?BACKUP DEVICE TYPE DISK AS BACKUPSET DATABASE PLUS ARCHIVELOG; JBACKUP DEVICE TYPE sbt BACKUPSET ALL; # copies backup sets on disk to tapecIf you don't understand the upper command

and proxy copies<LIST BACKUPSET; # lists only backup sets and proxy copies+LIST COPY; # lists only disk copiesdAfter connecting to the target database and recovery catalog (if you use one)searching for all files in the recovery areacataloging files...cataloging doneList of Cataloged Files=======================cfor database recoverability. The two major forms of REPORT used< to determine whether your database is recoverable are:RMAN> REPORT NEED BACKUP;V"metadata" of the database

Z 2 to_char(checkpoint_time

document

for example a unix system

we finally worked our way up to a SEV-1 analyst on a conference call and he figures it out.Wait for it...FCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default filesperset 20"format "ar_%d_%s_%p_%t.lv${LEVEL}""(archivelog all delete all input);release channel t1;LCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVI SET NEWNAME of course use the SET UNTIL command to specify the time60) from v$logfile;select * from v$log_history;select * from v$recover_file;select * from v$recovery_log;Mselect HXFIL File_num

you will see parameters that referr toda certain configuration file you add to your backup commands:*SQL> ! tar -rvf /dev/rmt/0hc /u06/archivesRMAN> create catalog;icopies of the broken mirror)

creation_change# from v$datafile;6select file#

document

that's allright

execute LIST BACKUP such as which files belong to the database as well as someZhistorical data. Now you might argue that the SYSTEM tablespace contains the real metadataXof the database. Sure the SYSTEM tablespace contains every metadata

'DD-MON-YYYY HH24:MI:SS') as checkpoint_time

document

that the sysadmin is using Tivoli TSM (or other backup suite)*3. Making a backup using the RMAN utility:iThe rman utility is quite good. In any case much better than the other options that are available to you.while the database is open:# rman.Just call the rman executable from the prompt:The rman prompt appears:RMAN>bOnce correctly "configured"

but the backup -being used is from before the last resetlogs.NThe problem is that when a database is opened with resetlogs and SWITCH commands.$>>>Datafile Media Recovery with RMAN http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/ibm-tsm-13/how-do-i-get-tdpo-to-send-controlfiles-to-sbt-tape-instead-o-88699/@My DBAs and I are completely baffled. How do I get TDPO to send *controlfiles to SBT_TAPE instead of DISK? � if you hit a bug with such aCsetup SCNsubstr(HXFNM

which will contain pointers on how to access the specilized libraries."RMAN configuration parameters are:5CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default you must use a CHANGE ... UNCATALOG command to update the recovery catalog 3and indicate that this copy is no longer available.&>>>Storage of Backups on Disk and TapecRMAN can create backups on disk or a third-party media device such as a tape drive. If you specify gDEVICE TYPE DISK

creation_change# from v$datafile_header;_/* the creation_change# between these views will be the same

document

because we still need to explain rman. #And that will be done in section 4.ekeep a repository of all recent backups

8specifying the desired objects and options. For example:HLIST BACKUP SUMMARY; # lists backup sets such as which files[belongs to the database

count(*) 3 FROM v$datafile_header\ 4 group by status

document

a full database backup could be produced as in the following example

the incarnation Pof the database is also reset and RMAN keeps a record of the incarnation of the !database in the Recovery Catalog.Problem Explanation: MWhen we do a point-in-time recovery and open the database with resetlogs

they're unlikely to fix it or even give the time of the day.3The $65 ^ or log sequence number at which recovery terminates. Alternatively

1

CONFIGURE BACKUP OPTIMIZATION OFF; # default0CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default/CONFIGURE CONTROLFILE AUTOBACKUP OFF; # defaultOCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultLCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # then your backups are created on disk

but different from the catalog */In Catalog database:@select db_key

document

and it will compress backups (saving space on disk or tape).nAs promised before

proxy copies which tables and indexes and other objects are present

resetlogs_change#

document

<Now

we Palso need to tell RMAN that we are reseting the database incarnation. Therefore Jwe use the RESET DATABASE command to direct RMAN to create a new database Iincarnation record in the recovery catalog. This new incarnation record Oindicates the current incarnation. RMAN will associate all subsequent backups Pand log archiving done by the target database

536 question: Why did I put 5.5 on AIX 5.2?HSimple: I was a little too hasty in reading the min requirements specify the UNTIL clause & on the RESTORE and RECOVER commands. RESTORE DATABASE;RECOVER DATABASE;>>> Corrupt Block recoverykAlthough datafile media recovery is the principal form of recovery70) File_name

CONFIGURE MAXSETSIZE TO UNLIMITED; # default=RMAN-03002: failure of restore command at 06/27/2008 23:10:435RMAN-06026: some targets not found - aborting restoreBRMAN-06024: no backup or copy of the control file found to restore!RMAN> list backup of controlfile;_Because we also tried to restore the controlfile in the file name space of the target instance [that is creating the backup. You can make a backup on any device that can store a datafile.gTo create backups on non-disk media

db_name

document

in section 4 we will explain exactly how to make correct backups

and disk copieskYou can also specify the EXPIRED keyword to identify those backups that were not found during a crosscheck:LIST EXPIRED BACKUP SUMMARY;# Show all backup detailsFORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIMEP---------------- ------------------------------ ------------ -------------------PEMP BI which user!has rights on which objects etc.._But before the Instance (Oracle software) can find and open the tablespaces

resetlogs_time

document

in this example

we need to tell RMAN that our current incarnation needs to be reset to the old one. Problem References: =================== 7RMAN-00569: ======= ERROR MESSAGE STACK FOLLOWS =======NRMAN-03009: failure of allocate command on ch00 channel at 05/21/2005 16:39:17HORA-19554: error allocating device

a rareGdeparture for my character. I always you can also use the RMAN BLOCKRECOVER gcommand to perform block media recovery. Block media recovery recovers an individual corrupt datablock gor set of datablocks within a datafile. In cases when a small number of blocks require media recoveryFHTYP Type

at SCN=549794 such as tape

file#

document

and how to restore them.sThe advantages (although its probably not obvious) is that rman will figure out where to store backups

original_name 2 from recyclebin it needs a (small)Gfile which contains "just enough" metadata to get the database mounted.database will keep in sync. 1 /dbms/tdbaprod/prodroca/database/default/system01.dbf 3 0 20344051 SYSTEM 8196 902 2 /dbms/tdbaprod/prodroca/database/default/undotbs01.dbf 3 0 203440� �

checkpoint_change#

document

you could type the following commands:RMAN> run { # backupsTThe above sql gives you an idea about how many IO needs to be performed at recovery.7SELECT RECOVERY_ESTIMATED_IOS FROM V$INSTANCE_RECOVERY;OAlbert van der Sel - Antapex Technologies B.V. - version 0.12 - 30/09/2008|respect to backup and recovery

device type: SBT_TAPE

with that one glaring exception Syou can selectively restore and recover damaged blocks rather than whole datafiles.JFor exampleHXERR Validity

rman tells us that there is nobackup at that specific SCN.7Lets see if we can find an SCN "close" to what we want.List of Backup Sets===================CBS Key Type LV Size Device Type Elapsed Time Completion TimeLIST BACKUP OF DATABASE;REPORT UNRECOVERABLE;REPORT SCHEMA;WIf you shut down an Oracle database "in a clean way" you must use third-party media management software

creation_change# from RC_DATAFILEK 2 Full 546326 28-JUN-08 C:\ORACLE\ORADATA\TEST10G\UNDOTBS01.DBFJ 3 Full 546326 28-JUN-08 C:\ORACLE\ORADATA\TEST10G\SYSAUX01.DBFI 4 Full 546326 28-JUN-08 C:\ORACLE\ORADATA\TEST10G\USERS01.DBFH 5 Full 546326 28-JUN-08 C:\ORACLE\ORADATA\TEST10G\T

document

and it will.3. Database in Archive log or non Archive log.AI'm looking to bring the server up to a newer AIX version soon toGresolve this uncomfortable position. Last

OBJECT_NAME ORIGINAL_NAME.Issues with online redologs and control files:list backup;================RMAN>report schema;4Shows the physical structure of the target database.RMAN> report obsolete;%RMAN-03022: compiling command: report%RMAN-06147: no obsolete backups foundAbout Reports of RMAN BackupsjReports enable you to confirm that yo handle="c-1133799276-20040311-00"

checkpoint_timeM (2) Perform recovery based on the type of datafile affected namely SYSTEM

document

the differences are actually not too big. But please be aware of the fact that 11g has some>6I%Backup Set 25 28-JUN-08PRMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rowsParchive log thread 1 sequence 5 is already on disk as file C:\ORACLE\FLASH_RECOV=RMAN> CHANGE BACKUPSET TAG year_end_2002 KEE

device name: 2ORA-27211: Failed to load Media Management LibraryAdditional information: 25Resolution:5is defined and points to an incorrect library name. GTo manually set the SBT_LIBRARY path

'stick to supported revs for everything.FWhy not backout? A lengthy maint moratorium amongst other things in my4environment made it more practical to just stay put.With that said:'# lslpp -l tivoli.tsm.server.aix5.rte64Fileset Level State DescriptiongIn this way you may discover the following messages in a user trace file:VThis is because your restore is till 2. Try to give a restore till the point-in-time. %Your script should b something like -restore until time 1.25 RMAn will take the backups taken before 1.25 and apply the logs so as to make it recover till 1.25. Hope you do have all the logs since then.CheersVinit Tuesday�OFHSCN SCN

no recovery is needed at startup.Note: cOracle recommendation: Use a minimum of two multiplexed or mirrored control files on separate disks0backup with sufficient frequency should be fine.PIf we want a RMAN recovery catalog in a database Zand allocate channels with device types

Err:501

document

but not the least

is restore the first backup parms="" PORA-27029: skgfrtrv: sbtrestore returned error RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE TThis error message basically means�

- ROLLBACK or UNDO

document

you can find the backupsets which are "after" theGretention policy. Lets say that your retention policy window is 7 days.NIn that case

follow the steps described below:v1. Modify the RMAN ALLOCATE CHANNEL statement in the backup script to reference the HP-UX 11.23 library file directly:REPORT OBSOLETE;quitEOFsgabriel6207-21-2005

you ensure that all your backups exist on both disk and tape. You can also duplex backups #of backup sets February 12 FHTNM TABLESPACE_NAME

we follow the following steps:1. Create a small databaseO3. Create the user "rman" which has as its default tablespace tablespace "rman"C5. Register all the databases you want to backup with this catalog.h2. Create a suitable tablespace such as SBT

5500-5999 Compilation of DUPLICATE command 6000-6999 General compilation 7000-7999 General execution 8000-8999 PL/SQL programs &9000-9999 Low-level keyword analyzer #10000-10999 Server-side execution 711000-11999 Interphase errors between PL/SQL and RMAN '12000-12999 Recovery catalog packages /20000-20999 Miscellaneous RMAN error mes

document

I've alsoEbeen duly thwacked by colleagues with multiple copies of the old ADSMA3.1 printed manuals to serve as a reminder to be more careful and

so Albert's table should become1Lets take a look at the first controlfile backup:=32 Full 6.80M DISK 00:00:03 01-JUL-08O BP Key: 34 Status: AVAILABLE Compressed: NO Tag: TAG20080701T074551| Piece Name: C:\ORACLE\FLASH_RECOVERY_AREA\PRODROSS\BACKUPSET\2008_07_01\O1_MF_NCSNF_TAG20080701T074551_ that the TSM server didn't find the backuppiece #called "c-1133799276-20040311-00" !NSo we verify the existence of this piece at TSM side with the following query:.(See Note 120468.1 for background information)[ tsm: IS4KAPBK01_SERVER1> select * from backups where ll_name = 'c-1133799276-20040311-00'R ANR2963W This SQL query may produce a very la

TEMP

document

all backups that are older than 7 days are reported as obsolete.EDo you really want to delete the above objects (enter YES or NO)? YESHRMAN-03009: failure of delete command on ORA_MAINT_SBT_TAPE_1 channel at"ORA-27191: sbtinfo2 returned errorAdditional information: 2EWhat in the world does "Additional information: 2" mean? I can't find!any more useful detail

01:05 AMHere is a discrepancyVersus the following errorYou have "channel differences"PAlso where is your TDP dsm.opt file

as in this example:.BACKUP COPIES 2 DEVICE TYPE sbt BA< CKUPSET ALL;5(Again 2008How to recover user errors ESQL*Plus: Release 10.1.0.2.0 - Production on Wed Dec 12 15:02:09 20077Copyright (c) 1982FHSTA status

e.g. with the name "rman" and that are supported by that software.>>>Backups of Archived LogsUThere are several features of RMAN backups specific to backups of archived redo logs.'Deletion of Archived Logs After BackupscRMAN can delete one or all copies of archived logs from disk after backing them up to backup sets. rIf you specify the DELETE INPUT option

>>>> LIST COMMAND:>>>> REPORT COMMANDS:About RMAN Backups:=- Database (all datafiles)=- Tablespaces=- Control files=- Archived redo logs=- Server parameter filesQ=- the default location

document

diligent in my reading. Sure deserved that.pDisplay posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First O Backup Central Forums Forum Index -> IBM TSM All times are GMT - 8 HoursPage 1 of 1Article 2-Issues with RMAN on AIX using TDP for Oracle ~So our group has thankfully decided to go with RMA

you could place the following at the end of your backupscript. We assume herep2> allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';p3> allocate channel t2 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';^Note that we still have omitted many interresting things like how to or may require a R significant amount of time to compute. R Do you wish to proceed? (Yes (Y)/No (N)) Y R NODE_NAME: DBLIMS_ORA O FILESPACE_NAME: /dblims_lisa R FILESPACE_ID: 1 R STATE: ACT

DATA or INDEX.L (3) The recover commands could be 'recover database'

document

and in G/usr/sys/include/errno.h

it should be in Oracle's working directory.Stevenrhysm08-02-2005

control file autobackups are never duplexed.)nYou can also use BACKUP BACKUPSET to manage backup space allocation. For example2004

FHRBA_SEQ Sequence from X$KCVFH;1select hxfil FileNo

let's say then RMAN backs up exactly one copy of each specified log sequence number Starting backup at 30-JUN-08? RMAN-03002: failure of backup command at 06/30/2008 23:30:45 RMAN> Recovery Manager complete. End archiving : 23:30:51lBefore we go into the real specifics of backup and restore

overwriting the files with the same name currently thereE=- A new location

document

and you know i'm first in line to take this task on. Here's my setup at a high level:-10gR2 database (rmandb - snappy name huh? :) L----------------------------------------------------------------------------Path: /usr/lib/objrepostivoli.tsm.server.aix5.rte64otarget database from a backup that matches the incarnation and mount it. You will need to do "startup nomount" 4befo

[like how much memory it may claim from the system that the backup piece is "owned" by node "DBLIMS_ORA"

'recover tablespace'D or 'recover datafile' based on the loss and the database state2** If restoring to a different mount point

document

you'll see that error# 2 is "no such file or Gdirectory. Accompanied with ORA-27191

03:53 AM'I have problem that looks very similar.3AIX 5.3L 64 bit

to keep more recent backups Ton disk and older backups only on tape Oracle. All rights reserved.FHSTA status from x$kcvfhall;spool off:The output would show a mismatch of the incarnation value.wThis leaves us with no option except re-creating controlfile. Any other solution will not be a valid fix for the issue.T1. Please mount the instance to get a script sceleton for recreating the controlfilesql> startup mount ..1sql> alter database backup controlfile to trace ; this will create a tracefile in your 'udump' directory Please modify it to build a create controlfile script and recreate the controlfilesee also�

with a initial size of 100MB.Y4. Create the catalog on tablespace rman as user rman (use the "CREATE CATALOG" command). we need to know what the differences are between;Test / development databases might be in non archive mode. planning_data01.dbfplanning_index01.dbf

which you can specify with the SET NEWNAME COMMANDfIn our sample database

document

like for example *CONFIGURE RETENTION POLICY TO REDUNDANCY 3fThis means that 3 backups needs to be maintained by rman

or how many processes may be concurrent.)Or on your Unix belongs Kto Filespace "dblims_lisa" (the "/" is automatically put in by TSM) and is 5basically still restoreable. (Status: ACTIVE_VERSION)Explanation:------------KAll backups taken with RMAN are stored on the TSM Server together with the *node name (TDPO_NODE) of the backup host. XThis information is stored in the TDPO client configuration file called "TDPO_OP

then :B (1) Restore the files to the new location from a previous backup (2) SQL> STARTUP MOUNTO (3) SQL> alter database rename file '/old path_name' to 'new path_name'; 8 -- Do this renaming for all datafiles affected. --M (4) Perform recovery based on the type of datafile affected namely SYSTEM

document

I'd guess that your problem is 3data can be stored

Oracle 9i 9.20

you can regularly run the following command:KBACKUP DEVICE TYPE sbt BACKUPSET COMPLETED BEFORE 'SYSDATE-7' DELETE INPUT;mThis command backs up backup sets that were created more than a week ago from disk to tape

FHSTA status from x$kcvfhall;spool off:The output would show a mismatch of the incarnation value.wThis leaves us with no option except re-creating controlfile. Any other solution will not be a valid fix for the issue.T1. Please mount the instance to get a script sceleton for recreating the controlfilesql> startup mount ..1sql> alter database backup controlfile to trace ; this will create a tracefile in your 'udump' directory Please modify it to build a create controlfile script and recreate the controlfilesee also�

the by the dba created files "planning_data01.dbf" and "planning_index01.dbf"

document

and other backups are considered "obsolete".RBut those other backups beyond retention

it might look like this:)SQL> ! tar -cvf /dev/rmt0.1 /u01/oradata)SQL> ! tar -rvf /dev/rmt0.1 /u02/oradata# tar -cvf /A589 /u01/oradata)SQL> ! tar -rvf /dev/rmt0.1 /u03/oradata*SQL> ! tar -rvf /dev/rmt0.1 /u06/archives`Indeed Dwhich is referenced by RMAN at allocating a tape (SBT_TAPE) channel:(allocate channel tivoli type 'SBT_TAPE' O parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; 4OR in the persistent channel configuration template:

L (5) The recover commands could be 'recover database'

document

in comparison to a controlfile.ZNow above we said that either the target's controlfile can be used

TSM 5.3 with tdpo /u01/app/oracle/920/lib/libobk.a is linked to /usr/lib/libobk64.a�

and then deletes `them from disk. Note that DELETE INPUT here is equivalent to DELETE ALL INPUT; RMAN deletes all aexisting copies of the backup set. If you duplexed a backup to four locations

4tNow what are the redo*.dbf files for? In our sample

document

are not expired or otherwise not usable.:If they are still present

the Instance only needs one controlfile. All the others are just safety copies which theKThe recovery catalog contains information about RMAN operations CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' z PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; YPlease note

'recover tablespace'OThe detailed steps of recovery based on the datafile lost and the Oracle error (are outlined in the following articles :

document

or a separate database^can be used as the rman catalog. Well

which is in turn linked to the libobk64.a in the TDPO installation.Ctsm/client/oracle/bin64/dsm.opt contains servername as per dsm.sys.Vtsm/client/oracle/bin64/tdpo.opt contains dsm.opt location

then RMAN deletes 5Subject: Top 10 Backup and Recovery best practices. $ Doc ID: Note:388422.1 Type: FAQ 6 Last Revision Date: 05-DEC-2007 Status: PUBLISHED Purpose/ Top 10 Backup and Recovery best practices. Questions and Answers1Oracle Server - Enterprise Edition - Version: 9.2*Top 10 Backup and Recovery best practices.GThis docume

we have three of those files

document

you can use them in a recovery._Besides this

including:<Datafile and archived redo log backup sets and backup piecesDatafile copies#Archived redo logs and their copies0Tablespaces and datafiles on the target database&Persistent RMAN configuration settings_If you want you can also store scripts that TDPO_OPTFILE is case sensitive and must be provided in UPPERCASE only. .Our client configuration file on host "dbqis":J2. A separate small database

document

even if a catalog database is present

log location and nodename.wtsm/client/api/bin64/dsm.sys is linked to tsm/client/baclient/bin/dsm.sys

very early the presence of corrupt blocks in the database.MThis has a slight performance overhead

but there could be more of them. That's the choice of the dba.)/u01/oradata/planning/planning_data01.dbfd-Place the Database in its normal state. For Example

document

it cannot be known beforehand how the< tape subsystem will deal with rman commands^like "delete obsolete". The tape subsystem has probably its own retention period

which are named user-created sequences of RMAN commandswhich is a small Oracle databaseperiodic synchronizationeNormally especially created to store rman's metadata.N to the rather "crude" OS commands

document

the controlfiles4to avoid using the controlfile as metadata for rman.Hthat your tape library doesn't currently have the tape(s) loaded and/or can't find them.Mladen Gogala:!creation time or RESETLOGS time. Action:BCheck the UNTIL TIME or RECOVERY WINDOW. If the database needs to =be restored to an old incarnation

which contains a server stanza for the TDPO.+Password is set and the node is registered.I have done a relink all.@Receiving this when attempting a very simple RMAN backup script:

but will allow Oracle to detect earlyMcorruption caused by underlying disk

open it or bring recovered Tablespaces online.lavailable on disk

document

and you needMmuch more details about all systems involved

the dba makes a choice on how many controlfiles he or she wants. In a default installation which has a file as its granular metric.F4. If you want

document

use the RESET DATABASE TO INCARNATION command. $Oracle 8.1 or Earlier Error Message

2> allocate channel t1 type 'sbt_tape' parms83> backup filesperset 5 format 'dt_%t_%s_%p' (database);XRMAN-00571: RMAN-03009: failure of allocate command on t1 channel at 08/02/2005 19:12:58

storage system

then you do not actually need to have RMAN copy the image copy back to its old location. qYou can instead have the database use the image copy in place

document

before you know whats going on. Err 1: Missing archived redolog: ================================SProblem: If an archived redo is missing

\the number of controlfiles is usually three. If you want to backup the controlfile with rman you can create full and incremental backups.QSo

document

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

or I/O system problems.:SQL> alter system set db_block_checking = true scope=both;B2. Turn on block tracking when using RMAN backups (if running 10g)^REASON: This will allow RMAN to backup only those blocks that have changed since the last fullVbackup

as a replacement for the datafile to be restored. eThe SWITCH command updates the RMAN repository indicate that the image copy should now be treated as ithe current datafile. Issuing the SWITCH command in this case is equivalent to issuing the SQL statement FALTER DATABASE RENAME FILE. You can then perform recovery on the copy.>>>User-Manage

document

you might get a message similar like this:? RMAN-03002: failure of backup command at 03/05/2008 07:44:35g ORA-19625: error identifying file /dbms/tdbaeduc/educroca/recovery/archive/arch_1_817_617116679.archSolution:If archived redo logs are (wrongly) deleted/moved/compressed from disk without being backed up�

you onlyneed one copy.KWe can use the following SQL command to create a backup of the controlfile: from v$log v the larger your database is

document

which will reduce the time taken to back up

such as native operating system file copy commands qor third-party utilities that leave image copies of files on disk. These copies are known as user-managed copies or operating system copies.xThe RMAN CATALOG command causes RMAN to inspect an existing image copy and enter its metadata into the RMAN repository. bOnce cataloged

document

the rman catalog will not know this has happened�

v$logfile f $At this stage 2 things can happend: 1) Media Recovery Completed/2) or additional redo log files must be appliedFIf 2) then just specify the next redo log file on the command line andHcontinue to do so until Media Recovery Completed is displayed. This mustJbe done with all the redo log files also the CURRENT redo log. To find the8CURRENT redo log file the more advantages you will have in using rman.OAdministrative Logfiles and the socalled "parameter file" are usually stored inVThis directory usually contains several subdirs like "dump"

document

as less blocks will be backed up.bSQL> alter database enable block change tracking using file /u01/oradata/ora1/change_tracking.f ;I3. Duplex log groups and members and have more than one archive log dest._REASON: If an archivelog is corrupted or lost

these files can be used like any other backup with the RESTORE or SWITCH commands.qSome sites store their datafiles on mirrored disk volumes

document

and will keep attempting to backup the missing archived redo logs. That will cause rman archived redo log backups R Platform: 64bit TDP Oracle AIX R TSM SERVER INFORMATION R Server Name: IS4KAPBK01_ORACLE R Server Address: 172.29.254.12

to_char(v.first_change#) udump

document

by having multiple copies in multiple locations

which permit the creation of image copies by breaking ma mirror. After you have broken the mirror

document

Release 1

v.sequence# >numbercdump

document

9the other logs will still be available and could be used.XIf an online log is deleted or becomes corrupt

you can notify RMAN of the existence of a new user-managed copy

document

Level 6.11 R (C) Copyright IBM Corporation 1990

howeveraudit"rSo when we talk about a "backup the database

document

you will have another member that can beused to recover if required.VSQL> alter system set log_archive_dest_2='location=/new/location/archive2' scope=both;MSQL> alter database add logfile member '/new/location/redo21.log' to group 1;A4. When backing up the database use the 'check logical' parameteraREASON: This will cause RMAN to check for logical corruption w

nthus making it a candidate for a backup operation. You must notify RMAN when the copy is no longer available

document

2003 All Rights Reserved. R Session established with server IS4KAPBK01_SERVER1: Windows R Server Version 5

the Change command give the following errors: we talk about creating a copy of the files in section II

document

requirements for backup recovery strategy. If not using a catalog

oby using the CHANGE ... UNCATALOG command. In this example

document

Release 2

RMAN> allocate channel for delete type disk;%RMAN-08030: allocated channel: delete/RMAN-08500: channel delete: sid=15 devtype=DISK%RMAN> change archivelog all validate;%RMAN-03022: compiling command: changeGRMAN-00569: ================error message stack follows================ RMAN-03013: command type: change6RMAN-06038: recovery catalog package dete that is

document

_ensure that your controlfile record keep time instance parameter matches your retention policy.BSQL> alter system set control_file_record_keep_time=21 scope=both;)This will keep 21 days of backup records. Run regular catalog maintenance.SREASON: Delete obsolete will remove backups that are outside your retention policy.XIf obsolete backups are not deleted

before resilvering the mirror (not including other iNow

document

Level 2.2 M Server date/time: 2004-03-12 12:34:20 Last access: 2004-03-12 12:24:52 R ANR0406I Session 2303 started for node DBLIMS_ORA (TDP Oracle AIX) (Tcp/Ip dbqis.domain.at(-32369)). LIf you still get node "DBQIS_ORA"

Jand then resync the catalog database. That action will update the catalog Cdatabase AL table with a first entry for the current incarnation.Ierror can be misleading. In that particular case should be understood asnull listing returned frOther articles.wof "cold" files at this time. This is very importantcHowever trivial that former statement may be

document

the catalog will continue to grow until performancebecomes an issue.[REASON: crosschecking will check that the catalog/controlfile matches the physical backups.XIf a backup is missing

if the database was indeed down

document

then the new client configuration is not Kused. This can be the case

otherwise we COULD NOT use the commands as shown in the examples.;As an example we could give the following command sequence:qThose types of tools may ALSO have been configured with the add-on product TDPO its important to know what exactly you need to backup-if you want to backup the true database data.expdb (Oracle supplied utility)can be backupped as well.dof those professional backup software suites

document

it will set the piece to 'EXPIRED' so when a restore is started

this was a valid backup. If the database was open

document

if you don't provide TDPO_OPTFILE in uppercase during channel allocation. ONote 120468.1 How to Query Tivoli (ADSM) to Get Name and Status of RMAN BackupsBNote 183025.1 ORA-19507 When Restoring Using RMAN and Tivoli (TSM)the recovery catalog.

so that (open) Oracle databases (Example locations of the database files 2III Admin/Log directories ("Fairly" static stuff)A# cp /u01/oradata/planning/planning_data01.dbf /backup/planningA# cp /u02/oradata/planning/planning_indx01.dbf /backup/planning7# cp /u03/oradata/planning/users.dbf /backup/planningmWhen you execute the BACKUP command in RMAN that are configured for making Oracle backups as well

document

>Type Key Completion Time Filename/HandleC-------------------- ------ ------------------ --------------------%Backup Set 24 28-JUN-08} Backup Piece 26 28-JUN-08 C:\ORACLE\FLASH_RECOVERY_AREA\TEST10G\BACKUPSET\2008_06_28\O1_MF_NNNDF_TAG20080628T012918_46C1GZMK_.BKPESQL> ALTER DATABASE BACKUP

and thus in use

document

5.5 List and Report commands of RMAN BackupsSection 2: Other notes on RMAN+Section 3: RMAN errors and troubleshooting:Possible quick solution:ZCheck permissions on libraries like listed in the PARMS of the allocate channel statement.Other Troubleshooting:bOracle RMAN backups will fail with a message "ORA-27211: Failed to load Media Management

you create one or < more backup sets or image copies. By default[So it might look to you as if the above table is not complete ! That's not true. Almost all^uses the Oracle's RMAN utility "under water"

document

now we have arrived to a usable backupscript using OS commands to create a backup3of our PLANNING database which is open and running: 7 /dbms/tdbaprod/prodroca/database/rocade/roc_rmwork_data01.dbf 3 0 20344051 ROC_RMWORK_DATA 4 902 8 /dbms/tdbaprod/prodroca/database/rocade/roc_rmwork_indx01� �

^this backup was not valid

document

now most companies will force a log switch after a

ZRMAN creates backup sets regardless of whether the destination is disk or a media manager.>>>About Image Copies^An image copy is an exact copy of a single datafile so it's not immediately obvious that really rmanis creating the Oracle backups.for filesystem backups.This is where the softwareoNow we give some examples in creating a backup of a database. Do NOT take these as "live" or "usable" examples

document

status

because the shared databases files are accessed by potentially manyKprocesses

document

set amount of time during the day so in DR

archived redo log fileoSo

document

substr(name

possibly modifying blocks while the database backup was running.Notes:h2. The commands above could have been in much smarter format like "cp with using ranges with brackets []42. Logical backup using "exp" and "expdp" utilities:mWe will create a logical backup

document

gA couple of archive log files were deleted from the OS. They still show up in the list of archive logs in Enterprise Manager. Note 6:Note 7:5So

or control file. lImage copies are not stored in an RMAN-specific format. They are identical to the results of copying a file fwith operating system commands. RMAN can use image copies during RMAN restore and recover operations creating backups could be similar as in the following examples: (do not takes these for as "being usable"):&to fail altogether with an error like:\RMAN-06059: expected archived log not found

document

1

that is

document

the crux is: check case of identifiers in scriptsNote 8:LSubject: Bug 6768289 - RMAN-6004 / RMAN-20242 if archivelog does not exist ' Doc ID: Note:6768289.8 Type: PATCH 6 Last Revision Date: 02-JUL-2008 Status: PUBLISHED 1 Click here for details of sections in this note.@Bug 6768289 RMAN-6004 / RMAN-20242 if archivelog does not exist2 This note g

+Subject: Recover database after disk loss 0 Doc ID: Note:230829.1 Type: TROUBLESHOOTING 6 Last Revision Date: 20-MAY-2007 Status: PUBLISHED ;This article aims at walking you through some of the common(recovery techniques after a disk failureAAll Oracle support Analysts lost of archived log compromises recoverability If you can�

document

70)

all objects (tables

document

RMAN-6027: on CHANGE ARCHIVELOG... Commands after Open Resetlogs ' Doc ID: Note:94206.1 Type: PROBLEM 6 Last Revision Date: 21-OCT-2005 Status: PUBLISHED Problem Description:IRMAN-20242 or RMAN-6027 on CHANGE ARCHIVELOG ... commands immediately -after opening target database with resetlogs.IObviously

DBAs and Consultants who have a role(to play in recovering an Oracle databaseLoss due to Disk Failure------------------------%What can we lose due to disk failure:A) Control filesB) Redo log filesC) Archivelog filesD) DatafilesE) Parameter file or SPFILEF) Oracle software installationDetecting disk failure-----------------------'1) Run copy utilities like "dd" on unixE2) If usi you should bring back the missing archved redo logs to their original location and name

document

checkpoint_change#MSELECT first_change#

indexes

document

you already reset the catalog database into a new incarnation B224 225 R815 579966833 NO 92402 05-MAY-99P6. After resetting the database

parity information may mask 8the disk failure and more vigorous check would be needed23) As always and let rman back them up. RBut if that is impossible

document

next_change#

procedures and all other fancy stuff)nwill be put nicely in one (or more) files. This file can be used if we want to restore the whole database

document

issue restore and recover commands to restore V and recover the database files from the prior incarnation

check the Operating system log files@4) Another obvious case would be when the disk could not be seenor mounted by the OS.F5) On the Oracle side the workaround is to crosscheck archivelog all

document

sequence#

or +only some objects (like some tables or so).Here are some examples:This is a full database backup:jThis basic intro is for people who know at least some basics of Oracle Databases

document

then open the database T with the RESETLOGS option. You need start from restoring a previous incarnation V control file when the database is in nomount state. When the database is reset to V the previous incarnation

run dbverify if the file affected is a datafile>6) The best way to detect disk failure is by running Hardware 0diagnostic tools and OS specific disk utilities.Next ActionIOnce the type of failure is identified like:rman <<e1connect target /)connect catalog username/password@catalogallocate channel c1 type disk ;crosscheck archivelog all ;release channel c1 ;e1)Or just go into rman and run the command: RMAN> crosscheck archivelog all;You ll get output like this:mvalidation succeeded for archived log archive log filename=D:REDOARCHARCH_1038.DBF recid=1017 st

document

archived

but who need an overview1<vis regarded as the most important backup

document

the catalog will automatically picks up a right control W file. After restoring the control file

the next step is to rectify them.Options could be:B(1) Replace the corrupted disk with a new one and mount them with "the same name (say /oracle or D:\)B(2) Replace the corrupted disk with a new one and mount them with 6a different name (say /oracle1 as the new mount point)E(3) Decide to use another existing disk mounted with a different name(say /oracle2)(The run an archivelog backup to make sure.+Err 2: online redo logs listed as archives:+===========================================JTestcase: a 10g 10.2.0.3 shows after recovery with resetlogs the following=in v$archived_log. It looks as if it will stay there forever:SEQ#FIRST NEXT NAME DIFF STATUS 12 D 42877 D 47857 D

document

substr(name

that is

document

the database must be mounted for datafiles

the next step is to perform recoveryMat the Oracle level. This would depend on the type of files that is lost (seeLLoss due to Disk Failure section) and also on the type of disk recovery done0as mentioned in the "Next Action" section above.(A) Control Files------------------JNormally run an archivelog backup to make sure.+Err 2: online redo logs listed as archives:+===========================================JTestcase: a 10g 10.2.0.3 shows after recovery with resetlogs the following=in v$archived_log. It looks as if it will stay there forever:SEQ#FIRST NEXT NAME DIFF STATUS 12 D 42877 D 47857 D

document

1

it s the backup you probably will use in case of disaster recovery.lbecause we still NEED to excplain the difference between a database in archive mode and in non-archive mode.Note:hThe "system/manager@planning" part in upper commands should be read as "account/password@connectstring" %2> backup database plus archivelog;3>

document

we have multiplexing of controlfiles and they are expected to beplaced in different disks.FIf one or more controlfile is/are lost

document

40) FROM V$ARCHIVED_LOG;>SELECT LF.member

elapsed time: 00:00:03Finished restore at 30-JUN-080Starting implicit crosscheck backup at 30-JUN-080Finished implicit crosscheck backup at 30-JUN-08.Starting implicit crosscheck copy at 30-JUN-08.Finished implicit crosscheck copy at 30-JUN-08Starting recover at 30-JUN-08archive log thread=1 sequence=8Wchannel t1: reading f

document

mount will fail as shown below:Oracle Instance started....JORA-00205: error in identifying controlfile

document

L.group#

elapsed time: 00:00:02Varchive log filename=C:\ORACLE\ORADATA\LOG\ARC00008_0658542361.001 thread=1 sequence=8/media recovery complete

document

check alert log for more info

document

L.thread#

elapsed time: 00:00:01Finished recover at 30-JUN-08TAs said before

document

You can verify the controlfile copies using:Q **If atleast one copy of the controlfile is not affected by the disk failure

document

L.sequence#

the best way to backup your database is with using the rman utility.mBut

document

) When the database is shutdown cleanly:B (a) Copy a good copy of the controlfile to the missing location (b) Start the database H Alternatively

document

L.status

we can demonstrate some features and theory

document

remove the lost control file location specified in the7 init parameter control_files and start the database.M **If all copies of the controlfile are lost due to the disk failure

document

FROM v$log L

by first discussing how to make a backup using OS commands.VAnd

document

then:N Check for a backup controlfile. Backup controlfile is normally taken using $ either of the following commands:G (a) SQL> alter database backup controlfile to '/backup/control.ctl';L -- This would have created a binary backup of the current controlfile --O -->If the backup was done in binary format as mentioned above

document

v$logfile LF

not everybody is using rman

document

restore the I file to the lost controlfile locations using OS copying utilities. --> SQL> startup mount;7 --> SQL> recover database using backup controlfile;COracle Server - Enterprise Edition - Version: 8.1.7.4.0 to 10.2.0.4.There are 3 options available

document

= (select min(checkpoint_change#) min_checkpoint_change# from v$datafile_header ! where status='ONLINE') DF WHERE LF.group# = L.group# 5AND L.first_change# >= DF.min_checkpoint_change#; BSQL> SELECT LF.member

and "legacy" scripts are still in use by some dba's.$This will be discussed in Section 5.'5. Backup an Oracle Database using RMANVOfcourse

document

as shown below: Option#3: Manually extract the data using the Oracle's Data Unloader (DUL)�

document

L.group#

the only difference between both listings is

document

which is performed by Oracle Field Support on-site for an extra charge.6Subject: RECOVER A DATAFILE WITH MISSING ARCHIVELOGS ( Doc ID: Note:418476.1 Type: PROBLEM 5 Last Revision Date: 23-NOV-2007 Status: REVIEWED kDatabase cannot be opened

document

L.thread#

how to address the tapedevice.DNotice how we completely manage the backup from the sqlplus utility.ZJust for demonstration purposes

document

because a datafile checkpoint is lagging behind from the rest of the datafiles. sA datafile was restored from a previous backup

document

L.sequence#

here is a script that backups the database to a dumpdisk:5SQL> ! cp /u01/oradata/planning/* /backups/planning5SQL> ! cp /u02/oradata/planning/* /backups/planning5SQL> ! cp /u03/oradata/planning/* /backups/planningKSQL> ALTER DATABASE BACKUP CONTROLFILE TO '/backups/planning/cf.bak' REUSE;

document

but archivelogs required to recover the said datafile are missing. Option#1: Restore the database from the same backupset�

document

L.status

SQL> ! cp /u06/archives/* /backups/planningANote: example on how to maintain the number of archived redologs._This coveres on what we wanted to say on the subject of how to make a open backup of a running "Oracle database using OS commands.JIf you do not use rman

document

and then recover it by applying up to the last available archivelog to roll it forward

document

D 2 L.first_change#

you need to have a method to deal with the growingNnumber of archived redologs. Ofcourse

document

Qbut any updates to the database after the point-in-time of recovery will be lost. Option#2: Force open the database by setting the _ALLOW_RESETLOGS_CORRUPTION=TRUE in the init.ora. But there is no 100% guarantee uthat we can open the database. However�

document

L.first_time

you want to keep enough of them on diskA(in case you need them)

document

once the database is opened

document

DF.min_checkpoint_change#" 3 FROM v$log L

but diskspace might be an issue as well.NSuppose your database archives redologs to the directory '/u06/archives/today'5mv /u06/archives/1dayago/*.arc /u06/archives/2dayago"rm -rf /u06/archives/2dayago/*.arcreport need backup;+# Show/Delete items not needed for recoveryreport obsolete;delete obsolete;@ 1 /dbms/tdbaprod/prodroca/recovery/redo

document

then you must immediately rebuild the database. Database rebuild means doing the following�

document

v$logfile LF

substr(HXFNM

document

namely: (1) perform a full-database export

document

A 4 (select min(checkpoint_change#) min_checkpoint_change#" 5 from v$datafile_header% 6 where status='ONLINE') DF 7 WHERE LF.group# = L.group#9 8 AND L.first_change# >= DF.min_checkpoint_change#;MEMBERI GROUP# THREAD# SEQUENCE# STATUS FIRST_CHANGE# FIRST_TIMI---------- ---------- ---------- ---------------- -----

1

document

(2) create a new and separate database

document

DAdditional information 2 means that OS returned status 2. That is a 4file not found error. In plain Spanglish

70) File_name

document

/and finally (3) import the recent export dump. FSolutionTo implement the solution

document

you cannot2delete files from tape

FHTYP Type

document

please execute the following steps:dIf this is the ONLY database registered in the catalog

document

only from the disk drives.Niall Litchfield:'The source error is the ora-27191 errorZ(http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10744/e24280.htm#ORA-27191)|If the above query returns no rows

HXERR Validity

document

can drop the catalog schema and recreate it::1. Connect to sqlplus of the catalog database and execute:- Drop user RMAN cascade;TEMRORARY TABLESPACE temp2DEFAULT TABLESPACE tools QUOTA UNLIMITED ON tools;'- GRANT RECOVERY_CATALOG_OWNER TO rman;"- GRANT CONNECT

document

because the V$DATABASE.CONTROLFILE_TYPE has a value of "BACKUP"

H FHSCN SCN

document

RESOURCE TO rman;*2. Connect to RMAN and create the catalog:$rman TARGET / CATALOG rman/cat@catdbRMAN> Create catalog;3. register the target:RMAN> Register database;[If the catalog has multiple registered databases

document

then try to apply each zof the redolog membes one at a time during the recovery. You may run the following query to determine the redolog members:L [os_res_size pl_res_size block_size block_count]>Bwhich suggests a tape library issue to me. You can search for RMAN*errors using the error search page as wellQhttp://otn.oracle.com/pls/db10g/

FHTNM TABLESPACE_NAME

document

unregister this target and reregister it:91. execute dbms_rcvcat.unregisterdatabase (db_key

document

for example---> RMAN-03009RRMAN-03009: failure of delete command on ORA_MAINT_SBT_TAPE_1 channel at date/time6{ This note contains error information about an "RMAN": error number. It may contain additional support notes as described in Note 22080.1 }Oracle9i Release 1 Message~~~~~~~~~~~~~~~~~~~~~~~~~~~Error:Text:9 UNTIL TIME or RECOVERY WIN

FHSTA status

document

db_id)2. register database;Error RMAN-20052Error on:CHow to restore rman backups made with sbt and TDPO to another host.GSubject: How to achieve alternate client restore with RMAN and Tivoli I 4 Full 551460 30-JUN-08 C:\ORACLE\ORADATA\TEST10G\USERS01.DBFH 5 Full 551460 30-JUN-08 C:\ORACLE\ORADATA\TEST10G\TEST01.DBFTT

document

v$log< rl'where al.sequence# = rl.sequence# (+)'and al.thread# = rl.thread# (+)!and ( rl.status = 'INACTIVE' or rl.status is nulland al.deleted = 'NO'XThe above command should show all archived redologs which are ready to be backupped with$rman if rman also deletes the input.ZSubject: RMAN-20242 specification does not match

FHRBA_SEQ Sequence 2 3 FILE_NUM FILE_NAME TYPE VALIDITY SCN TABLESPACE_NAME STATUS SEQUENCE ---------- ---------------------------------------------------------------------- ---------- ---------- ---------------- ------------------------------ ---------- ----------Example:RMAN> LIST BACKUP OF DATA� �

document

according to rman

document

recovery catalog and the. target database differ in their version. J Use the highest version of the RMAN executable to create the catalog or upgrade the catalog with : RMAN> upgrade catalog;RELATED DOCUMENTS-----------------dWhen you execute "'alter system archive log current" you force that the current log to be archived

but you can also specify that RMAN display the output in summarized form. tUse sbttest to perform a quick test of the media manager. The following table explains how to interpret the output: If sbttest returns... Then... p The program ran without error. In other words

document

obsolete

document

Aso it is safe: you are sure to have all the needed archived logs.alter system archive log all:DThis command will archive all filled redo logs but will not complete(current log because it will not be full.dList commands query the catalog or control file

the media manager is installed and can accept a data stream and ' return the same data when requested. 9RMAN-03002: failure of set command at 12/12/2007 15:31:22RMAN> shutdown immediatedatabase dismountedOracle instance shut downRMAN> startup nomount

document

but we want to investigate whether;we can use this backup in a simple restore/recovery action.

document

to determine which backups or copies are available.

document

List commands provide for basic information.1Report commands can provide for much more detail.0About RMAN Reports Generated by the LIST CommandkYou can control how the output is displayed by using the BY BACKUP and BY FILE options of the LIST command 5and choosing between the SUMMARY and VERBOSE options.5This time

document

we have set the following default in rman:>RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;Lets first list our backups:=24 Full 498.62M DISK 00:01:24 28-JUN-08O BP Key: 26 Status: AVAILABLE Compressed: NO Tag: TAG20080628T012918{ Piece Name: C:\ORACLE\FLASH_RECOVERY_AREA\TES

document

I get the message:PRMAN-20242: specification does not match any archive log in the recovery catalog@I also tried to uncatalog those files

document

but got the same message.Any suggestions on what to do?Thanks! hi

document

from rman run the commandlist expired archivelog;Oif ther archives are in this list they will show

document

then i think you should do a crosscheck archivelog all;'then you should be able to delete them.regardsNote 4: The RMAN error number would be helpful�

document

but this is a common problem - RMAN-20242 - and is addressed in detail in MetaLink notes. #We dont know what is going on here.*Err 3: Highlevel overview RMAN Error Codes@Start RMAN and connect to the target database. For example

document

run:CONNECT TARGET /EStart the target instance without mounting the database. For example:SET DBID 676549873;MRestore the autobackup control file

document

then perform recovery. Do the following: Optionally�

document

specify the most recent backup time stamp that RMAN can use when searching for a control file autobackup to restore. If you do not care about using configured channels from your control file�

document

then you can simply mount the database at this point. If the online logs are usable�

document

then perform a complete restore and recovery as described in Oracle Database Backup and Recovery Basics.RUN I # Optionally

document

set upper limit for eligible time stamps of control file } Backup Piece 67 28-JUN-08 C:\ORACLE\FLASH_RECOVERY_AREA\TEST10G\BACKUPSET\2008_06_28\O1_MF_ANNNN_TAG20080628T013104_46C1L9TC_.BKP%Backup Set 89 28-JUN-08} Backup Piece 94 28-JUN-08 C:\ORACLE\FLASH_RECOVERY_AREA\TEST10G\BAC

document

I

backup recovery oracle

Documents