OraFAQ Forum: Backup & Recovery » Yet another backup from .dbf files gone wrong!

Home » RDBMS Server » Backup & Recovery » Yet another backup from .dbf files gone wrong!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Yet another backup from .dbf files gone wrong! [message #116520]

Wed, 20 April 2005 08:49

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
-----

Report message to a moderator

Re: Yet another backup from .dbf files gone wrong! [message #116572 is a reply to message #116520]

Wed, 20 April 2005 12:01

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

Report message to a moderator

Previous Topic:	Does import overwrite existing data ?
Next Topic:	Backup software

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 23:01:08 CST 2024