| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: rman question
Joan,
You can use duplicate database command to create duplicate DB on a Local/Remote Host. If you use Local host to duplicate DB you need to take extra precaution as there is a danger of overwriting the production DB datafiles, so you should avoid using the NOFILENAMECHECK option.
The duplicate DB command itself creates the controlfiles with the names specified in the duplicateDB init.ora file. You don't need to create controlfiles.
You may need to archive the online logs just before the duplicate DB run script. And you need to specify LOGFILE clause in the duplicate command.
You need to specify "alter system archivelog current" before RMAN archivelog backup command. The tag includes complete backupset. You need to use seperate backupsets for datafiles and archivedlogs. Controlfiles and datafiles can be mixed in the same backupset. If you want to backup image copies, it should be done only to the disk. You can't use RMAN to backup image copies to tape. RMAN takes the coldbackup as condensed one which takes up less space, while restoring it would restore as if you took the image file cold backup. You may not need to take image copy backup in your case, whether cold/hot backup. You just need to archive the current online logs and take the whole database backups.
Probably you need to use differrent tag eachday(probably differrent shell script) as a workaround if the necessity arises to restore from the old backupset. This is just my thought as the tag concept is not of much help. Oracle might have enhanced in 9i, not sure.
Please let me know if it clarified your questions.
Thanks,
-- Janardhana Babu
-----Original Message-----
From: Joan Hsieh [mailto:joan.hsieh_at_tufts.edu]
Sent: Friday, July 13, 2001 7:11 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: rman question
Janardhana,
Thanks, another question is that on same production machine we have FM online production instance and reporting instance. We refresh reporting database everynight. (shutdown production, cp datafiles..) Can I use rman to restore all datafiles and redo files to reporting database and recreate control file to rename the reporting database? How rman deal with redo files if we use cold backup? (you know, I can do OS image copy for those files) Is that a tag name can include all the datafiles, control files and redo files image copies)?
Joan
> Janardhana Babu wrote:
>
> You may try duplicate database with the dbname the same as test
> database using RMAN.
>
> You may need to use the tag command while backing up sothat you can
> specify the tag while restoring, but, if more than one backupset
> available with the same tag (it is in most cases), it would restore
> the latest backupset with that tag. I haven't found anyother way to
> restore the old backup. Iam anxious to know if there is anyother
> possible solution from the list.
>
>
>
> -----Original Message-----
> From: Joan Hsieh [mailto:joan.hsieh_at_tufts.edu]
> Sent: Thursday, July 12, 2001 2:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: rman question
>
> Hi Dear List,
>
> We are using unix shell script to cold backup our production right now
>
> and ftp the backupset to the test machine refresh the testing instance
>
> once a week.
> My question is if I decide to use rman instead shell script. How it
> works with cold backup? Can I using rman catalog to restore a
> production
> database to test database? Can I restore obsolete backups to another
> machine using rman? Sometimes we have to restore old backups on the
> test
> machine to debug a production problem.
>
> Thanks a lot.
>
> Joan
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joan Hsieh
> INET: joan.hsieh_at_tufts.edu
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: joan.hsieh_at_tufts.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Jul 13 2001 - 11:09:27 CDT
 |
 |