Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Online backup: Backup online redologs?

Re: Online backup: Backup online redologs?

From: Charles Fisher <Charles.Fisher_at_alcoa.com>
Date: Wed, 16 May 2001 16:11:14 GMT
Message-ID: <Pine.GSO.4.31.0105161055520.666-100000@unknown> 






On Wed, 16 May 2001, Howard J. Rogers wrote:



> Once again, you demonstrate your well-honed inability to understand a word
> I've been saying to you... End of discussion.



Yeah, yeah, we've heard this all before. Glad to see you at top of form.



Hey Howard, make yourself useful. You are the "backup expert" for the
group; explain why you cannot restore from a backup controlfile as shown
below. The control file was produced by "alter database backup controlfile
to 'CONTROL.BAK'".



It would seem that the controlfile trace backup is more important than the
controlfile backup itself. Perhaps those backupcentral people knew what
they were doing when they used OS tools to backup the controlfile...



And, of course, all this stuff comes from a hotbackup (including the
redo).



:/pkg/prdcrm/oradata/prdcrm:root>ls -l


total 23498732


-rw-r-----   1 oracle     dba        49094656 May 16 09:14 CONTROL.BAK

-rw-r-----   1 oracle     dba        20979712 May 16 09:14 genrc_data.dbf

-rw-r-----   1 oracle     dba        20979712 May 16 09:14 genrc_index.dbf

-rw-r-----   1 oracle     dba        104865792 May 16 09:14 platinum.dbf

-rw-r-----   1 oracle     dba        1073750016 May 16 09:15 rbs01.dbf

-rw-r-----   1 oracle     dba        10486784 May 16 09:15 redoprdcrm01.log

-rw-r-----   1 oracle     dba        10486784 May 16 09:15 redoprdcrm02.log

-rw-r-----   1 oracle     dba        10486784 May 16 09:15 redoprdcrm03.log

-rw-r-----   1 oracle     dba        10486784 May 16 09:15 redoprdcrm04.log

-rw-r-----   1 oracle     dba        10486784 May 16 09:15 redoprdcrm05.log

-rw-r-----   1 oracle     dba        10486784 May 16 09:15 redoprdcrm06.log

-rw-r-----   1 oracle     dba        2097160192 May 16 09:16 sea_data.dbf

-rw-r-----   1 oracle     dba        2097160192 May 16 09:16 sea_data2.dbf

-rw-r-----   1 oracle     dba        2097160192 May 16 09:17 sea_index.dbf

-rw-r-----   1 oracle     dba        2097160192 May 16 09:18 sea_index2.dbf

-rw-r-----   1 oracle     dba        1073750016 May 16 09:19 siebel_amp.dbf

-rw-r-----   1 oracle     dba        83894272 May 16 09:19 system01.dbf

-rw-r-----   1 oracle     dba        1073750016 May 16 09:20 temp01.dbf

-rw-r-----   1 oracle     dba        26222592 May 16 09:20 tools01.dbf

-rw-r-----   1 oracle     dba        52436992 May 16 09:20 users01.dbf


:/pkg/prdcrm/oradata/prdcrm:root>mv CONTROL.BAK control01.ctl
:/pkg/prdcrm/oradata/prdcrm:root>cp control01.ctl control02.ctl
:/pkg/prdcrm/oradata/prdcrm:root>cp control01.ctl control03.ctl
:/pkg/prdcrm/oradata/prdcrm:root>ls -l ../../oraapp/admin/prdcrm/arch
total 18638


-rw-r-----   1 oracle     dba        9542656 May 15 13:38 arch.log1_267878.dbf



:/pkg/prdcrm/oradata/prdcrm:root>su - oracle
$ svrmgrl



Oracle Server Manager Release 3.0.5.0.0 - Production



(c) Copyright 1997, Oracle Corporation.  All Rights Reserved.



Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.0.0 - Production



SVRMGR> connect internal


Connected.


SVRMGR> startup mount


ORACLE instance started.

Total System Global Area                         26148952 bytes
Fixed Size                                          49240 bytes
Variable Size                                     5349376 bytes
Database Buffers                                 20480000 bytes
Redo Buffers                                       270336 bytes


Database mounted.


SVRMGR> recover automatic database using backup controlfile;

