Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g How dataguard master repository to Oracle single instance data recovery     - Switching Virtual Machine + Ubuntu graphical interface and terminal interface (Linux)

- Redhat Close SELinux correct step (Linux)

- Teach you self-built Linux firewall free (Linux)

- Talk about jsonp (Programming)

- Configuring Haproxy log support (syslog logging support) (Server)

- Why use Docker (Programming)

- Diagnose and resolve the SSH connection slow (Linux)

- Oracle TAF Analysis (Database)

- The headers for the current running kernel were not found when VirtualBox installation enhancements (Linux)

- The user of fedora is not in the sudoers file method to solve (Linux)

- Oracle 12C modify spfile path (Database)

- The most common and most effective security settings under linux (Linux)

- Oracle bug Ora-04043 (Database)

- Compare Swift achieve rapid sorting and sorted Methods (Programming)

- Ubuntu users to install Gnome-Pie 0.6.5 (Linux)

- How to clean up your Ubuntu 14.10 / 14.04 / 13.10 system (Linux)

- CentOS set up FTP server (Server)

- What is the Docker (Linux)

- Linux system server network security management tips (Linux)

- Python class of operator overloading (Programming)

 
         
  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:      
 
- Via Twitter how open source library to be used anywhere Emoji emoticons (Linux)
- Android Fragment really fully resolve (Programming)
- Configuring LIDS build Linux kernel security intrusion detection system (Linux)
- Vim custom color (Linux)
- A custom implementation of the Android sidebar (Programming)
- Port Telnet command to detect the remote host is turned on (Linux)
- Linux common network tools: batch scanning of hosting services netcat (Linux)
- JDK installation under CentOS (Linux)
- Installation Docker FAQ on Ubuntu (Linux)
- PostgreSQL use pgpool achieve high availability (Database)
- Security Features Linux and Unix operating system, programming (Linux)
- CentOS 7.1 install NTFS-3G (Linux)
- IBM Data Studio to use ---- window displays all rows (Database)
- Arduino UNO simulation development environment set up and run simulation (Linux)
- To get Java class / jar package path (Programming)
- Boot automatically remove Linux operating history records (Linux)
- Ubuntu 14.04 LTS installed Hadoop 1.2.1 (distributed cluster mode) (Server)
- Linux source code to install Apache and solutions to common errors (Server)
- Linux shell script under the use of randomly generated passwords (Programming)
- Ubuntu 14.04 install Nmap 6.46.1 (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.