Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g How dataguard master repository to Oracle single instance data recovery     - CentOS 6.5 installation and configuration Cobbler (Server)

- Install Oracle 11g illustrations and dependent libraries under SUSE11 (Database)

- Linux system security audit tools scan nessus installation tutorial (Linux)

- Iptables in Ubuntu (Linux)

- CentOS of NFS (Server)

- Linux nice program origin of the name (Linux)

- Learn to read the source code of vmstat (Linux)

- Distributed File System using MogileFS (Linux)

- Ubuntu 14.04 Configuring cuda-convnet (Linux)

- Linux environment variable settings and save places (Linux)

- Linux virtual machines to solve end MySQL database can not remote access (Database)

- QEMU code analysis: BIOS loading process (Linux)

- Python format string (Programming)

- CentOS minimal network is unavailable resolved (Linux)

- ORA-28000 the account is locked fault simulation (Database)

- BusyBox making the file system (Linux)

- Linux Detailed instructions alias settings (Linux)

- An Analysis of the C Algorithm for Calculating the Number of Days Between Date (Programming)

- RedHat 6.5 installation and deployment Openfire (Server)

- To install Ganglia (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:      
 
- Linux - Common process the command (Linux)
- Linux install Samba file sharing server (Server)
- How do I switch from NetworkManager to systemd-network on Linux (Linux)
- How to use the beta / unstable version of the software in Debian library (Linux)
- Oracle data row split multiple lines (Database)
- Windows7 system using Vagrant to build Linux virtualized development environment (Linux)
- To install JDK1.7 and compiler Hadoop-2.7.1 under CentOS7 (Server)
- Linux uses shared memory communication process synchronization Withdrawal (Programming)
- Kubernetes (k8s) environment to build combat (Server)
- To install Docker under Ubuntu 15.04 (Linux)
- Using Linux stat command to view the files (Linux)
- imp / exp Oracle Database import and export commands (Database)
- VirtualBox install Windows 8.1 has encountered an error 0x000000C4 solutions (Linux)
- awk Programming Model (Programming)
- Install Java on RHEL6 (Linux)
- Linux common network tools: ping host sweep (Linux)
- HAProxy Windows version of the compiler and its application in the CORS (Server)
- Linux System Getting Started Learning: modify environment variables in Linux PATH (Linux)
- Oracle TAF Analysis (Database)
- Oracle partition table data migration, process management automation (Database)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.