:
[EMAIL PROTECTED] Subject: Should I post a preview of
Oracle9i RMAN Backup and Recovery
Sent by: Hand
[EMAIL PROTECTED
chapter from
Oracle9i RMAN Backup and Recovery
by Mathew Hart and Myself. I don't want to just force it on you all, or make
it seem like a marketing ploy. So, if there
are enough folks interested in me doing so, I will, and if you object let me
know and I will not (as long as the list owner
doesn't mind
posting one chapter from
Oracle9i RMAN Backup and Recovery
by Mathew Hart and Myself. I don't want to just force it on you all, or make
it seem like a marketing ploy. So, if there
are enough folks interested in me doing so, I will, and if you object let me
know and I will not (as long as the list owner
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Robert_Freema cc:
[EMAIL PROTECTED] Subject: Should I post a preview of
Oracle9i RMAN Backup
Use map network drive on your target machine and define the drive as a
directory on your recovery machine.
I mean: map drive K on the target machine as f:\backup on the recovery
machine.
Then backup to drive K.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list
Guys,
I have a target DB and a recovery catalog DB.
both r on two diff. machines in two diff. network ; both on oracle 8.1.6/win2k.
i have created the recovery catalog and registered the target database.
i want to backup a datafile DF1 in the target database. when i say,
RMAN run {
Well since you haven't gotten a reply from anyone else yet, I'll take a
crack at it, but I don't use Oracle on Windows so I may be totally off
base.
I'm assuming that your f drive is a mapped drive to your catalog db
server. I don't recall the details, but I believe that just because you
have
You have to state the directory (full path) in a format statement. Then
rman will put it where you want it.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 30, 2002 10:28 PM
Hello,
I took an RMAN backup of a database
backups: format '/backups/rman/df_d%d_t%t_s%s_p%p', where d=database name,
t=timestamp, s=set#, p=piece#.
-- Philip
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, August 31, 2002 1:13 AM
What's the file name format of the RMAN backup set? I
=database name,
t=timestamp, s=set#, p=piece#.
-- Philip
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, August 31, 2002 1:13 AM
What's the file name format of the RMAN backup set? I see files in there
that
I suspect are my backup
OK guys. I found it.
Starting up RMAN with recovery catalog.
the
list backup
command will list the backups and the locations and the file names.
ltiu
On Friday 30 August 2002 22:13, ltiu wrote:
What's the file name format of the RMAN backup set? I see files in there
that I suspect are my
Hello,
I took an RMAN backup of a database (for testing purpose only, thank
goodness). The question is, where did RMAN put the backup set files?
I read through an RMAN book and the official Oracle RMAN User Guide and
neither mentions the location of the RMAN backup ?!!
Thanks for any input
Hmmm... IIRC they should be in $ORACLE_HOME/dbs
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 30, 2002 10:28 PM
Hello,
I took an RMAN backup of a database (for testing purpose only, thank
goodness). The question is, where did
What's the file name format of the RMAN backup set? I see files in there that
I suspect are my backup sets but they have wierd file names.
Such as:
01e1el7h_1_1
with no file name extensions.
ltiu
On Friday 30 August 2002 19:53, Philip Douglass wrote:
Hmmm... IIRC they should
ORACLE-L [EMAIL PROTECTED]
UCH.COM cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: RE: How do I restore an old
RMAN backup
by: Subject: RE: How do I restore an old
RMAN backup
[EMAIL PROTECTED
/NL)
Sent by: Subject: Re: How do I restore an old
RMAN backup
[EMAIL PROTECTED
Title: How do I restore an old RMAN backup
Hi!
I want to put a copy of the production database onto a test box. The deal is that I need to use the full backup taken on August 1st. How do I tell RMAN not to restore from the last backup, but use the one that was created almost two
PROTECTED]
hGruppe.de cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: How do I restore an old
RMAN backup
by: Subject: How do I
restore an old RMAN backup
[EMAIL PROTECTED]
13-08-2002 12:13
Please respond to
ORACLE-L
Hi!
I want to put a copy of the production
Peter :
I have seen this statement it in a couple of places.
The first reference is straight from the horses mouth (not the first time
Oracle's doc has been wrong).
If you took the Oracle 8i Enterprise DBA Part 1B: Backup and Recovery
class - refer to page 12-27 - under 'Parallelization of
I am researching RMAN and I am trying to understand how to parallelize the
backup.
I have come across the following statement in various papers and in the 8i
Backup and Recovery Course Material :
It is important to set FILESPERSET in the backup.
This will ensure that each allocated
Hi Pat
I don't know where you got the information on the Rman will not parallel
the backup without using the filesperset
parameter. I only use the filesperset parameter when backing up archive
files. It is the allocation of multiple channels
that determinate if it is possible to do backup's in
I have used SET LIMIT CHANNEL to limit the size of the backup pieces. I haven't used
SETSIZE, which limits the total byte size of a backup set. However, I don't see how
this will help, since a backup command can create many backup sets.
I face the same dilema. It looks like another example
HiI am doing RMAN incremental level 0 backup
.The database size is about 150GB out of which used would be about 100GB.I don't
have a single volume with 100GB of space.So I need to distribute the backup
across several disks.
Also I need to limit the backup size in each of the
volumes
]]Sent: Thursday, 7 February 2002 11:43
AMTo: Multiple recipients of list ORACLE-LSubject:
Limiting RMAN backup size
HiI am doing RMAN incremental level 0 backup
.The database size is about 150GB out of which used would be about 100GB.I
don't have a single volume with 100GB of space.So
Hi
My problem went away when I did a startup mount of the database.
I have Rman user in TEST2 just for testing purposes (same username password
on target catalog is easier with ctrl C ctrl V)
One more question if I may.
Do you or anybody else have an example of a very complex rman
Hi All,
I'm in the process of figuring out the workings of RMAN and created 2 test
databases.
TEST1 = catalog database
TEST2 = target database
I have created the catalogs and registered the database with the catalog.
I than mad a full backup of the database TEST2 (is in Archivelog mode)
with
Jack,
What is the status of your target database?
Try having it in startup mount status rather than startup open.
The other thing you should do is to backup your control file (using Rman)
with every database backup. I do this as my last step with every backup so
that the latest changes
What version of the database are you using? My info here is based on 8.1.7.
I connect to my databases as internal to do the backups. I fire up RMAN with either
one of these commands:
rman target / catalog rman/rman@test1 (SID must be set correctly)
rman target internal/pwd@test2 catalog
This error occurs when you are trying recovery on an open database.the
database should be in MOUNT mode for recovery.
Sona
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 4:25 AM
Hi All,
I'm in the process of
I am using rman on UNIX so I am not sure how it works for NT.
The rman log will have this information. You can spool it to disk.
HTH,
Ruth
--- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 16, 2001 11:20 AM
Hi
Does anyone have any
Thanks - that worked.
Chris
Mercadante, Thomas F wrote:
Chris,
here is one way - use the SETSIZE command
7 backup
8incremental level 0
9setsize 222
it will figure out how many database files to fit into the 2 gig limit above
and create multiple pieces.
How do you split a RMAN backupset into multiple pieces? I am using
Standard Edition so I can't use multiple channels but I need to split
the backup up because of a 2GB file size limit (I'm backing up files
from a Solaris box to a Linux box).
Chris Rezek
Oracle DBA
DotClick Digital Music Network
Chris,
here is one way - use the SETSIZE command
7 backup
8incremental level 0
9setsize 222
it will figure out how many database files
DBAs
I have taken hot backup using RMAN. The total Size of the Database is
5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put
together is 4600MB.
Where am I missing the remaining 600MB?
Thanks
Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Rman backs up only used blocks, so the size difference
Johnson
--- Raj Gopalan [EMAIL PROTECTED]
wrote:
DBAs
I have taken hot backup using RMAN. The total Size
of the Database is
5200MB(By Sum(byes) in Dba_data_files). Where us the
backup file size put
together is 4600MB.
Where am I
Hi,
It's all O.K., blocks that never been used aren't backuped by rman.
oli
[EMAIL PROTECTED] wrote
DBAs
I have taken hot backup using RMAN. The total Size of the Database is
5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put
together is 4600MB.
Where am I missing
I believe that RMAN only backs up blocks that have been allocated to an oracle object
- index, segment, table, etc. If the block is in a datafile but not in use by an
oracle object (that is, the block is free), then RMAN doesn't backup those blocks.
Steve
[EMAIL PROTECTED] 04/30/01 12:25PM
Don,
You don't state whether or not you're getting the archived
redo logs at each Level 0 and 1 backup as well as the 3
archive-logs-only backups. If not, you probably should.
Also, if recovery speed will be important, those incremental
backups should be cumulative, not differential. However,
Hi, In one of our production site, I implemented RMAN backup and recovery scripts. I
did the following way.
Take a full backup using RMAN, the following things will be backed up
datafiles,Archive logs files, controlfile. I didn't use the catalog database. I used
the database's controlfile
We are in the midst of starting to use RMAN for our Backup and Recovery. The backups I
have put into place are Once a week a Level 0 full backup, three times a week Level 1
incremental and three times archive logs only.
Can anyone suggest some different recovery scenarios to test? Or if I
101 - 142 of 142 matches
Mail list logo
