Any reference concerning the rman?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 10:19 PM
Yes. It's called RMAN.
On 12/12/2003 02:04:46 PM, John wrote:
Do you know any script for doing export and backup of Oracle 9i
John,
Oracle publishes reference material available on OTN.
You can sign up for an account on http://otn.oracle.com, where you can find their documentation and articles.
for example:
Configuring Oracle Recovery Manager
http://otn.oracle.com/oramag/oracle/02-nov/o62support.html
or the RMAN
In addition to that, you don't need any expensive software. The original poster said
that his platform
is SuSE. Well, I'm on RH-9, which is almost the same. Almost. When I want to back up
a database,
I write 700M backup pieces to the filesystem that I have for this purpose and use
xdroast to
John
What is your intention? If you have created a test Oracle database on
your Linux system just to learn, then just shut the database down and back
up all files. If you have some important data in this database that changes
frequently, then you need to learn about Oracle backup recovery.
Do you know any script for doing export and backup of Oracle 9i R2
server?My oracle is on a SuSE linux.
The scripts depend on your set up and environment.
Cold backup..
Shutdown database
copy all datafile,controlfiles,.ora files, etc to a separate disk
startup database
Hot backup..
place the tablespace in backup mode
copy the datafile to a different disk
place the tablespace in normal mode
...
Yes. It's called RMAN.
On 12/12/2003 02:04:46 PM, John wrote:
Do you know any script for doing export and backup of Oracle 9i R2 server?
My oracle is on a SuSE linux.
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: