ps?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, March 10, 2003 2:37 PM
To: Multiple recipients of list ORACLE-L
I am implementing hot backups on a small development database
using the following approach:
1. From sqlpl
AFTER completing tablespace
backups?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, March 10, 2003 2:37 PM
To: Multiple recipients of list ORACLE-L
I am implementing hot backups on a small development database
using the foll
rumman.com>cc:
Sent by: Subject: Hot backups
Peter - Shouldn't you backup the controlfile AFTER completing tablespace
backups?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, March 10, 2003 2:37 PM
To: Multiple recipients of list ORACLE-L
I am implementing hot backu
I am implementing hot backups on a small development database
using the following approach:
1. From sqlplus: backup controlfile to '';
2. For each tablespace
- sqlplus: alter tablespace begin backup;
- shell: copy files for that tablespace
- sqlplus: alter table
Ed
In my opinion, it comes down to:
If you have hot backup running very well on an existing system, stick with
it. Otherwise use RMAN. Technically, hot backups can create more redo
records, while RMAN has negligible affect on the production system, near as
I can tell.
Dennis Williams
DBA
If you are using the media management layer (ie rman
talks to tape devices) then you can't beat rman.
If rman is just dumping to disk, and these are going
to tape manually *and* you only want the most recent
backup, then you can't beat rman
If you want to be able to restore from various points
in
-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Veritas Agent for Oracle / incremental backups vs. hot backups
My manager asked me to assess how much smaller our backups would be if we
were doing incremental backups of our data
I'm sure this topic has come up before. I don't need to know the difference
between these backup methods. I am more curious about which is preferred.
>From what I can tell, I'd be a fool not to use RMAN whenever possible.
What experiences have you all had with these in production environments
My manager asked me to assess how much smaller our backups would be if we
were doing incremental backups of our database files, instead of the usual
hot backups.
We are running 8i on UNIX.
I know that the answer is "it depends" and "you can't really know 'till you
try&
Here's what I've used:
create session
select_catalog_role
alter database
alter tablespace
alter system
[EMAIL PROTECTED] wrote:
>
> Hi All,
>
> If I create a backup user, what is the minimum requirements to connect as
> that user and do hot backups?
>
> Thanks
Hi All,
If I create a backup user, what is the minimum requirements to connect as
that user and do hot backups?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
a lot of time and tape.
>
> RMAN backs up blocks, hot backup backs up files.
Agreed
Yet many sites do not have this pressure on their backup
window. These sites often panic when one of the incrementals
is corrupt/not found. Mind you the same thing happens with
hot backups, "What do y
ouple of StorageTek silos:
you don't really want to browse that to get all the correct files
for a database. Try it when you have several hundred files.
Dave, it seems that you do work for clients scattered all around,
hot backups probably works best for you.
Yes, RMAN adds some complexity
posted a simple shell (bourne)
script with environment file that does dynamic hot backups to disk
and has been tested on Oracle versions 6 through 9 and on Solaris,
Linux, AIX, SGI and HP. I have heard from another that she
had it running under CGWIN on Windoze.
Advantages:
dep
You are welcome. :)
-Original Message-
Sent: Thursday, July 18, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
My humble apologies to the list...
He checked the backup script...
host gzip -cf1 /disk2/oradata/rcdc/system.dbf >
/disk1/orabkup/rcdc/system.gz
Good call Richard..
My humble apologies to the list...
He checked the backup script...
host gzip -cf1 /disk2/oradata/rcdc/system.dbf >
/disk1/orabkup/rcdc/system.gz
Good call Richard...
There was a junior DBA that he was training that had setup the backup
script. Oh well. Sorry for wasting everyone's time. A b
>From what i remember Winzip has a file limit of 4gb...
Lewis Bishop
---
Barclays Enable/ISS/OPTS Oracle Database Consultant
Phone: 020 8298 3418
Mobile: 07950 380857
Email:[EMAIL PROTECTED]
-Original Message-
Sent: 17 July 2002 20:24
To: Multiple recipients of list ORACLE-L
This he
s of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: GZip/WinZip...hot backups...
A fellow DBA had mentioned that during his disaster recovery test, gzip
had
unzipped his Solaris files but did not restore the .dbf extension. Thus
leaving him to manually rename his f
If you gzip a .dbf file, you get .dbf.gz extension.
Is that what he was doing? What's the full filename after gzipped?
Richard
-Original Message-
Sent: Wednesday, July 17, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L
A fellow DBA had mentioned that during his disaster recover
A fellow DBA had mentioned that during his disaster recovery test, gzip had
unzipped his Solaris files but did not restore the .dbf extension. Thus
leaving him to manually rename his files to include a .dbf extension. He
examined the gzip man pages but could not find any flags to set or anything
Step 7 & 8 has always generated difference of opinions :-). And you are right, I
forgot to mention step 9. Archives are backed up to tape 4x day (10gb/day). Thanks!
Gene
>>> [EMAIL PROTECTED] 03/07/02 01:21PM >>>
I would swap 7) and 8): "backup control file" then "alter system archive log
cu
Here is what worked for me this morning.
+ sqlplus -s
+ 0<<
sys/syss
set pause off feedback off pages 0 echo off
spool CCC_begin_hot_backups.sql
SELECT 'ALTER TABLESPACE ' || TABLESPACE_NAME || ' BEGIN BACKUP;'
FROM DBA_TABLESPACES;
SPOOL OFF
@CCC_begin_hot_backups.sql
EXIT
ALTER TABLESPACE SYST
Step 7 & 8 has always generated difference of opinions :-). And you are right, I
forgot to mention step 9. Archives are backed up to tape 4x day (10gb/day). Thanks!
Gene
>>> [EMAIL PROTECTED] 03/07/02 01:21PM >>>
I would swap 7) and 8): "backup control file" then "alter system archive log
cu
I would swap 7) and 8): "backup control file" then "alter system archive log
current".
You also didn't mention step 9: copy archived logs onto backup destination
media.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECT
I know this has been mentioned on the list before, but for my sanity check, will this
Hot Backup Method work?
1) Alter system archive log current ; not really needed but can't hurt.
2) Check backup status.
3) Generate datafile listing to be used by step 5.
4) Alter tablespace begin backup ;
5)
ouched by the terrorist attack on the US and anger towards the cowards
who
> would go to such extremes to achieve their goals.
> Life is real. Life is a journey, we must complete it.
> Peace!!
>
>
> We are running Oracle 8.0.5 on NT in ARCHIVELOGMODE.
> I recently scheduled three da
ourney, we must complete it.
Peace!!
We are running Oracle 8.0.5 on NT in ARCHIVELOGMODE.
I recently scheduled three daily hot backups to disk.
The process is as follows:
1.) Perl script moves the old backup folders and creates the three daily
folders that hold the hot backups to disk
2.) Batch fil
ou need to edit that script to suit your needs.
>
> HTH
> Gerardo
>
> -Original Message-
> Sent: Thursday, March 01, 2001 5:01 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi, DBAs,
>
> I want to build a duplicate DB of the production DB using
CLE-LHi, DBAs,I want to build a duplicate DB of the production DB using the hot backupswithout RMAN.Redo online log files are not included in the hot backups according toOracle recommendation.The control file is modified to suit for the new host configuration. When Ilog into svrmgrl and run this new c
.
HTH
Gerardo
-Original Message-
Sent: Thursday, March 01, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L
Hi, DBAs,
I want to build a duplicate DB of the production DB using the hot backups
without RMAN.
Redo online log files are not included in the hot backups according to
Oracle reco
Hi, DBAs,
I want to build a duplicate DB of the
production DB using the hot backups without RMAN.
Redo online log files are not included in the hot
backups according to Oracle recommendation.
The control file is modified to suit for the
new host configuration. When I log into svrmgrl
32 matches
Mail list logo