ORA-00279: change 345384565128 generated at 05/13/01 15:52:18 needed for thread 1
ORA-00289: suggestion : /pkg/prdcrm/oraapp/admin/prdcrm/arch/arch.log1_267879.dbf
ORA-00280: change 345384565128 for thread 1 is in sequence #267879
ORA-00278: log file '/pkg/prdcrm/oraapp/admin/prdcrm/arch/arch.log1_267879.dbf' no longer needed for this recovery
ORA-00308: cannot open archived log '/pkg/prdcrm/oraapp/admin/prdcrm/arch/arch.log1_267879.dbf'
ORA-27037: unable to obtain file status




HP-UX Error: 2: No such file or directory
Additional information: 3


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel


Media recovery cancelled.


SVRMGR> shutdown


ORA-01109: database not open


Database dismounted.


ORACLE instance shut down.


SVRMGR> quit


Server Manager complete.


$ exit


logout


:/pkg/prdcrm/oradata/prdcrm:root>rm control0*
:/pkg/prdcrm/oradata/prdcrm:root>cat /pkg/prdcrm/prdcrm.sql
CREATE CONTROLFILE REUSE DATABASE "PRDCRM" NORESETLOGS ARCHIVELOG

    MAXLOGFILES 32



    MAXLOGMEMBERS 2



    MAXDATAFILES 30



    MAXINSTANCES 8



    MAXLOGHISTORY 39024



LOGFILE


  GROUP 1 '/pkg/prdcrm/oradata/prdcrm/redoprdcrm01.log'  SIZE 10M,
  GROUP 2 '/pkg/prdcrm/oradata/prdcrm/redoprdcrm02.log'  SIZE 10M,
  GROUP 3 '/pkg/prdcrm/oradata/prdcrm/redoprdcrm03.log'  SIZE 10M,
  GROUP 4 '/pkg/prdcrm/oradata/prdcrm/redoprdcrm04.log'  SIZE 10M,
  GROUP 5 '/pkg/prdcrm/oradata/prdcrm/redoprdcrm05.log'  SIZE 10M,
  GROUP 6 '/pkg/prdcrm/oradata/prdcrm/redoprdcrm06.log'  SIZE 10M


DATAFILE


  '/pkg/prdcrm/oradata/prdcrm/system01.dbf',
  '/pkg/prdcrm/oradata/prdcrm/rbs01.dbf',
  '/pkg/prdcrm/oradata/prdcrm/temp01.dbf',
  '/pkg/prdcrm/oradata/prdcrm/tools01.dbf',
  '/pkg/prdcrm/oradata/prdcrm/users01.dbf',
  '/pkg/prdcrm/oradata/prdcrm/genrc_data.dbf',
  '/pkg/prdcrm/oradata/prdcrm/genrc_index.dbf',
  '/pkg/prdcrm/oradata/prdcrm/siebel_amp.dbf',
  '/pkg/prdcrm/oradata/prdcrm/sea_data.dbf',
  '/pkg/prdcrm/oradata/prdcrm/sea_index.dbf',
  '/pkg/prdcrm/oradata/prdcrm/sea_data2.dbf',
  '/pkg/prdcrm/oradata/prdcrm/sea_index2.dbf',
  '/pkg/prdcrm/oradata/prdcrm/platinum.dbf'


;


:/pkg/prdcrm/oradata/prdcrm:root>su - oracle
$ svrmgrl



Oracle Server Manager Release 3.0.5.0.0 - Production



(c) Copyright 1997, Oracle Corporation.  All Rights Reserved.



Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.0.0 - Production



SVRMGR> connect internal


Connected.


SVRMGR> startup nomount


ORACLE instance started.

Total System Global Area                         26148952 bytes
Fixed Size                                          49240 bytes
Variable Size                                     5349376 bytes
Database Buffers                                 20480000 bytes
Redo Buffers                                       270336 bytes


SVRMGR> @/pkg/prdcrm/prdcrm.sql


Statement processed.


SVRMGR> recover automatic database;


Media recovery complete.


SVRMGR> alter database open;


Statement processed.





Charles J. Fisher - Consultant


Alcoa Davenport Works


(319) 459-2512
Received on Wed May 16 2001 - 11:11:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US