This discussion is archived
1 2 Previous Next 20 Replies Latest reply: Apr 30, 2013 2:51 AM by yxes2013 RSS

What contains the autobackup folder?

yxes2013 Newbie
Currently Being Moderated
Hi all,

10g

I checked our autobackup folder, and I see this file:
oracle@sdb51:/u01/app/oracle/flash_recovery_area/PROD/autobackup/2013_04_30> ls
o1_mf_s_814110141_8qypfxjy_.bkp

head *
ÂÀÿcø@}|{z Âÿÿÿÿÿÿ1p
ξ¨FTEST1]0@½U0TAG20130430T134221       ÝÅ2     /0Þ°&ÿÿÂ@ÿÿÿÿÿÿ×LL/0Å2  /0×:½U0ÿÿÿÿÒ(0Rÿÿ'Âÿÿÿÿÿÿ&©test1.__db_cache_size=1040187392
test1.__java_pool_size=16777216
test1.__large_pool_size=16777216
test1.__shared_pool_size=486539264
test1.__streams_pool_size=33554432
*.audit_file_dest='/u01/app/oracle/admin/PROD/adump'
*.background_dump_dest='/u01/app/oracle/admin/PROD/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/u01/app/oracle/oradata/PROD/control01.ctl','/u01/app/oracle/oradata/PROD/control02.ctl','/u01/app/oracle/oradata/PROD/control03.ctl'#Restore Controlfile
Is this the controlfile or the spfile? It looks like an spfile?


Thanks a lot,
  • 1. Re: What contains the autobackup folder?
    asahide Expert
    Currently Being Moderated
    Hi,
    It looks like an spfile?
    Yes.
    Also You can open your original spfile.

    Regards,
  • 2. Re: What contains the autobackup folder?
    Sunny kichloo Expert
    Currently Being Moderated
    Check this

    http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup004.htm#i1017907

    Also it is spfile in your case.
  • 3. Re: What contains the autobackup folder?
    John Stegeman Oracle ACE
    Currently Being Moderated
    Why would a control file have instance-related parameters in it?

    I think you've answered your own question
  • 4. Re: What contains the autobackup folder?
    Fran Guru
    Currently Being Moderated
    check in rman your configuration:

    rman> show all;

    probably you have something like:
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/flash_recovery_area/PROD/autobackup/<your_file>';

    and

    CONFIGURE CONTROLFILE AUTOBACKUP ON;

    in that folder you will have controlfile and spfile for each backup/change you have done. And yes probably is the spfile, it's look like ... :P
  • 5. Re: What contains the autobackup folder?
    MahirM.Quluzade Guru
    Currently Being Moderated
    Hi,

    If you configure RMAN CONTROLFILE AUTOBACKUP ON, then RMAN take control file and spfile backup automatically after backup command.

    Documentation says: RMAN can be configured to automatically back up the control file and server parameter file whenever the database structure metadata in the control file changes and whenever a backup record is added.

    Se more : http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup004.htm



    Thanks
    Mahir M. Quluzade
    http://www.mahir-quluzade.com
  • 6. Re: What contains the autobackup folder?
    MahirM.Quluzade Guru
    Currently Being Moderated
    Control file and SPFILE together.

    Updated:

    I have controlfile autobackup on and D:\ORACLE\FRA\PORTDB\PORTDB\AUTOBACKUP\2013_04_24\O1_MF_S_813621685_8QJ3Z5T5_.BKP
    is backup file.


    RMAN> list backup of spfile;
    
    
    List of Backup Sets
    ===================
    
    
    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    182     Full    9.64M      DISK        00:00:00     24-APR-13
            BP Key: 182   Status: AVAILABLE  Compressed: NO  Tag: TAG20130424T220125
            Piece Name: D:\ORACLE\FRA\PORTDB\PORTDB\AUTOBACKUP\2013_04_24\O1_MF_S_813621685_8QJ3Z5T5_.BKP
      SPFILE Included: Modification time: 24-APR-13
      SPFILE db_unique_name: PORTDB
    
    RMAN> list backup of controlfile;
    
    
    List of Backup Sets
    ===================
    
    
    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    182     Full    9.64M      DISK        00:00:00     24-APR-13
            BP Key: 182   Status: AVAILABLE  Compressed: NO  Tag: TAG20130424T220125
            Piece Name: D:\ORACLE\FRA\PORTDB\PORTDB\AUTOBACKUP\2013_04_24\O1_MF_S_813621685_8QJ3Z5T5_.BKP
      Control File Included: Ckp SCN: 22776223     Ckp time: 24-APR-13
    
    RMAN>
    Regards
    Mahir M. Quluzade

    Edited by: Mahir M. Quluzade on Apr 30, 2013 11:42 AM
  • 7. Re: What contains the autobackup folder?
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Is this the controlfile or the spfile? It looks like an spfile?
    Both. An AUTOBACKUP consists of both the controlfile and the spfile. It is a backuppiece containing two backups (controlfile and spfile).

    See the first line at
    http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup004.htm#sthref232


    Hemant K Chitale
  • 8. Re: What contains the autobackup folder?
    yxes2013 Newbie
    Currently Being Moderated
    i thank you all :)

    So why is the two merged? If I restore my backup does RMAN splits it into 2?
  • 9. Re: What contains the autobackup folder?
    MahirM.Quluzade Guru
    Currently Being Moderated
    It means, you can restore spfile and control file from same backup piece.

    Edited for code:

    If you are list your backuppiece for autobackup. You can see, there have not any different backup pieces.

    RMAN>  list backuppiece 'D:\ORACLE\FRA\PORTDB\PORTDB\AUTOBACKUP\2013_04_24\O1_MF_S_813621685_8QJ3Z5T5_.BKP';
    
    
    List of Backup Pieces
    BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
    ------- ------- --- --- ----------- ----------- ----------
    182     182     1   1   AVAILABLE   DISK        D:\ORACLE\FRA\PORTDB\PORTDB\AUTOBACKUP\2013_04_24\O1_MF_S_813621685_8QJ3Z5T5_.BKP
    It means, controlfile and spfile is in same backup piece.


    Regards
    Mahir M. Quluzade
    http://www.mahir-quluzade.com
  • 10. Re: What contains the autobackup folder?
    SalmanQureshi Expert
    Currently Being Moderated
    Hi,
    So why is the two merged? If I restore my backup does RMAN splits it into 2?
    Just like several datafiles can be merged in a single backupset and still RMAN is capable of restoring a single datafile form that backup set.

    Salman
  • 11. Re: What contains the autobackup folder?
    yxes2013 Newbie
    Currently Being Moderated
    I thanks you all :)

    I also checked my backupset:
    oracle@sdb51:/u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30> ls -l
    total 4284844
    -rw-r----- 1 oracle oinstall    2447360 2013-04-30 14:59 o1_mf_annnn_TAG20130430T145933_8qytypt2_.bkp
    -rw-r----- 1 oracle oinstall 4380934144 2013-04-30 14:59 o1_mf_nnndf_TAG20130430T145645_8qytsf6r_.bkp
    Why are there 2 files? what is this smaller TAG file? I guess the big are the datafiles.

    Thanks a lot...
  • 12. Re: What contains the autobackup folder?
    SalmanQureshi Expert
    Currently Being Moderated
    Why are there 2 files? what is this smaller TAG file? I guess the big are the datafiles.
    Connect to your RMAN and issue command "list backup".

    Salman
  • 13. Re: What contains the autobackup folder?
    MahirM.Quluzade Guru
    Currently Being Moderated
    I think big size file is datafies, small size file is archived logs.
    Did you using backup database plus archivelog; command for backup?

    Mahir

    Edited by: Mahir M. Quluzade on Apr 30, 2013 12:24 PM
  • 14. Re: What contains the autobackup folder?
    yxes2013 Newbie
    Currently Being Moderated
    Thanks mahir...

    I only run this command, others are default...
    run {
    CROSSCHECK COPY OF CONTROLFILE;
    crosscheck archivelog all;
    delete noprompt expired archivelog all;
    backup database;
    SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    BACKUP ARCHIVELOG ALL;
    delete obsolete;
    }
1 2 Previous Next

Legend

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