>  Operating System
>  VMWARE
>  Installations - Apps11i
>  R12 Topics
>  Installations - Apps R12
>  Patching
>  Cloning
>  Oracle Apps Upgrades
>  System Administration - R11/R12
>  Advance Features - Oracle Apps R12
>  Want to Become an Apps DBA ?
>  Certification - Apps DBA
>  Apps Performance
>  Oracle Apps DBA Interview Questions
>  Apps Day to Day Queries

Home

Username

Password

Remember Me







Installation
RMAN - Backup & Recovery
Replication
Convert DB Character Set
DATAPUMP
Recoveries
Oracle 11g Topics
Oracle 11g DBA course

   Installation

RMAN Backups - Online Database Backups - Solaris


RMAN Backups - Online Database Backups

Step 1. Start RMAN

ORACLE_SID=HMDEV; export ORACLE_SID
rman target=backup_admin/backup_admin@HMDEV catalog=rcat_user/rcat_user@RECO


Step 2. Configure the necessary parameters.

configure controlfile autobackup ON;

configure controlfile autobackup format for device type disk to 'd:\backup_test\%F';

configure channel device type disk format '/crmg/home/oracle92/rman_backups/bkup_%d_%s_%p';


(The below step is optional, if you want to store the backups in another server you need to setup NFS)
Step 3. Set NFS mount for /crmg/home/oracle92/rman_backups - Solaris

On the Server where u want to copy the files

vi /etc/dfs/dfstab
share -F nfs -o rw=190.2.12.113 -d "share" /crmg/home/oracle92/rman_backups

/etc/init.d/nfs.server stop
/etc/init.d/nfs.server start

On the database server
mkdir /rman_backups
# dfshares 190.2.12.114
RESOURCE SERVER ACCESS TRANSPORT
190.2.12.114:/crmg/home/oracle92/rman_backups 190.2.12.114 - -
mount 190.2.12.114:/crmg/home/oracle92/rman_backups /rman_backups

Step 4. Start the Backup

See down for incremental backups

RMAN> backup database plus archivelog;


Starting backup at 29-APR-04
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=94 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=29 recid=1 stamp=523805849
input archive log thread=1 sequence=30 recid=2 stamp=523824461
input archive log thread=1 sequence=31 recid=3 stamp=523862791
input archive log thread=1 sequence=32 recid=4 stamp=523967671
input archive log thread=1 sequence=33 recid=5 stamp=524071120
input archive log thread=1 sequence=34 recid=6 stamp=524175724
input archive log thread=1 sequence=35 recid=7 stamp=524280582
input archive log thread=1 sequence=36 recid=8 stamp=524386949
input archive log thread=1 sequence=37 recid=9 stamp=524492739
input archive log thread=1 sequence=38 recid=10 stamp=524597129
input archive log thread=1 sequence=39 recid=11 stamp=524686567
input archive log thread=1 sequence=40 recid=12 stamp=524686766
input archive log thread=1 sequence=41 recid=13 stamp=524686810
channel ORA_DISK_1: starting piece 1 at 28-APR-04
channel ORA_DISK_1: finished piece 1 at 28-APR-04
piece handle=/rman_backups/01fkc5es_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:16
Finished backup at 29-APR-04

Starting backup at 29-APR-04
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=/oracle/oradata/HMDEV/system01.dbf
input datafile fno=00002 name=/oracle/oradata/HMDEV/undotbs01.dbf
input datafile fno=00011 name=/oracle/oradata/HMDEV/T_HEALTH.dbf
input datafile fno=00005 name=/oracle/oradata/HMDEV/example01.dbf
input datafile fno=00010 name=/oracle/oradata/HMDEV/xdb01.dbf
input datafile fno=00006 name=/oracle/oradata/HMDEV/indx01.dbf
input datafile fno=00009 name=/oracle/oradata/HMDEV/users01.dbf
input datafile fno=00003 name=/oracle/oradata/HMDEV/cwmlite01.dbf
input datafile fno=00004 name=/oracle/oradata/HMDEV/drsys01.dbf
input datafile fno=00007 name=/oracle/oradata/HMDEV/odm01.dbf
input datafile fno=00008 name=/oracle/oradata/HMDEV/tools01.dbf
channel ORA_DISK_1: starting piece 1 at 28-APR-04
channel ORA_DISK_1: finished piece 1 at 28-APR-04
piece handle=/rman_backups/02fkc5j6_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:57
Finished backup at 29-APR-04

Starting backup at 29-APR-04
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=42 recid=14 stamp=524687130
channel ORA_DISK_1: starting piece 1 at 28-APR-04
channel ORA_DISK_1: finished piece 1 at 28-APR-04
piece handle=/rman_backups/03fkc5or_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 29-APR-04


5) List backup

6) show all

