RE: Backup and Restore
- From: "Chase Gruezo" <chase@xxxxxxxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Wed, 7 Jun 2006 11:03:30 +0800
Thanks! You guys have been very helpful!
Regards,
Chase
-----Original Message-----
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Jurijs Velikanovs
Sent: Tuesday, June 06, 2006 8:32 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: Re: Backup and Restore
I 100% agree with Kent,
Some additional comments:
On Apps Host:
-- Backup the following directories $APPL_TOP, $COMON_TOP,
$ORACLE_HOME, $IAS_HOME, + oraInventory, + all script dirs, + all
custom code dirs
-- You can use any File System backup method. Presumably the best one
is used already in your organisation (TAR/GZ, CP, Specific software
etc.)
-- You can make backup of that directories any time you wish (it is
good idea to do it at less active time of the day).
-- Most of the files in mentioned directories are static (can be
backed up ones after any changes[applied patches, changed
configuration etc]). Two exceptions are $APPLCFS/$APPLLOG and
$APPLCFS/$APPLOUT directories. Concurrent requests log and output
files are stored there. It would be good idea to make copy of those
directories more often (once a day for example). If you are not
limited in a backup area volume the simplest way in doing that type of
backup is implement daily backup of all mentioned directories. You
will be more or less covered by that.
DB:
-- Recommended method is hot backup, then you DB is in archive log
mode, and you are doing backups then DB is available for system users.
-- Depending on DB version used you can use ether RMAN (i would
recommend to use it starting from 9i R1/R2 version [in general i
wouldn't recommend to use 9iR1 anyway]) or traditional hot backup
method using BEGIN BACKUP/EN BACKUP sintacsis.
-- Please do not forget to backup your ORACLE_HOME/oraInventory/all
cfg/all scripts directories usinf traditional FS backup methods after
any change in the configuration.
In addition it is always good idea to practise you recovery on a test
environments. For example we have implemented regular production
environment cloning procedure in order to ensure that we CAN make
restore in planed time and allow to test any changes and deliveries in
pre-live environment first of all.
PS Check system administrators if they are ready to restore ALL OS as
it was day before crash (ALL parches, ALL cfg etc )
Enjoy,
Yury
On 6/6/06, Rolfe, Kent (GTI AIS OPS/SE) <kent_rolfe@xxxxxx> wrote:
>
>
> dont use import/export. Not for what you want.
>
> If you look up the 'utility' RMAN. That would be much better for you for
> various reasons. Its a standard Oracle product.
>
> RMAN is very easy to use and has loads of examples all over metalink and
the
> net. After some basic setup, it will only take a 10 line script to backup
> your database and similar to restore if it all goes wrong.
>
> Also, you will need to back up the code tree - i.e. RMAN will only do the
> database. For the code tree, you will have to use an OS utility - like
> tar/zip if you are on linux
>
> Kent.
>
>
> -----Original Message-----
> From: ora-apps-dba-bounce@xxxxxxxxxxxxx
> [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of
> Chase Gruezo
> Sent: 06 June 2006 11:11
> To: ora-apps-dba@xxxxxxxxxxxxx
> Subject: Backup and Restore
>
>
>
> Hi,
>
> Just want to ask your opinion regarding backup and restore on 11i.
>
> What are the types of backup and restore on 11i?
>
> What would you recommend to a starter?
>
> Also are there any articles, tips and know how regarding this matter?
>
> I've been trying to search docs on metalink and I had little luck.
>
> I came across this article 230627.1: 9i Export/Import Process for Oracle
> Applications Release 11i, would you recommend this to a beginner. I'm
> overwhelmed just skimming through the page.
>
> Thanks,
>
> Chase
> ________________________________
>
> If you are not an intended recipient of this e-mail, please notify the
> sender, delete it and do not read, act upon, print, disclose, copy, retain
> or redistribute it. Click here for important additional terms relating to
> this e-mail. http://www.ml.com/email_terms/
> ________________________________
>
--
Yury
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
Other related posts:
