RMAN restores
Oracle 8.1.7.0.0 on Solaris 2.8 with NetBackup 3.4 We are trying to use the same RMAN scripts that worked for us in 8.0.5 and 8.1.6. We can do full - incrememtal 0 - backup and restore. We can also do an incremental 1 backup, but when we try to do the restore, it does not restore the archive logs. The lists does show the correct archive logs, so I'm reasonabley certain that the logs are getting backed up, but they do NOT restore. I am working with Oracle on this, but because it is just testing at this point, WWW is not in any hurry to get back to me. Does any one have any scripts they use for 8.1.7 that work for them? I'd like to do a comparison and see if there is something we are missing. TIA Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN restores
Terry,
When you say that Rman does not restore the archive log files, what exactly
are you expecting?
Maybe Rman does not need to restore any archive logs, depending on what
point-in-time you are restoring to. It could just restore the db files, and
use the current redo logs to catch them up?
Below is a point-in-time restore script that I have used - the syntax has
not changed much since 816.
run {
allocate channel t1 type 'SBT_TAPE' parms 'BLKSIZE=2097152';
set until time to_date('2001-06-22:13:25:00','-mm-dd:hh24:mi:ss');
restore (database);
recover database;
release channel t1;
sql 'alter database open resetlogs';
}
reset database;
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, March 25, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.7.0.0 on Solaris 2.8 with NetBackup 3.4
We are trying to use the same RMAN scripts that worked for us in 8.0.5 and
8.1.6. We can do full - incrememtal 0 - backup and restore. We can also do
an incremental 1 backup, but when we try to do the restore, it does not
restore the archive logs. The lists does show the correct archive logs, so
I'm reasonabley certain that the logs are getting backed up, but they do NOT
restore. I am working with Oracle on this, but because it is just testing
at this point, WWW is not in any hurry to get back to me.
Does any one have any scripts they use for 8.1.7 that work for them? I'd
like to do a comparison and see if there is something we are missing.
TIA
Terry
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1801
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ball, Terry
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: RMAN restores
Here are the errors I am seeing.
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 27
scn 34
923
This lists all the logs EXCEPT the most recent. No logs are found in the
archive log directory and the database does not recover thru RMAN. I can
not recover the database manually, because the archive logs can not be
found. (The backup script removes the archive logs after they have been
(hopefully) backed up.
-Original Message-
Sent: Monday, March 25, 2002 12:36 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Terry,
When you say that Rman does not restore the archive log files, what exactly
are you expecting?
Maybe Rman does not need to restore any archive logs, depending on what
point-in-time you are restoring to. It could just restore the db files, and
use the current redo logs to catch them up?
Below is a point-in-time restore script that I have used - the syntax has
not changed much since 816.
run {
allocate channel t1 type 'SBT_TAPE' parms 'BLKSIZE=2097152';
set until time to_date('2001-06-22:13:25:00','-mm-dd:hh24:mi:ss');
restore (database);
recover database;
release channel t1;
sql 'alter database open resetlogs';
}
reset database;
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, March 25, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.7.0.0 on Solaris 2.8 with NetBackup 3.4
We are trying to use the same RMAN scripts that worked for us in 8.0.5 and
8.1.6. We can do full - incrememtal 0 - backup and restore. We can also do
an incremental 1 backup, but when we try to do the restore, it does not
restore the archive logs. The lists does show the correct archive logs, so
I'm reasonabley certain that the logs are getting backed up, but they do NOT
restore. I am working with Oracle on this, but because it is just testing
at this point, WWW is not in any hurry to get back to me.
Does any one have any scripts they use for 8.1.7 that work for them? I'd
like to do a comparison and see if there is something we are missing.
TIA
Terry
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1801
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ball, Terry
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ball, Terry
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
