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

# Fast database replication based on HP 3Par snapshot synchronization technology

Production cluster database, through the storage of underlying replication technology to generate snapshot data, the use of snapshot data, the database can be quickly opened, the new database can be used for testing, recovery and other purposes. The following are the specific steps to start the fast database, and the underlying replication operation is completed by the storage manufacturer.

Confirm host environment information

Fgscrmdb# [/] machinfofgscrmdb# [/] hostname check 3Par storage mount (root) fgscrmdb# [/] 3parinfo-I

Device File Name Size [MB]

=

/ dev/rdisk/disk212 1024

/ dev/rdisk/disk213 1024

/ dev/rdisk/disk214 1024

/ dev/rdisk/disk215 1024

/ dev/rdisk/disk216 1024

/ dev/rdisk/disk217 512000

/ dev/rdisk/disk218 512000

/ dev/rdisk/disk219 512000

/ dev/rdisk/disk220 512000

/ dev/rdisk/disk221 512000

/ dev/rdisk/disk222 512000

/ dev/rdisk/disk223 512000

/ dev/rdisk/disk224 512000

/ dev/rdisk/disk225 512000

/ dev/rdisk/disk226 512000

/ dev/rdisk/disk227 512000

/ dev/rdisk/disk228 512000

/ dev/rdisk/disk229 512000

/ dev/rdisk/disk230 512000

/ dev/rdisk/disk231 512000

/ dev/rdisk/disk232 512000

/ dev/rdisk/disk233 512000

/ dev/rdisk/disk234 512000

/ dev/rdisk/disk235 512000

/ dev/rdisk/disk236 512000

/ dev/rdisk/disk237 512000

/ dev/rdisk/disk238 512000

/ dev/rdisk/disk239 512000

/ dev/rdisk/disk240 512000

/ dev/rdisk/disk241 512000

/ dev/rdisk/disk242 512000

/ dev/rdisk/disk243 512000

/ dev/rdisk/disk244 512000

/ dev/rdisk/disk245 512000

/ dev/rdisk/disk246 512000

/ dev/rdisk/disk247 512000

/ dev/rdisk/disk248 512000

/ dev/rdisk/disk249 512000

/ dev/rdisk/disk250 512000

/ dev/rdisk/disk251 512000

/ dev/rdisk/disk252 512000

/ dev/rdisk/disk253 512000

/ dev/rdisk/disk254 512000

/ dev/rdisk/disk255 512000

/ dev/rdisk/disk256 512000

/ dev/rdisk/disk257 512000

/ dev/rdisk/disk258 512000

/ dev/rdisk/disk259 512000

/ dev/rdisk/disk260 512000

/ dev/rdisk/disk261 512000

/ dev/rdisk/disk262 512000

3. Modify 3Par storage disk ownership groups and permissions (root)

Fgscrmdb# [/] 3parinfo-I | grep pubdb | awk'{print "chown grid:asmadmin" $1}'> / tmp/3pardisk.pubdb.chown

Fgscrmdb# [/] 3parinfo-I | grep pubdb | awk'{print "chmod 660" $1}'> / tmp/3pardisk.pubdb.chmod

Fgscrmdb# [/] sh / tmp/3pardisk.pubdb.chown

Fgscrmdb# [/] sh / tmp/3pardisk.pubdb.chmod

4. Grid users perform ASM disk group disk discovery scan

Grid@fgscrmdb: [/ home/grid] kfod aisle RDIKUGUR 'disks=all ds=true o=all

Disk Size Path

= =

1: 1024 Mb / dev/rdisk/disk212

2: 1024 Mb / dev/rdisk/disk213

3: 1024 Mb / dev/rdisk/disk214

4: 1024 Mb / dev/rdisk/disk215

5: 1024 Mb / dev/rdisk/disk216

6: 512000 Mb / dev/rdisk/disk217

7: 512000 Mb / dev/rdisk/disk218

8: 512000 Mb / dev/rdisk/disk219

9: 512000 Mb / dev/rdisk/disk220

10: 512000 Mb / dev/rdisk/disk221

11: 512000 Mb / dev/rdisk/disk222

12: 512000 Mb / dev/rdisk/disk223

13: 512000 Mb / dev/rdisk/disk224

14: 512000 Mb / dev/rdisk/disk225

15: 512000 Mb / dev/rdisk/disk226

16: 512000 Mb / dev/rdisk/disk227

17: 512000 Mb / dev/rdisk/disk228

18: 512000 Mb / dev/rdisk/disk229

19: 512000 Mb / dev/rdisk/disk230

20: 512000 Mb / dev/rdisk/disk231

21: 512000 Mb / dev/rdisk/disk232

22: 512000 Mb / dev/rdisk/disk233

23: 512000 Mb / dev/rdisk/disk234

24: 512000 Mb / dev/rdisk/disk235

25: 512000 Mb / dev/rdisk/disk236

26: 512000 Mb / dev/rdisk/disk237

27: 512000 Mb / dev/rdisk/disk238

