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

1. Restore parameter file-any read / write path / u01/oracle/recoverydata (database needs to be in nomount or mount state)

2. Modify the parameter file-pfile_dmsdb.ora

# plusdb.db_cache_size=11408506880

# plusdb.java_pool_size=939524096

# plusdb.large_pool_size=805306368

Plusdb.oracle_base='/u01/orabase'#ORACLE_BASE set from environment

# plusdb.pga_aggregate_target=34225520640

# plusdb.sga_target=19864223744

# plusdb.__shared_io_pool_size=268435456

# plusdb.shared_pool_size=6174015488

Plusdb.streams_pool_size=0

.audit _ file_dest='/u01/oracle/admin/plusdb/adump'

#. Background_dump_dest='/u01/oracle/diag/rdbms/plusdb'

. compatible='11.2.0.4.0'

.control _ files='/u01/oracle/oradata/plusdb/controlfile/current.256.952221069'

.core _ dump_dest='/u01/oracle/diag/rdbms/plusdb'

.db _ block_size=8192

.db _ create_file_dest=''

.db _ domain=''

.db _ name='plusdb'

.db _ recovery_file_dest='/u01/oracle/fast_recovery_area'

.db _ recovery_file_dest_size=4282368

.diagnostic _ dest='/u01/oracle'

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

.log _ archiveformat='%t%s_%r.dbf'

.memory _ target=12884901888

.open _ cursors=300

.clients = 1500

.remote _ login_passwordfile='exclusive'

.clients = 1655

Plusdb.thread=1

Plusdb.undo_tablespace='UNDOTBS1'

#. User_dump_dest='/u01/oracle/diag/rdbms/plusdb'

* .diagnostic_dest='/u01/oracle'

3. Create spfile and start Oracle instance to STARTED based on the recovered parameter file

3.1. Close the database

Shutdown abort

Create a spfile file based on the recovered parameter file

Create spfile from pfile='/u01/oracle/recoverydata/pfile_dmsdb.ora'

3.3.Open database to nomount status

Startup nomount

3.3.The database status should be STARTED.

Select status from vault instances4, recover log files, control files and data files and redirect-any read / write path / u01/oracle/recoverydata

5. Rename online log file @ / home/oracle/test.sqlbr/ > 4. Restore log file, control file and data file and redirect-any read / write path / u01/oracle/recoverydata

5. Rename the online log file @ / home/oracle/test.sql

Alter database rename file'+ FRA/mhdb/onlinelog/group_1.438.982084575' to'/ oradata/oracle/oradata/mhdb/redo01_2.log'

Alter database rename file'+ DATA/mhdb/onlinelog/group_2.262.982084577' to'/ oradata/oracle/oradata/mhdb/redo02_1.log'

Alter database rename file'+ FRA/mhdb/onlinelog/group_2.260.982084577' to'/ oradata/oracle/oradata/mhdb/redo02_2.log'

Alter database rename file'+ DATA/mhdb/onlinelog/group_3.266.982084577' to'/ oradata/oracle/oradata/mhdb/redo03_1.log'

Alter database rename file'+ FRA/mhdb/onlinelog/group_3.259.982084579' to'/ oradata/oracle/oradata/mhdb/redo03_2.log'

Alter database rename file'+ DATA/mhdb/onlinelog/group_4.261.982086153' to'/ oradata/oracle/oradata/mhdb/redo04_1.log'

Alter database rename file'+ FRA/mhdb/onlinelog/group_4.258.982086153' to'/ oradata/oracle/oradata/mhdb/redo04_2.log'

Alter database rename file'+ DATA/mhdb/onlinelog/group_5.260.982086155' to'/ oradata/oracle/oradata/mhdb/redo05_1.log'

Alter database rename file'+ FRA/mhdb/onlinelog/group_5.257.982086155' to'/ oradata/oracle/oradata/mhdb/redo05_2.log'

Alter database rename file'+ DATA/mhdb/onlinelog/group_6.259.982086155' to'/ oradata/oracle/oradata/mhdb/redo06_1.log'

Alter database rename file'+ FRA/mhdb/onlinelog/group_6.408.982086157' to'/ oradata/oracle/oradata/mhdb/redo06_2.log'

6. Start the database

Alter database open resetlogs

Select name from v$datafile query oracle data file location

Select member from vault log file; view the redo path

Love number operation:

# ps-ef | grep esf

# cd / etc/init.d

#. / AnyBac status

#. / AnyBac stop

# su-oracle

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.