RE: duplicate command to clone database to another host
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <Paula_Stankus@xxxxxxxxxxxxxxx>, <all_about_oracle@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 May 2005 15:28:16 -0400
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='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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
