This discussion is archived
13 Replies Latest reply: Jan 30, 2013 7:28 PM by Aman.... RSS

backup archivelogs from different location

988012 Newbie
Currently Being Moderated
DB : 10.2.0.4
OS : HEHL5

due to space issue i moved the archived to different location from log_archive_dest_1.
is it possible to backup the archivelogs from different location as i moved them?

Thanks.
  • 1. Re: backup archivelogs from different location
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    You code use allocate channel to move your backup to another disk like the following
     ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'C:\new-location';
    backup archivelog all delete input
    how archivelog get full ? please share with us your script are you using the command above to backup your archive . do you have deletion policy
  • 2. Re: backup archivelogs from different location
    Aman.... Oracle ACE
    Currently Being Moderated
    If you are using Recovery Catalog, you can mention that new location in the catalog with the command catalog start with /new/location . After that those files can be backed up.

    Aman....
  • 3. Re: backup archivelogs from different location
    Aman.... Oracle ACE
    Currently Being Moderated
    Osama,

    I don't think that OP wants to move the archive log backup to a different location but want to do the backup of those archived logs which are moved to a different location other than the default location.

    Aman....
  • 4. Re: backup archivelogs from different location
    988012 Newbie
    Currently Being Moderated
    that's right...and i do not have recovery catalog configured.
  • 5. Re: backup archivelogs from different location
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Aman.... wrote:
    Osama,

    I don't think that OP wants to move the archive log backup to a different location but want to do the backup of those archived logs which are moved to a different location other than the default location.

    Aman....
    Thank you Aman for clarifying :)
  • 6. Re: backup archivelogs from different location
    Aman.... Oracle ACE
    Currently Being Moderated
    My bad , it's not a must! Please see,
    bash-3.2$ ls
    o1_mf_1_34_8jk60c7b_.arc  o1_mf_1_35_8jkz3p0l_.arc  o1_mf_1_36_8jlcqpky_.arc
    bash-3.2$ mkdir /tmp/archivelognewloc
    bash-3.2$ cp *.* /tmp/archivelognewloc
    bash-3.2$ rman target /
    
    Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jan 30 14:40:17 2013
    
    Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
    allconnected to target database: **** (DBID=1228973204)
    
    RMAN> 
    
    
    RMAN> catalog start with '/tmp/archivelognewloc';
    
    searching for all files that match the pattern /tmp/archivelognewloc
    
    List of Files Unknown to the Database
    =====================================
    File Name: /tmp/archivelognewloc/o1_mf_1_36_8jlcqpky_.arc
    File Name: /tmp/archivelognewloc/o1_mf_1_35_8jkz3p0l_.arc
    File Name: /tmp/archivelognewloc/o1_mf_1_34_8jk60c7b_.arc
    
    Do you really want to catalog the above files (enter YES or NO)? yes
    cataloging files...
    cataloging done
    
    List of Cataloged Files
    =======================
    File Name: /tmp/archivelognewloc/o1_mf_1_36_8jlcqpky_.arc
    File Name: /tmp/archivelognewloc/o1_mf_1_35_8jkz3p0l_.arc
    File Name: /tmp/archivelognewloc/o1_mf_1_34_8jk60c7b_.arc
    
    RMAN> 
    Update : A little better demo
    SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 30 15:00:32 2013
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
    With the Partitioning, Oracle Label Security, OLAP, Data Mining
    and Real Application Testing options
    
    SQL> alter system switch logfile;
    
    System altered.
    
    SQL> /
    
    System altered.
    
    SQL> alter system checkpoint;
    
    System altered.
    
    SQL> alter system switch logfile;
    
    System altered.
    
    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
    With the Partitioning, Oracle Label Security, OLAP, Data Mining
    and Real Application Testing options
    bash-3.2$ ls
    o1_mf_1_38_8jldnkog_.arc  o1_mf_1_40_8jlfdnph_.arc
    o1_mf_1_39_8jlfdmoq_.arc  o1_mf_1_41_8jlff2nn_.arc
    bash-3.2$ pwd
    /u01/app/oracle/flash_recovery_area/AMER/archivelog/2013_01_30
    [root@EDHDR3P0 ~]# ls /tmp/archivelognewloc/
    [root@EDHDR3P0 ~]# exit
    logout
    
    bash-3.2$ 
    bash-3.2$ 
    bash-3.2$ pwd
    /u01/app/oracle/flash_recovery_area/AMER/archivelog/2013_01_30
    bash-3.2$ ls
    o1_mf_1_38_8jldnkog_.arc  o1_mf_1_40_8jlfdnph_.arc
    o1_mf_1_39_8jlfdmoq_.arc  o1_mf_1_41_8jlff2nn_.arc
    bash-3.2$ ls /tmp/archivelognewloc/
    bash-3.2$ ls -l /tmp/archivelognewloc/
    total 0
    bash-3.2$ cp * /tmp/archivelognewloc/
    bash-3.2$ ls -l /tmp/archivelognewloc/
    total 3620
    -rw-r----- 1 oracle oinstall  549888 Jan 30 15:02 o1_mf_1_38_8jldnkog_.arc
    -rw-r----- 1 oracle oinstall 3117568 Jan 30 15:02 o1_mf_1_39_8jlfdmoq_.arc
    -rw-r----- 1 oracle oinstall    1024 Jan 30 15:02 o1_mf_1_40_8jlfdnph_.arc
    -rw-r----- 1 oracle oinstall   19456 Jan 30 15:02 o1_mf_1_41_8jlff2nn_.arc
    bash-3.2$ pwd 
    /u01/app/oracle/flash_recovery_area/AMER/archivelog/2013_01_30
    bash-3.2$ rm -rf *
    bash-3.2$ ls
    bash-3.2$ rman target /
    
    Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jan 30 15:03:13 2013
    
    Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
    connected to target database: AMER (DBID=1228973204)
    
    RMAN> backup archivelog all;
    
    Starting backup at 30-JAN-13
    current log archived
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=151 device type=DISK
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of backup command at 01/30/2013 15:03:32
    RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
    ORA-19625: error identifying file /u01/app/oracle/flash_recovery_area/AMER/archivelog/2013_01_30/o1_mf_1_38_8jldnkog_.arc
    ORA-27037: unable to obtain file status
    Linux Error: 2: No such file or directory
    Additional information: 3
    
    RMAN> catalog start with '//tmp/archivelognewloc';
    
    searching for all files that match the pattern //tmp/archivelognewloc
    
    List of Files Unknown to the Database
    =====================================
    File Name: /tmp/archivelognewloc/o1_mf_1_39_8jlfdmoq_.arc
    File Name: /tmp/archivelognewloc/o1_mf_1_41_8jlff2nn_.arc
    File Name: /tmp/archivelognewloc/o1_mf_1_40_8jlfdnph_.arc
    File Name: /tmp/archivelognewloc/o1_mf_1_38_8jldnkog_.arc
    
    Do you really want to catalog the above files (enter YES or NO)? yes
    cataloging files...
    cataloging done
    
    List of Cataloged Files
    =======================
    File Name: /tmp/archivelognewloc/o1_mf_1_39_8jlfdmoq_.arc
    File Name: /tmp/archivelognewloc/o1_mf_1_41_8jlff2nn_.arc
    File Name: /tmp/archivelognewloc/o1_mf_1_40_8jlfdnph_.arc
    File Name: /tmp/archivelognewloc/o1_mf_1_38_8jldnkog_.arc
    
    RMAN> backup archivelog all;
    
    Starting backup at 30-JAN-13
    current log archived
    using channel ORA_DISK_1
    archived log /u01/app/oracle/flash_recovery_area/AMER/archivelog/2013_01_30/o1_mf_1_38_8jldnkog_.arc not found or out of sync with catalog
    trying alternate file for archived log of thread 1 with sequence 38
    archived log /u01/app/oracle/flash_recovery_area/AMER/archivelog/2013_01_30/o1_mf_1_39_8jlfdmoq_.arc not found or out of sync with catalog
    trying alternate file for archived log of thread 1 with sequence 39
    archived log /u01/app/oracle/flash_recovery_area/AMER/archivelog/2013_01_30/o1_mf_1_40_8jlfdnph_.arc not found or out of sync with catalog
    trying alternate file for archived log of thread 1 with sequence 40
    archived log /u01/app/oracle/flash_recovery_area/AMER/archivelog/2013_01_30/o1_mf_1_41_8jlff2nn_.arc not found or out of sync with catalog
    trying alternate file for archived log of thread 1 with sequence 41
    channel ORA_DISK_1: starting archived log backup set
    channel ORA_DISK_1: specifying archived log(s) in backup set
    input archived log thread=1 sequence=38 RECID=45 STAMP=806079846
    input archived log thread=1 sequence=39 RECID=42 STAMP=806079846
    input archived log thread=1 sequence=40 RECID=44 STAMP=806079846
    input archived log thread=1 sequence=41 RECID=43 STAMP=806079846
    input archived log thread=1 sequence=42 RECID=41 STAMP=806079812
    input archived log thread=1 sequence=43 RECID=46 STAMP=806079851
    channel ORA_DISK_1: starting piece 1 at 30-JAN-13
    channel ORA_DISK_1: finished piece 1 at 30-JAN-13
    piece handle=/u01/app/oracle/flash_recovery_area/AMER/backupset/2013_01_30/o1_mf_annnn_TAG20130130T150411_8jlfmcmf_.bkp tag=TAG20130130T150411 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    Finished backup at 30-JAN-13
    
    RMAN> list backup of archivelog all;
    
    
    List of Backup Sets
    ===================
    
    
    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    1       981.94M    DISK        00:01:15     30-JAN-13      
            BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20130130T143224
            Piece Name: /u01/app/oracle/flash_recovery_area/AMER/backupset/2013_01_30/o1_mf_annnn_TAG20130130T143224_8jlcqs5d_.bkp
    
      List of Archived Logs in backup set 1
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    5       830546     25-JAN-13 841823     25-JAN-13
      1    6       841823     25-JAN-13 866733     25-JAN-13
      1    7       866733     25-JAN-13 889743     25-JAN-13
      1    8       889743     25-JAN-13 912846     26-JAN-13
      1    9       912846     26-JAN-13 931109     26-JAN-13
      1    10      931109     26-JAN-13 952239     26-JAN-13
      1    11      952239     26-JAN-13 979268     26-JAN-13
      1    12      979268     26-JAN-13 1004465    26-JAN-13
      1    13      1004465    26-JAN-13 1021707    26-JAN-13
      1    14      1021707    26-JAN-13 1040437    27-JAN-13
      1    15      1040437    27-JAN-13 1068031    27-JAN-13
      1    16      1068031    27-JAN-13 1091450    27-JAN-13
      1    17      1091450    27-JAN-13 1114656    27-JAN-13
      1    18      1114656    27-JAN-13 1137779    27-JAN-13
      1    19      1137779    27-JAN-13 1165125    27-JAN-13
      1    20      1165125    27-JAN-13 1199499    28-JAN-13
      1    21      1199499    28-JAN-13 1228282    28-JAN-13
      1    22      1228282    28-JAN-13 1249640    28-JAN-13
      1    23      1249640    28-JAN-13 1270613    28-JAN-13
      1    24      1270613    28-JAN-13 1291570    28-JAN-13
      1    25      1291570    28-JAN-13 1312497    28-JAN-13
      1    26      1312497    28-JAN-13 1332622    28-JAN-13
      1    27      1332622    28-JAN-13 1365097    28-JAN-13
      1    28      1365097    28-JAN-13 1395297    28-JAN-13
      1    29      1395297    28-JAN-13 1407058    28-JAN-13
      1    30      1407058    28-JAN-13 1437549    29-JAN-13
      1    31      1437549    29-JAN-13 1469773    29-JAN-13
      1    32      1469773    29-JAN-13 1504608    29-JAN-13
      1    33      1504608    29-JAN-13 1522578    29-JAN-13
      1    34      1522578    29-JAN-13 1553706    30-JAN-13
      1    35      1553706    30-JAN-13 1586954    30-JAN-13
      1    36      1586954    30-JAN-13 1603625    30-JAN-13
    
    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    2       538.00K    DISK        00:00:01     30-JAN-13      
            BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20130130T144745
            Piece Name: /u01/app/oracle/flash_recovery_area/AMER/backupset/2013_01_30/o1_mf_annnn_TAG20130130T144745_8jldnkxt_.bkp
    
      List of Archived Logs in backup set 2
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    38      1604067    30-JAN-13 1604680    30-JAN-13
    
    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    3       3.64M      DISK        00:00:00     30-JAN-13      
            BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20130130T150411
            Piece Name: /u01/app/oracle/flash_recovery_area/AMER/backupset/2013_01_30/o1_mf_annnn_TAG20130130T150411_8jlfmcmf_.bkp
    
      List of Archived Logs in backup set 3
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    38      1604067    30-JAN-13 1604680    30-JAN-13
      1    39      1604680    30-JAN-13 1606046    30-JAN-13
      1    40      1606046    30-JAN-13 1606049    30-JAN-13
      1    41      1606049    30-JAN-13 1606057    30-JAN-13
      1    42      1606057    30-JAN-13 1606303    30-JAN-13
      1    43      1606303    30-JAN-13 1606353    30-JAN-13
    
    
    RMAN> crosscheck backup of archivelog all;
    
    using channel ORA_DISK_1
    crosschecked backup piece: found to be 'AVAILABLE'
    backup piece handle=/u01/app/oracle/flash_recovery_area/AMER/backupset/2013_01_30/o1_mf_annnn_TAG20130130T143224_8jlcqs5d_.bkp RECID=1 STAMP=806077945
    crosschecked backup piece: found to be 'AVAILABLE'
    backup piece handle=/u01/app/oracle/flash_recovery_area/AMER/backupset/2013_01_30/o1_mf_annnn_TAG20130130T144745_8jldnkxt_.bkp RECID=2 STAMP=806078865
    crosschecked backup piece: found to be 'AVAILABLE'
    backup piece handle=/u01/app/oracle/flash_recovery_area/AMER/backupset/2013_01_30/o1_mf_annnn_TAG20130130T150411_8jlfmcmf_.bkp RECID=3 STAMP=806079851
    Crosschecked 3 objects
    
    
    RMAN> list backup of archivelog all;
    
    
    List of Backup Sets
    ===================
    
    
    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    1       981.94M    DISK        00:01:15     30-JAN-13      
            BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20130130T143224
            Piece Name: /u01/app/oracle/flash_recovery_area/AMER/backupset/2013_01_30/o1_mf_annnn_TAG20130130T143224_8jlcqs5d_.bkp
    
      List of Archived Logs in backup set 1
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    5       830546     25-JAN-13 841823     25-JAN-13
      1    6       841823     25-JAN-13 866733     25-JAN-13
      1    7       866733     25-JAN-13 889743     25-JAN-13
      1    8       889743     25-JAN-13 912846     26-JAN-13
      1    9       912846     26-JAN-13 931109     26-JAN-13
      1    10      931109     26-JAN-13 952239     26-JAN-13
      1    11      952239     26-JAN-13 979268     26-JAN-13
      1    12      979268     26-JAN-13 1004465    26-JAN-13
      1    13      1004465    26-JAN-13 1021707    26-JAN-13
      1    14      1021707    26-JAN-13 1040437    27-JAN-13
      1    15      1040437    27-JAN-13 1068031    27-JAN-13
      1    16      1068031    27-JAN-13 1091450    27-JAN-13
      1    17      1091450    27-JAN-13 1114656    27-JAN-13
      1    18      1114656    27-JAN-13 1137779    27-JAN-13
      1    19      1137779    27-JAN-13 1165125    27-JAN-13
      1    20      1165125    27-JAN-13 1199499    28-JAN-13
      1    21      1199499    28-JAN-13 1228282    28-JAN-13
      1    22      1228282    28-JAN-13 1249640    28-JAN-13
      1    23      1249640    28-JAN-13 1270613    28-JAN-13
      1    24      1270613    28-JAN-13 1291570    28-JAN-13
      1    25      1291570    28-JAN-13 1312497    28-JAN-13
      1    26      1312497    28-JAN-13 1332622    28-JAN-13
      1    27      1332622    28-JAN-13 1365097    28-JAN-13
      1    28      1365097    28-JAN-13 1395297    28-JAN-13
      1    29      1395297    28-JAN-13 1407058    28-JAN-13
      1    30      1407058    28-JAN-13 1437549    29-JAN-13
      1    31      1437549    29-JAN-13 1469773    29-JAN-13
      1    32      1469773    29-JAN-13 1504608    29-JAN-13
      1    33      1504608    29-JAN-13 1522578    29-JAN-13
      1    34      1522578    29-JAN-13 1553706    30-JAN-13
      1    35      1553706    30-JAN-13 1586954    30-JAN-13
      1    36      1586954    30-JAN-13 1603625    30-JAN-13
    
    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    2       538.00K    DISK        00:00:01     30-JAN-13      
            BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20130130T144745
            Piece Name: /u01/app/oracle/flash_recovery_area/AMER/backupset/2013_01_30/o1_mf_annnn_TAG20130130T144745_8jldnkxt_.bkp
    
      List of Archived Logs in backup set 2
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    38      1604067    30-JAN-13 1604680    30-JAN-13
    
    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    3       3.64M      DISK        00:00:00     30-JAN-13      
            BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20130130T150411
            Piece Name: /u01/app/oracle/flash_recovery_area/AMER/backupset/2013_01_30/o1_mf_annnn_TAG20130130T150411_8jlfmcmf_.bkp
    
      List of Archived Logs in backup set 3
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    38      1604067    30-JAN-13 1604680    30-JAN-13
      1    39      1604680    30-JAN-13 1606046    30-JAN-13
      1    40      1606046    30-JAN-13 1606049    30-JAN-13
      1    41      1606049    30-JAN-13 1606057    30-JAN-13
      1    42      1606057    30-JAN-13 1606303    30-JAN-13
      1    43      1606303    30-JAN-13 1606353    30-JAN-13
    
    RMAN> 
    HTH
    Aman....

    Edited by: Aman.... on Jan 30, 2013 3:06 PM
  • 7. Re: backup archivelogs from different location
    Aman.... Oracle ACE
    Currently Being Moderated
    No problem my friend :) .

    Aman....
  • 8. Re: backup archivelogs from different location
    988012 Newbie
    Currently Being Moderated
    thanks for the help.


    i catalogged them...


    started the backup let see whether RMAN picks them or not:

    File Name: /rptdb_data/archdata/MIMrpt1/1_5563_783022306.dbf
    RMAN-07518: Reason: Foreign database file DBID: 1761237920 Database Name: MIMRPT1
    File Name: /rptdb_data/archdata/MIMrpt1/1_5564_783022306.dbf
    RMAN-07518: Reason: Foreign database file DBID: 1761237920 Database Name: MIMRPT1
    File Name: /rptdb_data/archdata/MIMrpt1/1_5565_783022306.dbf
    RMAN-07518: Reason: Foreign database file DBID: 1761237920 Database Name: MIMRPT1
    File Name: /rptdb_data/archdata/MIMrpt1/1_5566_783022306.dbf
    RMAN-07518: Reason: Foreign database file DBID: 1761237920 Database Name: MIMRPT1
    File Name: /rptdb_data/archdata/MIMrpt1/1_5567_783022306.dbf
    RMAN-07518: Reason: Foreign database file DBID: 1761237920 Database Name: MIMRPT1
    File Name: /rptdb_data/archdata/MIMrpt1/1_5808_783022306.dbf
    RMAN-07518: Reason: Foreign database file DBID: 1761237920 Database Name: MIMRPT1
    File Name: /rptdb_data/archdata/MIMrpt1/1_5809_783022306.dbf
    RMAN-07518: Reason: Foreign database file DBID: 1761237920 Database Name: MIMRPT1
    File Name: /rptdb_data/archdata/MIMrpt1/1_5568_783022306.dbf
    RMAN-07518: Reason: Foreign database file DBID: 1761237920 Database Name: MIMRPT1
  • 9. Re: backup archivelogs from different location
    CKPT Guru
    Currently Being Moderated
    File Name: /rptdb_data/archdata/MIMrpt1/1_5568_783022306.dbf
    RMAN-07518: Reason: Foreign database file DBID: 1761237920 Database Name: MIMRPT1
    Please post the output of below two queries.

    SQL> select dbid, name, database_role from v$database;
    SQL> select sequence#,RESETLOGS_CHANGE# from v$archived_log where name is not null;
  • 10. Re: backup archivelogs from different location
    Aman.... Oracle ACE
    Currently Being Moderated
    I think you are good,
    RMAN-07518: Reason: Foreign database file DBID: string Database Name: string
        Cause: This is an informational message only.
        Action: No action is required.
    Aman....
  • 11. Re: backup archivelogs from different location
    988012 Newbie
    Currently Being Moderated
    looks it did not catalogged :

    SQL> select dbid, name, database_role from v$database;

    DBID NAME DATABASE_ROLE
    ------------------------ --------- ----------------
    1761237920 MIMRPT1 PRIMARY

    SQL>
    SQL>
    SQL> select sequence#,RESETLOGS_CHANGE# from v$archived_log where name is not null;

    SEQUENCE# RESETLOGS_CHANGE#
    ------------------------ ------------------------
    5746 388265
    5747 388265
    5749 388265
    5748 388265
    5750 388265
    5751 388265
    5752 388265
    5753 388265
    5754 388265
    5755 388265
    5756 388265
    5757 388265
    5758 388265
    5759 388265
    5761 388265
    5760 388265
    5762 388265
    5763 388265
    5765 388265
    5764 388265
    5766 388265

    SEQUENCE# RESETLOGS_CHANGE#
    ------------------------ ------------------------
    5767 388265
    5769 388265
    5768 388265
    5770 388265
    5771 388265
    5773 388265
    5772 388265
    5774 388265
    5775 388265
    5776 388265
    5777 388265
    5778 388265
    5779 388265
    5781 388265
    5780 388265
    5782 388265
    5783 388265
    5785 388265
    5784 388265
    5786 388265
    5787 388265

    SEQUENCE# RESETLOGS_CHANGE#
    ------------------------ ------------------------
    5789 388265
    5788 388265
    5790 388265
    5791 388265
    5793 388265
    5792 388265
    5794 388265
    5795 388265
    5797 388265
    5796 388265
    5798 388265
    5799 388265
    5800 388265
    5801 388265
    5802 388265
    5803 388265
    5805 388265
    5804 388265
    5806 388265
    5807 388265
    5809 388265

    SEQUENCE# RESETLOGS_CHANGE#
    ------------------------ ------------------------
    5808 388265
    5810 388265
    5811 388265
    5813 388265
    5812 388265
    5814 388265
    5815 388265
    5816 388265
    5817 388265

    72 rows selected.
  • 12. Re: backup archivelogs from different location
    CKPT Guru
    Currently Being Moderated
    looks it did not catalogged :
    Its make me the same sense. :)

    SQL> select dbid, name, database_role from v$database;

    DBID NAME DATABASE_ROLE
    ------------------------ --------- ----------------
    1761237920 MIMRPT1 PRIMARY
    I must ask you the Resetlogs_change along with DBID from v$database, Check again once.
    SEQUENCE# RESETLOGS_CHANGE#
    ------------------------ ------------------------
    5746 388265
    5747 388265
    5749 388265
    There are no sequences from 5563 are cataloged(whatever reported as foreign archive logs) , If so you can see them in v$archived_log.
  • 13. Re: backup archivelogs from different location
    Aman.... Oracle ACE
    Currently Being Moderated
    Did you get the message in the RMAN that the files were cataloged like I had shown?

    Aman....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points