Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g How dataguard master repository to Oracle single instance data recovery     - Oracle 11G using DG Broker create DataGuard (Database)

- Adjustment expand VMDK format VirtualBox disk space (Linux)

- Distributed transaction management Spring declarative transactions (Programming)

- Change CentOS 7 NIC name eno16777736 to eth0 (Linux)

- Execute command sentence can result in equipment permanently bricked in Linux laptop (Linux)

- Linux operating system security management skills (Linux)

- Java-- get the reflection object information (Programming)

- Ubuntu 14.10 / 14.04 / 12.04 virtual users to install the printing software Boomaga (Linux)

- Growth since Oracle set the table space (Database)

- To install Jetty server configuration in detail (Server)

- ORA-00600 error solve one case (Database)

- Install Ubuntu open source drawing program MyPaint 1.2.0 (Linux)

- Android Action Compendium (Programming)

- Oracle 11g modify MEMORY_TARGET (Database)

- CentOS install pip (Linux)

- Extended use of the swap file swap space on Linux (Linux)

- Magical Virtualbox under Ubuntu (Linux)

- Vi editor Introduction (Linux)

- Lua and C ++ (Programming)

- Linux system on a virtual machine to access the Internet (Linux)

 
         
  Oracle 11g How dataguard master repository to Oracle single instance data recovery
     
  Add Date : 2018-11-21      
         
         
         
  Dataguard need to restore the data to the main library Oracle single instance, it recorded a detailed procedure

1, from the back line to pull out a parameter file, copy to the test environment

SQL> create pfile = '/ oracle / pfile01.ora'from spfile;

File created.

SQL>
Then create spfile in accordance with the test library to copy parameter files

create spfile frompfile = '/ data / pfile01.ora';
SQL> create spfile frompfile = '/ data / impdp / pfile01.ora';

File created.

SQL>
Then start to test library nomount

        SQL> startup nomount
        ORA-00845: MEMORY_TARGET not supported onthis system
        SQL>
2, control file recovery

restore controlfile to '/home/oradata/orcstu/control01.ctl' from '/ data / impdp / c-3391761643-20151126-01'

RMAN> restore controlfile to '/home/oradata/orcstu/control01.ctl' from '/ data / impdp / c-3391761643-20151126-01'
2>;

Starting restore at 26-NOV-15
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 26-NOV-15

RMAN>

  RMAN> restore controlfile to '/oracle/app/oracle/flash_recovery_area/orcstu/control02.ctl' from '/ data / impdp / c-3391761643-20151126-01';

Starting restore at 26-NOV-15
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 26-NOV-15

RMAN>
3, registration filing

To mount the job status to db

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN>
1
Register file backup and archive data in the new control file backup

catalog start with '/ data / impdp / 2015-11-26 /';

RMAN> catalog start with '/ data / impdp / 2015-11-26 /';

Starting implicit crosscheck backup at 26-NOV-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID = 767 device type = DISK
Crosschecked 97 objects
Finished implicit crosscheck backup at 26-NOV-15

Starting implicit crosscheck copy at 26-NOV-15
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 26-NOV-15

searching for all files in the recovery area
cataloging files ...
no files cataloged

searching for all files that match the pattern / data / impdp / 2015-11-26 /

List of Files Unknown to the Database
=====================================
File Name: /data/impdp/2015-11-26/rman_backup.log
File Name: /data/impdp/2015-11-26/arch_orcstu_20151126_5036.bak
File Name: /data/impdp/2015-11-26/full_orcstu_20151126_5037.bak
File Name: /data/impdp/2015-11-26/arch_orcstu_20151126_5038.bak

Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files ...
cataloging done

List of Cataloged Files
=======================
File Name: /data/impdp/2015-11-26/arch_orcstu_20151126_5036.bak
File Name: /data/impdp/2015-11-26/full_orcstu_20151126_5037.bak
File Name: /data/impdp/2015-11-26/arch_orcstu_20151126_5038.bak

List of Files Which Where Not Cataloged
=======================================
File Name: /data/impdp/2015-11-26/rman_backup.log
  RMAN-07517: Reason: The file header is corrupted

RMAN>
4, began to restore the entire library

Because the front has been restored throughout the spfile controlfile, so then restore all libraries, then do not take parameters, you can directly restore restore database;

RMAN> restore database;

