DB13 whole DB online + redo log backup

Advertisement
Hi expetrs,
I am using hp-ux with oracle with ECC6.0 and data protector.
I ran DB13 whole DB online + redo log backup on tape and it ran successful on specified tape.
But if i check data on tape via login on data protector it shows no data.
Also i checked at os level using command mt -f  /dev/rmt/0mn status , it also show 0 data. But as per db13 log data written successfully on specified tape.
please help how to check online data files?
Note: presently i have taken backup on single tape.
regards
Tarun
Advertisement

Replay

Tablespace     TS-Status  F-Status  File                                                       Size   Id.     Device  Link    Type       MaxSize     IncrSize  BlkSize
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_1/sr3.data1                 2306875392    4  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_10/sr3.data10               2139103232   13  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_11/sr3.data11               2139103232   14  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_12/sr3.data12               2139103232   15  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_13/sr3.data13               2118131712   16  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_14/sr3.data14               2118131712   17  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_15/sr3.data15               2118131712   18  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_16/sr3.data16               1415585792   19  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_17/sr3.data17               2097160192   38  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_18/sr3.data18               2097160192   39  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_19/sr3.data19               2097160192   40  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_2/sr3.data2                 2202017792    5  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_20/sr3.data20               2097160192   41  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_21/sr3.data21               2097160192   42  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_22/sr3.data22               2097160192   43  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_3/sr3.data3                 2181046272    6  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_4/sr3.data4                 2181046272    7  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_5/sr3.data5                 2160074752    8  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_6/sr3.data6                 2139103232    9  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_7/sr3.data7                 2139103232   10  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_8/sr3.data8                 2139103232   11  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata2/sr3_9/sr3.data9                 2139103232   12  1073938434  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3_23/sr3.data23               2097160192   76  1073938436  NOLINK  FILE             0            0     8192
PSAPSR3        ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3_24/sr3.data24               2097160192   77  1073938436  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_19/sr3701.data19         2097160192   49  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_20/sr3701.data20         2097160192   50  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_21/sr3701.data21         2097160192   51  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_22/sr3701.data22         2097160192   52  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_23/sr3701.data23         2097160192   53  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_24/sr3701.data24         2097160192   54  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_25/sr3701.data25         2097160192   55  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_26/sr3701.data26         2097160192   56  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_27/sr3701.data27         2097160192   57  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_28/sr3701.data28         2097160192   58  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_29/sr3701.data29         2097160192   59  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_30/sr3701.data30         2097160192   60  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_31/sr3701.data31         2097160192   61  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_32/sr3701.data32         2097160192   62  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_33/sr3701.data33         2097160192   63  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_34/sr3701.data34         2097160192   64  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_35/sr3701.data35         2097160192   65  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sr3701_36/sr3701.data36         2097160192   66  1073938433  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_1/sr3701.data1           2789220352   20  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_10/sr3701.data10         2810191872   29  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_11/sr3701.data11         2789220352   30  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_12/sr3701.data12         2705334272   31  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_13/sr3701.data13         6123692032   32  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_14/sr3701.data14         2904563712   33  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_15/sr3701.data15         2097160192   45  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_16/sr3701.data16         2097160192   46  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_17/sr3701.data17         2097160192   47  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_18/sr3701.data18         2097160192   48  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_2/sr3701.data2           2747277312   21  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_3/sr3701.data3           3124764672   22  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_4/sr3701.data4           3124764672   23  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_5/sr3701.data5           3208650752   24  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_6/sr3701.data6           2915049472   25  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_7/sr3701.data7           2873106432   26  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_8/sr3701.data8           2873106432   27  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata3/sr3701_9/sr3701.data9           2810191872   28  1073938435  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3701_37/sr3701.data37         2097160192   68  1073938436  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3701_38/sr3701.data38         2097160192   69  1073938436  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3701_39/sr3701.data39         2097160192   70  1073938436  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3701_40/sr3701.data40         2097160192   71  1073938436  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3701_41/sr3701.data41         2097160192   72  1073938436  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3701_42/sr3701.data42         2097160192   73  1073938436  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3701_43/sr3701.data43         2097160192   74  1073938436  NOLINK  FILE             0            0     8192
PSAPSR3701     ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3701_44/sr3701.data44         2097160192   75  1073938436  NOLINK  FILE             0            0     8192
PSAPSR3DB      ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3db_1/sr3db.data1             2097160192   35  1073938436  NOLINK  FILE             0            0     8192
PSAPSR3DB      ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3db_2/sr3db.data2             2097160192   36  1073938436  NOLINK  FILE             0            0     8192
PSAPSR3DB      ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3db_3/sr3db.data3             1048584192   37  1073938436  NOLINK  FILE             0            0     8192
PSAPSR3USR     ONLINE*    ONLINE    /oracle/TAQ/sapdata4/sr3usr_1/sr3usr.data1             31465472   34  1073938436  NOLINK  FILE             0            0     8192
PSAPTEMP       ONLINE#    ONLINE    /oracle/TAQ/sapdata1/temp_1/temp.data1               1468014592   -1  1073938433  NOLINK  FILE             0            0     8192
PSAPUNDO       ONLINE-    ONLINE    /oracle/TAQ/sapdata1/undo_1/undo.data1               5872033792    2  1073938433  NOLINK  FILE             0            0     8192
SYSAUX         ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sysaux_1/sysaux.data1            209723392    3  1073938433  NOLINK  FILE             0            0     8192
SYSAUX         ONLINE*    ONLINE    /oracle/TAQ/sapdata1/sysaux_2/sysaux.data2           2097160192   67  1073938433  NOLINK  FILE             0            0     8192
SYSTEM         ONLINE*    SYSTEM    /oracle/TAQ/sapdata1/system_1/system.data1            891297792    1  1073938433  NOLINK  FILE             0            0     8192
SYSTEM         ONLINE*    SYSTEM    /oracle/TAQ/sapdata1/system_2/system.data2            524296192   44  1073938433  NOLINK  FILE             0            0     8192
BR0119I Redo log files
File                                                Size  Group     Device  Status    Link    Type
/oracle/TAQ/origlogA/log_g11m1.dbf              52429824    1   1073872899  INUSE     NOLINK  FILE
/oracle/TAQ/mirrlogA/log_g11m2.dbf              52429824    1   1073872897  INUSE     NOLINK  FILE
/oracle/TAQ/origlogB/log_g12m1.dbf              52429824    2   1073872900  INUSE     NOLINK  FILE
/oracle/TAQ/mirrlogB/log_g12m2.dbf              52429824    2   1073872898  INUSE     NOLINK  FILE
/oracle/TAQ/origlogA/log_g13m1.dbf              52429824    3   1073872899  INUSE     NOLINK  FILE
/oracle/TAQ/mirrlogA/log_g13m2.dbf              52429824    3   1073872897  INUSE     NOLINK  FILE
/oracle/TAQ/origlogB/log_g14m1.dbf              52429824    4   1073872900  INUSE     NOLINK  FILE
/oracle/TAQ/mirrlogB/log_g14m2.dbf              52429824    4   1073872898  INUSE     NOLINK  FILE

