BackUpDB2Cloud-SRE空间

1、到cloud.oracle.com申请30天试用的Storage
Cloud Serivce

2、填写好自己的邮箱，然后等待Oracle发送的验证码和激活邮件，激活你的Storage Clould
Service，据我的经验现在当天激活当天就可以使用Stroage Cloud
Service，虽然邮件说需要花费1~2个工作才可以完成Provioning，可见Oracle后台的处理能力相当强。

3、激活你的试用后登录你的帐户可以看到如下图Storage服务的名称比如stroagetrial1479。

点击stroagetrial1479进入详细的界面如下图，注意下图红色部分都是需在下一步在数据库服器上设置需要用到信息：

4、Setup
opc_install onlocal database machine (以为我的试用为例）

Note Down storage service name storagetrial1479 (Oracle Storage Cloud Service)

Data Center: US Commercial 2 (Time zone:
US/Central)

Identity Domain:
cntestcompanytrial56716

Subscription: Trial (Activate by 29-Mar-2015 3:13 PM
CST)

Storage CloudService

REST Endpoint:

https://cntestcompanytrial56716.storage.oraclecloud.com/v1/storagetrial1479-cntestcompanytrial56716

Download opc_installer.zip from this link (for Internal
only) or from OTN:

https://storage.us2.oraclecloud.com/v1/odbsdev-usoracleinter76305/oracle-sbt-installer/opc_installer.zip

ssh to database machine(注意你的数据库服务器需要能够上互联网):

$java -jar opc_install.jar –opcId xxx.xx@oracle.com –serviceName <storageServiceName>-identityDomain cntestcompanytrial56716 -opcPass’YourPassword‘ -libDir $ORACLE_HOME/lib
-walletDir/home/oracle/opc

注意以上红色部份不要填错,具体例子如下：

oracle@localhost:~/opc$ java -jaropc_install.jar -opcId
XX.li@oracle.com -serviceName storagetrial1479-identityDomain
cntestcompanytrial56716 -opcPass ‘Oxxxxx’ -libDir$ORACLE_HOME/lib -walletDir
/home/oracle/opc

Oracle DatabaseCloud Backup Module Install Tool, build
2014-10-27

Oracle Database Cloud Backup Modulecredentials are
valid.

Oracle Database Cloud Backup Module walletcreated in
directory /home/oracle/opc.

Oracle Database Cloud Backup Moduleinitialization file
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/opcPROD.oracreated.

Downloading Oracle Database Cloud BackupModule Software
Library from file opc_linux64.zip.

Downloaded 23169388 bytes in 589 seconds.Transfer rate
was 39336 bytes/second.

Download complete.

安装完成。

5、RMAN设置和备份

oracle@localhost:~/opc$ rman target /

RecoveryManager: Release 11.2.0.4.0 – Production on Tue
Mar 24 09:11:37 2015

connected to target database:
PROD(DBID=259864268)

RMAN> CONFIGURE CHANNEL DEVICE TYPE
sbtPARMS=’SBT_LIBRARY=/u01/app/oracle/product/11.2.0/dbhome_1/lib/libopc.so,SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/opcPROD.ora)’;

—注意以上的libopc.so和opcPROD.ora都是在第4步设置的结果。

using target database control file insteadof recovery
catalog

new RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE ‘SBT_TAPE’PARMS
‘SBT_LIBRARY=/u01/app/oracle/product/11.2.0/dbhome_1/lib/libopc.so,SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/opcPROD.ora)’;

new RMAN configuration parameters aresuccessfully
stored

–由于使用internet因此配置备份压缩以减少对带宽的需求，配置为Medium。

使用Oracle Database Backup
Service进行备份启用压缩功能时无需对高级压缩选件进行付费。

ACO licensing NOT required when used with
ODBS
HIGH, MEDIUM, LOW options generally require ACO
license
MEDIUM is recommended for cloud backups

RMAN> configure compression algorithm
‘MEDIUM’;

new RMAN
configuration parameters:
CONFIGURE COMPRESSION ALGORITHM ‘MEDIUM’ AS OF RELEASE
‘DEFAULT’ OPTIMIZE FOR LOAD TRUE;
new RMAN
configuration parameters are successfully stored

使用ODBS时RMAN强制使用加密机制，同样的恢复时也强制使用加密机制

RMAN>SET ENCRYPTION ON IDENTIFIED BY ‘oracle’
Only;
RMAN>backup device type sbt database;

本地备份大小为1447

