Home » RDBMS Server » Backup & Recovery » To test the restore of a database to new host
To test the restore of a database to new host [message #269905] Tue, 25 September 2007 01:49 Go to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)

am having two oracle database

Database 1--dbsib
and i had created recovery catalog in dbsib.

Database 2--newdb

Both the database is in different nodes.

now in another new node i had installed oracle software alone.

i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.

And i copied all these backups datas manually to the new node where i installed oracle software.

by using the pfile i just try to start the instance but i face the following errors.

i followed the RMAN advance user guide,
in that they had given that in page(8-13 to 8-18)
Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)

am having two oracle database

Database 1--dbsib
and i had created recovery catalog in dbsib.

Database 2--newdb

Both the database is in different nodes.

now in another new node i had installed oracle software alone.

i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.

And i copied all these backups datas manually to the new node where i installed oracle software.

by using the pfile i just try to start the instance but i face the following errors.

i followed the RMAN advance user guide,
in that they had given that


Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)

am having two oracle database

Database 1--dbsib
and i had created recovery catalog in dbsib.

Database 2--newdb

Both the database is in different nodes.

now in another new node i had installed oracle software alone.

i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.

And i copied all these backups datas manually to the new node where i installed oracle software.

by using the pfile i just try to start the instance but i face the following errors.

i followed the RMAN advance user guide,
in that they had given that
Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)

am having two oracle database

Database 1--dbsib
and i had created recovery catalog in dbsib.

Database 2--newdb

Both the database is in different nodes.

now in another new node i had installed oracle software alone.

i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.

And i copied all these backups datas manually to the new node where i installed oracle software.

by using the pfile i just try to start the instance but i face the following errors.

i followed the RMAN advance user guide,
in that they had given that

Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)

am having two oracle database

Database 1--dbsib
and i had created recovery catalog in dbsib.

Database 2--newdb

Both the database is in different nodes.

now in another new node i had installed oracle software alone.

i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.

And i copied all these backups datas manually to the new node where i installed oracle software.

by using the pfile i just try to start the instance but i face the following errors.

i followed the RMAN advance user guide,
in that they had given that

Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)

am having two oracle database

Database 1--dbsib
and i had created recovery catalog in dbsib.

Database 2--newdb

Both the database is in different nodes.

now in another new node i had installed oracle software alone.

i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.

And i copied all these backups datas manually to the new node where i installed oracle software.

by using the pfile i just try to start the instance but i face the following errors.

i followed the RMAN advance user guide,
in that they had given that

Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)

am having two oracle database

Database 1--dbsib
and i had created recovery catalog in dbsib.

Database 2--newdb

Both the database is in different nodes.

now in another new node i had installed oracle software alone.

i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.

And i copied all these backups datas manually to the new node where i installed oracle software.

by using the pfile i just try to start the instance but i face the following errors.

i followed the RMAN advance user guide,
in that they had given that

Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)

am having two oracle database

Database 1--dbsib
and i had created recovery catalog in dbsib.

Database 2--newdb

Both the database is in different nodes.

now in another new node i had installed oracle software alone.

i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.

And i copied all these backups datas manually to the new node where i installed oracle software.

by using the pfile i just try to start the instance but i face the following errors.

i followed the RMAN advance user guide,
in that they had given that


Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)

am having two oracle database

Database 1--dbsib
and i had created recovery catalog in dbsib.

Database 2--newdb

Both the database is in different nodes.

now in another new node i had installed oracle software alone.

i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.

And i copied all these backups datas manually to the new node where i installed oracle software.

by using the pfile i just try to start the instance but i face the following errors.

i followed the RMAN advance user guide,
in that they had given that

rman target/ nocatalog

set DBID (2873463223) ie newdb according to my setup
RMAN> startup nomount;

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/new/oracle/product/db/database/dbs/initnewdb.ora'

starting Oracle instance without parameter file for retrival of spfile
Oracle instance started

Total System Global Area 159383552 bytes

Fixed Size 1218268 bytes
Variable Size 54528292 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes


RMAN> run {
2> allocate channel t1 type disk;
3> restore spfile to pfile '/new/oracle/product/db/initnewdb.ora' from autobackup;
4> shutdown abort;
5> }

allocated channel: t1
channel t1: sid=36 devtype=DISK

Starting restore at 25-SEP-07

channel t1: looking for autobackup on day: 20070925
channel t1: looking for autobackup on day: 20070924
channel t1: looking for autobackup on day: 20070923
channel t1: looking for autobackup on day: 20070922
channel t1: looking for autobackup on day: 20070921
channel t1: looking for autobackup on day: 20070920
channel t1: looking for autobackup on day: 20070919
channel t1: no autobackup in 7 days found
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/25/2007 13:09:01
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

i had tried in catalog mode also.
please provide me a solution.

Re: To test the restore of a database to new host [message #269923 is a reply to message #269905] Tue, 25 September 2007 02:35 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

How many times you posted same thing,

About the error no autobackup found. Did you do configure autobackup on? I think no. If yes then locate a valid copy of backup.
Re: To test the restore of a database to new host [message #269929 is a reply to message #269905] Tue, 25 September 2007 02:47 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
how many times i say you that i had configured autobackup on.
i had configured autobackup on in newdb according to my setup.
and i had taken backup.

RMAN> startup mount;

Oracle instance started
database mounted

Total System Global Area 293601280 bytes

Fixed Size 1219040 bytes
Variable Size 83887648 bytes
Database Buffers 205520896 bytes
Redo Buffers 2973696 bytes

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/new/oracle/product/db/database/dbs/snapcf_newdb.f'; # default

Re: To test the restore of a database to new host [message #269930 is a reply to message #269905] Tue, 25 September 2007 02:54 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Then you don't trust Oracle. So find it yours' one.
no autobackup found or specified handle is not a valid copy or piece


Cause

A restore could not proceed because no autobackup was found or 
specified handle is not a valid copy or backup piece. In case of 
restore from autobackup, it may be the case that a backup exists, 
but it does not satisfy the criteria specified in the user"s 
restore operands. In case of restore from handle, it may be the 
handle is not a backup piece or controflile copy. In may be that it
does not exist.


Action

Modify autobackup search criteria or verify the handle.
Re: To test the restore of a database to new host [message #269931 is a reply to message #269905] Tue, 25 September 2007 02:55 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

And please format your post so that it is nicely readable. And read oracle forum guide.
Previous Topic: auto specified any value after ran RECOVER STANDBY DATABASE;
Next Topic: RMAN Backup with LTO Tapes
Goto Forum:
  


Current Time: Thu Dec 08 16:39:45 CST 2016

Total time taken to generate the page: 0.22165 seconds