28: 512000 Mb / dev/rdisk/disk239

29: 512000 Mb / dev/rdisk/disk240

30: 512000 Mb / dev/rdisk/disk241

31: 512000 Mb / dev/rdisk/disk242

32: 512000 Mb / dev/rdisk/disk243

33: 512000 Mb / dev/rdisk/disk244

34: 512000 Mb / dev/rdisk/disk245

35: 512000 Mb / dev/rdisk/disk246

36: 512000 Mb / dev/rdisk/disk247

37: 512000 Mb / dev/rdisk/disk248

38: 512000 Mb / dev/rdisk/disk249

39: 512000 Mb / dev/rdisk/disk250

40: 512000 Mb / dev/rdisk/disk251

41: 512000 Mb / dev/rdisk/disk252

42: 512000 Mb / dev/rdisk/disk253

43: 512000 Mb / dev/rdisk/disk254

44: 512000 Mb / dev/rdisk/disk255

45: 512000 Mb / dev/rdisk/disk256

46: 512000 Mb / dev/rdisk/disk257

47: 512000 Mb / dev/rdisk/disk258

48: 512000 Mb / dev/rdisk/disk259

49: 512000 Mb / dev/rdisk/disk260

50: 512000 Mb / dev/rdisk/disk261

51: 512000 Mb / dev/rdisk/disk262

ORACLE_SID ORACLE_HOME

+ ASM / grid/app/11.2.0.4/grid5. Grid users mount new disk groups

Grid@fgscrmdb: [/ home/grid] sqlplus / as sysasm

SQL > alter diskgroup PUBDBDATA_DG mount

SQL > alter diskgroup YYDBADATA_DG mount

SQL > alter diskgroup YYDBBDATA_DG mount

6. Check disk group information in crs resourc

Grid@fgscrmdb: [/ home/grid] crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.FGSCRM_OCRDG.dg

ONLINE ONLINE fgscrmdb

Ora.LISTENER.lsnr

ONLINE ONLINE fgscrmdb

Ora.PUBDBDATA_DG.dg

ONLINE ONLINE fgscrmdb

Ora.YYDBADATA_DG.dg

ONLINE ONLINE fgscrmdb

Ora.YYDBBDATA_DG.dg

ONLINE ONLINE fgscrmdb

Ora.asm

ONLINE ONLINE fgscrmdb Started

Ora.ons

OFFLINE OFFLINE fgscrmdb

Grid@fgscrmdb: [/ home/grid] sqlplus / as sysasm

SQL > show parameter asm

NAME TYPE VALUE

Asm_diskgroups string PUBDBDATA_DG, YYDBADATA_DG, YY

DBBDATA_DG

Asm_diskstring string / dev/rdisk/disk*

7. Create the pfile file of the original production database and adjust the parameter values

Grid@fgscrmdb: [/ home/grid] asmcmd

ASMCMD > find-type PARAMETERFILE. / *

+ PUBDBDATA_DG/PUBDB/PARAMETERFILE/spfile.267.923089341

+ PUBDBDATA_DG/PUBDB/spfilepubdb.ora

+ YYDBADATA_DG/YYDBA/PARAMETERFILE/spfile.267.923058269

+ YYDBADATA_DG/YYDBA/spfileyydba.ora

+ YYDBBDATA_DG/YYDBB/PARAMETERFILE/spfile.267.923059267

+ YYDBBDATA_DG/YYDBB/spfileyydbb.ora

ASMCMD > cp + PUBDBDATA_DG/PUBDB/spfilepubdb.ora / tmp

Copying + PUBDBDATA_DG/PUBDB/spfilepubdb.ora-> / tmp/spfilepubdb.ora

ASMCMD > cp + YYDBADATA_DG/YYDBA/spfileyydba.ora / tmp

Copying + YYDBADATA_DG/YYDBA/spfileyydba.ora-> / tmp/spfileyydba.ora

ASMCMD > cp + YYDBBDATA_DG/YYDBB/spfileyydbb.ora / tmp

Copying + YYDBBDATA_DG/YYDBB/spfileyydbb.ora-> / tmp/spfileyydbb.ora

Oracle@fgscrmdb: [/ home/oracle] cd $ORACLE_HOME/dbs

