[Oracle Datagard] recover from library Ora-16032:parameter ORA-07286: Issue

The machine room is powered down, so Oracle's Datagard from the library needs to be restarted:

1 Login sqlplus Start, error message:

Sql> STARTUP MOUNT;

Ora-16032:parameter log_archive_dest_3 Destination string cannot be translated
Ora-07286:sksagdi:cannot obtain device information.
linux-x86_64 error:2: No such file or directory

2 Go to see the exact path to the log_archive_dest_3 .

[Email protected] ~]# su-oracle
[Email protected] ~]$ echo $ORACLE _home
/oracle/app/oracle/product/11.2.0/dbhome_1
[Email protected] ~]$ cd/oracle/app/oracle/product/11.2.0/dbhome_1
[Email protected] dbhome_1]$
[Email protected] dbhome_1]$ CD DBS
[email protected] dbs]$ LL
Total Dosage 13160
-RW-RW----. 1 Oracle DBA 1544 May 4 14:49 Hc_powerdes.dat
-rw-r--r--. 1 Oracle DBA 2851 May Init.ora
-rw-r-----. 1 Oracle DBA 24 August LKPDDGUNQ
-rw-r-----. 1 Oracle Oinstall 1536 August orapwpowerdes
-rw-r-----. 1 Oracle DBA 13451264 April 05:00 snapcf_powerdes.f

-rw-r-----. 1 Oracle DBA 5632 August Spfilepowerdes.ora

3 # found the path

[Email protected] dbs]$ strings Spfile*.ora|grep dest_3
*.log_archive_dest_3= ' location=/data/oracle/oradgdata/standby_archive valid_for= (STANDBY_LOGFILES,STANDBY_ROLE) Db_unique_name=pddgunq '



4 Check Path to troubleshoot problems
[Email protected] data]# ls-l/data/oracle/oradgdata/standby_archive
LS: Unable to access/data/oracle/oradgdata/standby_archive: No file or directory

[Email protected] dbs]$ mkdir-p/data/oracle/oradgdata/standby_archive
mkdir: Unable to create directory "/data/oracle": Read-only file system

[Email protected] dbhome_1]$ df-h
File systemCapacity has been used with available percent mount points
/dev/mapper/volgroup-lv_root
50G 28G 19G 60%/
Tmpfs 8.9G 3.0G 5.9G 34%/DEV/SHM
/dev/sda2 485M 76M 384M 17%/boot
/DEV/SDA1 200M 260K 200M 1%/boot/efi
/dev/mapper/volgroup-lv_home
76G 37G 36G 51%/Home
/DEV/SDB1 1008G 221G 737G 24%/data

5 Problem Solving

/data already exist, just can't use, Google, see 2 kinds of solutions
mkdir: Could not create directory ' XX ': read-only file system
Touch: Unable to touch "XX": Read-only file system,
Creating files and directories prompts for errors,
Here's how to fix it:
First, restart the server
That's all I'm going to do.
Second
If the first is not good enough,
We have to repair the hard drive,
Boot into repair mode,
See in which directory you are able to create files and then use Fsck.ext3-y. Mount Partition ... The repair will be OK.
Reference: HTTP://HI.BAIDU.COM/LIJUNYI0198/ITEM/2558F8C613618F61F6C95D04
Reboot try it.

6 Log in again Sqlplus start from library

Sql>  STARTUP mount;oracle instance started. Total System Global area 5344731136 bytesfixed size    2213136 bytesvariable size 3489663728 bytesdatabase buffers 181193 9328 Bytesredo buffers   40914944 bytesdatabase mounted. sql> ALTER database RECOVER MANAGED STANDBY database DISCONNECT from Session;database altered. sql> ALTER database RECOVER MANAGED STANDBY database USING current LOGFILE; ALTER database RECOVER MANAGED STANDBY database USING current Logfile*error on line 1:ora-01153:an Incompatible Media rec Overy is activesql> ALTER DATABASE open;alter database Open*error on line 1:ora-10456:cannot open standby database; Media recovery Session may inprogress

# There is an error message, see here, need to temporarily stop media recovery.

sql> Recover managed standby database cancel; Media recovery complete.

7 try to automatically recover, but still fail, just stop again

