Dataguard issues

[Chucks_k]

O/S: RHEL 4
DB: 6 node RAC + Dataguard at 10.2.0.1 using ASM

Hi all,
We are in the middle of rebuilding our standby database.
We have a done a backup of our live database. The live database has about 5files offline (these were made offline by the backup due to ORA-01200's). Once the backup completed we restored the backup on DRS using

restore database skip tablespace tbs1,tbs2,tb3 check readonly;

The restore completed successfully ( after teething problems). However, once I put the standby db into managed recovery mode no archive logs were being applied. I presume this is because of those missing tablespaces? there is no 'skip' tablespace in managed recovery as i am wondering if I can create the datafiles like so:

alter database create datafile ' /blah' as '/blah';

And hopefully let the arch redo logs 'recreate' the datafile.

Please let me know if this logic is correct or if there is any other way of progressing!

Thanks in advance,
Chucks

[hrishy]

Hi

can you run the following on standby

SELECT thread#, low_sequence#, high_sequence#
     from V$archive_gap

and also post the alert log of the standby database which is meaningful and it shows that the archive logs are not being applied

regards
Hrishy