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

Current control file

SQL > select inst_id,name from gv$controlfile

INST_ID NAME

2 + DG1/prodb/controlfile/current.276.998921677

1 + DG1/prodb/controlfile/current.276.998921677

Backup parameter file

SQL > create pfile='/home/oracle/prodb.pfile' from spfile

Modify parameter file

SQL > alter system set control_files='+DG1/prodb/controlfile/current.276.998921677','+FRG' scope=spfile sid='*'

Shut down the database

[oracle@prodb1] $srvctl stop database-d racdb-o immediate

Check statu

[oracle@prodb1] $srvctl status database-d prodb

Restore control file

[oracle@prodb1 ~] $rman target /

RMAN > startup nomount

RMAN > restore controlfile from'+ DG1/prodb/controlfile/current.276.998921677'

Starting restore at 30-JAN-19

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=34 instance=prodb1 device type=DISK

Channel ORA_DISK_1: copied control file copy

Output file name=+DG1/prodb/controlfile/current.276.998921677

Output file name=+FRG/prodb/controlfile/current.334.998923047

RMAN > exit

Restart the database

[oracle@prodb1] $srvctl stop database-d prodb-o immediate

[oracle@prodb1] $srvctl start database-d prodb

Verification

SQL > select inst_id,name from gv$controlfile

INST_ID NAME

2 + DG1/prodb/controlfile/current.276.998921677

2 + FRG/prodb/controlfile/current.334.998923047

1 + DG1/prodb/controlfile/current.276.998921677

1 + FRG/prodb/controlfile/current.334.998923047

SQL > show parameter controlfile

SQL > show parameter control

NAME TYPE VALUE

-

Control_file_record_keep_time integer 7

Control_files string + DG1/prodb/controlfile/current

.276.998921677, + FRG/prodb/con

Trolfile/current.334.998923047

Control_management_pack_access string DIAGNOSTIC+TUNING

SQL >

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.