Manual registering of missing files

Manual registering of missing files

1.      1.)  Connect to the standby database (TRAXSP) on SYDDC1TRX01 Server using sqlplus tool and confirm the right database is connected by executing the below SQL command.

SQL> select instance_name,status from v$instance;

2.       2.) Check the missing files in TRAXSP.

a.       To check the number of sequences missing along with the higher and lower sequence:

SQL> select * from v$archive_gap;

b.       To check the missing file sequence number:

SQL> select sequence#,applied,status from v$archived_log where applied='NO';

3. )Using the sequence number, copy the missing file from (/arch/oraarchive/traxp/) MELDC1TRX01 Server to the appropriate location (/arch/oraarchive/traxsp/) in SYDDC1TRX01 Server.

It can be copied by using scp command.

·         Connect to SYDDC1TRX01 server and fire the below command from OS prompt.

scp oracle@meldc1trx01:/arch/oraarchive/traxp/<missing sequence name> /arch/oraarchive/traxsp/

OR

·         Connect to meldc1trx01 server and fire the below command from OS prompt.

scp /arch/oraarchive/traxp/<missing sequence name>  oracle@meldc1trx02:/arch/oraarchive/traxsp/

                                                                                                                                                                            

Provide password when asked.

4. )On the Standby database, type the below command to register the missing files manually.

SQL> alter database register logfile ‘/arch/oraarchive/traxsp/<missing sequence name>;

For example:

SQL> alter database register logfile ‘/arch/oraarchive/traxsp/TRAXP_ARC1235911_694072247.1';