| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie backup question
Brian,
If you need 24/7 database availability and you cannot afford loosing any transactions in case of failure you have to switch the database to ARCHIVELOG mode before you can start making "hot backups" (i.e. taking backups while the database is up and running). However if you don't want to deal with ARCHIVELOG mode issues and potential loss of some reasonable number of transactions (e.g. one day transactions if you would do a backup everyday) does not terrify you can use Export utility with CONSISTENT=YES parameter for dumping all the schema or database data into a file in consistent state even while the database is open and being used. You can then use this file to recreate all the data in the database (so called “import”). However the recommended solution is running a production database in ARCHIVELOG mode and using RecoveryManager for backup and recovery procedures. I would suggest you to register for technet.oracle.com and go to: http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76955/toc.htm for information on Export utility.
Regards,
Tom Olczak
"Brian Dick" <bdick_at_home.com> wrote in article
<D66q6.13243$PR.91127_at_news1.wwck1.ri.home.com> :
>I am mainly an application developer, but I've been tossed onto a project
>that needs a quick solution for backup. We have no "real" DBA, just me as a
>"de facto" DBA.
>
>The project uses Oracle V8.1.6 as an imbedded database, so it needs to run
>almost entirely unattended and 24x7. The database is relatively small and is
>configured to run in NOARCHIVE mode.
>
>But the users of the system do want to be able to frequently run a script
>that takes a full backup of the database. If the system incurrs a media
>crash, then the users would run a script for a restore from the backup. Loss
>of data from the time of backup to the time of restore is NOT an issue.
>
>I've read the Oracle8i Backup and Recovery Guide a couple of times, and I am
>confused with all of the options available. I think my requirements are
>fairly simple and all of these ARCHIVE/NOARCHIVE, consistent/inconsistent,
>complete/incomplete decisions really blur the picture.
>
>I know the above scenario is less than optimal, but I have to play with the
>cards I have been delt. We plan to have a robust backup/recovery process in
>the next version of our system (promise <g>).
>
>Later,
>BEDick
>
>
>
 |
 |