This is a multipart message in MIME format.
--=_alternative 005025C885256DFA_=
Content-Type: text/plain; charset="us-ascii"
I am not a database expert, but from what I have learned working with SAP,
I would not recommend doing what you suggest. If you want to recover the
database
to a point in time you need to run with archivelogs on. You need to stop
and restart
the database in order to turn archivelog mode on and off. I believe that
a hot backup
in the scenario you suggest would be useless. The database might be
inconsistent.
The rule is, as I understand, to do hot backups you must run in archivelog
mode
all the time. If you are normally running without archivelogs, you need
to shut down
the database and do a cold backup.
=============================
Carl Stehman
PHI Services Company
202-331-6619
Pager 301-765-2703
ckstehman AT pepco DOT com
"James Peppas" <perf AT peppas DOT gr>
Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu
12/12/2003 05:32 AM
Please respond to perf
To: <veritas-bu AT mailman.eng.auburn DOT edu>
cc:
Subject: RE: [Veritas-bu] RMAN & Archive Logs
I'm not very sure because I'm not really into oracle but I think you can
put
your db in archivelog enabled mode without it spitting out archives.
Then when you want to start an online backup, you turn on archive
logging,
do the online backuo of the db, backup the archives and turn of archive
logging.
If there are any Oarcle experts, please tell me if this is true.
JP
-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of Weber,
Philip
Sent: Friday, November 21, 2003 2:18 PM
To: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: RE: [Veritas-bu] RMAN & Archive Logs
Fair enough,
thanks for the confirmations.
regards, Phil
-----Original Message-----
From: Nick Lefebvre [mailto:nick AT solnet.com DOT au]
Sent: 19 November 2003 22:58
To: 'Weber, Philip'; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] RMAN & Archive Logs
Hi Philip,
In order to do an online backup using RMAN the database must be in
ARCHIVELOG mode. When the database is running in ARCHIVELOG mode, the
archiver (ARCH) background process will make a copy of the online redo log
file to archive backup location. This will allow you to create
point-in-time
recovery.
This does not mean that you shouldn't be able to use RMAN to backup the
database if you run in NOARCHIVELOG mode but the only way you can use RMAN
to back up the database is if you shut down the database consistently (you
can't use RMAN if you issue a shutdown abort command).
In fact I think from the documentation placing the database into
ARCHIVELOG
mode is not a pre-requisite.
Let me know if someone knows any differently here.
If you want to create online backups but not put the database into
ARCHIVELOG mode then you could possibly look at the following:
- Oracle's Export utility - Logical exports create an export file that
contains a list of SQL statements to recreate the database. The Export is
performed when the database is open and does not affect users work. You
could then backup the export file.
I would suggest that you use cold backups in conjunction with the export
utility.
- snapshot technology - You could look at shutting down the database for
an
instant (if at all possible) and then creating a snapshot of the disk
volume. You would then backup the snapshot.
If you are using Solaris you could use fssnap to do this.
Hope this helps.
Nick
-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of Weber,
Philip
Sent: Thursday, 20 November 2003 1:58 AM
To: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: [Veritas-bu] RMAN & Archive Logs
Dear all,
I am being told that in order to do an RMAN backup, we must have our
databases in archive log mode. Lack of space to do so is holding up
getting
some databases on a backup schedule, so does anybody know if this is true?
Ideally I would like to back the databases up online, accept that I don't
have point-in-time recovery but be able to recover back to time of backup,
but not have the overhead of archive logging being turned on - these
database are updated in batch mode only.
thanks for any info.
regards, Phil
Phil Weber
Egg Distributed Hosts - UNIX Systems Engineer
Phone: 01384 26 4136
Mobile:
This private and confidential e-mail has been sent to you by Egg. The Egg
group of companies includes Egg Banking plc (registered no. 2999842), Egg
Financial Products Ltd (registered no. 3319027) and Egg Investments Ltd
(registered no. 3403963) which carries out investment business on behalf
of
Egg and is regulated by the Financial Services Authority.
Registered in England and Wales. Registered offices: 1 Waterhouse Square,
138-142 Holborn, London EC1N 2NA. If you are not the intended recipient of
this e-mail and have received it in error, please notify the sender by
replying with 'received in error' as the subject and then delete it from
your mailbox.
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
--=_alternative 005025C885256DFA_=
Content-Type: text/html; charset="us-ascii"
<br><font size=2 face="sans-serif">I am not a database expert, but from what I
have learned working with SAP, </font>
<br><font size=2 face="sans-serif">I would not recommend doing what you
suggest. If you want to recover the database</font>
<br><font size=2 face="sans-serif">to a point in time you need to run with
archivelogs on. You need to stop and restart</font>
<br><font size=2 face="sans-serif">the database in order to turn archivelog
mode on and off. I believe that a hot backup</font>
<br><font size=2 face="sans-serif">in the scenario you suggest would be
useless. The database might be inconsistent.</font>
<br><font size=2 face="sans-serif">The rule is, as I understand, to do hot
backups you must run in archivelog mode</font>
<br><font size=2 face="sans-serif">all the time. If you are normally
running without archivelogs, you need to shut down</font>
<br><font size=2 face="sans-serif">the database and do a cold backup.</font>
<br><font size=2 face="sans-serif"><br>
=============================<br>
Carl Stehman<br>
PHI Services Company<br>
202-331-6619<br>
Pager 301-765-2703<br>
ckstehman AT pepco DOT com</font>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>"James Peppas" <perf AT
peppas DOT gr></b></font>
<br><font size=1 face="sans-serif">Sent by: veritas-bu-admin AT
mailman.eng.auburn DOT edu</font>
<p><font size=1 face="sans-serif">12/12/2003 05:32 AM</font>
<br><font size=1 face="sans-serif">Please respond to perf</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To:
<veritas-bu AT mailman.eng.auburn DOT edu></font>
<br><font size=1 face="sans-serif"> cc:
</font>
<br><font size=1 face="sans-serif"> Subject:
RE: [Veritas-bu] RMAN & Archive Logs</font></table>
<br>
<br>
<br><font size=2 face="Courier New"><br>
I'm not very sure because I'm not really into oracle but I think you can put<br>
your db in archivelog enabled mode without it spitting out archives.<br>
Then when you want to start an online backup, you turn on archive
logging,<br>
do the online backuo of the db, backup the archives and turn of archive<br>
logging.<br>
<br>
If there are any Oarcle experts, please tell me if this is true.<br>
<br>
<br>
JP<br>
<br>
<br>
<br>
<br>
<br>
-----Original Message-----<br>
From: veritas-bu-admin AT mailman.eng.auburn DOT edu<br>
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of Weber,
Philip<br>
Sent: Friday, November 21, 2003 2:18 PM<br>
To: 'veritas-bu AT mailman.eng.auburn DOT edu'<br>
Subject: RE: [Veritas-bu] RMAN & Archive Logs<br>
<br>
<br>
Fair enough,<br>
<br>
thanks for the confirmations.<br>
<br>
regards, Phil<br>
<br>
-----Original Message-----<br>
From: Nick Lefebvre [mailto:nick AT solnet.com DOT au] <br>
Sent: 19 November 2003 22:58<br>
To: 'Weber, Philip'; veritas-bu AT mailman.eng.auburn DOT edu<br>
Subject: RE: [Veritas-bu] RMAN & Archive Logs<br>
<br>
Hi Philip,<br>
<br>
In order to do an online backup using RMAN the database must be in<br>
ARCHIVELOG mode. When the database is running in ARCHIVELOG mode, the<br>
archiver (ARCH) background process will make a copy of the online redo log<br>
file to archive backup location. This will allow you to create point-in-time<br>
recovery.<br>
<br>
This does not mean that you shouldn't be able to use RMAN to backup the<br>
database if you run in NOARCHIVELOG mode but the only way you can use RMAN<br>
to back up the database is if you shut down the database consistently (you<br>
can't use RMAN if you issue a shutdown abort command).<br>
<br>
In fact I think from the documentation placing the database into ARCHIVELOG<br>
mode is not a pre-requisite.<br>
<br>
Let me know if someone knows any differently here.<br>
<br>
If you want to create online backups but not put the database into<br>
ARCHIVELOG mode then you could possibly look at the following:<br>
<br>
- Oracle's Export utility - Logical exports create an export file that<br>
contains a list of SQL statements to recreate the database. The Export is<br>
performed when the database is open and does not affect users work. You<br>
could then backup the export file.<br>
<br>
I would suggest that you use cold backups in conjunction with the export<br>
utility.<br>
<br>
- snapshot technology - You could look at shutting down the database for an<br>
instant (if at all possible) and then creating a snapshot of the disk<br>
volume. You would then backup the snapshot.</font>
<br><font size=2 face="Courier New"><br>
If you are using Solaris you could use fssnap to do this.<br>
<br>
Hope this helps.<br>
<br>
Nick<br>
<br>
<br>
<br>
-----Original Message-----<br>
From: veritas-bu-admin AT mailman.eng.auburn DOT edu<br>
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of Weber,
Philip<br>
Sent: Thursday, 20 November 2003 1:58 AM<br>
To: 'veritas-bu AT mailman.eng.auburn DOT edu'<br>
Subject: [Veritas-bu] RMAN & Archive Logs<br>
<br>
Dear all,<br>
<br>
I am being told that in order to do an RMAN backup, we must have our<br>
databases in archive log mode. Lack of space to do so is holding up
getting<br>
some databases on a backup schedule, so does anybody know if this is true?<br>
<br>
Ideally I would like to back the databases up online, accept that I don't<br>
have point-in-time recovery but be able to recover back to time of backup,<br>
but not have the overhead of archive logging being turned on - these<br>
database are updated in batch mode only.<br>
<br>
thanks for any info.<br>
<br>
regards, Phil<br>
<br>
Phil Weber<br>
Egg Distributed Hosts - UNIX Systems Engineer<br>
Phone: 01384 26 4136<br>
Mobile: <br>
<br>
<br>
<br>
This private and confidential e-mail has been sent to you by Egg. The Egg<br>
group of companies includes Egg Banking plc (registered no. 2999842), Egg<br>
Financial Products Ltd (registered no. 3319027) and Egg Investments Ltd<br>
(registered no. 3403963) which carries out investment business on behalf of<br>
Egg and is regulated by the Financial Services Authority. <br>
Registered in England and Wales. Registered offices: 1 Waterhouse Square,<br>
138-142 Holborn, London EC1N 2NA. If you are not the intended recipient of<br>
this e-mail and have received it in error, please notify the sender by<br>
replying with 'received in error' as the subject and then delete it from<br>
your mailbox.<br>
<br>
_______________________________________________<br>
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu<br>
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu<br>
<br>
_______________________________________________<br>
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu<br>
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu<br>
<br>
<br>
<br>
_______________________________________________<br>
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu<br>
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu<br>
</font>
<br>
<br>
<br>
--=_alternative 005025C885256DFA_=--
|