sql> recover automatic standby database; Ora-00279:change 10386441904 generated at 04/18/2014 17:56:46 needed Forthrea D 1ora-00289:suggestion:/data/oracle/oradgdata/standby_archive/1_7368_821708334.dbfora-00280:change 10386441904 For thread 1 was in sequence #7368ORA -00278:log file '/data/oracle/oradgdata/standby_archive/1_7368_821708334.dbf ' no Longer neededfor this recoveryora-00308:cannot open archived log '/data/oracle/oradgdata/standby_archive/1_7368_ 821708334.DBF ' ora-27037:unable to obtain file statuslinux-x86_64 error:2: No such file or directoryadditional Informatio N:3specify log: {<ret>=suggested | AUTO | Cancel}ora-00308:cannot Open archived log '/data/oracle/oradgdata/standby_archive/1_7368_821708334.dbf ' ORA-27037: Unable to obtain file statuslinux-x86_64 error:2: No such file or directoryadditional information:3sql> RECOVER MANAG ED STANDBY DATABASE DISCONNECT from SESSION; Media recovery complete.

8, view the status of the current Datagard

Sql> SELECT MESSAGE from V$dataguard_status; MESSAGE--------------------------------------------------------------------------------Arc0:archival Startedarc1:archival startedarc2:archival startedarc3:archival startedarc4:archival startedarc5:archival Startedarc6:archival startedarc7:archival startedarc8:archival startedarc9:archival startedarca:archival Startedmessage--------------------------------------------------------------------------------Arcb:archival Startedarcc:archival startedarcd:archival startedarce:archival startedarcf:archival startedarcg:archival Startedarch:archival startedarci:archival startedarc1:becoming the ' no FAL ' archarc2:becoming the heartbeat ARCHARCj: Archival startedmessage--------------------------------------------------------------------------------Media Recovery start:managed Standby recoverymanaged Standby Recovery not using Real time Applymedia Recovery waiting for Threa D 1 sequence 7368Fetching gap sequence in thread 1, Gap seqUence 7368-7392fal[client]: Failed to request gap sequence Gap-thread 1 sequence 7368-7392 DBID 3391761643 branch 821708 334fal[client]: All defined FAL servers has been attempted. Attempt to start background Managed Standby Recovery processmrp0:background Managed Standby Recovery Process Startedmanag Ed Standby Recovery not using Real time Applymessage--------------------------------------------------------------------------------Media Recovery Waiting for thread 1 sequence 7368Fetching gap sequence on thread 1, Gap sequence 7368-7392fal[client]: Failed to request Gap sequence Gap-thread 1 sequence 7368-7392 DBID 3391761643 branch 821708334fal[client]: All defined FAL servers has b Een attempted.  Mrp0:background Media Recovery cancelled with status 16037mrp0:background media Recovery process shutdownmanaged Standby Recovery canceledmanaged Standby Recovery not using Real time applyattempt to start background Managed Standby Recovery p Rocessmessage--------------------------------------------------------------------------------mrp0:background Managed Standby Recovery Process startedmanaged  Standby Recovery not using Real time Applymedia Recovery waiting for thread 1 sequence 7368Fetching gap sequence in thread 1, Gap sequence 7368-7392fal[client]: Failed to request gap sequence Gap-thread 1 sequence 7368-7392 DBID 3391761643 BR Anch 821708334fal[client]: All defined FAL servers has been attempted.52 rows selected.

9 Try to change the status directly to open.
# Open Standary from library

sql> ALTER DATABASE Open;database altered. Sql>  Select Open_mode from V$database;open_mode--------------------READ only# put the standby in the AutoRecover state sql> recover Managed standby database disconnect from session; Media recovery complete.

Check the master-slave archive log condition
# Main Library Status:

sql> archive log list;                                                                                                                                                                         Database log mode       Archive modeautomatic archival       enabledarchive destination       /oracle/app/oracle/flash_ Recovery_area/archivelogoldest Online log sequence     7777Next log sequence to archive   7779Current log sequence       7779sql>   

#从库状态:

sql>  archive log list;                                                                                                                                                                        Database log mode       Archive modeautomatic archival       enabledarchive destination       /data/oracle/oradgdata/ Standby_archiveoldest Online log sequence     7778Next log sequence to archive   0Current log sequence       

Finally asked the cat, how can be completely check under the Datagard master-slave data consistent, the results were cats and cats beauty a crazy batch, more to see Datagard official documents, don't always ask her, you have to go to study to summarize.

Haha, it seems that you have to take the effort to Datagard Oracle.