7) report obsolete; - to reports no of backup copies
delete obsolete;


RMAN Backups - Incremental RMAN Backups - Cumulative
----------------------------------------------------

Incremental RMAN Backups - Cumulative
Day Level Command
Sun 0 backup incremental level=0 database plus archivelog delete input tag='qcdb level 0 backup (Sun)'
Mon 2 backup incremental level=2 cumulative database plus archivelog delete input tag = 'qcdb level 2 backup (Mon)'
Tue 2 backup incremental level=2 cumulative database plus archivelog delete input tag = 'qcdb level 2 backup (Tue)'
Wed 1 backup incremental level=1 database plus archivelog delete input tag = 'qcdb level 1 backup (Wed)'
Thur 2 backup incremental level=2 cumulative database plus archivelog delete input tag = 'qcdb level 2 backup (Thur)'
Fri 2 backup incremental level=2 cumulative database plus archivelog delete input tag = 'qcdb level 2 backup (Fri)'
Sun 0 backup incremental level=0 database plus archivelog delete input tag = 'qcdb level 0 backup (Sun)'


RMAN> backup incremental level 0 database plus archivelog delete input tag='qcdb level 0 backup (Sun)';


Starting backup at 07-MAR-05
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=23 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 03/07/2005 11:54:23
RMAN-06059: expected archived log not found, lost of archived log compromises re
coverability
ORA-19625: error identifying file D:\ORACLE\ORA92\RDBMS\ARC00028.001
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

change archivelog all crosscheck;

RMAN> change archivelog all crosscheck;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=23 devtype=DISK
validation failed for archived log
archive log filename=D:\ORACLE\ORA92\RDBMS\ARC00028.001 recid=18 stamp=551016351

validation succeeded for archived log
archive log filename=D:\ORACLE\ADMIN\QCDB\ARCHIVE\ARC00057.001 recid=33 stamp=55
2228124

RMAN> backup incremental level 0 database plus archivelog delete input tag='qcdb level 0 backup (Sun)';


Starting backup at 07-MAR-05
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=57 recid=33 stamp=552228124
input archive log thread=1 sequence=58 recid=34 stamp=552303737
input archive log thread=1 sequence=59 recid=35 stamp=552304073
input archive log thread=1 sequence=60 recid=36 stamp=552304080
input archive log thread=1 sequence=61 recid=37 stamp=552304171
input archive log thread=1 sequence=62 recid=38 stamp=552311463
input archive log thread=1 sequence=63 recid=39 stamp=552311662
input archive log thread=1 sequence=64 recid=40 stamp=552312680
channel ORA_DISK_1: starting piece 1 at 07-MAR-05
channel ORA_DISK_1: finished piece 1 at 07-MAR-05
piece handle=D:\QCDB_BACKUP\BKUP_QCDB_13_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:27
channel ORA_DISK_1: deleting archive log(s)
archive log filename=D:\ORACLE\ADMIN\QCDB\ARCHIVE\ARC00057.001 recid=33 stamp
archive log filename=D:\ORACLE\ADMIN\QCDB\ARCHIVE\ARC00058.001 recid=34 stamp
archive log filename=D:\ORACLE\ADMIN\QCDB\ARCHIVE\ARC00059.001 recid=35 stamp
archive log filename=D:\ORACLE\ADMIN\QCDB\ARCHIVE\ARC00060.001 recid=36 stamp
archive log filename=D:\ORACLE\ADMIN\QCDB\ARCHIVE\ARC00061.001 recid=37 stamp
archive log filename=D:\ORACLE\ADMIN\QCDB\ARCHIVE\ARC00062.001 recid=38 stamp
archive log filename=D:\ORACLE\ADMIN\QCDB\ARCHIVE\ARC00063.001 recid=39 stamp
archive log filename=D:\ORACLE\ADMIN\QCDB\ARCHIVE\ARC00064.001 recid=40 stamp
Finished backup at 07-MAR-05