Oracle@fgscrmdb: [/ oracle/app/oracle/11.2.0.4/db_1/dbs] cp / tmp/*.ora. /

Oracle@fgscrmdb: [/ oracle/app/oracle/11.2.0.4/db_1/dbs] strings spfilepubdb.ora > initpubdb.ora

Oracle@fgscrmdb: [/ oracle/app/oracle/11.2.0.4/db_1/dbs] vi initpubdb.ora

# the parameters starting with _ _ are the dynamic parameters recorded in the database, which can be deleted

. _ gby_hash_aggregation_enabled=FALSE

. _ gc_policy_time=0

. _ high_priority_processes='VKTM | LMS | LGWR'

. _ memory_imm_mode_without_autosga=FALSE

. _ optim_peek_user_binds=FALSE

. _ optimizer_adaptive_cursor_sharing=FALSE

. _ optimizer_cartesian_enabled=FALSE

. _ optimizer_extended_cursor_sharing='NONE'

. _ optimizer_extended_cursor_sharing_rel='NONE'

. _ optimizer_use_feedback=FALSE

. _ PX_use_large_pool=TRUE

. _ undo_autotune=FALSE

. _ use_adaptive_log_file_sync='FALSE'

.audit _ trail='db'

.commit _ logging='BATCH'

. compatible='11.2.0.4.0'

.control _ files='+PUBDBDATA_DG/pubdb/controlfile/current.345.930096785'#Restore Controlfile

.db _ block_size=8192

.db _ create_file_dest='+PUBDBDATA_DG'

.db _ domain=''

.db _ files=10000

.db _ name='pubdb'

.deferred _ segment_creation=FALSE

.diagnostic _ dest='/oracle/app/oracle'

.customers ='(PROTOCOL=TCP) (SERVICE=pubdbXDB)

.event = '28401 TRACE NAME CONTEXT FOREVER, LEVEL 1pur10949 TRACE NAME CONTEXT FOREVER'

.fast _ start_parallel_rollback='HIGH'

.open _ cursors=1000

.parallel _ force_local=TRUE

.clients = 8000

. recyclebin='OFF'

.remote _ login_passwordfile='exclusive'

.session _ cached_cursors=500

.clients = 1655

* .undo_retention=10800

# parameters to be adjusted, cluster_database needs to be changed to FALSE

* .cluster_database=FALSE

# need to pay attention to creating the necessary directory structure

* .audit_file_dest='/oracle/app/oracle/admin/pubdb/adump'

# parameters to be deleted

.log _ archive_dest_1='LOCATION=+PUBDBARCH_DG'

.remote _ listener='pubdb-scan:1521'

# the parameters related to the instance need to be modified, delete the contents of node 2, and modify the value of node 1 to

.instance _ number=1

.thread = 1

.undo _ tablespace='UNDOTBS1'

# memory parameters need to be adjusted

.sga _ max_size=100G

.sga _ target=0

.db _ cache_size=60G

.shared _ pool_size=20G

.large _ pool_size=2G

.pga _ aggregate_target=20G

8. Create the necessary directory `oracle@fgscrmdb: [/ oracle/app/oracle/11.2.0.4/db_1/dbs] mkdir-p/oracle/ app/oracle/admin/pubdb/ adump`9. Create a password file `oracle@fgscrmdb: [/ oracle/app/oracle/11.2.0.4/db_1/dbs] orapwd file=orapwpubdb password= 08080808`10. Adjust oracle executable program permissions. Without adjusting permissions, oracle users cannot access disk group content.

Oracle@fgscrmdb: [/ oracle/app/oracle/11.2.0.4/db_1/bin] ls-la oracle

-rwsr-s--x 1 oracle oinstall 574113064 Mar 9 09:41 oracle

Oracle@fgscrmdb: [/ home/oracle] su-grid

Grid@fgscrmdb: [/ home/grid] cd $ORACLE_HOME/bin

Grid@fgscrmdb: [/ grid/app/11.2.0.4/grid/bin]. / setasmgidwrap o=/oracle/app/oracle/11.2.0.4/db_1/bin/oracle

Grid@fgscrmdb: [/ grid/app/11.2.0.4/grid/bin] ls-la / oracle/app/oracle/11.2.0.4/db_1/bin/oracle

-rwsr-s--x 1 oracle asmadmin 574113064 Mar 9 09:41 / oracle/app/oracle/11.2.0.4/db_1/bin/oracle

11. Create a spfile parameter file, start the instance for testing (first verify through pfile startup, then create spfile correctly, and restart the database instance with spfile)

Oracle@fgscrmdb: [/ oracle/app/oracle/11.2.0.4/db_1/dbs] rm spfilepubdb.ora

Oracle@fgscrmdb: [/ oracle/app/oracle/11.2.0.4/db_1/dbs] export ORACLE_SID=pubdb

SQL > startup nomount

SQL > create spfile from pfile

SQL > startup force nomount

SQL > alter database mount

SQL > alter database noarchivelog

SQL > alter database open

SQL > shutdown immediate

twelve。 Register database resources-d Unique name for the database-n Database name (DB_NAME), if different from the unique name given by the-d option-o ORACLE_HOME path-p Server parameter file path-a "" Comma separated list of disk groups

Oracle@fgscrmdb: [/ home/oracle] srvctl add database-d pubdb-n pubdb-o $ORACLE_HOME-p $ORACLE_HOME/dbs/spfilepubdb.ora

Oracle@fgscrmdb: [/ home/oracle] srvctl config database-d pubdb

13. Test starts and stops database resources through cluster

Oracle@fgscrmdb: [/ home/oracle] srvctl start database-d pubdb

Oracle@fgscrmdb: [/ home/oracle] crsctl stat res-t

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.