As I explained in my first post, my company has just bought Oracle8i Server Entreprise Edition v8.1.7 release 3.
Our OS is windows 2000 Server Advanced Edition.
And I have bee assign the task to be the inhouse DBA.
I am a complete newbie but I have been learning much for the last couple of months.
I am actually putting in place our backu/recovery strategy.
I tried to simulate a complete lost of the database (datafile+cf+redo). The DB is in archivelog
When I try to recover I have the following errors.
My backup scripts are :
replace script alloc_disk
allocate channel d1 type disk;
replace script rel_disk
release channel d1;
replace script FullDisk
database include current controlfile
sql 'alter system archive log current';
1.I don't understand why you are trying to replace same script, the one you are using inside: FullDisk
2. catalog archivelog all;
The synatax is wrong here. Instead of all, you have to give specific file name. But what is the need for this in the first place. If the archive log files are there in the destination as per the init$SID file, they are automatically taken care by rman. Only if you have copied archived files manually to a non standard destination, then you have to use this.
Good luck !!
08-22-2003, 12:16 AM
First error is due to wrong syntax and second error is because RMAN couldn't find the logfile required for recovery.
08-22-2003, 06:10 AM
You are probably not using recovery catalog.
You should backup controlfile after datafile and archivelogs, so it includes information of backed up datafiles and archivelogs.
08-22-2003, 07:16 AM
One thing perhaps worth mentioning here is that if you are not using a recovery catalog in 8i you can probably expect some minor problems during disaster recovery. From the 8.1.7 documentation:
The only way to restore and recover when you have lost all control files and do not use a recovery catalog is to call Oracle Support Services. Support will need to know the following:
Current schema of the database
Which files were backed up
What time the files were backed up
Names of the backup pieces containing the files
This caveat seems to have been removed from the docs for 9i Release 1 onwards. I can confirm that I've successfully performed disaster recovery without a catalog in 9i onwards on a few occaisions (albeit in a test environment).
If you're not using a catalog and don't want to then perhaps to could persuade your boss to upgrade to 9i (it's free providing you pay for yearly product update restrictions).
08-22-2003, 07:21 AM
Oh, and rember to set controlfile_record_keep_time to a big enough value in init.ora (or spfile in 9i) to prevent stuff being overwritten in the controlfile. I don't think they stress this enough in the docs. Click here for details
08-22-2003, 09:00 AM
1/ I am using RMAN8i with a Oracle8i catalog to backup Oracle8i Databases.
2/ I have controlfile_record_keep_time set to 90
3/ My archive logs files are there in their default destination as per the init$SID file (since DB creation).
4/ From my readings in Oracle Doc and Metalink Notes, I know that I have while doing that to catalog archivelogs and it works when I perform it manually.
5/ The process is good. The problem comes while restoring a backup controlfile from the archivelog files on the disk.
catalog archivelogs all;
The synatax is wrong here. Instead of "all", I have to give specific file name even if if the archive log files are there in the destination as per the init$SID file.
But I am looking for a way to avoid this manual operation (subject to syntax error under pressure).
I want my archive log files in the default init.ora wich are not catalogued to be catalogued automatiquely.
Any workaround ?
I have red somewhere something like catalog archivelog until cancel;
will this work ???
08-22-2003, 10:05 AM
I still think that your problem is that your backed up controlfile does not include information of last archived log that you need for recovery.
After all, you generated it only after controlfile backup with > sql 'alter system archive log current';
Or if you are using recovery catalog, try without restoring controlfile.
08-22-2003, 10:11 AM
Thanks for your help.
I have finally found out the answer.
THERE IS NO WORKAROUND, I HAVE TO PERFORM MANUAL TASKS !!!