Shulou(Shulou.com)06/01 Report--

This manual is limited to VEEAM Backr backup Oracle 11g scenarios.

1. Start to check the VEEAM service status

Veeam Backup Service service

VeeamBrokerSvc service

Veeam Cloud Connect Service service

Veeam Data Mover Service service

Veeam Guest Catalog Service service

Veeam Installer Service service

Veeam Mount Service service

Veeam vPower NFS Service service

And SQL Server related services

two。 Open Oracle 11g archive mode 2. 1. Check the current archiving mode

In Sqlplus mode

Shutdown immediate

Startup mount

Archive log list

R Note: Database Log mode is No Archive Mode by default

Show parameter db_recovery_file

2.2. Log file settings

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH SID='orac1'

# set the archive log file size of sales

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST ='C:\ Oracle' SCOPE=BOTH SID='orac1'

# set the archive log path of orac1

# display current configuration information

3. Create a new Oracle backup task 3.1. Modify the Windows host file

Notepad opens C:\ Windows\ System32\ Drivers\ etc\ hosts

3.2. Create a backup task

3.3. Run backup

4. Simulate ORACLE failure

Shut down the database

Sqlplus / nolog

Connect / as sysdba

Shutdown immediate

Delete control file

Delete database files

Delete archive log file

Failed to start the database, no control file is indicated, and the simulation failure is successful.

5. Recovery proc

5.1. VEEAM client operation

Open the restore wizard and select the application category

Select the Oracle database type

Select the restore point to restore

End the restore wizard

Enter Explorer for Oracle

Select restore point

Confirm and perform restore

Start restore

The recovery was successful.

5.2. Restore post-processing 5.2.1 check restore files

Restore the database to the Cancel state

Sqlplus / nolog

Connect / as sysdba

Shutdown immediate

Startup mount

RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROL FILE

5.2.2 reset Log

In Sqlplus mode

Alter database open resetlogs

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.