How to Apply Archive after restore database using BRRESTORE command

[former_member556006]

Hello,

I have taken an offline backup for the database through Netbackup and restored the backup to another server and now i want to restore the archive logs in a sequence, what is the proper way or th eexact command to do so? throgh brrestore or rman?

Thanks,

[Former Member]

Hi,

Why don't you just use Oracle dataguard for this?

Restore the online backup of production and enable dataguard, it will take care of shipping and application of archive logs.

Regards,

Nick Loy

[former_member556006]

Dear Nick,

Can you give me an idea about oracle dataguard? will it sync the control files?

[Former Member]

Hi,

You shouldn't sync your control files between primary and standby databases.

Data guard takes care of archive log shipping, application.

Refer below link OR Google/Search SDN with a key word "Oracle Data guard".

ORACLE-BASE - Data Guard Physical Standby Setup in Oracle Database 11g Release 2

Regards,

Nick Loy

[former_member182657]

Apply command recover standby database;

Please use this after getting redo logs under oraarch directory.Also share are you able to connect this server from Netbackup end.

Thanks,

Gaurav

[former_member556006]

This is how archive los backup looks like in netbackup and when i want to restore it will be these names but the proper name in the system should be like this

[former_member182657]

Hi Ola,

Share value for log_archive_dest_1  from init<SID>.ora file . And for now you need to rename these logs after restoring at the location on server.

And again i request you to first go through the standard guides for successful DR creation.

[former_member556006]

This is a test DR server and we wanted first to try the backup and restore on it.

It is difficult to rename all those files.

[former_member182657]

Hi Ola,

I have taken an offline backup for the database through Netbackup and restored the backup to another server and now i want to restore the archive logs in a sequence.

First you need to consider SAP system copy methods by following System Copy - SAP NetWeaver Library: Function-Oriented View - SAP Library

On other end i.e Netbackup end are you able to get details of ID7 system on Netbackup server .Your system should be under resolvable conditions as like below.

Gaurav

[former_member556006]

Dear Guarav,

this is a different case than ID7 and ID8, here i'm trying to restore the production server to the DR server.

[former_member188883]

Hi Ola,

In your case,

Mount the DR database using

SQL> ALTER DATABASE MOUNT STANDBY DATABASE;

Then recover

SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Hope this helps.

Regards,

Deepak Kori

[former_member556006]

[former_member182657]

Hi Ola,

Okay.So you are performing DR creation for your production server.So in this regards you need to follow standard SAP DR creation methods as well as Oracle data guard steps.You just need to perform Managed recovery mode.

Simply restore left redo from Netbackup end to the new server after complete client connectivity .

Please follow guide

http://www.oracle.com/us/solutions/sap/wp-ora4sap-dataguard11g-303811.pdf

Gaurav

[former_member188883]

Hi Ola,

First shutdown the database and then mount it again. From the error message it says database was already mounted. Then execute the commands suggested

Please share fresh results.

Regards,

Deepak Kori

[former_member556006]

[former_member188883]

Hi Ola,

You need not execute startup command.

What I mentioned was , shutdown database

Mount the DR database using

SQL> ALTER DATABASE MOUNT STANDBY DATABASE;

Then recover using the command

SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Hope this helps.

Regards,

Deepak Kori

[former_member556006]

[former_member188883]

Hi Ola,

On standby database do the following

1) Shutdown database

2) startup nomount;

3) alter database mount standby database;

4) alter database recover managed standby database disconnect from session;

Hope this helps.

Regards,

Deepak Kori

[former_member556006]

[former_member182657]

Please share alert_<SID>.log file .

[former_member556006]

There is no such file, where can i find it?

[ACE-SAP]

Hello,

It can be done through either BR*Tools

Command Options for BRRECOVER - SAP Database Guide: Oracle (BC-DB-ORA-DBA) - SAP Library

Or using rman

Or simply at sqlplus prompt

recover database until cancel

Brest regards

605062 - FAQ: Restore and recovery

602497 - BRRECOVER - New tool for Oracle Restore and Recovery

23070 - Backup and Recovery: Basic Concepts

[former_member556006]

brrestore -u / -a 27401-27420=/oracle/ECP/oraarch -p /oracle/ECP/112_64/dbs/initECP1.sap -r /oracle/...

I have tried this command but it gave an error

[former_member182657]

Hi Ola,

Please correct backup_dev_type under init<SID>.ora .If you are using third party tool then provide util_file for backup_dev_type.

Other way you can restore selected logs through Netbackup Backup & Restore tool.

Hope this will help you.

Thanks,

Gaurav

[former_member556006]

non of them worked with me.

[former_member556006]

There is nothing called backup_dev_type in this file initSID.ora

Through netbackup tools the files came with different names.

[former_member182657]

Sorry it's init<SID>.sap instead init<SID>.ora.Please check there.

Gaurav

[former_member556006]

it is util_file

[former_member188883]

Hi Ola,

As you take backup using netbackup tool you need to restore the archive logs as well using netbackup tool. once this is done you may recover the database using

SQL> recover database using backup controlfile until cancel;

Hope this helps.

Regards,

Deepak Kori

[former_member556006]

[former_member188883]

Hi Ola,

Please re-create a new controfile. Looks like you have copied backup of standby database.

Remove parameters related to standby database in initSID.ora.

Post this check the recovery.

Hope this helps.

Regards,

Deepak Kori

[former_member556006]

How to recreate a control file and to be similar to one in the production server?

[former_member188883]

Hi Ola,

On Production database execute

SQL> alter database backup controlfile to trace;

This will create a trace file under saptrace/usertrace folder.

Copy this trace file to Standby server and rename it as CONTROL.SQL.

Change the SID in this file to Standby and replace "reuse" to "set"

Mount the standby database and excute the control.sql scrip

SQL> @<path of CONTROL.SQL file>

Hope this helps.

Regards,

Deepak Kori

[former_member556006]

Thanks Mr. Deepak,

but when executing the alter should the production at that time be offline?