SnapCnter for Oracle backup and restore

[chinchillaking]

Hi,

refer SMO, when backup and it will take snapshot data, archive, control file each LUN.

but SnapCenter for Oracle, when backup and it will take snapshot data and archive only, may I know more deatil as below?

- why control file did not take snapshot when backup, how SnapCenter restore control file?

- if use SnapCenter for Oracle backup RAC with ASM daily, bin, data, archive, control file and redo log seperate LUN, could use snap restore LUN snapshot replace use SnapCenter restore?

Best regards,

Chung

[chinchillaking]

Hi All,

I found the KB https://kb.netapp.com/app/answers/answer_view/a_id/1001219, the backup control file  'control-bkp-<id#>.bkp'. and ascii file named control-bkp-<id#>.trc is created in the .snapshot of the volume.

But I cannot found the backup control file in ASM disk group, anyone know the backup controler file location in ASM disk group?

SQL> show parameter control_files

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string +REDO/RACTEST/CONTROLFILE/curr
ent.256.980006545

ASMCMD> pwd
+
ASMCMD> ls
ARCH/
CTRL/
DATA/
FRA/
GIMR/
OCR_VOTE/
REDO/
ASMCMD> find / current.256.980006545
+REDO/RACTEST/CONTROLFILE/Current.256.980006545
ASMCMD>
ASMCMD> find / current.256.*
+REDO/RACTEST/CONTROLFILE/Current.256.980006545
ASMCMD>
ASMCMD> find / control-bkp-*
ASMCMD>

Best regards,

Chung

[stanton]

Backup of controlfile to trace cannot be made on the ASM diskgroup since ASM will allow a text file in a data DG. For ASM environments, SCO points the "backup controlfile to trace" command to the /tmp directory and then copies the complete content in the NSM database (SnapCenter's repository) for future use.

[chinchillaking]

Hi Stanton,

Thanks for your rpely.

Prd site

- two Redhat Oracle 12C RAC with ASM

- NetApp FAS8200 present individual LUNs for Oracle bin, data, log, redo and control file individual ASM disk group

- SnapCenter for Oracle daily 00:30 backup (data + log + control file) successful

- daily 01:30 SnapMirror to DR site FAS2650

DR dite

- dev Redhat Oracle 12C stanalone

- FAS2650

 Refer best pactices https://www.netapp.com/us/media/tr-4700.pdf   page 26, Disaster Recovery 2 as below.

---------------------------------------------------

 2. If an entire site fails such as storage, compute, host, or network:

You must break the SnapMirror relationship across the storage layer, using the latest application-consistent Snapshot copy, and bring up the storage on the disaster recovery site.

----------------------------------------------------

- break SnapMirror relationship

- manual snap restore yesterday snapshot for data and log volumes

- dev Redhat Oracle 12C stanalone import above ASM disk group

- fail bring up the database due to control file did not have snapshot/backup restore to yesterday status

Refer SnapCenter will take snapshot for data and log volumes when backup, could move control file LUNs to log volume (volume include log and control file LUNs) with SnapCenter daily backup, when simulate above disaster recovery, manual restore data and log/control_file volume snapshot for above disaster recovery?

Best regards,

Chung

[stanton]

I'm assuming you did the restore through SnapCenter.  Did you choose to restore the control file or just the datafiles? What recovery options did you choose?

[chinchillaking]

Hi Stanton,

Just simulate disastre recovery mention in best practcise and restore from OnTap "snap restore" command.

Best regards,

Chung

[stanton]

If you are going to manually run snap restore from ONTAP, then you will manually need to recreate the control file.  If you use SnapCenter to restore then it will create the control file for you.