Recovery from different machines based on one full backup of RMAN

Recovery from different machines based on one full backup of rman I. Target database preparation: Back up dbrun {allocatechannelch1devicetypediskmaxpiecesize10

Recovery from different machines according to one full backup of rman I. Target database preparation: Backup dbrun {allocate channel recovery device type disk maxpiecesize = 10

Homepage → Database Technology

Background:

Read News

Recovery from different machines based on one full backup of RMAN

[Date:] Source: Linux community Author: huiyang23 [Font:]

Recovery from different machines based on one full backup of rman

I. Preparations for the Target database:

Back up db

Run {

Allocate channel specified device type disk maxpiecesize = 10g;

SQL 'alter system archive log current ';

Change archivelog all crosscheck;

Backup full database tag = ora10gdbfullbk

Format '/u01/backup/% d_db _ % t _ % s _ % P'

Plus archivelog format'/u01/backup/% d_arch _ % t _ % s _ % P' delete all input;

Backup current controlfile

Format '/u01/backup/% d_ctlfile _ % t _ % s _ % P ';

Release channel identifier;

}

View backup files

-Bash-3.1 $ ll/u01/backup

Total 850468

-Rw-r -- 1 root 1277 Apr 20 21:53 initora10g. ora

-Rw-r -- 1 root 8484864 Apr 21 ORA10G_arch_749016313_41_1

-Rw-r -- 1 root 386560 Apr 21 ORA10G_arch_749016700_43_1

-Rw-r -- 1 root 7438336 Apr 21 ORA10G_ctlfile_749016703_44_1

-Rw-r -- 1 root 853688320 Apr 21 ora10g_db_7490163342642_1

Ii. Auxiliary database preparation:

1. Create a password file

$ Orapwd file =/u01/app/Oracle/product/10.2.0/db_1/dbs/orapwhy2 password = oracle

2. Create related directories

$ Mkdir oradata

$ Pwd

/U01/oradata

3. Copy the pfile of the target database and the backup database to the auxiliary database.

4. Use pfile to start the aupoliciary Library to the nomount state.

SQL> startup nomount pfile =/u01/app/oracle/product/10.2.0/db_1/dbs/orapwhy2;

5. Restore Control Files

$ Export ORACLE_SID = hy2

$ Rman target/

RMAN> restore controlfile from '/u01/backup/ORA10G_ctlfile_749016703_44_1 ';

6. Start the database to the mount status.

RMAN> alter database mount;

7. restore db

7.1 different directory recovery situations:

RMAN>

Run

{

Set newname for datafile 1 to "/u01/oradata/system01.dbf ";

Set newname for datafile 2 to "/u01/oradata/sysaux01.dbf ";

Set newname for datafile 3 to "/u01/oradata/undotbs01.dbf ";

Set newname for datafile 4 to "/u01/oradata/users01.dbf ";

Restore database;

Switch datafile all;

}

7.2 restore the same directory

RMAN> restore database;

8. recover db

RMAN> recover database;

$ Export ORACLE_SID = ora10g

9. Use open resetlogs? Open Database

SQL> alter database open resetlogs;

10. Run the NID command to modify the DBID and DBNAME of the mount database.

SQL> shutdown immediate

SQL> startup mount;

$ Nid target = sys/password dbname = hy2

SQL> alter system set db_name = hy2 scope = spfile;

SQL> shutdown immediate

SQL> startup

SQL> alter database open resetlogs;

Verification:

SQL> select name, dbid from v $ database;

NAME DBID

-------------------

HY2 2874673008

0

Oracle constructs a table with the same structure as a known table

MySQL Rename Table statement

Oracle tutorial

Image Information

View All comments in this article (0)

Comments

Latest Information

Popular this week

Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.


Copyright©2006-2011 Linux community All rights reserved Zhejiang ICP backup No. 06018118