Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g How dataguard master repository to Oracle single instance data recovery     - CentOS7 boot systemd introduction and use of management (Linux)

- UUID in Java (Programming)

- Oracle GoldenGate Installation and Configuration Tutorial Introduction (Database)

- Compression decompression command under Linux (Linux)

- Linux environment has been running Tomcat how to deploy the new Tomcat (Server)

- CentOS 7 source code to compile and install Nginx process record (Server)

- iTerm - let your command line can also be colorful (Linux)

- MySQL Tutorial: Some optimized for I / O memory areas (Database)

- Linux Log (Linux)

- Prevent security threats caused Rootkit (Linux)

- LNMP summary of the issues common 502 Bad Gateway (Server)

- On the PC goes heavy security watch your startup items (Linux)

- Linux / Unix desktops interesting: Christmas tree on the terminal (Linux)

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

- Puppet centralized configuration management system (Server)

- Hands to teach you to solve Ubuntu error message (Linux)

- ActiveMQ configuration Getting Started Tutorial (Server)

- Ubuntu is not in the sudoers file problem solving (Linux)

- Java Foundation - Variables and data types (Programming)

- rsync server set up (Server)

 
         
  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:      
 
- Android custom slideshow menu slidmenu (Programming)
- To record command input under Linux (Linux)
- Linux awk text analysis tool (Linux)
- Python script file directory traversal examples (Programming)
- Ubuntu install Lighttpd + Mono support .net (Linux)
- Java memory analysis tool uses detailed MAT (Programming)
- Build your own Web server under Ubuntu Linux system (Server)
- How to configure MongoDB replica set (Database)
- Exploring the Android Listview display confusion (Programming)
- pkg-config to use (Linux)
- Bubble Sort Algorithms (Programming)
- Use Mop monitor stock prices at the Linux command line (Linux)
- Java Virtual Machine Basics (Programming)
- To install PostgreSQL 9.4 (Database)
- Ten best plug surge Emacs Productivity (Linux)
- Java thread pool: ExecutorService, Executors (Programming)
- CentOS 6.5 upgrade to CentOS 7 (Linux)
- Ubuntu 14.04 install PostgreSQL 9.2 (Database)
- SpringMVC garbage processing (Programming)
- Talk about the Linux ABI compatibility Application (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.