Starting restore at 26-NOV-15
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile (s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /home/oradata/orcstu/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /home/oradata/orcstu/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /home/oradata/orcstu/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /home/oradata/orcstu/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /home/oradata/orcstu/orcstuk01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /home/oradata/orcstu/plas01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /home/oradata/orcstu/pl01.dbf
channel ORA_DISK_1: restoring datafile 00008 to /home/oradata/orcstu/help01.dbf
channel ORA_DISK_1: restoring datafile 00009 to /home/oradata/orcstu/adobelc01.dbf
channel ORA_DISK_1: restoring datafile 00010 to /home/oradata/orcstu/sms01.dbf
channel ORA_DISK_1: restoring datafile 00011 to /home/oradata/orcstu/plcrm01.dbf
channel ORA_DISK_1: restoring datafile 00012 to /home/oradata/orcstu/orcstuk02.dbf
channel ORA_DISK_1: restoring datafile 00013 to /home/oradata/orcstu/datagm01.dbf
channel ORA_DISK_1: reading from backup piece /data/impdp/2015-11-26/full_orcstu_20151126_5037.bak
channel ORA_DISK_1: piece handle = / data / impdp / 2015-11-26 / full_orcstu_20151126_5037.bak tag = TAG20151126T030008
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:32:50
Finished restore at 26-NOV-15

RMAN>
1
5, recover database

RMAN> recover database;

Starting recover at 26-NOV-15
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread = 1 sequence = 39674
channel ORA_DISK_1: reading from backup piece /data/impdp/2015-11-26/arch_orcstu_20151126_5038.bak
channel ORA_DISK_1: piece handle = / data / impdp / 2015-11-26 / arch_orcstu_20151126_5038.bak tag = TAG20151126T032346
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
archived log file name = / oracle / app / oracle / flash_recovery_area / archivelog1_39674_821708334.dbf thread = 1 sequence = 39674
unable to find archived log
archived log thread = 1 sequence = 39675
RMAN-00571: ============================================== =============
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ============================================== =============
RMAN-03002: failure of recover command at 11/26/2015 21:48:13
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 39675 and starting SCN of 11688009482

RMAN>

Background alert log:
 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13
Completed: alter database recover datafile list
 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13
alter database recover if needed
 start until cancel using backup controlfile
Media Recovery Start
 started logmerger process
Parallel Media Recovery started with 4 slaves
ORA-279 signalled during: alter database recover if needed
 start until cancel using backup controlfile
...
alter database recover logfile '/oracle/app/oracle/flash_recovery_area/archivelog1_39674_821708334.dbf'
Media Recovery Log /oracle/app/oracle/flash_recovery_area/archivelog1_39674_821708334.dbf
ORA-279 signalled during: alter database recover logfile '/oracle/app/oracle/flash_recovery_area/archivelog1_39674_821708334.dbf' ...
Thu Nov 26 21:48:13 2015
alter database recover cancel
Media Recovery Canceled
Completed: alter database recover cancel
Visible, the first reason for this error is to restore the archive logs required record was not found in the control file or recovery catalog. Solution two cases:
1. If the relevant log exists and is available, then it is this log record is added to the control file or recovery catalog.
2. If the associated logs have been deleted or unavailable, and then follow the prompts error database restore this scn scn, here is 11,688,009,482. That is when the database can not be fully restored, and when you open the database have to use resetlogs open.

Here only to return to 11,688,009,482 scn this point so far:

recover database until scn 11688009482;
RMAN> recover database until scn 11688009482;

Starting recover at 26-NOV-15
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 26-NOV-15

RMAN>
6, open the database

RMAN> alter database open resetlogs;

database opened

RMAN>
change Password

SQL> alter user orcstuk identified by "pd141287l118";

User altered.

SQL> exit
7, remote connection error

C: \ Users \ Administrator> tnsping TEST2_180.60

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 26-NOV-2
015 21:59:33

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:
D: \ app \ Administrator \ product \ 11.2.0 \ client_2 \ network \ admin \ sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 12.18.10.6) (PORT = 1521))) (CONNECT_DATA = (SID = orcstu)))
TNS-12535: TNS: operation timed out

C: \ Users \ Administrator>
Solution: Close oracle database firewall.

8, is set to cancel dg single oracle

See backstage stop error log:

Error 12154 received logging on to the standby
Errors in file /oracle/app/oracle/diag/rdbms/pdunq/orcstu/trace/orcstu_arc2_13889.trc:
ORA-12154: TNS: could not resolve the connect identifier specified
PING [ARC2]: Heartbeat failed to connect to standby 'PD_DG' Error is 12154..
Thu Nov 26 22:48:02 2015
Error 12154 received logging on to the standby
Errors in file /oracle/app/oracle/diag/rdbms/pdunq/orcstu/trace/orcstu_arc2_13889.trc:
ORA-12154: TNS: could not resolve the connect identifier specified
PING [ARC2]: Heartbeat failed to connect to standby 'PD_DG' Error is 12154..
After analysis, because my rman backup is taken from dg environment, primary, backup time will naturally put on transmission dg archive log to standby function, so the rman backup and recovery to this single time, it in dg archive log transmission time being given, because single thing. Solution, close the log transfer archived, as follows:

SQL> ALTER system SET log_archive_dest_state_2 = 'defer';

System altered.

SQL>
This will stop oracle dg log file transfer, no longer being given back.
     
         
         
         
  More:      
 
- MyCAT easy entry (Database)
- Linux Task Scheduler (at, crontab) (Linux)
- Linux environmental performance data acquisition system (Linux)
- Summarize small problems encountered in the use Lua (Programming)
- The signature can not be verified under Debian (Linux)
- Elixir: the future of programming languages (Programming)
- Hibernate + JUnit test entity class generate database table (Programming)
- Linux basis: a comprehensive study pwd command (Linux)
- MongoDB3.0.x version of the user authorization profile (stand-alone environment) (Database)
- Linux system security settings (Linux)
- Hadoop 2.0 Detailed Configuration Tutorial (Server)
- Use Ansible efficient delivery Docker container (Server)
- The virtual memory (Linux)
- Linux kernel IPv6 protocol closed manner (Linux)
- Fedora 19/20 and Debian Jessie / Sid users to install FFmpeg 2.3.2 (Linux)
- Linux some lessons learned about network security (Linux)
- Seven Steps to Help Google Chrome Speed - (Linux)
- Linux, modify / retrieve the root password (Linux)
- Ubuntu 14.04 after the restart the default maximum screen brightness solutions (Linux)
- Hadoop + Zookeeper NameNode achieve high availability (Server)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.