RE: duplicate command to clone database to another host
- From: <Paula_Stankus@xxxxxxxxxxxxxxx>
- To: <rgramolini@xxxxxxxxxxxxxxx>, <all_about_oracle@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 May 2005 15:36:43 -0400
Thanks Ruth,
I have actually accomplished a duplication before by using a full
backup. So I am not sure why incremental level 0 is necessary. I do a
full database backup which apparently gets the controlfile, I then
archivelog current all, then backup the archives and remove archives
from the file system so that seems to match what you are doing.
I think it is the until time that I needed and how to find out the
exactly correct one and thank you sooo much for the rman sql to see and
the advice on setting the until time (plus one second). I will try that
and let you know.
Thanks again Ruth.
You're the best!
-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini@xxxxxxxxxxxxxxx]=20
Sent: Tuesday, May 24, 2005 3:28 PM
To: Stankus, Paula G; all_about_oracle@xxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: duplicate command to clone database to another host
Paula,
Use this sql against the rman schema in the recovery catalog database:
select max(to_char(completion_time,'YYYY-MM-DD:hh24:mi:ss')) from
RMAN.rc_backup_datafile where db_name=3D'YOUR_DB';
If you aren't using a recovery catalog use the system logs to find out
the end time of the backup. Then use this time plus 1 second to account
for the fractions of a second, to determine the proper until time. Then
use a set until time clause in your duplicate script as shown in
O_H/rdbms/demo/case4.rcv.
The archivelogs will only be backed up if you tell rman to do so. Here
are my 2 backup statements: the first does the db backup and the second
backups the archivelogs (after a build in switch log) and deletes the
input if successful.
backup incremental level 0
( database include current controlfile );
backup ( archivelog all delete input );
As you can see, I use incremental level 0 instead of a full backup.
This allows a point in time recovery or duplicate.
I hope this helps, if not, let me know. I may be able to help more.
Call me if you want - 802-828-5708.
Yours,
Ruth
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Tuesday, May 24, 2005 3:10 PM
To: all_about_oracle@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: duplicate command to clone database to another host
I am using the duplicate command in RMAN to duplicate a database to
another server.
I have not specified set until time but I wish to have to go to the last
night's backup which is run at 3:00 according to the crontab job.
When I recover without using any set until time I get errors that state
that there are missing log files. When I copy over the existing archive
files from the production server they are at a much later release then
what is being requested during recovery of the "duplicate" database.
So - those archivelogs are not online.
Should I set the set until to get the hot backup from last night and
what should I set the time to - 3:00 a.m. or later??
Are those logs actually backed up?
How can I be sure that my database full backup gets all the necessary
logs so I can recover from the last night's backup?
Thanks,
Paula
--
//www.freelists.org/webpage/oracle-l
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 33468615) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D33468615&m=3D6acc=
5b140
d89
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D33468615&m=3D6acc=
5b140
d89
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D33468615&m=3D6acc=
5b140
d89
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS
--
//www.freelists.org/webpage/oracle-l
Other related posts:
