Home » RDBMS Server » Backup & Recovery » Rman do not backup online redo.log?
Rman do not backup online redo.log? [message #73698] Mon, 21 June 2004 19:31 Go to next message
Straight
Messages: 3
Registered: June 2004
Junior Member
hi all,

Rman without catalog backup whole db&archive log all.

To test restore action.I delete all datafiles except control files

When rman run "recover database",it report it can't find redo02.log

I just want to simulate the event all datafiles are lost .I have all backups but how to recover?

Thanks!!

 

 
Re: Rman do not backup online redo.log? [message #73704 is a reply to message #73698] Tue, 22 June 2004 07:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
first did you backup the database and archived logs?
-- use the following in 9i
-- first archive and the ORL and 
-- backup the datbase along with the archived logs
crosscheck archivelog all;
backup database plus archivelog;
-- during  restore
-- first restore the control file
--  the restore the database
-- and recover the database
restore controlfile;
restore database;
sql "alter database mount";
recover database;
sql "alter database open resetlogs";

I backup the DB an archived logs. [message #73707 is a reply to message #73704] Tue, 22 June 2004 17:14 Go to previous messageGo to next message
Straight
Messages: 3
Registered: June 2004
Junior Member
Thanks!!

i am using Oracle 8.17

the problem is redoxx.logs were not backup .When i restore it report missing of redoxx.logs.

"backup database plus archivelog" in 9i will backup redoxx.logs?
Re: I backup the DB an archived logs. [message #73711 is a reply to message #73707] Wed, 23 June 2004 03:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
rman will NOT backup redolog information directly.
any redolog information will be archived into archivedlog files by a process( archiver).
RMAN will backup only the archived logs.
If redoxx.logs are not backup then how to restore them. [message #73714 is a reply to message #73711] Wed, 23 June 2004 17:23 Go to previous messageGo to next message
Straight
Messages: 3
Registered: June 2004
Junior Member
thanks!
neither "backup database" or "archivelog all" dosen't backup redoxx.log .So how to restore redoxx.log.

Given a scenario when "*.dbf, redoxx.logs " are lost .I can restore *.dbf from "database backup" ,but how to restore redoxx.logs?? I sucessfully restored *.dbf but failed to recover DB " reporting missing redoxx.logs"
Re: If redoxx.logs are not backup then how to restore them. [message #73725 is a reply to message #73714] Thu, 24 June 2004 05:49 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Ok.
redologs are just files used in cyclic fashion.
any information in redologfile is archived into archived redologs.
RMAN backups up ONLY archivedlog files.
during backup, u need to backup the control and archived log files alongwith the database files.
during restore (Please refer mY first posting)
first you
restore the control file , restore the database
and recover the database.
when you do restore control file, a new controlfile is created to use database (old sid). in this process,
logfiles are created.
when you restore the database, all the database files that are pulled from rman backupsets are made available to the new database ( that is restored).
during the recovery stage, you goto a particular point-in-time SCN available in archivedlog.

-- Please refer the following session
-- this is the log file of a duplication process.
-- A production database in hostA is duplicated / cloned
-- to another another hostB.
-- RMAN is used.
-- instead of restoration i am using duplication.
-- the process is almost same even in case of restoration.
-- in the bolded area, you can see the logfiles are recreated.
-- NOTE that all these happen in the background when you use restore controlfile and restore datbase.!

Recovery Manager: Release 9.2.0.3.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN>
connected to target database: KRONOS (DBID=1780043248)

RMAN>
connected to recovery catalog database

RMAN>
connected to auxiliary database: kronos (not mounted)

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>
14> set newname for datafile 1 to '/u01/oradata/kronos/system01.dbf';
15> set newname for datafile 2 to '/u01/oradata/kronos/undotbs01.dbf';
16> set newname for datafile 3 to '/u02/oradata/kronos/tkcs1.dbf';
17> set newname for datafile 4 to '/u03/oradata/kronos/tkcs2.dbf';
18> set newname for datafile 5 to '/u02/oradata/kronos/tkcs3.dbf';
19> set newname for datafile 6 to '/u03/oradata/kronos/tkcs4.dbf';
20> set newname for datafile 7 to '/u02/oradata/kronos/tkcs5.dbf';
21> set newname for datafile 8 to '/u03/oradata/kronos/tkcs6.dbf';
22> set newname for datafile 9 to '/u03/oradata/kronos/tkcs7.dbf';
23> set newname for datafile 10 to '/u03/oradata/kronos/tkcs8.dbf';
24> set newname for datafile 11 to '/u02/oradata/kronos/users01.dbf';
25> **end-of-file**
26> 27> 28> 29> 30> 31> 32> 33>
allocated channel: ch1
channel ch1: sid=132 devtype=DISK

allocated channel: ch2
channel ch2: sid=89 devtype=DISK

allocated channel: ch3
channel ch3: sid=133 devtype=DISK

allocated channel: ch4
channel ch4: sid=100 devtype=DISK

allocated channel: ch5
channel ch5: sid=160 devtype=DISK

allocated channel: ch6
channel ch6: sid=111 devtype=DISK

allocated channel: aux1
channel aux1: sid=13 devtype=DISK

allocated channel: aux2
channel aux2: sid=14 devtype=DISK

allocated channel: aux3
channel aux3: sid=15 devtype=DISK

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting Duplicate Db at JUN 18 2004 08:18:10

printing stored script: Memory Script
{
   set until scn  8175887;
   set newname for datafile  1 to
 "/u01/oradata/kronos/system01.dbf";
   set newname for datafile  2 to
 "/u01/oradata/kronos/undotbs01.dbf";
   set newname for datafile  3 to
 "/u02/oradata/kronos/tkcs1.dbf";
   set newname for datafile  4 to
 "/u03/oradata/kronos/tkcs2.dbf";
   set newname for datafile  5 to
 "/u02/oradata/kronos/tkcs3.dbf";
   set newname for datafile  6 to
 "/u03/oradata/kronos/tkcs4.dbf";
   set newname for datafile  7 to
 "/u02/oradata/kronos/tkcs5.dbf";
   set newname for datafile  8 to
 "/u03/oradata/kronos/tkcs6.dbf";
   set newname for datafile  9 to
 "/u03/oradata/kronos/tkcs7.dbf";
   set newname for datafile  10 to
 "/u03/oradata/kronos/tkcs8.dbf";
   set newname for datafile  11 to
 "/u02/oradata/kronos/users01.dbf";
   restore
   check readonly
   clone database
   ;
}
executing script: Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at JUN 18 2004 08:18:11

channel aux1: starting datafile backupset restore
channel aux1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/oradata/kronos/undotbs01.dbf
restoring datafile 00003 to /u02/oradata/kronos/tkcs1.dbf
restoring datafile 00004 to /u03/oradata/kronos/tkcs2.dbf
channel aux2: starting datafile backupset restore
channel aux2: specifying datafile(s) to restore from backup set
restoring datafile 00008 to /u03/oradata/kronos/tkcs6.dbf
channel aux3: starting datafile backupset restore
channel aux3: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/oradata/kronos/system01.dbf
restoring datafile 00005 to /u02/oradata/kronos/tkcs3.dbf
restoring datafile 00006 to /u03/oradata/kronos/tkcs4.dbf
restoring datafile 00007 to /u02/oradata/kronos/tkcs5.dbf
restoring datafile 00011 to /u02/oradata/kronos/users01.dbf
channel aux2: restored backup piece 1
piece handle=/backup/kronos/disk1/rman_KRONOS_529056664_bpiece1.bak tag=TAG20040617T080719 params=NULL
channel aux2: restore complete
channel aux2: starting datafile backupset restore
channel aux2: specifying datafile(s) to restore from backup set
restoring datafile 00009 to /u03/oradata/kronos/tkcs7.dbf
channel aux2: restored backup piece 1
piece handle=/backup/kronos/disk1/rman_KRONOS_529056770_bpiece1.bak tag=TAG20040617T080719 params=NULL
channel aux2: restore complete
channel aux2: starting datafile backupset restore
channel aux2: specifying datafile(s) to restore from backup set
restoring datafile 00010 to /u03/oradata/kronos/tkcs8.dbf
channel aux1: restored backup piece 1
piece handle=/backup/kronos/disk1/rman_KRONOS_529056439_bpiece1.bak tag=TAG20040617T080719 params=NULL
channel aux1: restore complete
channel aux3: restored backup piece 1
piece handle=/backup/kronos/disk2/rman_KRONOS_529056439_bpiece2.bak tag=TAG20040617T080719 params=NULL
channel aux3: restore complete
channel aux2: restored backup piece 1
piece handle=/backup/kronos/disk2/rman_KRONOS_529056770_bpiece2.bak tag=TAG20040617T080719 params=NULL
channel aux2: restore complete
Finished restore at JUN 18 2004 08:28:41
[b]
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "kronos" RESETLOGS ARCHIVELOG
  MAXLOGFILES      5
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     1
  MAXLOGHISTORY      454
 LOGFILE
  GROUP  1 ( '/u01/oradata/kronos/redo1.log' ) SIZE  134217728  REUSE,
  GROUP  2 ( '/u01/oradata/kronos/redo2.log' ) SIZE  134217728  REUSE,
  GROUP  3 ( '/u01/oradata/kronos/redo3.log' ) SIZE  134217728  REUSE
 DATAFILE
  '/u01/oradata/kronos/system01.dbf'
 CHARACTER SET WE8ISO8859P1

[/b]
printing stored script: Memory Script
{
   switch clone datafile all;
}
executing script: Memory Script

datafile 2 switched to datafile copy
input datafilecopy recid=1 stamp=529144123 filename=/u01/oradata/kronos/undotbs01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=2 stamp=529144123 filename=/u02/oradata/kronos/tkcs1.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=3 stamp=529144123 filename=/u03/oradata/kronos/tkcs2.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=4 stamp=529144123 filename=/u02/oradata/kronos/tkcs3.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=5 stamp=529144123 filename=/u03/oradata/kronos/tkcs4.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=6 stamp=529144124 filename=/u02/oradata/kronos/tkcs5.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=7 stamp=529144124 filename=/u03/oradata/kronos/tkcs6.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=8 stamp=529144124 filename=/u03/oradata/kronos/tkcs7.dbf
datafile 10 switched to datafile copy
input datafilecopy recid=9 stamp=529144124 filename=/u03/oradata/kronos/tkcs8.dbf
datafile 11 switched to datafile copy
input datafilecopy recid=10 stamp=529144124 filename=/u02/oradata/kronos/users01.dbf

printing stored script: Memory Script
{
   set until time  "to_date('JUN 18 2004 07:00:00','MON DD YYYY HH24:MI:SS')";
   recover
   clone database
    delete archivelog
   ;
}
executing script: Memory Script

executing command: SET until clause

Starting recover at JUN 18 2004 08:28:46

starting media recovery

channel aux1: starting archive log restore to default destination
channel aux1: restoring archive log
archive log thread=1 sequence=204
channel aux1: restoring archive log
archive log thread=1 sequence=205
channel aux1: restoring archive log
archive log thread=1 sequence=206
channel aux1: restored backup piece 1
piece handle=/backup/kronos/disk2/rman_KRONOS_529141623_bpiece2.bak tag=TAG20040618T074515 params=NULL
channel aux1: restore complete
archive log filename=/u01/app/oracle/product/9.2.0/dbs/arch1_204.dbf thread=1 sequence=204
channel clone_default: deleting archive log(s)
archive log filename=/u01/app/oracle/product/9.2.0/dbs/arch1_204.dbf recid=2 stamp=529144140
archive log filename=/u01/app/oracle/product/9.2.0/dbs/arch1_205.dbf thread=1 sequence=205
channel clone_default: deleting archive log(s)
archive log filename=/u01/app/oracle/product/9.2.0/dbs/arch1_205.dbf recid=3 stamp=529144141
archive log filename=/u01/app/oracle/product/9.2.0/dbs/arch1_206.dbf thread=1 sequence=206
channel clone_default: deleting archive log(s)
archive log filename=/u01/app/oracle/product/9.2.0/dbs/arch1_206.dbf recid=1 stamp=529144140
media recovery complete
Finished recover at JUN 18 2004 08:29:14

printing stored script: Memory Script
{
   shutdown clone;
   startup clone nomount pfile= '/backup/rmanscr/kronos/initkronos.ora';
}
executing script: Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     270501592 bytes

Fixed Size                      730840 bytes
Variable Size                234881024 bytes
Database Buffers              33554432 bytes
Redo Buffers                   1335296 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "kronos" RESETLOGS ARCHIVELOG
  MAXLOGFILES      5
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     1
  MAXLOGHISTORY      454
 LOGFILE
  GROUP  1 ( '/u01/oradata/kronos/redo1.log' ) SIZE  134217728  REUSE,
  GROUP  2 ( '/u01/oradata/kronos/redo2.log' ) SIZE  134217728  REUSE,
  GROUP  3 ( '/u01/oradata/kronos/redo3.log' ) SIZE  134217728  REUSE
 DATAFILE
  '/u01/oradata/kronos/system01.dbf'
 CHARACTER SET WE8ISO8859P1

printing stored script: Memory Script
{
   catalog clone datafilecopy  "/u01/oradata/kronos/undotbs01.dbf";
   catalog clone datafilecopy  "/u02/oradata/kronos/tkcs1.dbf";
   catalog clone datafilecopy  "/u03/oradata/kronos/tkcs2.dbf";
   catalog clone datafilecopy  "/u02/oradata/kronos/tkcs3.dbf";
   catalog clone datafilecopy  "/u03/oradata/kronos/tkcs4.dbf";
   catalog clone datafilecopy  "/u02/oradata/kronos/tkcs5.dbf";
   catalog clone datafilecopy  "/u03/oradata/kronos/tkcs6.dbf";
   catalog clone datafilecopy  "/u03/oradata/kronos/tkcs7.dbf";
   catalog clone datafilecopy  "/u03/oradata/kronos/tkcs8.dbf";
   catalog clone datafilecopy  "/u02/oradata/kronos/users01.dbf";
   switch clone datafile all;
}
executing script: Memory Script

cataloged datafile copy
datafile copy filename=/u01/oradata/kronos/undotbs01.dbf recid=1 stamp=529144162

cataloged datafile copy
datafile copy filename=/u02/oradata/kronos/tkcs1.dbf recid=2 stamp=529144163

cataloged datafile copy
datafile copy filename=/u03/oradata/kronos/tkcs2.dbf recid=3 stamp=529144163

cataloged datafile copy
datafile copy filename=/u02/oradata/kronos/tkcs3.dbf recid=4 stamp=529144163

cataloged datafile copy
datafile copy filename=/u03/oradata/kronos/tkcs4.dbf recid=5 stamp=529144163

cataloged datafile copy
datafile copy filename=/u02/oradata/kronos/tkcs5.dbf recid=6 stamp=529144163

cataloged datafile copy
datafile copy filename=/u03/oradata/kronos/tkcs6.dbf recid=7 stamp=529144163

cataloged datafile copy
datafile copy filename=/u03/oradata/kronos/tkcs7.dbf recid=8 stamp=529144164

cataloged datafile copy
datafile copy filename=/u03/oradata/kronos/tkcs8.dbf recid=9 stamp=529144164

cataloged datafile copy
datafile copy filename=/u02/oradata/kronos/users01.dbf recid=10 stamp=529144164

datafile 2 switched to datafile copy
input datafilecopy recid=1 stamp=529144162 filename=/u01/oradata/kronos/undotbs01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=2 stamp=529144163 filename=/u02/oradata/kronos/tkcs1.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=3 stamp=529144163 filename=/u03/oradata/kronos/tkcs2.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=4 stamp=529144163 filename=/u02/oradata/kronos/tkcs3.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=5 stamp=529144163 filename=/u03/oradata/kronos/tkcs4.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=6 stamp=529144163 filename=/u02/oradata/kronos/tkcs5.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=7 stamp=529144163 filename=/u03/oradata/kronos/tkcs6.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=8 stamp=529144164 filename=/u03/oradata/kronos/tkcs7.dbf
datafile 10 switched to datafile copy
input datafilecopy recid=9 stamp=529144164 filename=/u03/oradata/kronos/tkcs8.dbf
datafile 11 switched to datafile copy
input datafilecopy recid=10 stamp=529144164 filename=/u02/oradata/kronos/users01.dbf

printing stored script: Memory Script
{
   Alter clone database open resetlogs;
}
executing script: Memory Script

database opened
Finished Duplicate Db at JUN 18 2004 08:29:48
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
released channel: ch5
released channel: ch6

RMAN>

Recovery Manager complete.

Previous Topic: how to recover a truncated table
Next Topic: restore DB from datafiles
Goto Forum:
  


Current Time: Thu May 23 11:20:10 CDT 2024