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

Adding redundant control files naturally adds a layer of protection to the security of the database. After all, single-link control files are a little dangerous, after all, they are the hub of library files. No more nonsense, into today's topic, for RAC can also be for stand-alone, if there is a demand for this aspect of the building will be released in the later stage.

The adorable dividing line

Note: library operations are required during the addition of redundant control files, please pay attention to!

Backup control file

SQL > alter session set tracefile_identifier='backupctrl'

Session altered.

SQL > alter database backup controlfile to trace

Database altered.

SQL >

View the current control file path

SQL > select name from vault control file; (can be retained, this path will be used later to restore in rman)

NAME

+ ARCH/xxx/controlfile/current.256.936287107

SQL >

Find the location of the backup controlfile file in the trace file and confirm

SQL > show parameter user

NAME TYPE VALUE

-

License_max_users integer 0

Parallel_adaptive_multi_user boolean TRUE

Redo_transport_user string

User_dump_dest string / u02/app/oracle/diag/rdbms/xxx/xxx1/trace

SQL >

If the RAC environment is ASM, that is, two nodes share a spfile, you can operate on either node, but closing the library requires both nodes to execute.

SQL > alter system set control_files='+ARCH/xxx/controlfile/current.256.936287107','+DATADG' scope=spfile

Close the library:

Alter system checkpoint; / / create checkpoints manually to avoid database jams caused by checkpoints created in the background when shutting down the database.

Alter system archive log current; / / switches redo for all instances and generates archive logs.

Shutdown immediate

Start the database to nomount

Srvctl start database-d xxx-o nomount

RMAN > restore controlfile from'+ ARCH/xxx/controlfile/current.256.936287107'

SQL > shutdown immediate / / both instances need to be operated

ORA-01507: database not mounted

Open the database

Srvctl start database-d xxx

SQL > select open_mode from v$database

OPEN_MODE

-

READ WRITE

SQL > show parameter control_files

NAME TYPE VALUE

Control_files string + ARCH/xxx/controlfile/curren

T.256.936287107, + DATADG/xxx/controlfile/current.263.93652

9407

View cluster status

Extend:

For those of you who watch this document, you need to know the following small details

By default, my control files are placed under ARCH instead of DATADG.

The "xxx" that appears in the document and the place covered by the pink color is the instance name of the database.

According to the old rule, the red mark is the part that the landlord thinks needs to be implemented in the database.

Srvctl start database-d xxx is executed under the oralce user (your own opinion only)

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.