| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Rookie restore problem
I backed up a database using the following script:
/*************************************************************/
/* Description: Oracle Backup script */
/* Usage: Execute in SYSDBA-privileged SQL*Plus session */
/*************************************************************/
PROMPT Backup up database to jar file
PROMPT $ORACLE_BASE/backups/db-backup.tar
PROMPT Backing up SYSTEM tablespace ...
PROMPT
ALTER TABLESPACE system BEGIN BACKUP;
HOST cp $ORACLE_BASE/oradata/www/system01.dbf $ORACLE_BASE/backups/.
ALTER TABLESPACE system END BACKUP;
PROMPT SYSTEM tablespace backed up.
PROMPT
PROMPT Backing up TOOLS tablespace ...
PROMPT
ALTER TABLESPACE tools BEGIN BACKUP;
HOST cp $ORACLE_BASE/oradata/www/tools01.dbf $ORACLE_BASE/backups/.
ALTER TABLESPACE tools END BACKUP;
PROMPT TOOLS tablespace backed up.
PROMPT
PROMPT Backing up TEMP tablespace ...
PROMPT
ALTER TABLESPACE temp BEGIN BACKUP;
HOST cp $ORACLE_BASE/oradata/www/temp01.dbf $ORACLE_BASE/backups/.
ALTER TABLESPACE temp END BACKUP;
PROMPT TEMP tablespace backed up.
PROMPT
PROMPT Backing up USERS tablespace ...
PROMPT
ALTER TABLESPACE users BEGIN BACKUP;
HOST cp $ORACLE_BASE/oradata/www/users01.dbf $ORACLE_BASE/backups/.
ALTER TABLESPACE users END BACKUP;
PROMPT USERS tablespace backed up.
PROMPT
PROMPT Backing up SYSTEM tablespace ...
PROMPT
ALTER TABLESPACE system BEGIN BACKUP;
HOST cp $ORACLE_BASE/oradata/www/system01.dbf $ORACLE_BASE/backups/.
ALTER TABLESPACE system END BACKUP;
PROMPT SYSTEM tablespace backed up.
PROMPT
PROMPT Backing up RBS tablespace ...
PROMPT
ALTER TABLESPACE rbs BEGIN BACKUP;
HOST cp $ORACLE_BASE/oradata/www/rbs01.dbf $ORACLE_BASE/backups/.
ALTER TABLESPACE rbs END BACKUP;
PROMPT SYSTEM RBS backed up.
PROMPT
PROMPT Backing up DRSYS tablespace ...
PROMPT
ALTER TABLESPACE drsys BEGIN BACKUP;
HOST cp $ORACLE_BASE/oradata/www/drsys01.dbf $ORACLE_BASE/backups/.
ALTER TABLESPACE DRSYS END BACKUP;
PROMPT DRSYS tablespace backed up.
PROMPT
PROMPT Backing up INDX tablespace ...
PROMPT
ALTER TABLESPACE indx BEGIN BACKUP;
HOST cp $ORACLE_BASE/oradata/www/indx01.dbf $ORACLE_BASE/backups/.
ALTER TABLESPACE indx END BACKUP;
PROMPT INDX tablespace backed up.
PROMPT
PROMPT Backing up CONTROLROOM tablespace ...
PROMPT
ALTER TABLESPACE controlroom BEGIN BACKUP;
HOST cp $ORACLE_BASE/oradata/db/CONTROLROOM.dbf $ORACLE_BASE/backups/.
ALTER TABLESPACE controlroom END BACKUP;
PROMPT CONTROLROOM tablespace backed up.
PROMPT
PROMPT Backing up database control file ....
PROMPT
ALTER DATABASE BACKUP CONTROLFILE TO '$ORACLE_BASE/backups/controlbkup.ctl'
REUSE;
PROMPT Database Control file backed up.
PROMPT
PROMPT Backing up misc files.....
PROMPT
HOST cp $ORACLE_HOME/dbs/initwww.ora $ORACLE_BASE/backups/. HOST cp $ORACLE_HOME/dbs/orapwwww $ORACLE_BASE/backups/. HOST cp $ORACLE_HOME/network/admin/*.ora $ORACLE_BASE/backups/.HOST cp /etc/oratab $ORACLE_BASE/backups/. HOST cp /etc/rc.d/init.d/dbora $ORACLE_BASE/backups/.
PROMPT misc files backed up
PROMPT
I have a different box with Oracle installed that I would like to restore the backup from above. I've tried a few different ways, but I'm not having any luck. Any suggestions?
Thanks,
Todd
 |
 |