Can we use online redo log to recover lost datafile in NOARCHIVE mode?

I am working on OCA exam and confued about these 2 sample questions. (similar questions with totally different answer) Please give me hint about the different between these 2 questions. ** If the database is in NOARCHIVELOG mode, and one of the dataf

Windows Modified date for online redo logs

I am doing a full database backup (oracle 10g) weekly and incremental backups nightly. The database is running in archivelog mode and I am multiplexing the online redo logs. However, when I look in windows the modified date for all Redo logs is displ

Redo log backup failing with BR253E errno 2:

Hi all, I am able to take online as well as offline backup through sapdba , but unfortunately from last 7 days my redo log backup is failing after online backup is complete with below mentioned error. I also tried to start redo log backup seperately

Redo log backup on disk

Hi I want to take Redo log backup on disk. what changes i have to made in init<SID>.sao file. Regards VikramHi Vikram, If you use brtools then even without parameter change in init<SID>.sap also you can take backup.You have to provide media as

Commit Completes although current online redo log file have been removed.

Although i have removed current online redo log file in linux os (Oracle Linux),when i type "commit" it says that "commit complete". Is this fair for this princip?*:" if Only when all redo records associated with a given transacti

Redo log backups not showing

Dear all In  DB12 tcode when i click following buttons 1) Last successful backup, 2) Overview of database backups, 3) Overview of redo log backups not showing any logs please replyHello previous problem was solved, one of the table locked, i have unl