Starting backup at 25-MAR-15
allocated
channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=23 device
type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Database Backup Service
Library VER=3.15.1.16
channel ORA_SBT_TAPE_1: starting full datafile backup
set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup
set
input datafile file number=00007
name=/u04/oradata/PROD/datafile03.dbf
input datafile
file number=00004 name=/u04/oradata/PROD/users01.dbf
input datafile
file number=00003 name=/u04/oradata/PROD/undotbs01.dbf
input datafile
file number=00001 name=/u04/oradata/PROD/system01.dbf
input datafile
file number=00006 name=/u04/oradata/PROD/users03.dbf
input datafile
file number=00002 name=/u04/oradata/PROD/sysaux01.dbf
input datafile
file number=00005 name=/u04/oradata/PROD/users02.dbf
input datafile
file number=00008 name=/u04/oradata/PROD/users04.dbf
input datafile
file number=00009 name=/u04/oradata/PROD/users05.dbf
channel
ORA_SBT_TAPE_1: starting piece 1 at 25-MAR-15
channel
ORA_SBT_TAPE_1: finished piece 1 at 25-MAR-15
piece
handle=0eq2nb3h_1_1 tag=TAG20150325T123705 comment=API Version 2.0,MMS Version
3.15.1.16
channel ORA_SBT_TAPE_1: backup set complete, elapsed
time: 02:58:09 <-网络带宽还是太慢啊
channel
ORA_SBT_TAPE_1: starting full datafile backup set
channel
ORA_SBT_TAPE_1: specifying datafile(s) in backup set
including
current control file in backup set
including
current SPFILE in backup set
channel
ORA_SBT_TAPE_1: starting piece 1 at 25-MAR-15
channel
ORA_SBT_TAPE_1: finished piece 1 at 25-MAR-15
piece
handle=0fq2nlhi_1_1 tag=TAG20150325T123705 comment=API Version 2.0,MMS Version
3.15.1.16
channel ORA_SBT_TAPE_1: backup set complete, elapsed
time: 00:01:25
Finished backup at 25-MAR-15

恢复数据库：

RMAN>Shutdown immediate

RMAN>STARTUP NOMOUNT;

RMAN> set decryption identified by
‘oracle’;

executing
command: SET decryption

RMAN>
restore database;

Starting
restore at 25-MAR-15
using channel ORA_DISK_1
using channel
ORA_SBT_TAPE_1

channel
ORA_SBT_TAPE_1: starting datafile backup set restore
channel
ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel
ORA_SBT_TAPE_1: restoring datafile 00001 to
/u04/oradata/PROD/system01.dbf
channel
ORA_SBT_TAPE_1: restoring datafile 00002 to
/u04/oradata/PROD/sysaux01.dbf
channel
ORA_SBT_TAPE_1: restoring datafile 00003 to
/u04/oradata/PROD/undotbs01.dbf
channel
ORA_SBT_TAPE_1: restoring datafile 00004 to
/u04/oradata/PROD/users01.dbf
channel
ORA_SBT_TAPE_1: restoring datafile 00005 to
/u04/oradata/PROD/users02.dbf
channel
ORA_SBT_TAPE_1: restoring datafile 00006 to
/u04/oradata/PROD/users03.dbf
channel
ORA_SBT_TAPE_1: restoring datafile 00007 to
/u04/oradata/PROD/datafile03.dbf
channel
ORA_SBT_TAPE_1: restoring datafile 00008 to
/u04/oradata/PROD/users04.dbf
channel
ORA_SBT_TAPE_1: restoring datafile 00009 to
/u04/oradata/PROD/users05.dbf
channel
ORA_SBT_TAPE_1: reading from backup piece 0eq2nb3h_1_1
channel
ORA_SBT_TAPE_1: piece handle=0eq2nb3h_1_1 tag=TAG20150325T123705
channel
ORA_SBT_TAPE_1: restored backup piece 1
channel
ORA_SBT_TAPE_1: restore complete, elapsed time: 02:04:18 <–恢复时间
Finished
restore at 26-MAR-15

RMAN>
recover database ;

Starting
recover at 26-MAR-15
using channel ORA_DISK_1
using channel
ORA_SBT_TAPE_1

starting media
recovery
media recovery complete, elapsed time:
00:00:16

Finished
recover at 26-MAR-15

RMAN> alter
database open;

database
opened

最后备注一下数据库的相关信息：

备份与恢复时使用如下语句监控备份与恢复状态：

select to_char(START_TIME,’YYYYMMDD HH24:MI:SS’) startT,
to_char(END_TIME,’YYYYMMDD HH24:MI:SS’) endT,
(end_time-start_time)*24*60*60 ELAPSED_SECONDS,MBYTES_PROCESSED,
OUTPUT_DEVICE_TYPE from v$rman_status
where status
=’RUNNING’
and MBYTES_PROCESSED >0
order by 1

SQL> /

STARTT ENDT
ELAPSED_SECONDS MBYTES_PROCESSED OUTPUT_DEVICE_TYP
—————– —————– —————
—————- —————–
20150325
22:45:06 20150326 00:48:53 7427 12232.4922 DISK

数据库全部数据文件大小：
SQL> select
sum(bytes)/1024/1024/1024 size_gb from dba_data_files;

SIZE_GB
———-
11.9912109

未经允许不得转载：SRE空间 » BackUpDB2Cloud

BackUpDB2Cloud

相关推荐

评论抢沙发

评论前必须登录！

oracle

相关推荐

评论 抢沙发

评论前必须登录！

oracle

评论抢沙发