Home » RDBMS Server » Backup & Recovery » Yet another backup from .dbf files gone wrong!
Yet another backup from .dbf files gone wrong! [message #116520] Wed, 20 April 2005 08:49 Go to next message
olecr
Messages: 2
Registered: April 2005
Junior Member
I wish to restore the ACCEPTAS* databases from the backups..

I have tried
SQLPLUS> conn sys/passwd as sysdba
..
SQLPLUS> alter database recover automatic datafile '/var/restore/ACCEPTAS20X.dbf';

and so on, as mentioned in the forums and the documentation, but there are still no tables.

I have some older backups of the dbf files (direct copies from /usr/local/oracle/oradata/db01/*) I don't know if this is silly, and unusable, since they were probably in use when being copied?

I just took over administrating the systems & database from an administrator that consequently took the shortest path and did some horrid solutions in regards to system administration.. Neutral

I have now setup RMAN backups of the database.

cutout from backup.sql:
-----
alter tablespace ACCEPTAS20 begin backup;
host cp /usr/local/oracle/oradata/db01/ACCEPTAS201.dbf /var/backup_DB01
alter tablespace ACCEPTAS20 end backup;

alter tablespace ACCEPTAS20X begin backup;
host cp /usr/local/oracle/oradata/db01/ACCEPTAS20X1.dbf /var/backup_DB01
alter tablespace ACCEPTAS20X end backup;

%%... lots of other databases ...%%

alter system switch logfile;
host cp /usr/local/oracle/oradata/db01/redo*.log /var/backup_DB01/

alter database backup controlfile to '/var/backup_DB01/controldb01.ora';
alter database backup controlfile to trace;

host cp -r /usr/local/oracle/oradata/db01/archive/ /var/backup_DB01/

quit
-----

Re: Yet another backup from .dbf files gone wrong! [message #116572 is a reply to message #116520] Wed, 20 April 2005 12:01 Go to previous message
olecr
Messages: 2
Registered: April 2005
Junior Member
Now I've tried any possible solution I know of..

The weird part is there are two db files..

ACCEPTAS201.dbf and ACCEPTAS20X1.dbf

i cannot even alter database datafile ACCEPTAS201.dbf... ( file doesn't exist errors )

I have tried restoring from the dumpfile generated as mentioned above.. and from a directly copied file (copy of the datafile while the db was running)..

Any suggestions?

Some examples of what i've tried:

SQL> recover datafile '/usr/local/oracle/oradata/db01/ACCEPTAS201.dbf';
ORA-01179: filen /usr/local/oracle/oradata/db01/ACCEPTAS201.dbf finnes ikke

SQL> recover datafile '/usr/local/oracle/oradata/db01/ACCEPTAS20X1.dbf';
ORA-00279: endring 13540422 som ble generert p? 04/19/2005 22:11:58, kreves til
tr?d 1
ORA-00289: forslag : /usr/local/oracle/9.0.1/dbs/arch1_1233.dbf
ORA-00280: endring 13540422 for tr?d 1 er i sekvens nr 1233

Angi logg: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: kan ikke ?pne den arkiverte loggen
/usr/local/oracle/9.0.1/dbs/arch1_1233.dbf
ORA-27037: kan ikke hente filstatus
Linux Error: 2: No such file or directory
Additional information: 3

SQL> alter database datafile '/usr/local/oracle/oradata/db01/ACCEPTAS20X1.dbf' offline;

Database endret.

SQL> alter database recover datafile  '/usr/local/oracle/oradata/db01/ACCEPTAS20X1.dbf' ;
alter database recover datafile  
FEIL p? linje 1:
ORA-00279: endring 13540422 som ble generert p? 04/19/2005 22:11:58, kreves til
tr?d 1
ORA-00289: forslag : /usr/local/oracle/9.0.1/dbs/arch1_1233.dbf
ORA-00280: endring 13540422 for tr?d 1 er i sekvens nr 1233

SQL> alter database recover cancel;

Database endret.

SQL> recover datafile '/usr/local/oracle/oradata/db01/ACCEPTAS20X1.dbf' ;
ORA-00279: endring 13540422 som ble generert p? 04/19/2005 22:11:58, kreves til
tr?d 1
ORA-00289: forslag : /usr/local/oracle/9.0.1/dbs/arch1_1233.dbf
ORA-00280: endring 13540422 for tr?d 1 er i sekvens nr 1233

Angi logg: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: kan ikke ?pne den arkiverte loggen
/usr/local/oracle/9.0.1/dbs/arch1_1233.dbf
ORA-27037: kan ikke hente filstatus
Linux Error: 2: No such file or directory
Additional information: 3

ORA-00308: kan ikke ?pne den arkiverte loggen
/usr/local/oracle/9.0.1/dbs/arch1_1233.dbf
ORA-27037: kan ikke hente filstatus
Linux Error: 2: No such file or directory
Additional information: 3

SQL> shutdown abort
ORACLE-forekomsten er avsluttet.
SQL> startup nomount
ORACLE-forekomsten er startet.

Total System Global Area  235693108 bytes
Fixed Size                   279604 bytes
Variable Size             167772160 bytes
Database Buffers           67108864 bytes
Redo Buffers                 532480 bytes
SQL> recover database using backup controlfile until cancel;
ORA-01507: databasen er ikke montert

SQL> alter database datafile '/usr/local/oracle/oradata/db01/ACCEPTAS20X1.dbf' offline;
alter database datafile '/usr/local/oracle/oradata/db01/ACCEPTAS20X1.dbf' offline
*
FEIL p? linje 1:
ORA-01507: databasen er ikke montert

SQL>  alter database recover datafile  '/usr/local/oracle/oradata/db01/ACCEPTAS20X1.dbf' ;
 alter database recover datafile  '/usr/local/oracle/oradata/db01/ACCEPTAS20X1.dbf'
*
FEIL p? linje 1:
ORA-01507: databasen er ikke montert

SQL> recover datafile  '/usr/local/oracle/oradata/db01/ACCEPTAS20X1.dbf' ;
ORA-01507: databasen er ikke montert
Previous Topic: Does import overwrite existing data ?
Next Topic: Backup software
Goto Forum:
  


Current Time: Fri Mar 29 04:03:14 CDT 2024