Archive all the active online redo logs

Hi, in 9.2.0 and in archivelog mode, how can I archive all the active online redo logs ? Thank you.Is ur database already running in archivelog mode?? If yes and if automatic archiving is enabled then ur redo will be archived automatically. I think f

Moving the online redo log files to different location

We just installed few more drives into our sandbox system and I want to move the online redo log files for better performance.  We've got the SAPARCH directory moved to a different location.  Does anyone know how/where I can change the parameters so

Online redo log switching

Hello. I have a question about online redo logs. Assume that I have two small redo log groups in my database. I am processing a big batch load consisting of many inserts, but no checkpoing. The first redo log group gets full, it's switched to the sec

Abot loss online Redo log group

Hi, Is there different from recovering between loss CURRENT online redo log group and ACTIVE online redo log group? Both of them are needed to incomplete recovery, right?For CURRENT redolog recovery: startup mount recover database until cancel; alter

Online redo logs vs standby redo logs

Hi All, Oracle version : 10.2.0.4 OS : SunOS 5.10 Generic_118855-36 i86pc i386 i86pc This might be a silly question for the experts :( We are having 2 standby databases and 1 logical database. Everything is running fine , I have one confusion : My pr

Best practice - online redo logs and virtualization

I have a 10.1.0.4 instance (soon to be migrated to 11gr2) running under Windows Server 2003. We use a non-standard disk distribution scheme - on the c: drive we have oracle_home as well as directories for control files and online redo logs. on the d:

Optimal online redo log file size

hello to all, I have installed just now 11gr2 patching 2. I found The Redo Logfile Size Advisor can be used to determine the least optimal online redo log file size based on the current FAST_START_MTTR_TARGET setting and MTTR statistics. Which means

Clearing Online redo logs on the target physical standby

Hi, Version 11202. Primary on machine A Standby on machine B Following note: 11.2 Data Guard Physical Standby Switchover Best Practices using SQL*Plus [ID 1304939.1]. Online redo logs on the target physical standby need to be cleared before that stan

Online redo logs fill-up due to long running SCM processes

DB2 v9.7 AIX v6.1 P570 Running Standard SAP Code Going live with SCM system running SNP/DP GATP how can we avoid having our online redo logs fill-up due to long running processes (i.e., CTM. Process Chains, BOP, DP Runs) Need to know SAP Best Practic

Online Redo log file/ Archive Files

hi guyz, is there any tool available for to view contents of redo log file, or archive file (WHAT"S INSIDE????) i hope i've explained what i want regards neoDear Friend, Good day to you and I hope that this e-mail will find you well and in good healt

Redo Log Switch 결과...

환경 : 8.1.7.3.0 (no archive log 모드) log_checkpoint_timeout = 0 log_checkpoint_interval = 999999999 redo log size = 200M 현재 check point는 log switch 상태에서만 가능하도록 설정된 것 같습니다. 거래량이 적어서 그런지 log switch는 30시간 주기입니다. 제가 실행한 것은 아래 4번째 로그가 current일때 alter system

Data Guard : Standby Redo Log CONFUSION

Trying to set up test Standby db on 10.2.0 I am well confused about below step 3.1.3, how is the normal redo linked with standby redo, should standby not be members of orginal redo groups? http://download.oracle.com/docs/cd/B19306_01/server.102/b1423

Why do we need standby redo log on Primary database.

Hi Gurus, I was going through the document in OBE, http://www.oracle.com/technology/obe/11gr1_db/ha/dataguard/physstby/physstdby.htm I have two queries: 1) I noticed the statement - "Configure the primary database to receive redo data, by adding the