Restore Controlfile para manual duplicate

Dúvidas, dicas e atualizações sobre o Treinamento Oracle Backup & Recovery.

Restore Controlfile para manual duplicate

Mensagempor gcomenale » Sáb Out 03, 2015 8:11 pm

Estou tentando fazer um duplicate manual (cópia/restore/recover dos arquivos de backup para outro sv, mas não consigo resturar o control file. Ele sempre me aponta RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

Origem: marte
Destino: saturno
Instancia: ORCLP


[oracle@marte dbs]$ r

Recovery Manager: Release 12.1.0.2.0 - Production on Sat Oct 3 16:59:16 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCLP (DBID=3673457665)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCLP are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/snapcf_ORCLP.f'; # default

RMAN> backup database;

Starting backup at 03-OCT-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=55 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCLP/undotbs01.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCLP/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ORCLP/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCLP/users01.dbf
channel ORA_DISK_1: starting piece 1 at 03-OCT-15
channel ORA_DISK_1: finished piece 1 at 03-OCT-15
piece handle=/u01/app/oracle/fast_recovery_area/ORCLP/backupset/2015_10_03/o1_mf_nnndf_TAG20151003T165927_c10dwz7c_.bkp tag=TAG20151003T165927 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
Finished backup at 03-OCT-15

Starting Control File and SPFILE Autobackup at 03-OCT-15
piece handle=/u01/app/oracle/fast_recovery_area/ORCLP/autobackup/2015_10_03/o1_mf_s_892141222_c10dyph6_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 03-OCT-15

RMAN> exit


Recovery Manager complete.
[oracle@marte dbs]$ scp /u01/app/oracle/fast_recovery_area/ORCLP/backupset/2015_10_03/o1_mf_nnndf_TAG20151003T165927_c10dwz7c_.bkp oracle@saturno:/home/oracle/backup
o1_mf_nnndf_TAG20151003T165927_c10dwz7c_.bkp 100% 1707MB 16.7MB/s 01:42
[oracle@marte dbs]$ scp /u01/app/oracle/fast_recovery_area/ORCLP/autobackup/2015_10_03/o1_mf_s_892141222_c10dyph6_.bkp oracle@saturno:/home/oracle/backup
o1_mf_s_892141222_c10dyph6_.bkp 100% 9888KB 9.7MB/s 00:00
[oracle@marte dbs]$ scp spfileORCLP.ora oracle@saturno:/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/
spfileORCLP.ora 100% 2560 2.5KB/s 00:00


[oracle@saturno dbs]$ s

SQL*Plus: Release 12.1.0.2.0 Production on Sat Oct 3 17:04:25 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 490733568 bytes
Fixed Size 2925936 bytes
Variable Size 411044496 bytes
Database Buffers 71303168 bytes
Redo Buffers 5459968 bytes
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@saturno dbs]$ cd /home/oracle/backup/
[oracle@saturno backup]$ ls -ltr
total 3515272
-rw-r-----. 1 oracle oinstall 10125312 Oct 3 16:33 o1_mf_s_892139440_c10c70g2_.bkp
-rw-r-----. 1 oracle oinstall 1789345792 Oct 3 16:35 o1_mf_nnndf_TAG20151003T162944_c10c5914_.bkp
-rw-r-----. 1 oracle oinstall 1790033920 Oct 3 17:02 o1_mf_nnndf_TAG20151003T165927_c10dwz7c_.bkp
-rw-r-----. 1 oracle oinstall 10125312 Oct 3 17:03 o1_mf_s_892141222_c10dyph6_.bkp
[oracle@saturno backup]$ r

Recovery Manager: Release 12.1.0.2.0 - Production on Sat Oct 3 17:05:46 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCLP (not mounted)

RMAN> restore controlfile from 'o1_mf_s_892141222_c10dyph6_.bkp';

Starting restore at 03-OCT-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/03/2015 17:05:56
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

RMAN> restore controlfile from 'o1_mf_nnndf_TAG20151003T165927_c10dwz7c_.bkp';

Starting restore at 03-OCT-15
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/03/2015 17:06:05
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

RMAN>

Estou esquecendo de fazer alguma coisa?
gcomenale
 
Mensagens: 0
Registrado em: Qui Mar 26, 2015 1:19 am

Re: Restore Controlfile para manual duplicate

Mensagempor gcomenale » Seg Out 05, 2015 4:38 pm

Resolvi. Ele não acha o arquivo quando você passa 'nome arquivo' ele precisa do full path 'diretório/arquivo'
gcomenale
 
Mensagens: 0
Registrado em: Qui Mar 26, 2015 1:19 am

Re: Restore Controlfile para manual duplicate

Mensagempor portilho » Ter Out 06, 2015 1:19 pm

:-D
Sim, tem que citar o caminho completo.
portilho
Site Admin
 
Mensagens: 436
Registrado em: Qua Mai 29, 2013 11:51 am


Voltar para Treinamento Oracle Backup & Recovery

Quem está online

Usuários navegando neste fórum: Nenhum usuário registrado e 1 visitante

cron