Hi like to seek help on READONLY tablespaces especially on restore and recovery
I'm using control file (nocatalog) in running RMAN backup and restore:
#1) I set READONLY on a few tablespaces and run backup on these select tablespaces,
run {
allocate channel d1 type disk;
backup full format 'J:\icaritas_rman\rotspc\%d_bkpc%u%p%c' maxpiecesize 16000
( tablespace 'LTAB27','LTAB61');
release channel d1;
}
then after a few weeks of regular full database backups using SKIP READONLY, I notice in the backup control file
the entries pertaining to the READONLY tablespace seems gone. How will one restore the READONLY tablespace?
Should I have included a step to backup the control file?
#2) Like to ask also how to restore, (assuming on another host) and be able to successfully recover and open it resetlogs,
Using the backup control file, I'm able to restore the READONLY tablespace
run {
allocate channel d1 type disk;
restore (tablespace 'LTAB27','LTAB61') from tag TAG20170427T185223;
release channel d1;
}
also I've restored the rest of the database using the latest backup control (from weekly regular backup)
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
RESTORE DATABASE FROM TAG 'TAG20170429T190116' skip readonly;
-- RECOVER DATABASE ;
release channel d1;
release channel d2;
}
What is the correct command to recover database and if ever open it resetlogs?
Should I use RESTORE DATABASE CHECK READONLY? I tried this but it deleted the READONLY files
restored earlier.
Is there such command like RECOVER DATABASE SKIP READONLY? Am getting invalid option error here,
(must be some syntax error). Or should the READONLY tablespaces be set to offline,
and proceed with the recovery to open the database?