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='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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paula_Stankus_at_doh.state.fl.us
Sent: Tuesday, May 24, 2005 3:10 PM
To: all_about_oracle_at_hotpop.com; oracle-l_at_freelists.org 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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 24 2005 - 15:33:03 CDT