Pular para o conteúdo principal

Clonando database usando RMAN

Database de Origem:

oracle@denilson:~> rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Oct 1 15:07:49 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=3270432501)
RMAN> backup database plus archivelog;

-- mais informações sobre RMAN:
http://dicasoracledba.blogspot.com/2009/05/backup-rapido-e-simples-com-rman.html

* Copiar todos os backup pieces
* Copiar controlfile backup piece
* Copiar arquivo de parametros (init.ora)

Database Destino:

oracle@denilson_bkp:~> rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Sep 19 15:07:49 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database (not started)
RMAN> startup nomount;
Oracle instance started
Total System Global Area 205520896 bytes
Fixed Size 1218508 bytes
Variable Size 75499572 bytes
Database Buffers 121634816 bytes
Redo Buffers 7168000 bytes


Restaurar controlfile do backup piece:


RMAN> restore controlfile from '/u01/rman/backup/c-3932056136-20070213-02';
Starting restore at 13-SEP-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete,
elapsed time: 00:00:02
output filename=/u01/oracle/product/oradata/ora10g/orcl/control01.ctl
Finished restore at 13-SEP-09

RMAN> alter database mount ;

-- Catalogar todos os backup pieces copiados do banco de origem:

Exemplo:
RMAN> catalog backuppiece '/u01/rman/backup/o1_mf_annnn_TAG20070213T002925_2x21m6ty_.bkp';
Starting implicit crosscheck backup at 13-FEB-07allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=155 devtype=DISK
Crosschecked 3 objects
Finished implicit crosscheck backup at 13-FEB-07
Starting implicit crosscheck copy at 13-FEB-07using channel ORA_DISK_1
Finished implicit crosscheck copy at 13-FEB-07searching for all files in the recovery areacataloging files..

-- Verificar após catalogar:

RMAN > list backup of archivelog all;

Caso a estrutura de diretórios no servidor de destino estiver diferente você pode renomear os arquivos:

-- Renomeando redo logs:
SQL> alter database rename file '/u01/oracle/product/oradata/ora10g/orcl/redo01.log' to '/u01/oracle/product/oradata/orcl/redo01.log';

-- Renomeando datafiles:
RMAN> run { set until sequence set newname for datafile 1 to '/u01/oracle/product/oradata/orcl/system01.dbf';
set newname for datafile 2 to '/u01/oracle/product/oradata/orcl/undotbs01.dbf'; set newname for datafile 3 to '/u01/oracle/product/oradata/orcl/sysaux01.dbf'; }


RMAN> restore database;

-- Caso foi necessário renomear os arquivos utilize o switch datafile:
RMAN> switch datafile all;

RMAN> recover database;

RMAN> alter database open resetlogs;

Comentários

Postar um comentário

Postagens mais visitadas deste blog

Webcenter Content - Cache Configuration for JdbcFileStore configuration

The configuration values below, control the temporarily cached files keep in FileCache table. FsCacheThreshold Specifies the maximum cache size, in megabytes (default=100) Once the threshold is met, Content Server starts deleting files that are older than the minimum age, as specified by the FsMinimumFileCacheAge parameter FsMaximumFileCacheAge The age at which files are deleted, expressed in days. The default is 365 days FsMinimumFileCacheAge The minimum age at which cached files can be deleted This parameter is used in conjunction with the FsCacheThreshold parameter to determine when to delete cached files FsCleanUpCacheDuringIndexing This parameter activates vault cache cleaning, while FsCacheThreshold, FsMaximumFileCacheAge and FsMinimumFileCacheAge are controling its behaviour.  Expect, when this is enabled on a system that currently has a large number of files in the FileCache table, the first cycle will take a long time to complete. How to Confi...
Postar um comentário
Leia mais

Assign Backup Policy for Boot and Block Volumes - OCI

To get Availability Domain oci iam availability-domain list  #!/bin/bash OCI_AD="hQsi:SA-SAOPAULO-1-AD-1" OCI_COMPARTMENT="ocid1.compartment.oc1..aaaaaaaavgyjpoffz5qliieawamjaksfb6juxejurtduclqjkvv66ookcxja" #Get Silver policy ocid funct_get_policy(){ OCI_POL_OCID=$(oci bv volume-backup-policy list | jq -r '.data[] | select(."display-name"|contains("silver"))' | jq -r '.id') } funct_boot_vol (){ #Create a file with all boot volume ocid oci bv boot-volume list --availability-domain ${OCI_AD} -c  ${OCI_COMPARTMENT} | jq -r '.data[].id' > boot-vol.txt while IFS="" read -r p || [ -n "$p" ] do   printf 'Seeting backup policy for %s\n' "$p"   oci bv volume-backup-policy-assignment create  --asset-id  $p  --policy-id ${OCI_POL_OCID} done < boot-vol.txt } funct_block_vol (){ #Create a file with all block volume ocid oci bv volume list  -c ${OCI_COMPARTMENT} | jq -r '.data[].id' ...
Postar um comentário
Leia mais

Logical Backup Using dbms_datapump

Sample scripts to make a logical backup using dbms_datapump -- BACKUP BY SCHEMA declare h1 NUMBER; begin h1 := dbms_datapump.open (operation => 'EXPORT', job_mode => 'SCHEMA', job_name => 'TESTE2', version => 'COMPATIBLE'); dbms_datapump.set_parallel(handle => h1, degree => 1); dbms_datapump.add_file(handle => h1, filename => 'BKP_SCHEMAS.LOG', directory => 'BKP_DATA_PUMP', filetype => 3); dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0); dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''DENILSON'')'); dbms_datapump.add_file(handle => h1, filename => 'BKP_SCHEMAS.DMP', directory => 'BKP_DATA_PUMP', filetype => 1); dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1); dbms_datapump.set_parameter(handle => h1, name ...
Postar um comentário
Leia mais