Starting backup at 07-MAR-05
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00019 name=D:\ORACLE\ORADATA\GOVT\T_HEALTH01.DBF
input datafile fno=00001 name=D:\ORACLE\ORADATA\GOVT\SYSTEM01.DBF
input datafile fno=00013 name=D:\ORACLE\ORADATA\GOVT\HM_CORE_TBL_TB01.DBF
input datafile fno=00002 name=D:\ORACLE\ORADATA\GOVT\UNDOTBS01.DBF
input datafile fno=00011 name=D:\ORACLE\ORADATA\GOVT\HM_REF_IDX_TB01.DBF
input datafile fno=00015 name=D:\ORACLE\ORADATA\GOVT\HM_REF_TBL_TB01.DBF
input datafile fno=00005 name=D:\ORACLE\ORADATA\GOVT\EXAMPLE01.DBF
input datafile fno=00010 name=D:\ORACLE\ORADATA\GOVT\XDB01.DBF
input datafile fno=00006 name=D:\ORACLE\ORADATA\GOVT\INDX01.DBF
input datafile fno=00009 name=D:\ORACLE\ORADATA\GOVT\USERS01.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\GOVT\CWMLITE01.DBF
input datafile fno=00004 name=D:\ORACLE\ORADATA\GOVT\DRSYS01.DBF
input datafile fno=00007 name=D:\ORACLE\ORADATA\GOVT\ODM01.DBF
input datafile fno=00008 name=D:\ORACLE\ORADATA\GOVT\TOOLS01.DBF
input datafile fno=00012 name=D:\ORACLE\ORADATA\GOVT\HM_USERS_IDX_TB01.DBF
input datafile fno=00014 name=D:\ORACLE\ORADATA\GOVT\HM_CORE_IDX_TB01.DBF
input datafile fno=00017 name=D:\ORACLE\ORADATA\GOVT\HM_MQS_IDX_TB01.DBF
input datafile fno=00016 name=D:\ORACLE\ORADATA\GOVT\HM_MQS_TBL_TB01.DBF
input datafile fno=00018 name=D:\ORACLE\ORADATA\GOVT\T_INDEX.DBF
channel ORA_DISK_1: starting piece 1 at 07-MAR-05

Issues Faced
------------
Note:119434.1
Subject: RMAN Remote Backup or Remote Restore Fails with ora-27040

Created on 05/29/2008 08:28 PM by akr14feb
Updated on 05/29/2008 08:44 PM by akr14feb
 Printable Version

The comments are owned by the poster. We are not responsible for its content.
Discount Dallas Cowboys Jerseys
Posted on: 2012-10-05 00:33:53   By: Anonymous
 
And, to one degree or another, they were kind of clueless about what was really important to be successful.It's a skill. The skill of throwing is very similar to the skill of swinging a golf club or a baseball bat, for that matter. And it's all timing and leverage and rhythm, except you have to be a lot stronger because the implements are heavier obviously.Your life is certainly unbalanced. I mean, you're very narrowly focused and you're going a mile and half deep on one tiny little thing. And you have to give up other stuff.
Official Dallas Cowboys Jerseys
Nike Cincinnati Bengals Jerseys
Nike Cleveland Browns Jerseys
Nike Dallas Cowboys Jerseys
Cheap Cincinnati Bengals Jerseys

[Reply ]

Where to buy cheap hollister products?The hollister outlet online store will supply the best quality products with cheap
Posted on: 2013-03-17 07:41:40   By: Anonymous
 
Where to buy cheap hollister products?The hollister outlet online store will supply the best quality products with cheap price.When you enter hollister uk store,you can find a lot of new hollister outlet,hollister outlet uk,hollister uk,hollister uk outlet,Hollister T-Shirts,Hollister Long Sleeve T-Shirts,Hollister Polos,Hollister Hoodies,Hollister Shirts,Hollister Sweaters,Hollister Outerwear,Hollister Swim Shorts,Hollister Classic Shorts,Hollister Jeans,Hollister Sweatpants,Hollister Boxers,Hollister T-Shirts,Hollister Shirts,Hollister Fashion Tops,Hollister Tanks,Hollister Skirts,Hollister Dresses,Hollister Hoodies,Hollister Sweaters,Hollister Down Jackets,Hollister Down Vests,Hollister Sweatpants,Hollister Swimsuits,Hollister Bags,Hollister Bracelets,Hollister Flip Flops Men,Hollister Flip Flops Women sale cheap now.Both of them are brand new with original quality.
Some people live special style bags.Such as longchamp outlet,longchamp sale,Longchamp Tote,Longchamp Hobo,Longchamp Planetes,Longchamp Backpack,Longchamp Handbag Large,Longchamp Handbag Medium,Longchamp Handbag Mini,Longchamp Cosmetic Handbags,Longchamp Eiffel Tower Handbags,Longchamp Embroidered Handbags,Longchamp Greatwall Handbags,Longchamp Jacquard Handbags,Longchamp Le Pliage Cabas,Longchamp Le Pliage Large,Longchamp Le Pliage Medium,Longchamp Le Pliage Hobo Handbags,Longchamp Le Pliage Love Handbags,Longchamp Le Pliage Puzzle Handbags,Longchamp Messenger Bags,Longchamp Shoulder Bags,Longchamp Victoire,Longchamp Travel Bag,Longchamp Coin Purses and some luxury design bags.Do you love it?If you love it,please follow us to shop now.

[Reply ]

Re: Useful information
Posted on: 2014-05-06 12:29:17   By: Anonymous
 
great article, precisely the right information that I was looking for! Thanks.
friv games

[Reply ]